Summer 2026 Student - Data Analytics Analyst

Key Skills

Big Data Technology, Business Intelligence, Data Analytics, Microsoft-Excel, PowerBI, Python Programming, SQL, Tableau

Job Description

The Commercial Distribution Model and Advisor Role Strategy (CDMARS) Insights & Analytics team enables use of data in strategic decision making, measures / monitors key initiative impact, leads process automation / optimization, and executes ad-hock data-related requests. CDMARS Insights & Analytics Intern will contribute to this mandate, responsible for supporting and conducting analysis, design, and implementation of data solutions, leveraging RBC’s enterprise suite of analytical tools.

What will you do?

• Support and conduct analysis, design, and implementation of data solutions, leveraging RBC’s enterprise suite of analytical tools
• Support with defining / implementing data governance, security, and integrity / accuracy of data in model development
• Support with the implementation and maintenance of models
• Build relationships and collaborate with the CDMARS Insights & Analytics team and other key business partners

What do you need to succeed?

Must have:

• Experience with big data technologies and familiarity with range of data tools (Big Data Tools, Datameer, Teradata, SQL);
• Experience with data manipulation with Python ecosystem (Pandas, Numpy, PySpark, etc.)
• Experience with maintaining existing and creating new ETL infrastructure
• Ability to perform complex data analysis on large volumes of data, and to translate technical data findings into clear business friendly insights;
• Excellent analytical and problem solving skills, as well as keen eye for detail to support team with QA reviews
• Interest in the financial services industry

Nice-to-have

• Experience building automated solutions using different tools combined (Python, SQL, Excel, Tableau, PowerBI)
• Business Intelligence and Visualization tools experience (Tableau, Datameer, PowerBI)
• Data pipeline automation experience with Spark.

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.
• Opportunities to do challenging work and make a difference.
• Opportunities to build close relationships.

Job Skills

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