Job Description
What is the opportunity?
Group Risk Management - Balance Sheet and Liquidity Risk (GRM-BSLR) provides independent second line oversight of all balance sheet and liquidity risks at the enterprise level.

As a Co-op Student, you will work on the data engineering behind ALM risk reporting & analytics, and support the transformation of our risk practices – building and extending data pipelines, scripting away manual processes, automating data quality checks, and applying AI tooling to work that has traditionally been done by hand.

What will you do?

Contribute to the design, build, and optimization of ETL/ELT pipelines that ingest, transform, and consolidate ALM risk data from multiple sources into a centralized data platform

Engineer validation logic in SQL and Python that reconciles risk data against source systems and pinpoints the root cause of discrepancies

Convert ad-hoc checks into an automated, rule-driven data quality process with clear pass/fail reporting

Apply AI-assisted tooling to accelerate pipeline development, validation, and documentation

Move recurring data and reporting jobs onto a scheduler/orchestrator so they run and alert without manual intervention

Monitor pipeline runs, resolve failures, and investigate data issues

What do you need to succeed?

Currently enrolled at a Canadian post-secondary institution in computer science, data science, financial engineering, mathematics, statistics, or a related quantitative discipline

Exposure to ETL/ELT concepts and data transformation logic

Python for data manipulation, pipeline scripting, and automation





SQL and working knowledge of relational databases

Familiarity with AI coding assistants (e.g., GitHub Copilot, Claude Code)

Self-driven, comfortable with ambiguity, and able to communicate clearly with non-technical stakeholders

Nice-to-have

Cloud data warehouse experience (e.g., Snowflake) for querying and transforming large datasets

Job scheduling or workflow orchestration (e.g., Airflow) for automating recurring processes

BI tools (e.g., Tableau, Power BI) for reporting and data visualization

Knowledge of financial markets, balance sheet management, or risk management.

Please note:
This posting is for a 4-months 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-months 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-months work term as a mandatory component to in order to graduate successfully.

Please ensure that you meet these eligibility requirements before applying - candidates who apply but are found to be ineligible are not able to be considered.





RBC is committed to supporting flexible work arrangements when and where available. The successful candidate for this role will be required to be located within Ontario for the duration of the work term. Details regarding the specific virtual, hybrid, and in-office arrangements for this Integrated Learning/ Co-op position are to be discussed with the Hiring Manager.

ET27

Job Skills
Analytics, Communication, Computer Literacy, Data Automation, Data Engineering, Data ETL, Data Transformation, Data Visualization, Detail-Oriented, Interpersonal Relationships, Listening Effectively, Personal Development, Personal Initiative, Python (Programming Language), Structured Query Language (SQL), Tableau (Software)

Additional Job Details
Address: ROYAL BANK PLAZA, 200 BAY ST:TORONTO

City: Toronto

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: GROUP RISK MANAGEMENT

Job Type: Student/Coop (Fixed Term)

Pay Type: Salaried

Posted Date: 2026-08-31

Application Deadline: 2026-09-21

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above.

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 recent 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.

#J-18808-Ljbffr

📌 2027 Winter - GRM, ALM Risk Data & Automation Analyst Intern (4 Months) (Ontario)
🏢 ODAIA
📍 Ontario