Senior Associate

Description:

Capital One is seeking a Senior Associate, Data Analyst to join its Toronto team. As a part of their Data Analytics division, you will be instrumental in using data to shape personalized financial products and improve business decision-making. The position supports Capital One Canada’s flexible hybrid working model, requiring in-office presence three days a week (Tuesdays and Thursdays mandatory), while Mondays and Fridays are virtual.

In this role, the candidate will take ownership of building and automating business-critical reports using cutting-edge tools. You’ll write SQL to clean, transform, and analyze large-scale datasets, collaborate with business stakeholders to ensure data-driven strategies, and design data visualizations for effective communication with leadership. You will also be involved in data integrity assurance, regulatory compliance, and process automation.

Candidates should be curious and creative problem solvers who enjoy tackling large, undefined problems. Strong collaboration and communication skills are essential, as you’ll work closely with diverse teams.

Responsibilities Include:

• Creating and maintaining reports and dashboards

• Writing SQL queries for large and complex databases

• Designing data visualizations for business insights

• Supporting and advising business partners with data strategies

• Ensuring compliance with regulatory requirements

• Automating data verification processes

• Performing ad-hoc analysis and identifying process improvements

Basic Requirements:

• Bachelor’s degree

• 2+ years SQL experience

• 1+ year with Unix

• 1+ year using version control (e.g., GitHub)

Preferred Qualifications:

• Master’s degree

• 3+ years with SQL

• Python or equivalent programming for large-scale analysis

• Experience with AWS services (EC2, S3, Lambda, RDS)

• Familiarity with advanced Git workflows