Associate Director, Balance Sheet Analytics & Liquidity Attribution
About the role
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
About RBC
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 94,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada's biggest bank and one of the largest in the world, based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our more than 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com. We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at www.rbc.com/community-social-impact.
La Banque Royale du Canada est une institution financière mondiale définie par sa raison d'être, guidée par des principes et orientée vers l'excellence en matière de rendement. Notre succès est attribuable aux quelque 94 000+ employés qui mettent à profit leur créativité et leur savoir faire pour concrétiser notre vision, nos valeurs et notre stratégie afin que nous puissions contribuer à la prospérité de nos clients et au dynamisme des collectivités. Selon la capitalisation boursière, nous sommes la plus importante banque du Canada et l'une des plus grandes banques du monde. Nous avons adopté un modèle d'affaires diversifié axé sur l'innovation et l'offre d'expériences exceptionnelles à nos plus de 17 millions de clients au Canada, aux États Unis et dans 27 autres pays. Pour en savoir plus, visitez le site rbc.com/francais
Nous sommes fiers d'appuyer une grande diversité d'initiatives communautaires par des dons, des investissements dans la collectivité et le travail bénévole de nos employés. Pour de plus amples renseignements, visitez le site www.rbc.com/collectivite-impact-social.
Associate Director, Balance Sheet Analytics & Liquidity Attribution
About the role
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
About RBC
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 94,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada's biggest bank and one of the largest in the world, based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our more than 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com. We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at www.rbc.com/community-social-impact.
La Banque Royale du Canada est une institution financière mondiale définie par sa raison d'être, guidée par des principes et orientée vers l'excellence en matière de rendement. Notre succès est attribuable aux quelque 94 000+ employés qui mettent à profit leur créativité et leur savoir faire pour concrétiser notre vision, nos valeurs et notre stratégie afin que nous puissions contribuer à la prospérité de nos clients et au dynamisme des collectivités. Selon la capitalisation boursière, nous sommes la plus importante banque du Canada et l'une des plus grandes banques du monde. Nous avons adopté un modèle d'affaires diversifié axé sur l'innovation et l'offre d'expériences exceptionnelles à nos plus de 17 millions de clients au Canada, aux États Unis et dans 27 autres pays. Pour en savoir plus, visitez le site rbc.com/francais
Nous sommes fiers d'appuyer une grande diversité d'initiatives communautaires par des dons, des investissements dans la collectivité et le travail bénévole de nos employés. Pour de plus amples renseignements, visitez le site www.rbc.com/collectivite-impact-social.