Logo of Huzzle


2024 CFO - Fall Benchmarking Strategy and Model Analytics (4 Months)

Logo of RBC


24d ago

🚀 Off-cycle Internship


6d left

AI generated summary

  • You must have solid analytical skills, data manipulation experience, Excel/VBA proficiency, and excellent communication skills to excel in this 4-month CFO role. Python/R programming and SQL knowledge are a plus. Prior Capital Markets experience is beneficial.
  • You will play a key role in overseeing teams, providing data analysis, enhancing reporting processes, and supporting advisory functions within Capital Markets.

Off-cycle Internship



  • 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 Market’s 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 Market’s front office.


  • 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

Education requirements

Currently Studying

Area of Responsibilities



  • 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.
  • Build a thorough knowledge of key Capital Markets businesses and financial reporting processes.
  • Be instrumental in advanced analytic capabilities that are used to support advisory functions to the Capital Market’s 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.


Work type

Full time

Work mode


Application deadline

May 26, 2024