Senior Associate, Data Analyst

Capital One; Toronto; Hybrid; CAD 112,000 - 128,000; Full time

Benefits offered by this job

Hybrid work model

Work From Home allowance

Mental health coverage

Job summary

Capital One Canada is seeking a Senior Associate, Data Analyst to partner with senior stakeholders and drive data-driven strategies across fraud prevention, risk, and marketing. You will transform complex data into actionable insights and compelling narratives for leadership.

The role emphasizes end-to-end data analysis, governance, and advanced SQL usage in a hybrid, Canada-based environment. A quantitative degree and experience with cloud tools are required for success.

Qualifications

• 2+ years of professional experience with SQL across Snowflake, MySQL, PostgreSQL, Oracle or similar.
• Proficient in SQL for data extraction, wrangling and advanced analytics.
• Strong analytical and mathematical skills to solve business problems.
• Experience using dbt for data transformation and maintaining a production-ready data warehouse.

Responsibilities

• Engage directly with senior stakeholders to understand business goals and translate them into analytics initiatives.
• Translate technical insights into clear, concise, actionable recommendations and executive narratives.
• Lead end-to-end data analysis lifecycle from problem framing to implemented solutions.
• Apply expert SQL to transform raw data into clean, accessible datasets for analysts.
• Develop and automate governance, reporting, and dashboards to support decision making.

Skills

SQL

Data analysis

Python

Stakeholder management

Education

Bachelor's or Master's in a quantitative field

Tools

dbt

Git/GitHub

AWS

Tableau

Snowflake

Linux

Job description

161 Bay Street (93021), Canada, Toronto,Toronto, Ontario, Senior Associate, Data Analyst

About Capital One Canada For 30 years, we’ve been on a mission to change banking for good. We challenge the traditional bank stereotype, fostering a culture where innovation thrives and bold ideas are celebrated. We’re driven by what’s possible, leveraging the power of data and technology to empower innovative solutions, inspire one another to dream boldly, and take transformative ownership of decisions and outcomes that directly impact millions of Canadians. Every challenge is an opportunity to lead from the front, working together toward a shared vision that extends far beyond banking. We balance high-performance with investment in your long-term success, ensuring you have the support you need to do your best work. Here, you’ll take full accountability for your path, upskilling through hands-on experience and mentorship, to turn your curiosity into a career built on your own terms. Are you ready to redefine what’s next?

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 (e.g., line-of-business leads, product owners, 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.

You’ll be empowered to take end-to-end ownership of your work and your career, backed by a high-performance, hybrid culture and holistic suite of benefits designed to support your whole self. Take ownership of your own potential: Whether you’re looking to upskill, pivot into new business areas, or master your craft, you’ll have access to tools and mentorship to reach your potential and define your career trajectory.

Find your rhythm:

We believe trust fosters the flexibility and autonomy required to balance personal needs with a focus on high performance. We support a hybrid model – with 3 days in the office per week – that gives room for both collaboration and personal commitments.

Benefits built for your life:

We take a holistic approach to well-being, providing support for you and those who are most important to you. This includes: full coverage for spouses, domestic partners and dependents, a one-time Work From Home allowance to build your comfortable workspace, up to $3,000 in mental health coverage and up to $5,000 in annual tuition subsidies.

You’ll find that Capital One is committed to helping you thrive and evolve every step of the way.

This posting is for an existing vacancy. The expected annual salary range for this position is $112,240 to $128,100. This role is also eligible to earn performance-based incentive compensation, which may include cash bonus(es). Incentives could be discretionary or non-discretionary depending on the plan.

Weembrace the responsible use of artificial intelligence (AI) to enhance the candidate experience and streamline our recruitment processes. However, no hiring decisions are made using AI as every hiring decision is made by our hiring managers, business interviewers, and recruitment professionals. Our teams are equipped with training that empowers them to use AI responsibly.

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 1-800-304-9102 or via email at [e-mail]. 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 [e-mail]

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

At Capital One, we’re building a leading information-based technology company. Still founder-led by Chairman and Chief Executive Officer Richard Fairbank, Capital One is on a mission to help our customers succeed by bringing ingenuity, simplicity, and humanity to banking. We measure our efforts by the success our customers enjoy and the advocacy they exhibit.