2027 Winter - GRM, Global AML Metrics Reporting Analyst (4 Months)

0000050007 Royal Bank of Canada; Toronto; Hybrid; CAD 25,000 - 39,000; Full time

Job summary

Royal Bank of Canada is seeking a Reporting Analyst co-op to turn raw data into insights through reports and dashboards. You will write SQL queries, develop Python scripts, and collaborate across teams to deliver ad-hoc data requests.

The role emphasizes data analysis, visualization with Tableau, and documentation of processes in a fast-paced environment. Ontario location with hybrid/remote work arrangements and a 4‑month winter term in 2027.

Qualifications

• Enrolled in an undergraduate degree with focus on Mathematics, Statistics, IT, or Computer Science.
• Proficiency in SQL, Python, R and/or SAS; familiarity with data analysis tools.
• Ability for complex data analysis on large datasets.
• Familiarity with data visualization tools such as SAS VIYA and Tableau.
• Strong interpersonal and written communication skills.
• Creative, analytical, and self-driven in a fast-paced environment.
• Nice-to-have: Git/GitHub familiarity.

Responsibilities

• Write and optimise SQL queries to extract data from enterprise systems.
• Develop Python scripts to extract, transform, and build reports.
• Document code, processes, and query logic; upgrade manuals as needed.
• Support ad-hoc reports and data requests for multiple business teams.

Skills

SQL

Python

R/SAS

Tableau

Data analysis

Communication

Teamwork

Git/GitHub

Education

Undergraduate degree focus: Math/Stats/IT/CS

Tools

SAS VIYA

Tableau

Job description

What is the opportunity?

As a Reporting Analyst co‑op student, you'd support RBC's business teams by turning raw data into actionable insights through reports and dashboards.

What will you do?

Work collaboratively with cross‑functional teams. Contributing to defined projects or tasks under direct supervision. Write and optimise SQL queries to extract data from enterprise systems. Develop Python scripts to extract, transform, and build reports. Document all code, processes, and query logic or upgrading existing procedure manuals. Assist various business teams with ad‑hoc reports and data requests.

What do you need to succeed?

• Must‑have Currently enrolled in Undergraduate degree with focus on Mathematics, Statistics, IT, or Computer Science
• Programming skills in SQL, Python, R and/or SAS and/or other data analysis tools
• Ability to perform complex data analysis on large volumes of data
• Familiarity with data visualization software such as SAS VIYA, Tableau, etc.
• Excellent interpersonal and highly developed communication skills (verbal and written)
• Creative and analytical thinker who is self‑driven and capable of working in a fast‑paced environment
• Nice‑to‑have Ability to learn and absorb new concepts (in business and in systems) quickly and apply new knowledge
• Debugging data issues, optimising thinking
• Familiarity with Git/GitHub

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; Work in a dynamic, collaborative, progressive, and high‑performing team; Real‑world experience with enterprise data systems; Exposure to RBC's business operations; Understanding of financial industry workflows; Flexible work/life balance options.

Placement details and eligibility

This posting is for a 4‑month Winter 2027 Student placement with a start date of January 2027, and end date of April 2027. In order to be eligible for this 4‑month Student position, you must either: be returning back to school after the work term end‑date of April 2027 or, if you are not returning back to school (i.e. are graduating in April 2027), you must require the full 4‑month work term as a mandatory component to in order to graduate successfully.

Eligibility & requirements

Full time, 37.5 hours per week, Salaried.

Location: Ontario (must be located within Ontario for the duration).

Hybrid/remote: Specific virtual, hybrid, and in‑office arrangements to be discussed with the Hiring Manager.

Pay Type: Salaried.

Employment Type: Full time, Student/Co‑op (Fixed Term).

Platform: GROUP RISK MANAGEMENT.

Job skills

• Communication
• Data Query
• Detail‑Oriented
• Interpersonal Relationships
• Listening Effectively
• Personal Development
• Personal Initiative
• Python (Programming Language)
• Structured Query Language (SQL)
• Tableau (Software)

Address

20 KING ST W, TORONTO, Canada.

Other details

• Posted Date: 2026-08-27
• Application Deadline: 2026-09-21

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.

We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities.