AML Metrics & Reporting Analyst (Co-op)

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

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.