Manager, Business Intelligence & Information Management

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 and reporting solutions to define, measure, and deliver insights that mitigate risk, enhance client experience, and support Commercial advisors and leaders through data-driven coaching and analytics.

• Design and oversee the development and enhancement of Tableau reports and performance metrics to monitor performance management, presenting key insights into underlying drivers for informed decision-making. 

• Respond to ad-hoc investigations, inquiries, data requests, and run production jobs as assigned, ensuring timely and accurate delivery.

• Demonstrate expertise in data and reporting infrastructure design, configuration, and optimization, providing recommendations for effective execution and alignment with business objectives.

• Apply design principles and ETL (Extract/Transform/Load) processes to measure key indicators, disclose trends, and provide actionable insights, ensuring data quality and meaningful performance management.

• Be a thought partner within the Commercial Reporting team, participate in design and solution reviews with the Senior Manager and/or internal partners (role design, incentive, practice management, and portfolio quality), understand business strategies and objectives, and define reporting solutions that ensure satisfaction and project success.

• Test and validate reports for business and technical requirements, enhance production processes, maintain comprehensive documentation, and demonstrate commitment to continuous learning and adaptation as business needs and analytical tools evolve.

What do you need to succeed?
Must-have

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

• Proven working experience in SAS/SQL and Tableau; demonstrated ETL and big data modeling capabilities with programming experience in SAS/SQL, SQL Server, and Teradata SQL Assistant.

• Strong expertise in statistical methods, data profiling, cleaning, and mining. Ability to perform complex data analysis on large datasets and present findings to senior leaders.

• Proficient in SQL extracts for data investigation from warehouses and flat files. Experience with Cloud computing technologies (e.g., Snowflake/Snowsight, Trino) and knowledge of RBC’s EDW.

• Expert technical documentation skills and the ability to communicate complex technical concepts clearly to non-technical audiences, both verbally and in writing.

• Proficient in UNIX for process submission, logging, and data storage, and skilled in Microsoft Office applications (Excel, PowerPoint, Outlook).

Nice-to-have:

• Deep knowledge of the Financial Services Industry/Business Financial Services.

• Proven experience in developing performance metrics and reports.

• Proficiency in programming/coding with Python and Hadoop (HIVE), alongside expertise in Tableau Security and Tableau Server Administration.

• Knowledge of 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 Skills

Critical Thinking, Data Administration, Data Mining, Data Modeling, Detail-Oriented, Extract Transform Load (ETL), Group Problem Solving, Hive Query Language, Python (Programming Language), Red Hat Enterprise Linux (RHEL), SAS, Snowflake (Platform), Structured Query Language (SQL), Tableau (Software), Tableau Administration, Tableau Dashboard Development, Unix

Additional Job Details

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTOTorontoCanada37.5Full timePERSONAL & COMMERCIAL BANKINGRegularSalaried2026-04-222026-05-07

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.

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.