Information Security Office (Data Analyst), Principal Associate

Information Security Office (Data Analyst), Principal Associate

At Capital One, you will help consult on initiatives, programs, and projects to raise their game in Information Security. You are pragmatic and practical in your understanding of risk and security, but also willing to know when to pull in experts and escalate. You collaborate and innovate with other teams within Capital One to push the envelope. As an associate in Capital One’s Cyber Information Security Office - Risk Operations team, you will work with top talent to solve problems and drive solutions to help the company reduce cyber risk.  This position requires strong Business Intelligence, analytics and automation skills and those proficient in using QuickSight and other BI tools are strongly encouraged to apply.  You should have experience with traditional and modern technologies such as Databricks, Python, REST API, relational databases, Snowflake, Git, Shell scripting, and AWS.

In this role, you will be responsible for creating, maintaining and optimizing our data delivery and extraction from multiple data sources into our data warehouse.  You will be asked to create, enhance, and optimize Quicksight visualizations that are used by our business customers and internal leaders to include insights and alerting for Cybersecurity risk mitigation.

Responsibilities:

• Build data pipeline frameworks to automate high-volume and real-time data delivery to our cloud platform

• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS ‘big data’ technologies

• Develop and enhance applications using a modern technology stack such as Python, Shell Scripting, Snowflake, Lambda and Databricks

• Generate data science patterns and machine learning models to drive delivery of discovery insights to customers 

• Utilize reporting tools, such as Quicksight, to build and maintain dashboards used by internal leadership teams

• Build relationships with Information Security Officers and business requirement stakeholders to generate new/improved value streams using data and insights

• Analyze and interpret best practices and metrics to develop reporting dashboards and risk management tooling to identify cyber risk trends, analytics, and/or maturity opportunities for internal teams.

About You:

• You have a desire to work in a very fast moving, forward leaning, and modern computing environment

• You have a deep passion for Securing modern computing platforms

• You have a strong desire to continually learn about new technologies

• You possess strong conceptual thinking and communication skills

• You are able to work well under minimal supervision

• You are a demonstrated leader with team-oriented interpersonal skills and the ability to interface effectively with a broad range of people and roles, including upper management, IT leaders, and technology vendors

• You maintain calmness and clarity of thought under pressure and ability to maintain confidentiality

• You have a deep understanding of strategic business objectives and the ability to drive results toward those objectives

• You have an understanding of risk management principles and cybersecurity controls

Basic Qualifications:

• High School Diploma, GED or equivalent certification

• At least 3 years of experience working in cybersecurity or information technology 

• At least 2 years of professional data analysis experience

• At least 2 years of experience scripting in Python 

• At least 1 years of experience utilizing Tableau or AWS QuickSight

• At least 1 years of experience using database management tools 

• At least 1 years of experience using relational database systems

Preferred Qualifications:

• Bachelor’s Degree

• 3+ years of experience building software utilizing public cloud (AWS, GCP, Azure)

• 2+ years experience utilizing Agile methodologies

• 2+ years of experience with Risk Management principles and Cybersecurity controls

• 2+ years of experience building data pipelines and using ETL tools

• 2+