2026 Wealth Management, Summer Data Analyst (4-16 months)

RBC; Toronto; On-site; CAD 80,000 - 100,000; Part time

Job summary

A leading financial institution is seeking summer interns for various Data Analyst roles within its Wealth Management team in Toronto. Selected candidates will assist in delivering data solutions, lead efforts in data quality, and collaborate across diverse teams. Ideal applicants are pursuing degrees in quantitative fields and have a strong foundation in SQL, cloud platforms, and analytics tools. This internship provides a comprehensive experience in the financial services sector, aiding professional growth and development.

Benefits

World-class training program

Dynamic and collaborative work environment

Coaching and management opportunities

Qualifications

• Strong quantitative background with a relevant degree.
• Experience with SQL and managing large data sets.
• Familiarity with cloud platforms like AWS.
• Unix/Linux/Bash scripting skills are a plus.

Responsibilities

• Assist in developing data product solutions.
• Lead data hygiene efforts in CRM system.
• Develop and maintain data pipelines.
• Write SQL queries and Python scripts.
• Support testing requirements for data products.

Skills

Strong quantitative background

Experience with SQL and large data sets

Familiar with Kubernetes

Strong analytical skills

Effective communication skills

Education

Degree in math/statistics/computer science/engineering

Tools

SQL Server

AWS

Python

Snowflake

Eagle

Charles River

Excel

Job description

Job Description

Your application will be reviewed for consideration across multiple roles within the following areas:

RBC Dominion Securities

RBC PH&N Investment Counsel

RBC Royal Trust

RBC Private Banking

RBC Wealth Management Financial Services

RBC Global Asset Management

What is the opportunity?

We are seeking summer interns across several Data Analyst roles (including but not limited to the following: Data Analysts, Analytics Engineer, Data Team Co-Op, Data Engineer, Advisor Sales Analyst) to join the RBC Wealth Management Team. If you are passionate to learn about data engineering and data products delivery practices, please read on.

What will you do?

• Assist in the development and delivery of data product solutions including building, customizing, and management of data pipelines, data integration tools, databases, data warehouses, and analytical systems.
• Lead “data hygiene” effort in on our CRM system to ensure accurate quality data.
• Develop and maintain data pipelines for extracting, transforming, and loading data across SQL Server, SAS, and Snowflake.
• Write efficient SQL queries and Python scripts to automate workflows and ensure data quality.
• Use in-house applications to process trades and monitor settlement workflows. Leverage tools such as Eagle, Charles River, Bloomberg, and Excel for data analysis and reporting.
• Support testing requirements for data products and services including testing automation.
• Support the development and execution of strategic initiatives in collaboration with internal and external stakeholders using our software development life cycle (SDLC)
• Design, develop, implement, and support our emerging big data analytics capabilities through the development and maintenance of advanced data ingestion, processing, modeling and reporting capabilities.
• Process security, product and employee set up on Eagle system.
• Collaborate with engineers, analysts, and AI practitioners to prepare high-quality data for advanced analytics and business use cases.
• Review data quality monitors daily and address data quality issues with data stakeholders.
• Analyze data and data workflows to improve data quality.
• Work with cloud platforms (AWS, Azure, GCP) to deploy and manage data infrastructure.

What do you need to succeed?

Must have:

• Have a strong quantitative background, a degree in math/statistics/computer science/engineering would be a plus
• Experience working with SQL and large data sets and knowledge of AWS, cloud computing, or similar storage solutions
• Manipulate, organize and retrieve data using formulas and logic functions (particularly vlookups).
• Familiar with Kubernetes, Docker and containerization technologies and strong Unix/Linux/Bash scripting skills
• Experience working with DevOps CI/CD pipelines and automated testing.
• Experience working within professional software engineering practices for the full software development life cycle, including coding standards, code reviews, source code management, build processes and testing.
• Desire to learn data capabilities such as data management, data governance, data mastering, data quality, data literacy, etc.

Nice to have:

• Exposure to Snowflake or cloud data platforms.
• Basic understanding of AI/ML workflows (e.g., data preparation, model input/output).
• Must be a self-starter, with strong analytical and problem-solving skills
• Ability to work in teams and collaborate effectively with people in different functional areas
• Excellent interpersonal and highly developed communication skills (verbal and written)

Please note

In order to be eligible for these student positions, you must either:

• Be returning back to school after the work term end-date; or
• If you are not returning back to school (i.e.are graduating immediately after the work term), you must require the full work term as a mandatory component in order to graduate successfully

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.

• 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 service

Job Skills

Communication, Computer Literacy, Detail-Oriented, Interpersonal Relationships, Listening Effectively, Personal Development, Personal Initiative

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: Student/Coop (Fixed Term)

Pay Type: Salaried

Posted Date: 2025-12-13

Application Deadline: 2026-01-19

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.