Associate Director, Balance Sheet Analytics

Job DescriptionWhat 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 capabilitiesExtract 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 Have5+ years of work experience in Finance/ Performance Management, Treasury, Capital Markets or related fieldSolid understanding and working knowledge of the balance sheet and ledgerStrong understanding of Liquidity and banks’ balance sheet e.g. regulatory metrics (LCR)Advanced programming skills e.g. VBA, SQL, pivot tablesHighly developed interpersonal skills; able to present complex concepts in a simplified mannerAbility to cope under pressure and manage competing prioritiesResults oriented; strong attention to detailNice to HaveProfessional designation i.e. CFA, FRM, CPA is an asset but not requiredPython/MatLabJob SkillsAI 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 WritingAdditional Job DetailsAddress:RBC CENTRE, 155 WELLINGTON ST W:TORONTOCity:TorontoCountry:CanadaWork hours/week:37.5Employment Type:Full timePlatform:OFFICE OF THE CFOJob Type:RegularPay Type:SalariedPosted Date:2025-12-01Application Deadline:2025-12-16Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date aboveInclusion and Equal Opportunity EmploymentAt 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 CommunityStay 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.