Capital One is seeking a data analyst to be part of a team delivering game-changing cybersecurity solutions based on threat, data, and design thinking. At Capital One, we believe in the values of Excellence and Doing the Right Thing. We are a technology-oriented company delivering financial products to market through modern technology and constant innovation at a massive scale. Part of that innovation is leveraging technology to deliver the best cybersecurity solutions for the business.
As a candidate for this role, you’re able to dive deep into data models and then switch to leading conversations with stakeholders about business impact or clarifying the meaning of data trends you are uncovering. You are comfortable asking questions, taking initiative, and are able to manage your time across multiple tasks. Most importantly, you are passionate about delivering impactful and actionable analytics.
What you'll do...
Write and fine-tune SQL queries in Snowflake (structured and semi-structured data) to feed reporting and analytics
Troubleshoot data-related issues
Design, build, and enhance dashboards in AWS QuickSight, Tableau, and other similar data visualization tools
Perform data-wrangling and ETL using Python
Communicate risk-based and data-driven metrics, reporting and insights for data protection at various levels of the organization
Engage stakeholders with the objective to provide impactful insights while also learning about the various Cyber processes and technologies at Capital One
Build relationships with subject matter experts in various functions within Cyber and beyond
About You...
You have strong analytical skills
You are detail oriented
You are independent, but also able to collaborate as part of a team
You are self-aware about when to ask for help
You have demonstrated communication skills and ability to interact effectively at all levels of an organization
You have strong developer skills in SQL (Python is a plus), and extensive experience with at least one data visualization tool (Tableau, Power BI, Qlik, Looker, etc.)
Basic Qualifications:
High School Diploma, GED or equivalent certification
At least 4 years of professional experience in analytics/reporting
Preferred Qualifications:
Bachelor’s or an advanced degree in Computer Science or related discipline
3+ years experience in enterprise security metrics and risk analytics
3+ years in public cloud security and multi-cloud environments
AWS Certified Data Analytics, Tableau, Power BI or equivalent certification(s)
Experience in financial services
At this time, Capital One will not sponsor a new applicant
McLean, VA
Capital One Financial Corporation operates as the bank holding company for the Capital One Bank (USA), National Association; and Capital One, National Association, which provides various financial products and services in the United States, the United Kingdom, and Canada. It operates through three segments: Credit Card, Consumer Banking, and Commercial Banking.
The company offers non-interest-bearing and interest-bearing deposits, such as checking accounts, money market deposit accounts, negotiable order of withdrawals, savings deposits, and time deposits. It also provides credit card loans; auto, home, and retail banking loans; and commercial and multifamily real estate, commercial and industrial, and small-ticket commercial real estate loans. In addition, the company offers credit and debit card products; online direct banking services; and treasury management and depository services.
It serves consumers, small businesses, and commercial clients through the Internet and mobile banking, as well as through Cafés, ATMs, and branches located in New York, Louisiana, Texas, Maryland, Virginia, New Jersey, and the District of Columbia. Capital One Financial Corporation was founded in 1988 and is headquartered in McLean, Virginia.