Royal Bank of Canada

Lead Data Analyst

Royal Bank of Canada • $100K — $130K *
Toronto, ON M3C 0E3In-Person
Information Technology
8 - 10 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 10+ years experience as a data analyst, analytics engineer, or senior business systems analyst, demonstrating enterprise-level delivery.
  • Leadership of complex, cross-functional data initiatives from inception to production.
  • Deep expertise in data mapping, UAT leadership, and validation for analytics solutions.
  • Expert-level SQL skills including complex joins and performance tuning on large datasets.
  • Strong understanding of AI/ML workflows and the design of data platforms supporting them.
  • Hands-on knowledge of event streaming tools like Kafka and concepts such as schema evolution.
  • Familiarity with modern data architectures including data warehouses and lakehouses.

Responsibilities

  • Lead requirements definition and translate business needs into technical specifications.
  • Conduct analyses on customer behavior and campaign effectiveness, focusing on AI-augmented insights.
  • Architect and build dashboards and reporting frameworks for senior leadership.
  • Serve as the technical liaison among business stakeholders, engineering, and data science teams.
  • Oversee production readiness and continuous improvement of data solutions.
  • Mentor junior analysts and engineers, establishing best practices in data analytics engineering.

Benefits

  • A comprehensive rewards program that includes bonuses and flexible benefits options.
  • Leadership support for personal development through coaching and opportunities.
  • Dynamic and collaborative team environment with a high-performance focus.
  • Challenging work opportunities that create lasting community impact.
  • Casual work environment with a comfortable dress code.
  • Networking opportunities with a diverse group of developers across Canada and globally.
Full Job Description
Job Description

The Engineering team is driving multiple complex, enterprise-wide initiatives to build RBC's next-generation data platform - one that is AI-ready, scalable, and trusted across the organization. In this senior role, you will serve as a technical lead and strategic partner: shaping how data flows, how AI/ML systems consume it, and how analytics insights reach decision-makers. You will own end-to-end delivery - from requirements through production - while mentoring teams and influencing platform direction.

What will you do?
  • Lead requirements definition and translate complex business needs into precise technical specifications: data contracts, transformation logic, AI/ML feature requirements, non-functional requirements, and acceptance criteria.
  • Drive deep-dive analyses on customer behavior, product performance, campaign outcomes, and channel effectiveness - with a lens toward AI-augmented insight generation and predictive opportunity identification.
  • Architect, build, and own dashboards, scorecards, and executive reporting frameworks; define standards for how data products are presented to senior leadership.
  • Act as a technical bridge between business stakeholders, engineering, and data science teams - validating source-to-target mappings, enforcing data quality, and ensuring AI/ML pipelines consume reliable, well-governed data.
  • Lead production readiness reviews, post-implementation validation, and continuous improvement cycles to ensure solutions are accurate, stable, and performing at scale.
  • Mentor and guide junior analysts and engineers; establish best practices for analytics engineering, data quality, and AI-ready data design across the team.


What do you need to succeed?

Must have :
  • 10+ years of progressive experience as a data analyst, analytics engineer, or senior business systems analyst - with a track record of delivering at enterprise scale.
  • Proven ability to lead complex, cross-functional data initiatives from ambiguous requirements through production delivery.
  • Deep expertise in data mapping, acceptance criteria definition, UAT leadership, and production validation for analytics or data platform solutions.
  • Expert-level SQL: complex multi-table joins, window functions, query optimization, and performance tuning on large enterprise datasets.
  • Strong understanding of AI/ML workflows and how data platforms must be designed to support feature engineering, model training pipelines, and real-time inference.
  • Hands-on knowledge of Kafka, schema registries, and event streaming concepts - including schema evolution, data contracts, and event quality validation.
  • Deep familiarity with modern data platform architectures: data warehouses, Lakehouses (e.g., Delta Lake, Iceberg), and how they serve both BI and AI use cases.
  • Exceptional stakeholder communication skills: able to translate technical complexity into clear narratives for senior and executive audiences.


Nice-to-have:
  • Domain experience in financial services - banking, credit data, or regulatory reporting.
  • Familiarity with LLM/GenAI integration patterns: RAG pipelines, embedding workflows, or AI-assisted analytics.
  • Experience with GitHub Actions and CI/CD for data pipelines.
  • Knowledge of Debezium, GraphQL, or ELK Stack (Elasticsearch / Logstash / Kibana).
  • Hands-on experience with cloud-native platforms: OpenShift, Kubernetes, S3 object storage.
  • MongoDB experience: querying semi-structured data, aggregation pipelines for analytics use cases.
  • Proficiency with BI tools (Tableau, Power BI) and data quality frameworks for trusted, governed reporting.


What's in it for you?

  • A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation and pension plan.
  • Leaders who support your development through coaching and managing opportunities
  • Work in a dynamic, collaborative, progressive and highly performing team
  • Opportunities to do challenging work, making a difference and lasting impact on communities.
  • Enjoy a comfortable work environment with the option to dress casually.
  • Network and build lasting relationships with developers from diverse backgrounds from across Canada and the world.


#LI-POST

Job Skills
Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Quality Management, Requirements Analysis

Additional Job Details

Address:

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO

City:

Toronto

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-07-02

Application Deadline:

2026-08-02
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

About Royal Bank of Canada

Royal Bank of Canada Careers

Join the dynamic team at Royal Bank of Canada (RBC), a global leader in financial services and a company committed to excellence and innovation. At RBC, we offer a wide range of job opportunities that empower professionals to shape their career paths with leadership, diversity training, and continuous growth.

Work You’ll Do

At Royal Bank of Canada, we are not just hiring; we are building a culture of innovation and leadership. Our team members are at the forefront of the financial industry, driving transformation and delivering targeted solutions that meet the evolving needs of our clients and communities.

Explore Job Opportunities and Employment at RBC

Whether you are starting your career or looking to take it to the next level, RBC offers positions that challenge your skills and fuel your ambition. From entry-level positions to leadership roles, our job opportunities span across various functions and regions. Join us and be part of a team that values professional growth and diversity.

Internship and Professional Development

Kickstart your career with an internship at Royal Bank of Canada. Our internships provide invaluable hands-on experience, networking opportunities, and insights into the financial services industry. Interns at RBC gain the skills necessary to excel and are often considered for full-time positions within the company.

Benefits and Culture

At RBC, we prioritize the well-being and satisfaction of our employees. Our benefits package is designed to support our team members at every stage of their life and career. RBC’s culture is built on a foundation of respect, integrity, and responsibility, fostering an environment where everyone can thrive.

Career Growth and Innovation

We believe in nurturing the potential of our employees through continuous learning and career development programs. At RBC, you will find endless opportunities to grow professionally through on-the-job experiences, formal training programs, and leadership development initiatives. Our commitment to innovation means we are constantly seeking out new ideas and perspectives, making RBC a perfect place for those who aim to lead and innovate.

Diversity and Inclusion

Diversity is our strength. At Royal Bank of Canada, we are committed to building an inclusive workplace where every employee feels valued and respected. Our diversity training programs are designed to educate and inspire, creating a more inclusive and equitable workplace.

Join Our Team

Search open positions that match your skills and interests. We look for passionate, curious, creative, and solution-driven team players. Start your journey with RBC today and be part of a world-class team known for its commitment to client service, community involvement, and innovation.

Stay Connected

Keep up to date with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who work here at Royal Bank of Canada.

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities awaiting you at RBC. Explore the possibilities with Royal Bank of Canada, where your future is filled with potential and the path to success is paved with countless opportunities for professional and personal growth. Join us and shape not just your career but the future of the financial industry.
Learn more about Royal Bank of Canada
Size
86,007 employees
Market Cap
$130.3 billion
Industry
Finance & Insurance
5 Year Trend
+8.7%
NASDAQ
RY
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Royal Bank of Canada

More Information Technology Jobs

Find similar Lead Data Analyst jobs:

NationwideToronto, ON