2025 CFO - Summer Benchmarking Strategy and Model Analytics (4 Months)

What is the opportunity?

This is an exciting opportunity in Benchmarking Strategy and Model Analytics team under Capital Markets and Treasury Services Performance Management team. In this role, you will be at the forefront of delivering value-add inputs and support in developing model frameworks that enable our Finance leaders and advisory team to enhance the current forecasting and financial planning process as well as enrich the data strategy across the group and broader RBC enterprise. The ultimate goal of Capital Markets financial modelling initiative is develop a future state where business forecasts are supported by bottoms-up macroeconomic data and models, and where financial advice, assessment and tracking business results, competitive benchmarking, real-time decision support, detailed analytics, and scenario / what-if attribution analysis can be tied to macroeconomic indicators. Data strategy efforts that the team leads are also focused on driving forward the Future of Finance in efforts to enrich the existing data infrastructure to promote greater value-add insights and advice offered by the team to senior management, the CFO and the Capital Markets front office.

What will you do?

1. Play a central oversight and collaboration role across teams within the department. This includes providing detailed data and analysis that will help other teams within the group enhance and transform their existing reporting processes and dialogue with key stakeholders.

2. Build a thorough knowledge of key Capital Markets businesses and financial reporting processes.

3. Be instrumental in advanced analytic capabilities that are used to support advisory functions to the Capital Markets senior management team across Finance and the Front Office, Group Risk Management by aiding in the development and advancement of financial models and data inventories/dashboards.

What do you need to succeed?

Must-have

• Ability to convert financial data and knowledge into clear and concise messaging with actionable advice for business partners
• Excellent problem solving and proven analytical skills, with a high degree of initiative
• Solid data engineering / manipulation experience
• Ability to work under pressure and demonstrate multi-tasking skill
• Advance knowledge of MS Excel (VBA) and PowerPoint
• Excellent oral and written communication skills

Nice-to-have

• Programming experience in R or Python is an asset
• Programming experience in SQL is an asset
• Knowledge about Capital Markets businesses is a plus

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

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

• 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 and make a difference
• Opportunities to building close relationships

Additional Job Details

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

Inclusion and Equal Opportunity Employment