Data and Reporting Analyst

What is the opportunity?

This is an exciting opportunity in the Data Intelligence team where you will play an instrumental role in leveraging RBC's strategic data assets to build automation solutions and data analytic models. You will support the team with focus in data extraction through automation and dashboarding utilizing innovative technologies.

We are looking for a passionate complex problem solver and strategic thinker who excels in a highly demanding fast-paced environment. The ideal candidate has a strong data/business analysis background, is quick to adapt to new technologies, and is enthusiastic about developing innovative solutions to support digital transformation.

What will you do?

• Analyze large datasets to build data insights and visualizations
• Design and implement automated data workflows through Python scripts, incorporating data quality validation to identify errors/anomalies and ensuring timely data availability
• Build and maintain Tableau dashboards and automation solutions to reduce manual tasks and provide data insights
• Explore alternative options and recommend technology solutions for data automation and reporting
• Create and document procedures related to supported solutions to increase adoption across enterprise
• Create agentic/AI and proof of concept solutions to increase efficiency

What do you need to succeed?

Must have:

• 1- 2 years experience in data analytics and reporting
• Experience creating and enhancing data insight/reports with BI Reporting Tools (e.g., Tableau, Power BI)
• Demonstrated experience with data extraction, transformation, and loading from a wide variety of data sources using Python, SQL, and related technologies
• Innovation and automation mindset with curiosity for emerging technologies in Artificial Intelligence and Machine Learning
• Excellent analytical skills & critical thinking skills to investigate system and business issues, determine root cause, and deliver sustainable solutions

Nice-to-have: 

• Knowledge of machine learning and AI fundamentals
• Familiarity with APIs and integration platforms for connecting data sources and automating processes
• Experience with designing and developing large-scale data pipelines, working with Airflow, Helios, Github
• Experience with automation frameworks and workflow orchestration tools

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
• Opportunities to take on progressively greater accountabilities 

#TECHPJ

#LI-POST

Job Skills

AI Agents, Analytics, Critical Thinking, Data Administration, Data Analysis, Data-Driven Decision Making, Data Mining, Data Modeling, Data Movement, Data Quality, Datasource, Data Validation, Detail-Oriented, Group Problem Solving, Machine Learning (ML), Python (Programming Language), Quantitative Research, Research Documents, Tableau (Software)

Additional Job Details

RBC CENTRE, 155 WELLINGTON ST W:TORONTOTorontoCanada37.5Full timeTECHNOLOGY AND OPERATIONSRegularSalaried2026-05-272026-07-10

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.