Overview The Senior Manager will shape the next phase of our Asset‑Liability Management (ALM) risk data strategy and support 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.

Responsibilities

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.<...