Senior Manager, CRM and Executive Reporting

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.

Join our Talent Community

Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.