Associate Director, Balance Sheet Analytics & Liquidity Attribution

RBC; Toronto; On-site; CAD 125,000 - 150,000; Full time

Job summary

A leading financial institution is seeking an Associate Director for Balance Sheet Analytics & Liquidity Attribution in Toronto. This role involves providing analytical support for liquidity and cash impacts while managing data models and producing reports for senior management. The ideal candidate has a bachelor’s degree related to finance or engineering, with over 5 years of relevant experience. Strong skills in SQL and advanced programming are essential. This full-time position offers a collaborative work environment.

Qualifications

• 5+ years of work experience in Finance/Performance Management, Treasury, Capital Markets or related field.
• Solid understanding and working knowledge of the balance sheet and ledger.
• Strong understanding of liquidity and banks’ balance sheet regulatory metrics.

Responsibilities

• Engage Finance and business segments in analyzing General Ledger accounts.
• Build analytic tools to explain liquidity changes.
• Prepare End-User Developed Application (EUDA) and load into Cluster 7.

Skills

AI Programming

Analytical Support

Liquidity Risk

Data Analysis

SQL Query Writing

Education

Bachelors degree – Finance, Computer Engineering, Math or other related discipline

Tools

VBA

SQL

Python

Job description

Job Description

What is the opportunity?

The Associate Director, Balance Sheet Analytics & Liquidity Attribution, will be responsible for providing analytical support relating to cash and liquidity and its impact on Regulatory metrics, producing/enhancing multiple spreadsheets/models that account for Intersegment Liquidity Attribution (ISLA) and Notional Cash RFR Top-up (NCRT), emanating from the IBOR transition. There is a need to develop a new Framework for Governance in Forecasting and Liquidity comprising of risk controls, newly written documentation which is expected to be submitted into Cluster 7 and build out of new models.

In this role, the Associate Director will be working with partners across all finance segments and IT to expand the existing infrastructure capabilities, and be responsible for providing in‑depth cash and liquidity analytics reports for senior leaders.

What you will do?

• Engage Finance and business segments in investigating and analyzing General Ledger/ EPM intragroup accounts balance and underlying business drivers.
• Run weekly liquidity meetings with Performance management teams.
• Define and interpret requirements to IT with respect to data, functionality and reporting for development of any existing or new models.
• Create, design and develop new methods to enhance ISLA capabilities.
• Extract data from EPM, manage and manipulate large datasets for analysis (intragroup cash flows by transit, currency, counterparty).
• Build analytic tools to explain liquidity changes driven by balance sheet movements and inter‑segment cash flows.
• Operate monthly ISLA and NCRT reporting production including troubleshooting issues that may arise when results do not meet expectations. Enhance reporting capabilities to account for current or future changes in Segments i.e. newly split of P&CB into Personal and Commercial Banking representing them as separate segments.
• Build out Governance requirements. Document risks and develop procedural risk mitigation material.
• Prepare End‑User Developed Application (EUDA) and load into Cluster 7.

What do you need to succeed?

Must Have

• Bachelors degree – Finance, Computer Engineering, Math or other related discipline
• 5+ years of work experience in Finance/ Performance Management, Treasury, Capital Markets or related field
• Solid understanding and working knowledge of the balance sheet and ledger
• Strong understanding of Liquidity and banks’ balance sheet e.g. regulatory metrics (LCR)
• Advanced programming skills e.g. VBA, SQL, pivot tables
• Highly developed interpersonal skills; able to present complex concepts in a simplified manner
• Ability to cope under pressure and manage competing priorities
• Results oriented; strong attention to detail

Nice to Have

• Professional designation i.e. CFA, FRM, CPA is an asset but not required
• MBA
• Python/MatLab

Job Skills

AI Programming, Analytical Support, Balance Sheets, Big Data, Big Data Computing, Data Analysis, Data Modeling, Data Science, Design Reports, Detail‑Oriented, Liquidity Risk, Python (Programming Language), SQL Query Writing

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

Pay Type: Salaried

Posted Date: 2025‑12‑01

Application Deadline: 2025‑12‑16

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.

Join our Talent Community

Stay in‑the‑know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.
Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well‑being of our clients and communities at jobs.rbc.com.