Senior Manager, CRM and Executive Reporting

RBC; Toronto; On-site; CAD 110,000 - 160,000; Full time

Benefits offered by this job

Total rewards program with bonuses

Flexible benefits

Dynamic collaborative team environment

Progressively greater accountabilities

Job summary

RBC is seeking a data analytics leader to design and deliver next‑generation reporting solutions for Personal and Commercial Banking. You will build dashboards, leverage PME/ODS assets, and champion standardized design and data enablement across channels.

You will migrate the reporting suite from SAS to Python, automate jobs with Apache Airflow, and partner with NBA, Marketing, Product, Digital and Personal Distribution to drive business outcomes.

Qualifications

• Bachelor's degree in a quantitative field.
• 5+ years building analytical data workflows in Python, including data extraction, transformation, and semantic layer design.
• Strong SQL skills across Teradata and data lakes, with query optimization.
• Advanced data visualization with Tableau for dashboards.
• Strong stakeholder management and cross-functional collaboration.
• Strong business acumen and communication skills.

Responsibilities

• Lead development and maintenance of NBA and client dashboards delivering insights across lines of business.
• Partner with stakeholders to capture reporting requirements driving strategic decisions.
• Leverage AI tools to generate insights and build agentic data solutions.
• Drive dashboard improvements, optimizing front-end visuals and backend processes.
• Lead migration from SAS to Python and automate production jobs with Apache Airflow.

Skills

Big Data Analytics

Critical Thinking

Data Administration

Data Mining

Data Modeling

Data Movement

Detail-Oriented

ETL Processing

Group Problem Solving

Quantitative Research

Research Documents

SAS

Education

Bachelor's degree in Computer Science, Statistics, Mathematics, Engineering, or related quantitative discipline

Master's degree in quantitative discipline

Tools

Tableau

Apache Airflow

PySpark

Teradata

Hive

Python

Pandas

Polars

Job description

Job Description

What is the opportunity?

In this role, you will drive data-driven decision-making across RBC's most strategic initiatives by leading the design and delivery of next-generation reporting solutions. These dashboards and insights will empower our partners to make timely and informed decisions on mission critical initiatives - including Next Best Action (NBA), Client Growth and channel effectiveness across RBC's physical and digital channels. In this role you will work directly with business partners in NBA, Marketing, Product, Digital and Personal Distribution to fulfill the following critical functions:

• Develop and deliver next-generation NBA and client reporting solutions for Personal Banking and Commercial Banking that align with business, marketing, and financial objectives

• Provide subject matter expertise on Performance Measurement Enablement (PME), Operation Data Store (ODS) and Client 360 data assets to support National Office partners in tracking client and advisor interaction activities across digital and physical channels, and lead deployment initiatives.

• Champion best practices in data and reporting development, including standardized design and user experience, accurate key metrics measurement, process automation and data enablement through semantic data layer implementation

What will you do?

• Lead the development and maintenance of NBA and client dashboards that deliver insights and track campaign performance and client journey success across all lines of business
• Partner with business and marketing stakeholders to understand campaign objectives and capture reporting requirements that drive strategic decision-making
• Leverage AI tools such as RBC Assist Pro and Copilot to generate insights for new and existing dashboards. Lead the development of agentic solutions that empower end users to ask analytical questions directly against team-maintained data assets
• Drive continuous improvement by identifying and implementing enhancements to existing dashboards - optimizing both front-end visualizations and backend data processes to enhance user experience and adoption
• Lead the migration of the existing reporting suite from SAS to Python, leveraging AI tools to accelerate development, and automate production jobs using Apache Airflow

What you need to succeed?

Must-have:

• Bachelor's degree in Computer Science, Statistics, Mathematics, Engineering, or related quantitative discipline
• 5+ years of experience building analytical data workflows in Python. Proficient in extracting data from enterprise sources (Teradata, data lakes, S3), performing complex transformations and wrangling, and persisting semantic layers for reporting; skilled in optimizing processing approach (Pandas/Polars for in-memory, PySpark for distributed workloads) with strong emphasis on code quality, documentation, and testability; experience with workflow orchestration and automation (e.g., Apache Airflow)
• Strong proficiency in SQL with ability to extract and manipulate data from multiple data platforms including Teradata (RDBMS) and data lake (Hive tables); skilled in advanced SQL techniques and query optimization across different architectures
• Advanced proficiency in data visualization and experience in developing dashboards using Tableau
• Strong stakeholder management and cross-functional collaboration abilities
• Strong business acumen and communication and presentation skills

Nice-to-have:

• Technical experience with SAS (Base SAS 9.4/Enterprise guide/SAS Studio)
• Knowledge of Direct Marketing Campaigns
• Understanding of product management, sales, finance, pricing and risk management
• Master's degree in quantitative discipline

What's in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation
• Ability to make a difference and lasting impact
• Work in a dynamic, collaborative, progressive, and high-performing team
• Opportunities to take on progressively greater accountabilities

Job Skills

Big Data Analytics, Critical Thinking, Data Administration, Data Mining, Data Modeling, Data Movement, Detail-Oriented, ETL Processing, Group Problem Solving, Quantitative Research, Research Documents, SAS

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:

PERSONAL & COMMERCIAL BANKING

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-09-03

Application Deadline:

2026-09-21

Note

** : ** Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One RBC. We believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.