Principal Data Analyst - Strategy and Analytics
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.
What you’ll do:
- 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.
What you’ll do:
- 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 a