Senior Associate Data Analyst

Capital One Canada; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading financial institution is seeking a Data Analyst in Toronto to drive strategic initiatives by leveraging advanced SQL and data visualization tools. This role involves collaborating with senior stakeholders, transforming complex data into actionable insights, and leading comprehensive data analysis projects. Ideal candidates should possess strong analytical skills, experience with database management, and a background in a quantitative field. Enjoy a hybrid work model and attractive benefits focused on personal wellbeing.

Benefits

Mental health coverage up to $3000

Tuition subsidies up to $5000

Work From Home allowance

Qualifications

• At least 2 years of professional experience with SQL.
• Proficient in SQL for data extraction, wrangling and advanced analytics.
• Strong analytical and mathematical skills to solve complex business problems.

Responsibilities

• Engage with senior stakeholders to understand business goals and challenges.
• Present insights that explain business conclusions and recommendations.
• Lead the data analysis lifecycle to implement defined specifications and solutions.
• Transform raw data into clean datasets for analysis.
• Build, automate and maintain business reporting.

Skills

SQL

Data wrangling

Data visualization tools

Stakeholder management

Analytical skills

Education

Bachelor's or Master’s Degree in a quantitative field

Tools

Snowflake

MySQL

Tableau

Python

Git/GitHub

Job description

About Capital One Canada

For 30 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

Data is at the centre of everything we do at Capital One. Your role as a Data Analyst on the team will heavily leverage your deep expertise in SQL. You will be a creative data wrangler, comfortable with extracting, transforming and analyzing large, complex datasets to uncover new narratives. This requires more than just the ability to write complex, performant queries; you must also possess a thorough understanding of database structures, query optimization techniques and best practices for data governance. Ultimately, you will be a proactive collaborator, skilled at articulating complex ideas through data visualization tools like QuickSight, Tableau or Matplotlib and eagerly sharing your knowledge across diverse teams.

About the Role

In this role, you will serve as a vital partner to the business, influencing strategy and execution across key areas like fraud prevention, credit risk or marketing. This role requires a blend of advanced technical analysis skills and strong business acumen to tackle complex challenges and deliver groundbreaking solutions. You will be responsible for translating technical insights into clear, concise and actionable strategic recommendations. Success in this position involves working effectively with both technical and non-technical stakeholders to implement strategies and innovative solutions that enhance performance, mitigate risk and drive profitable growth.

Your Responsibilities

• Strategic Stakeholder Partnership & Business Recommendations: Engage directly with senior stakeholders such as line‑of‑business leads, product owners and risk management to deeply understand business goals, challenges and decision needs. Partner with them to prioritize initiatives and refine strategies. Drive business strategy by proactively identifying, quantifying risks and translating complex analysis into compelling, concise recommendations that guide critical roadmap and decision‑making processes.


• Actionable Insight and Executive Storytelling: Draw clear business conclusions and present comprehensive insights that explain “what happened,” “why it happened,” “what it means” and “what we recommend doing next” (including risk mitigation or growth levers). Design and deploy rich data visualizations and craft crisp, executive‑ready narratives and dashboards to empower senior leadership to make high‑stakes decisions efficiently.


• End‑to‑End Data Analysis and Execution: Lead the full data analysis lifecycle, translating complex business problems into defined specifications and final implemented solutions.


• Data Preparation & Transformation: Apply expert‑level SQL skills to efficiently transform raw data into clean, accessible datasets for yourself and other analysts.


• Governance, Reporting and Automation: Build, automate and maintain critical business reporting and controls for processes and proactively identify and deliver process improvements for efficiency.

Basic Qualifications

• At least 2 years of professional experience with SQL (e.g., Snowflake, MySQL, SQL Server, PostgreSQL, Microsoft SQL Server, Oracle, etc.).


• Proficient in SQL for data extraction, wrangling and advanced analytics including joins, window functions, CTEs, aggregations and performance trending across large enterprise data environments.

Preferred Qualifications

• Bachelor’s or Master’s Degree in a quantitative field such as Data Analytics, Data Science, Computer Science, Engineering, Mathematics, Statistics, Economics, Finance or a related discipline.


• At least 1 year of professional experience using dbt (data build tool) for data transformation, modeling and maintaining a production‑ready data warehouse.


• At least 1 year of experience applying strong analytical and mathematical skills to solve complex business problems.


• Effective stakeholder management experience with strong skills in communication, negotiation, strategic thinking, influence and technical abilities is highly desirable.


• Proficient in data analysis within a cloud environment, including experience with open‑source programming (e.g., Python), advanced SQL for large datasets (e.g., Snowflake), version control (e.g., Git/GitHub) and cloud services (e.g., AWS).


• Experience with Linux or equivalent is preferred.

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.

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.

Equal Opportunity

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.