Principal Associate, Data Analyst

161 Bay Street , Canada, Toronto,Toronto, Ontario,Principal Associate, Data Analyst

About Capital One Canada.

For over 20 years, we've been on a mission to change banking for good and build relationships by making credit accessible, simple, intuitive and rewarding. We want to help Canadians succeed with credit, because we believe in people — in our customers, in our associates, and in talent like you 

About the Team

Capital One is more than you think. We're a data-driven tech company that just happens to do credit cards. We focus on customer-first solutions, and we're united with this common goal. We have all the advantages of a startup, with the resources of a big company. Working here means you're curious, an innovative spirit will be encouraged as you push boundaries and try new things, while your career is nurtured and supported. Our environment is creative and filled with teams that are passionate about the dynamic work they're doing. We're ahead of other banks in tech and we want to keep it that way.

About the Role

As a Principal Associate, Data Analyst at Capital One, you'll be part of a team that's leading the next wave of disruption at a whole new scale, using the latest in distributed computing technologies and operating across billions and billions of customer transactions to unlock the big opportunities that help everyday people save money, time, and agony in their financial lives.

Your Responsibilities: 

• Writing SQL to clean, transform, investigate, and augment large, complex database tables

• Working closely with business partners to make sure our business strategy is as data driven as possible

• Designing rich data visualizations to communicate complex ideas to customers or company leaders

• Ensure data and intent integrity by automated data quality verification pipelines

• Supporting and consulting with the business to propagate data management best practices

• Investigating the impact of new technologies on the future of digital banking and the financial world of tomorrow

Basic Qualifications:

• At least 3 years of experience with relational databases and programming in SQL

• At least 3 years of experience with version control systems like GitHub.

Preferred Qualifications:

• Experience working with AWS (EC2, S3, Lambda, RDS, etc.)

• Experience working with advanced Git Workflows (Pull Requests, Code Reviews, Issues, and Branching)

• At least 3 years' experience in open source programming languages for large scale data analysis (Python or Scala)

• At least 5 years' experience with SQL

Working at Capital One.

Enjoy a hybrid work environment, with 3 days in the office. Build a comfortable workspace with our one-time, Work From Home allowance and enjoy our head office located conveniently across the street from Union Station. 

Live well—physically, financially and emotionally. Receive support for you and those who are most important to you, with full coverage for spouses, domestic partners, and dependents. With up to $3000 in mental health coverage and up to $5000 in tuition subsidies per year—and much more—you'll discover that Capital One is committed to helping you live your best life. 

Capital One Canada is an equal opportunity employer committed to fostering a diverse and inclusive work environment. We consider all qualified applicants and will meet the needs of those requiring reasonable accommodations.

If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation, please contact Capital One Recruiting at or via email at All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.

For technical support or questions about Capital One's recruiting process, please send an email to

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).

We may use your information for automated decision making. We may, for certain purposes, render a decision based exclusively on automated processing of your personal information as a part of the candidate screening process. 

Capital One Canada is an equal opportunity employer committed to fostering a diverse and inclusive work environment. We consider all qualified applicants and will meet the needs of those requiring reasonable accommodations.

If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation, please contact Capital One Recruiting at or via email at All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.

For technical support or questions about Capital One's recruiting process, please send an email to

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).

---