Associate Director, Balance Sheet Analytics

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 it's 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 AD 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 Clustery 7.

What do you need to succeed?

Must Have

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

Employment Type:

Full time

Platform:

OFFICE OF THE CFO

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

Application Deadline:

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

---