CCapital One logo

Capital One

Financial Services · 83k people

Principal Data Analyst - Strategy and Analytics

Posted 9 Oct

What’s this role about? The role involves owning the data transformation layer, designing data models, and implementing infrastructure roadmaps to support analytical needs. You will also drive data governance, ensure data quality, and collaborate across business units to provide trusted metrics and insights.

New York, New York
On-site
$143K – $164K
Full-time
5-10 years exp
Bachelor degree or Postgraduate degree

Skills required

Tap the ones you have

Want to get this job faster?

Apply with AI

No more application formsOur AI fills them in and submits them for you. You just pick the jobs.

Find hiring manager

Reach the person hiringEmail the person behind the job, not the inbox.

Company

About Capital One At Capital One, we're making things better for our customers and associates through innovation and collaboration. We were founded on the belief that everyone deserves financial freedom—and are dedicated to a world where all have equal opportunity to prosper. Banking is in our DNA, but we are so much more than a bank. We always think about what’s next—and how we can bring our customers the tools needed to improve their financial lives. Your ideas, experiences and skills will help make banking better. You’ll be part of a supportive culture while earning amazing benefits. That’s life at Capital One. Capital One is an equal opportunity employer (EOE, including disability/vet) committed to non-discrimination in compliance with applicable federal, state, and local laws. View our Social Media Community Guidelines https://www.capitalone.com/digital/social-media/

Capital One

Business Banking
CCapital One logo
10,001+ employees
Financial Services
Public Company
1.2M LinkedIn followers
Raised $5.5B

Responsibilities

  • Data is at the center of everything we do at Capital One. Your role as a Data Analyst on the team will heavily leverage your deep expertise in SQL and data transformation. You will be a creative data wrangler, comfortable with extracting, modeling, and transforming large, complex datasets to support our consumers. This requires more than just the ability to write complex, performant queries; you must also possess a thorough understanding of database structures, warehousing best practices, query profiling, and optimization techniques for data modeling and data governance. Ultimately, this is an analytics engineering role supporting not only analysts in the Strategy & Analytics team but a swathe of other data customers across a broader team who are hungry for data, metrics, and insights.
  • Own the transformation layer, applying best practices to design and implement data cubes, warehouses, and other data models to best serve our users. Define, manage, and implement the analytics engineering and infrastructure roadmap.
  • Level up our data models, infrastructure, and dashboard interfaces to drive effective self-service. Liaise with team members and other data customers to understand and meet their analytical needs.
  • Drive quality metadata and data discovery with a semantic layer—for both AI and humans. Excited to work alongside AI tools, not just using them, but improving their outputs by rigorously reviewing, refining, and iterating on AI-generated code and analyses
  • Act as a performing data steward. Define and enforce rigorous data governance standards while managing metadata frameworks to ensure data compliance and discoverability
  • Drive a high level of data quality and observability of our data at all stages of the data lifecycle.
  • Support modernization and migration initiatives from legacy reporting platforms.
  • Perform unit tests and conduct reviews with other team members to make sure your code is rigorously designed, elegantly coded, and effectively tuned for performance
  • Drive a single source of truth of trusted metrics and data that users can find and understand easily and make decisions with confidence.
  • Drive current and future strategy by leveraging your analytical skills
  • Assist with building and using models to test and validate data
  • Work with vast amounts of data in new and evolving environments
  • Leverage analytics to create a customer experience above our peers
  • Be a part of the full life cycle of projects and see end results
  • Collaborate across business units
  • Work with top talent in a fast paced, entrepreneurial environment where analytics and good data are a top priority
  • Driving high data and code quality, consistency, and simplicity.
  • Identifying and implementing process, data, and reporting improvements for the organization
  • Working with large and complex databases containing millions to billions of records
  • Improving operational efficiencies and effectiveness
  • Conducting analysis to evaluate processes and tests
  • Enhancing self-service offering with enhanced data cubes, dashboards, and AI interfaces
  • Consulting on the design and implementation of new production and data storage systems
  • An ideal candidate will be on the leading edge of Analytical technology with a passion for the newest and most innovative tools. Possessing strong problem solving and conceptual thinking abilities in addition to communication, interpersonal and leadership skills are also important. This position will be in a fast-paced and entrepreneurial environment where you will be handling multiple concurrent projects while working independently and in teams. This role will have a strong analytics engineering component.

Qualification

Data & AnalyticsTechnologyFinance & AccountingSoftwareEngineering

Required

  • Currently has, or is in the process of obtaining a Bachelor’s Degree in quantitative field (Statistics, Economics, Operations Research, Analytics, Mathematics, Computer Science or a related quantitative field) plus at least 5 years of experience performing data analytics, or, a Master’s Degree plus at least 3 years performing data analytics with an expectation that required degree will be obtained on or before the scheduled start date.
  • At least 3 years of experience working with at least one scripting language
  • At least 3 years of experience utilizing a business intelligence visualization tool
  • At least 3 years of experience in querying, analyzing and working with data languages and platforms

Preferred

  • Master’s Degree in a Science, Technology, Engineering, Mathematics discipline
  • At least 4 years of experience coding in Python, R, Spark, or SQL
  • At least 4 years of experience working within process management and improvement methodologies – Agile, Lean, Six Sigma, etc.
  • At least 2 years of experience utilizing and developing within AWS services
  • At least 2 years of experience delivering Data Governance and Data Quality Management concepts and practices within the financial services industry
  • Capital One will consider sponsoring a new qualified applicant for employment authorization for this position.
  • The minimum and maximum full-time annual salaries for this role are listed below, by location. Please note that this salary information is solely for candidates hired to perform work within one of these locations, and refers to the amount Capital One is willing to pay at the time of this posting. Salaries for part-time roles will be prorated based upon the agreed upon number of hours to be regularly worked.
  • Candidates hired to work in other locations will be subject to the pay range associated with that location, and the actual annualized salary amount offered to any candidate at the time of hire will be reflected solely in the candidate’s offer letter.
  • This role is also eligible to earn performance based incentive compensation, which may include cash bonus(es) and/or long term incentives (LTI). Incentives could be discretionary or non discretionary depending on the plan.
  • Capital One offers a comprehensive, competitive, and inclusive set of health, financial and other benefits that support your total well-being. Learn more at the Capital One Careers website. Eligibility varies based on full or part-time status, exempt or non-exempt status, and management level.
  • This role is expected to accept applications for a minimum of 5 business days.
  • For technical support or questions about Capital One's recruiting process, please send an email to Careers@capitalone.com
  • Capital One does not provide, endorse nor guarantee and is not liable for third-party products, services, educational tools or other information available through this site.
  • Capital One Financial is made up of several different entities. Please note that any position posted in Canada is for Capital One Canada, any position posted in the United Kingdom is for Capital One Europe and any position posted in the Philippines is for Capital One Philippines Service Corp. (COPSSC).

Benefits

  • Health insurance
  • Financial benefits
  • Performance based incentive compensation
  • Cash bonus
  • Long term incentives

Interested in this role?

Recommended jobs

  • NNew York University logo

    Senior Procure to Pay Data Analyst

    New York University·New York

    $110K – $130K
    Hybrid
    OTHER
    5-10 years exp

    Skills required

    Data AnalyticsBusiness IntelligenceProcurement
  • TThe Cadmus Group, Inc. logo

    Data Analyst - Water Quality

    The Cadmus Group, Inc.·Boston

    $70K – $85K
    Remote
    OTHER
    2-5 years exp

    Skills required

    Data analysisRPython
  • CCiti logo

    Data Analyst - Credit Risk Management & Counterparty Risk (Client & Markets Data)

    Citi·Tampa

    $87.3K – $130.9K
    Hybrid
    Full-time
    2-5 years exp

    Skills required

    Data analysisCredit risk managementSQL