Senior Manager, ALM Risk Transformation

What is the opportunity?

The Senior Manager will shape the next phase of our Asset-Liability Management (ALM) risk data strategy and supporting the transformation of our risk practices. This role will design, build, and optimize scalable data pipelines, data models, and analytics infrastructure to support RBC’s ALM risk and Non-Trading Portfolio Market Risk. This position bridges technical execution with strong business understanding, delivering reliable data solutions that enable timely risk insights, independent oversight, and effective implementation of RBC’s balance sheet risk framework.

What will you do?  

• Design, build, and optimize ETL/ELT pipelines that ingest, transform, and consolidate ALM risk data from multiple sources into a centralized data platform, streamlining aggregation of ALM risk exposures and reporting capabilities.
• Develop optimized SQL transformations and data architectures to support reliable market risk measures, stress testing, and regulatory reporting.
• Develop Python scripts and automation workflows to streamline data ingestion, validation, and quality controls.
• Build and maintain self-serve dashboards (Tableau/Power BI), enabling risk teams to access timely and actionable risk insights.
• Collaborate with risk managers, business partners, and IT to translate business requirements into scalable technical solutions; serve as both an independent risk fiduciary and a value-added partner to the business.
• Ensure robust data governance and lineage documentation-encompassing transformation logic, data quality frameworks, and technical architecture standards.
• Apply deep understanding of market risk concepts (sensitivity measures, stress testing, ALM frameworks) and financial products (IR derivatives, FX, repo) to inform data model design and risk infrastructure decisions.
• Lead data engineering projects end-to-end, from requirements definition and IT delivery oversight to operational documentation and process guides, navigating ambiguity and driving sound decisions.

What do you need to succeed?

Must-have

• University degree or equivalent in a quantitative, technical, or financial discipline
• Strong proficiency in Python for data pipelines, automation, and scripting
• Solid experience with SQL and relational databases (MySQL, PostgreSQL, SQL Server, or equivalent), including designing and implementing ETL/ELT workflows and data transformation logic
• Working knowledge of financial markets and products, including fixed income, linear interest rate (IR) derivatives; familiarity with market risk concepts such as sensitivity measures and stress testing
• Excellent interpersonal skills and ability to communicate complex technical concepts clearly to non-technical stakeholders, both verbally and in writing

Nice-to-have

• Expertise with Snowflake (or equivalent cloud data warehouse) and SQL optimization
• Experience with big data processes (Spark, Airflow) including batch processing and/or real-time streaming technologies is preferred.
• Deep understanding of the bank’s balance sheet composition and business lines

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• Ability to make a difference and lasting impact
• Work in a dynamic, collaborative, progressive, and high-performing team
• Opportunities to do challenging work

Job Skills

Asset and Liability Management (ALM), Balance Sheet Analysis, Cloud Computing, Data Engineering, Data ETL, Data Governance, Data Solutions, Data Warehouse, Financial Derivatives, Generative AI, Market Risk, Portfolio Analysis, Python Automation, Snowflake (Platform), Structured Query Language (SQL) Development, Tableau (Software)

Additional Job Details

ROYAL BANK PLAZA, 200 BAY ST:TORONTOTorontoCanada37.5Full timeGROUP RISK MANAGEMENTRegularSalaried2026-05-062026-05-21

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.