# Senior Data Engineer

**Company**: CNB (City National Bank), an RBC company
**Location**: Vancouver
**Experience**: senior
**Job type**: full-time
**Category**: Engineering
**Industry**: Finance

**Apply**: https://rbc.wd3.myworkdayjobs.com/en-US/RBCGLOBAL1/job/745-THURLOW-STVANCOUVER/Senior-Manager-Data-Engineering_R-0000184832-2?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/job/senior-data-engineer-ff06e194-d71/

## Description

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.

**Responsibilities**

- 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 tune Snowflake environments, including workload management, query optimization, virtual warehouse sizing, and cost optimization

- Develop custom Python components, reusable frameworks, and PySpark scripts for advanced processing and data validation

- Implement dimensional data models, star/snowflake schemas, and Slowly Changing Dimensions (SCD Type 1 & Type 2) to support analytics requirements

- Establish and maintain automated CI/CD deployment pipelines (Git-based) for database schemas, Python code, and Informatica assets

- Design and implement automated data quality checks, reconciliation processes, audit controls, and end-to-end data lineage

- Partner with architecture, business intelligence, and data science teams to translate complex requirements into scalable technical solutions; mentor junior engineers on best practices

**Requirements**

- 7–10+ years of professional experience in data engineering, ETL development, and enterprise data warehousing

- 5+ years of hands-on development using Informatica PowerCenter or Informatica Cloud (IICS/IDMC)

- 5+ years of deep technical expertise in Snowflake, including SnowSQL, Snowpark (Python), and native cloud loading

- Advanced proficiency in Python (including libraries like Pandas or PySpark) and expert-level SQL development (stored procedures, analytical functions, performance tuning).

- Strong familiarity with cloud ecosystems such as AWS (S3, Lambda, Glue) or Microsoft Azure

- Proven experience with version control systems (Git) and automated deployment tools (Azure DevOps, or GitHub Actions).

- Strong problem-solving, analytical thinking, and excellent communication skills with the ability to collaborate across functions

**Nice-to-Have**

- Official certifications such as Snowflake Certified Core Engineer or Informatica Cloud Data Integration Specialist.

- Experience with one of cloud platforms (AWS, Azure, or GCP)

- Exposure to big data tools (Spark, Kafka, etc.)

- Understanding of data security and compliance

- Prior experience preparing and optimizing datasets for machine learning and AI initiatives.

**Benefits**

- A comprehensive Total Rewards Program including competitive compensation, bonuses, and flexible benefits

- Leaders who invest in your development through coaching and career advancement opportunities

- Ability to drive meaningful impact on RBC's data and technology strategy

- Work with a dynamic, collaborative, high-performing team on enterprise-scale challenges

- Opportunities to take on progressively greater accountabilities and technical leadership roles

- Access to learning resources and career development across RBC's business

For more fresh new jobs, check out [yubhub.co](https://yubhub.co/).

## Skills

### Required
- Informatica PowerCenter
- Informatica Cloud
- Snowflake
- Python
- PySpark
- SQL
- Git
- Azure DevOps
- GitHub Actions
- AWS
- Microsoft Azure

### Nice to have
- Snowflake Certified Core Engineer
- Informatica Cloud Data Integration Specialist
- GCP
- Spark
- Kafka

---

Source: [Apply at rbc.wd3.myworkdayjobs.com](https://rbc.wd3.myworkdayjobs.com/en-US/RBCGLOBAL1/job/745-THURLOW-STVANCOUVER/Senior-Manager-Data-Engineering_R-0000184832-2?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)