2027 CFO, Winter Markets Data Analyst (4 months)

Royal Bank of Canada

Toronto

On-site

CAD 25,000 - 36,000

Full time

8 days ago

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Royal Bank of Canada (RBC) invites students to join the ALM Portfolio Management and Execution Data team within Corporate Treasury. You will collaborate with portfolio managers and traders to learn how RBC manages risk exposures across banking products.

You will assist hedging calculations, help automate team outputs, and compile hedge performance analyses while engaging with internal CT stakeholders to study key risk metrics for ALM. This role develops balance sheet risk and simulation skills.

Qualifications

Studying Mathematics/Statistics/Finance
Prior co-op experience in finance industry
Coding experience (Python/VBA/SQL/HIVE/Tableau)
Knowledge of financial products/derivatives

Responsibilities

Assist the team in calculating and troubleshooting hedging activities
Work to automate several work products that the team produces
Compile reports and analysis of the performance of hedges
Work with internal stakeholders within CT to investigate changes in key risk metrics used for ALM
Develop proficiency in balance sheet risk measures and simulation

Skills

Communication

Computer Coding

Computer Literacy

Detail-Oriented

Finance

Fixed Income Analysis

Fixed Income Analytics

Fixed Income Assets

Fixed-Income Markets

Fixed Income Portfolio Management

Fixed Income Risk

Fixed Income Trading

Fixed Income Valuation

Interpersonal Relationships

Listening Effectively

Microsoft Excel

Python (Programming Language)

SQL Coding

Structured Query Language (SQL)

Education

Studying Mathematics/Statistics/Finance

Tools

Python

VBA

SQL

Hive

Tableau

Job description

Job Description

What is the opportunity?

This is an exciting opportunity to work in the ALM Portfolio Management and Execution Data team with the RBC Corporate Treasury. You will work with a highly skilled team of Portfolio Managers and Traders, getting a great exposure to the way in which the bank seeks to manage the risk exposures that arise from various banking products. You will gain exposure and an opportunity to learn more about the workings of the financial markets and the business of banking.

What will you do?

Assist the team in calculating and troubleshooting hedging activities
Work to automate several work product that the team produces
Compile reports and analysis of the performance of hedges
Work with internal stakeholders within CT to investigate changes in key risk metrics used for ALM
Develop proficiency in balance sheet risk measures and simulation

Must Haves:

Studying Mathematics/Statistics/Finance
Prior co-op experience infinance industry
Coding experience (Python/VBA/SQL/HIVE/Tableau)
Knowledge of financial products/derivatives

Please note:

In order tobe eligible for these student positions, you must either:

Bereturning backto school after the work term end-date; or
If you are not returning back to school (i.e.are graduating immediately after the work term), you must require the full work term as a mandatory component in order to graduate successfully

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. At RBC, you will have opportunities to:

Interact with leaders who support your development through coaching and managing
Network and build lasting relationships with students from diverse backgrounds from across Canada
Make a difference and lasting impact through meaningful work
Work in a dynamic, collaborative, progressive, and high-performing team

please note that the formal application deadline is Sep 20, 2026 at 11:59 PM ET.

Job Skills