Senior Manager, Business Intelligence & Reporting

Job Description

Join the GAM Business Intelligence & Reporting team as the technical lead for Tableau. This is a hands-on individual contributor role. You will set technical direction, establish development standards, and be the team’s authority on BI best practices. The team enables self-service analytics for business users across multiple Lines of Business, and you will help make sure they get timely, accurate and intuitive insights.

You will also work with enterprise data warehouses and data marts and evaluate emerging reporting tools and data platforms that improve how GAM’s business users access and act on data.

What will you do?:

• Dashboard Development and Visualization: Design, develop and maintain Tableau dashboards and reports end to end, turning business requirements into clear, intuitive visualizations. Apply visual design and UX best practices to create dashboards that are well structured, accessible and easy to use. Develop and maintain SQL Server Reporting Services (SSRS) reports.
• Technical Leadership: Define and uphold Tableau development standards, architecture and design patterns. Review work from other developers and mentor the team on best practices. Provide technical support to end users and fellow developers across performance optimization, extract optimization and query tuning. Set standards for release process, including version control, and where applicable, automated deployment practices.
• Tableau Administration and Support: Manage user access, permissions and row-level security on Tableau Server. Monitor server performance and ensure platform stability. Support the development environment used by the BI team.
• Data Warehousing and Integration: Extract, transform and load data from enterprise data warehouses and data marts into BI solutions. Apply dimensional modelling, layered data architecture and data lineage awareness to produce reliable, business-ready datasets. Ensure data accuracy, consistency and fitness for reporting.
• Thought Leadership: Stay current with developments in the BI space. Evaluate and pilot alternative reporting solutions, including Power BI, Snowflake dashboards, Databricks dashboards and Streamlit, and recommend new capabilities that improve the data-to-insight-to-decision journey for business users.
• Operational Support and Quality: Own the ongoing support and maintenance of existing dashboards, including proactive monitoring and issue resolution. Maintain documentation of technical solutions, standards and operating procedures. Test thoroughly through peer review, UAT coordination and validation against source data. BI governance and data quality, including certified data sources, KPI consistency, data lineage and documentation standards.

What do you need to succeed? Must Have:

• 5+ years of hands-on Tableau development experience, with the depth to set technical direction and define standards

• Strong knowledge of visual design and UX principles for dashboards

• Advanced SQL proficiency: Demonstrated ability to write complex queries including joins, subqueries, aggregations, and window functions, across multiple database platforms

• Solid understanding of data warehouse concepts, including dimensional modelling and layered architecture, and familiarity with comparable enterprise data warehouse environments

• Experience administering Tableau Server

• Demonstrated ability to independently manage work across the full BI lifecycle: data modelling, development, testing, documentation and deployment

Nice to Have's:

• Experience in asset/wealth management or financial services industry

• Hands-on exposure on other analytical solutions like Power BI, SSRS, Snowflake dashboards, Databricks dashboards or Streamlit

• Direct experience with enterprise data warehouses and data marts, including data extraction and transformation for reporting

• Familiarity with Trino, Presto, or other distributed SQL query engines

• Working knowledge of Python for data manipulation or automation

• Experience with Agile delivery frameworks and tools such as Jira and Confluence

• Knowledge of data governance or data architecture practices

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.
• A world-class training program in financial services
• Flexible work/life balance options
• Opportunities to do challenging work.

#LI_POST

Job Skills

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

Additional Job Details

Address:

RBC CENTRE, 155 WELLINGTON ST W:TORONTO

City:

Toronto

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

WEALTH MANAGEMENT

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-11-12

Application Deadline:

2026-12-04

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

Compensation for this position (including salary and discretionary/variable payments) will be determined by factors, including but not limited to candidate's experience, skills, registration status, performance, individual goals, market conditions, and business needs.

Pay Range

The expected pay range for this position is:

$90,000.00 - $140,000.00

The pay range provided is for the primary work location referenced in the Additional Job Details section of this job posting. Pay ranges may differ based on location. If the posting lists multiple job locations, a recruiter can confirm availability of the role and the relevant pay range for the additional locations listed. RBC supports pay transparency and we strive to ensure all pay ranges are competitive, fair, and equitable.

You have the potential to earn RBC's discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided that business meets its performance targets and you meet your individual goals.

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.