Manager, Business Intelligence & Information Management

Job Description

What is the opportunity?RBC Regional Banking Support’s Commercial Reporting is hiring a Manager, Business Intelligence & Information Management role that will support strategic reporting and visual insights for Regional Banking’s Commercial by successfully transforming data into useful, relevant information, and by leveraging sound business knowledge, additional sources of information, and resources to deliver insight to the Commercial field. The position plays a role in driving strategic, timely, and accurate insights to business partners and senior leaders in a Commercial banking environment, alongside key technology partners. What will you do?

• Utilize cutting edge business intelligence capabilities to optimize business results, define, measure, and deliver insights and mitigate risk.

• Design and develop/enhance innovative reporting solutions to monitor performance management, present key analytical and business insights to underlying drivers in support of the Commercial advisors and leaders on client and coaching insights to drive an exceptional client experience.

• Take end to end responsibility in the development and enhancement of performance metrics and reporting in Tableau.

• Respond to ad-hoc investigations, inquiries, data, and report requests as assigned.

• Run production jobs as assigned.

• Demonstrate Subject Matter Expertise in data and reporting infrastructure design, configuration and optimization, providing recommendations on approach and execution.

• Apply standard design principles and data visualization techniques to measure key indicators, disclose trends, provide proactive actionable insights/indicators and address business questions.

• Identify appropriate data sources and perform Extract/Transform/Load (ETL) for data modelling, data quality assessments, understand patterns and provide the basis to inform the reporting solution which provides meaningful performance management insights.

• Participate in conversations with internal partners to understand their business strategies (role design, incentive, practice management and portfolio quality) and objectives in order to define/recommend reporting solutions to meet those objectives, effectively communicate project status and develop relationships to ensure satisfaction.

• Participate in design and solution review demonstrations with the Senior Manager and/or internal partners at critical tollgates to ensure adherence to requirements, resolve obstacles, while mitigating deployment risk and the need for post-deployment modifications.

• Test and validate (QA) new and existing reports and analytics for adherence to business and technical requirements.

• Enhance and optimize existing production processes.

• Create and maintain accurate documentation related to reporting solutions, including specifications, data lineage, technical and business definitions for metrics, and test plan/test cases.

• Be a thought partner within the Commercial Reporting team, supporting the developments of insights, processes, data approaches/ methodologies and information that is valued by partners across Regional Banking and Commercial.

• Demonstrate a commitment to continuous learning and professional growth, with the ability to adapt to evolving business needs and new analytical methodologies or tools.

What do you need to succeed?
Must-have

• Degree in Computer Science, Mathematics/Statistics, Engineering, related field or equivalent related experience.

• Working experience in both SAS and Tableau.

• Demonstrated ETL and big data modeling capabilities, with programming experience in large databases/datasets and using SAS, SQL Server and Teradata SQL Assistant.

• Experience in statistical methods, strong data profiling, cleaning, and mining.

• Proficient in SQL extracts in order to investigate data from data warehouse and other sources (flat files) for investigation/analysis purposes.

• Ability to perform complex data analysis on large volumes of data and present findings to senior leaders in order to inform of strategic decisions.

• Proven quantitative analytical (including data knowledge, data discovery, data aggregation and summarization) and problem solving skills.

• UNIX knowledge (i.e. submit process, create logs, store data).

• Advanced proficiency in report development using Tableau.

• Experience with Cloud computing technologies (Snowflake/Snowsight & Trino)

• Data knowledge on RBC’s EDW.

• Skilled in Microsoft Office applications (Excel, PowerPoint, Outlook).

• Expert technical documentation skills and the ability to effectively communicate, verbally and in writing, technical concepts to a non-technical audience.

Nice-to-have

• Financial Services Industry/Business Financial Services knowledge

• Experience in developing performance metrics/reports

• Programming/coding skills in Python and Hadoop (HIVE)

• Experience with Tableau Security, Tableau Server Administration

• Fundamentals of Red Hat Enterprise Linux

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, commissions, and stock where applicable

• Leaders who support your development through coaching and managing opportunities

• Ability to make a difference and lasting impact

• Work in a dynamic, collaborative, progressive, and high-performing team

• Opportunities to do challenging work and take on progressively greater accountabilities

Job SkillsCritical Thinking, Data Administration, Data Mining, Data Modeling, Data Movement, Detail-Oriented, Group Problem Solving, Quantitative Research, Research DocumentsAdditional 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-01-08

Application Deadline:

2026-03-20Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date aboveOur Employment OpportunitiesAt 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.