About the role
Job Description
What is the opportunity?
You will work within Personal & Commercial Operations (PCO) to build business intelligence (BI) solutions that power decision-making across PCO. The position plays a key role in driving strategic, timely, and accurate insights to business partners and senior leaders.
What will you do?
- Design and develop innovative business intelligence solutions to monitor operational performance, present insights to underlying drivers, and support leaders in managing their business
- Source data from various platforms and build automated data pipelines
- Lead conversations with business partners to solicit requirements and project feedback
- Apply standard design principles and advanced data visualization techniques to provide actionable insights
- Test and validate new and existing reports and analytics for adherence to business and technical requirements
- Create and maintain accurate documentation related to reporting solutions, including specifications, data lineage, technical and business definitions for metrics, and test plan/test cases
What will you need to succeed?
Must-have
- Advanced proficiency in developing reports using Tableau or an equivalent reporting tool
- Experienced in querying and transforming large datasets and/or creating reports using SQL (e.g. MSSQL, Teradata, HDFS)
- Experienced with transforming data with Python or other automation technologies
- Ability to perform complex data analysis on large volumes of data and present findings to senior leadership to inform strategic decisions
- Proven innovative mindset with quantitative analytical and problem solving skills
- Expert technical documentation skills and the ability to effectively communicate, verbally and in writing, technical concepts to a non-technical audience
- Comfortable dealing with ambiguity and working independently
- A team player who is passionate about developing peers, winning as a team, and providing constructive feedback when needed
Nice to have
- University degree in a quantitative field of study (e.g., engineering, mathematics, statistics, etc.)
- Experience with technologies such as GitHub and Jira
- Project management capabilities
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.
- Ability to make a difference and lasting impact
- An opportunity to further develop your skills
- Work with a great and supportive team
Job Skills
Atlassian JIRA, Data Analysis, Datameer, GitHub, Group Problem Solving, Python (Programming Language), Structured Query Language (SQL), Tableau (Software), Teamwork, Waterfall Model, Working Independently
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:
2025-09-24
Application Deadline:
2025-10-09
Note**:** Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
I****nclusion and Equal Opportunity Employment
At 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.
About RBC
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 94,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada's biggest bank and one of the largest in the world, based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our more than 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com. We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at www.rbc.com/community-social-impact.
La Banque Royale du Canada est une institution financière mondiale définie par sa raison d'être, guidée par des principes et orientée vers l'excellence en matière de rendement. Notre succès est attribuable aux quelque 94 000+ employés qui mettent à profit leur créativité et leur savoir faire pour concrétiser notre vision, nos valeurs et notre stratégie afin que nous puissions contribuer à la prospérité de nos clients et au dynamisme des collectivités. Selon la capitalisation boursière, nous sommes la plus importante banque du Canada et l'une des plus grandes banques du monde. Nous avons adopté un modèle d'affaires diversifié axé sur l'innovation et l'offre d'expériences exceptionnelles à nos plus de 17 millions de clients au Canada, aux États Unis et dans 27 autres pays. Pour en savoir plus, visitez le site rbc.com/francais
Nous sommes fiers d'appuyer une grande diversité d'initiatives communautaires par des dons, des investissements dans la collectivité et le travail bénévole de nos employés. Pour de plus amples renseignements, visitez le site www.rbc.com/collectivite-impact-social.
About the role
Job Description
What is the opportunity?
You will work within Personal & Commercial Operations (PCO) to build business intelligence (BI) solutions that power decision-making across PCO. The position plays a key role in driving strategic, timely, and accurate insights to business partners and senior leaders.
What will you do?
- Design and develop innovative business intelligence solutions to monitor operational performance, present insights to underlying drivers, and support leaders in managing their business
- Source data from various platforms and build automated data pipelines
- Lead conversations with business partners to solicit requirements and project feedback
- Apply standard design principles and advanced data visualization techniques to provide actionable insights
- Test and validate new and existing reports and analytics for adherence to business and technical requirements
- Create and maintain accurate documentation related to reporting solutions, including specifications, data lineage, technical and business definitions for metrics, and test plan/test cases
What will you need to succeed?
Must-have
- Advanced proficiency in developing reports using Tableau or an equivalent reporting tool
- Experienced in querying and transforming large datasets and/or creating reports using SQL (e.g. MSSQL, Teradata, HDFS)
- Experienced with transforming data with Python or other automation technologies
- Ability to perform complex data analysis on large volumes of data and present findings to senior leadership to inform strategic decisions
- Proven innovative mindset with quantitative analytical and problem solving skills
- Expert technical documentation skills and the ability to effectively communicate, verbally and in writing, technical concepts to a non-technical audience
- Comfortable dealing with ambiguity and working independently
- A team player who is passionate about developing peers, winning as a team, and providing constructive feedback when needed
Nice to have
- University degree in a quantitative field of study (e.g., engineering, mathematics, statistics, etc.)
- Experience with technologies such as GitHub and Jira
- Project management capabilities
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.
- Ability to make a difference and lasting impact
- An opportunity to further develop your skills
- Work with a great and supportive team
Job Skills
Atlassian JIRA, Data Analysis, Datameer, GitHub, Group Problem Solving, Python (Programming Language), Structured Query Language (SQL), Tableau (Software), Teamwork, Waterfall Model, Working Independently
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:
2025-09-24
Application Deadline:
2025-10-09
Note**:** Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
I****nclusion and Equal Opportunity Employment
At 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.
About RBC
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 94,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada's biggest bank and one of the largest in the world, based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our more than 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com. We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at www.rbc.com/community-social-impact.
La Banque Royale du Canada est une institution financière mondiale définie par sa raison d'être, guidée par des principes et orientée vers l'excellence en matière de rendement. Notre succès est attribuable aux quelque 94 000+ employés qui mettent à profit leur créativité et leur savoir faire pour concrétiser notre vision, nos valeurs et notre stratégie afin que nous puissions contribuer à la prospérité de nos clients et au dynamisme des collectivités. Selon la capitalisation boursière, nous sommes la plus importante banque du Canada et l'une des plus grandes banques du monde. Nous avons adopté un modèle d'affaires diversifié axé sur l'innovation et l'offre d'expériences exceptionnelles à nos plus de 17 millions de clients au Canada, aux États Unis et dans 27 autres pays. Pour en savoir plus, visitez le site rbc.com/francais
Nous sommes fiers d'appuyer une grande diversité d'initiatives communautaires par des dons, des investissements dans la collectivité et le travail bénévole de nos employés. Pour de plus amples renseignements, visitez le site www.rbc.com/collectivite-impact-social.