Senior Manager - Data Analytics and Reporting

What is the opportunity?  

The Senior Manager - Data Analytics and Reporting will work closely with traders, data analysts, and various teams within Corporate Treasury (CT). The successful candidate will play an important role in maintaining and developing our data and analytics systems, as well as creating reports to support multiple areas, including:

• Management of CT's $70+Bn liquid asset portfolio

• Interest rate risk strategy for RBC's banking books

• FX, Equity, and Share-based compensation hedging portfolios

The ideal candidate must have strong technical skills, excellent analytical abilities, and effective communication skills to support the development and maintenance of our data and reporting systems. They will need to understand business needs and provide actionable insights to inform decision making, ultimately contributing to the success of Corporate Treasury’s interest rate risk management and portfolio strategies.

What will you do?  

• Integrate various trading systems, databases and financial information to maintain consistent and timely reporting

• Enhance processes through automation and use of advance technology for higher efficiencies

• Collaborate with various stakeholders to build and maintain in-house database

• Develop Python modules to rank assets and suggest top trades for portfolio managers according to market conditions and internal investment policies

• Provide on demand analytics by leveraging big data to enhance our current trading practices

What do you need to succeed?

Must-have  

• Bachelor’s degree in Math/Computer Science/Engineering/Finance

• Proficient with Python/VBA/SQL/Tableau; Data cleaning/Data visualization

• 2-5 years of experience in data/finance related fields

• Strong attention to detail  

• Strong team player and interpersonal skills

Nice-to-have

• Experience with HIVE/PySpark/PowerBI/Qlik

• Knowledge of derivatives, portfolio reporting, P&L reporting

• Experience in Treasury/Finance/Product Control department of the bank

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.

• A comprehensive Total Rewards Program including bonuses and flexible benefits and competitive compensation

• Leaders who support your development through coaching and managing opportunities

• Ability to make a difference and lasting impact

• Work in a dynamic, collaborative, progressive, and high-performing team

• Opportunities to do challenging work

Job Skills

Asset and Liability Management (ALM), Fixed Income Analytics, Hive Query Language, Interest Rate Derivatives, Profit and Loss (P&L) Management, PySpark, Python (Programming Language), Reporting Processes, Structured Query Language (SQL), Tableau (Software)

Additional Job Details

RBC CENTRE, 155 WELLINGTON ST W:TORONTOTorontoCanada37.5Full timeOFFICE OF THE CFORegularSalaried2025-09-232025-10-06

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

Inclusion and Equal Opportunity Employment

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