Manager, Balance Sheet Advisory

RBC•Toronto, ON

1d•Onsite

About The Position

This position combines financial resources (Balance Sheet, RWA, Leverage, and Capital) subject matter expertise with data reporting capabilities. This position will support business stakeholders in understanding financial resource reporting while pursuing data enhancements to streamline processes and improve calculation efficacy across model reporting. The Manager , Balance Sheet Advisory will support and assist initiatives to advise on optimization opportunities for Balance Sheet, RWA, Leverage, and Capital and support the implementation of an enhanced Weekly RWA / Leverage reporting model and process, increasing the operational efficiency and imploring new and independent sources of information. This position will support the development of balance sheet analytical expertise and forward looking analytical support as well as planning and forecasting of Capital Markets’ Balance Sheet, including RWA, leverage exposure and liquidity.

Requirements

Accounting or Finance Designation including CPA, CFA, or MBA
3+ years' experience working in a Performance Management type role in a Financial Institution
Advanced level of expertise in Excel - you will need to be fully proficient in building Pivot Tables, Slicers, and debugging VBA code
Experience with MS Access, Python, and TM1 is needed.
You will need to know how to build a dashboard from scratch on Tableau.
Your SQL knowledge will need to be upper intermediate, you'll be creating tables, you will have mastered joins and data aggregation.
Strong verbal and written communication skills
Organization skills and ability to multi-tasking, attention to detail
Ability to work flexibly and to adapt to changing priorities
Exposure to Capital Markets products - you will need to understand RWA and Leverage concepts.

Responsibilities

Assist in the enhancement of data to support RWA and Leverage calculation and reporting.
Support the implementation of an enhanced Weekly RWA/ Leverage reporting model and process, increasing the operational efficiency and imploring new and independent sources of information.
Support in the development of a center of expertise related to Balance Sheet, RWA, Leverage, and Capital to advise, educate and inform a wide audience of stakeholders, with an overarching goal to initiate and implement financial resource optimization efforts to maximize resource utilization and returns.
Support the advisory to business stakeholders on areas of potential risk and capital optimization and collaborate with key stakeholders to implement optimization efforts.
Assist in the enhancement of in-depth Wholesale businesses financial resources analytics to support emerging regulatory environment and strategic business growth.
Assist in managing the planning, forecasting and strategic business (and legal entity) reviews of CM balance sheet, Risk Weighted Assets (RWA) and leverage exposure in collaboration with BU Advisors and report on the overall monthly/quarterly/annual results
Assist in the management and development of risk and returns ratios under key financial resource constraints; identify red flags and implement processes to ensure the potential impacts of such developments and potential mitigating actions are communicated to CM OC for timely entity analysis and new business proposals, driven by various stakeholders across CM, RBC HO and/or OSFI.
Support the development and maintenance of analytical models and drivers to proactively identify growth impacts on the balance sheet, clearly identify incremental value of key balance sheet lines and the potential impact on RWA/ leverage exposure growth.
Collaborate with Corporate Treasury, Wholesale Finance Control Team, and BU Advisors to understand, analyze and report on RWA and Leverage for Wholesale Businesses.
Participate in various projects as required and support and prepare monthly, quarterly and annual Head Office and Investor Relations related materials to report on consolidated CM business results, ad-hoc analysis and potential impacts and sensitivities.