2027 Winter - GRM, ALM Risk Data & Automation Analyst Intern (4 Months)

0000050007 Royal Bank of Canada; Toronto; On-site; CAD 35,000 - 48,000; Full time

Job summary

Royal Bank of Canada is seeking a Co-op Data Engineer in Toronto for a 4‑month winter 2027 placement to design and optimize data pipelines supporting ALM risk reporting. You will automate data quality checks, apply AI-assisted tooling, and move recurring tasks to a scheduler while collaborating with stakeholders.

The role requires Python, SQL, ETL/ELT experience, and familiarity with BI tools; eligibility requires enrollment in a Canadian post-secondary program and relocation to Ontario for the

Qualifications

• Enrolled in a Canadian post-secondary program (CS/DS/Math/Stats)
• Exposure to ETL/ELT concepts and data transformation
• Python for data manipulation, pipeline scripting, and automation
• SQL and relational databases
• Familiarity with AI coding assistants (e.g., GitHub Copilot, Claude Code)
• Nice-to-have Snowflake cloud data warehouse experience
• Job scheduling/workflow orchestration (e.g., Airflow)
• BI tools for reporting and data visualization

Responsibilities

• Contribute to the design, build, and optimization of ETL/ELT pipelines ingesting ALM risk data
• Engineer validation logic in SQL and Python to reconcile data
• Automate data quality checks with clear pass/fail reporting
• Apply AI-assisted tooling to accelerate pipeline development and validation
• Move recurring data/reporting jobs to a scheduler/orchestrator and monitor runs

Skills

Python

SQL

ETL/ELT

Data pipelines

Data quality

Education

Currently enrolled in Canadian post-secondary program (CS/DS/Math/Stats)

Tools

Snowflake

Airflow

Tableau

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

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.

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 84,000+ employees who bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada's biggest bank, and one of the largest in the world based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to more than 16 million clients in Canada, the U.S. and 34 other countries. Learn more at rbc.com.

We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at rbc.com/community-social-impact.