2027 CFO, Winter Markets Data Analyst (4 months)

0000050007 Royal Bank of Canada; Toronto; On-site; CAD 42,000 - 54,000; Full time

Job summary

Royal Bank of Canada in Toronto is seeking a student/co-op to join the ALM Portfolio Management and Execution Data team within Corporate Treasury. You will collaborate with Portfolio Managers and Traders to understand risk exposures and learn how the bank manages a variety of banking products.

You will assist with hedging calculations, automation, reporting, and analyzing hedge performance, while engaging with internal stakeholders to explore changes in key risk metrics.

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

Skills

Coding experience

Finance knowledge

Python

SQL

VBA

Tableau

HIVE

Education

Mathematics/Statistics/Finance student

Tools

Python

VBA

SQL

Hive

Tableau

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 in finance industry
• Coding experience (Python/VBA/SQL/HIVE/Tableau)
• Knowledge of financial products/derivatives

Please note:

In order to be eligible for these student positions, you must either: Be returning back to 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.

• 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

Job 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, Personal Development, Personal Initiative, Python (Programming Language), SQL Coding, Structured Query Language (SQL)

Additional Job Details

Address: RBC CENTRE, 155 WELLINGTON ST W:TORONTO City: Toronto Country: Canada Work hours/week: 37.5 Employment Type: Full time Platform: OFFICE OF THE CFO Job Type: Student/Coop (Fixed Term) Pay Type: Salaried Posted Date: 2026-09-10 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.

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.