Senior Data Engineer
RBC — 745 THURLOW ST:VANCOUVER
Posted 2026-09-29
Job Description WHAT IS THE OPPORTUNITY? CNB (City National Bank), an RBC company, is modernizing its data architecture as a core part of our digital transformation strategy. We're seeking a Senior Data Engineer to architect and build scalable, cloud-native ETL/ELT pipelines that power our enterprise data ecosystem. In this critical role, you will design end-to-end data solutions leveraging Informatica (PowerCenter/IDMC) and Snowflake, while driving our data modernization initiatives forward. You will blend traditional enterprise data warehousing concepts with modern cloud technologies, specifically leveraging Informatica (PowerCenter/IDMC) and Snowflake, while using Python for advanced scripting, customization, and automation using frameworks such as Django, FastAPI, or Flask, and proficiency in Unix/Linux scripting. WHAT WILL YOU DO? Design, build, and maintain robust batch and near-real-time ETL/ELT pipelines to ingest and transform data from diverse enterprise sources (APIs, databases, third-party systems) into Snowflake Build and optimize complex data mappings, task flows, and transformations using Informatica Intelligent Cloud Services (IICS/IDMC) or PowerCenter Manage and tu