📢 New: get today's jobs on our WhatsApp Channel
Jobiglo

No results.

Senior Data Engineer - ETL Pipelines, Snowflake & Informatica

rbc · 745 Thurlow St:vancouver

New
Senior 🇬🇧 English
Informatica PowerCenter Snowflake Snowpark Python PySpark SQL Git CI/CD Azure DevOps GitHub Actions AWS Azure

Job description

About the role

CNB (City National Bank), an RBC company, is modernizing its data architecture as part of its digital transformation strategy. It is looking for a Senior Data Engineer to architect and build scalable, cloud-native ETL/ELT pipelines that feed its enterprise data ecosystem. The role blends traditional data warehousing with cloud technologies, using Informatica (PowerCenter/IDMC) and Snowflake, with Python for scripting and automation.

Key responsibilities

  • Design, build and maintain batch and near-real-time ETL/ELT pipelines that ingest and transform data from APIs, databases and third-party systems into Snowflake.
  • Build and optimize data mappings, task flows and transformations in 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 and 2).
  • Set up Git-based CI/CD pipelines for database schemas, Python code and Informatica assets.
  • Implement automated data quality checks, reconciliation, audit controls and data lineage.
  • Partner with architecture, BI and data science teams and mentor junior engineers.

Required profile

  • 7-10+ years of experience in data engineering, ETL development and enterprise data warehousing.
  • 5+ years of hands-on development with Informatica PowerCenter or Informatica Cloud (IICS/IDMC).
  • 5+ years of deep Snowflake expertise, including SnowSQL, Snowpark (Python) and native cloud loading.
  • Proven experience with Git and automated deployment tools (Azure DevOps or GitHub Actions).
  • Nice to have: Snowflake or Informatica certifications, exposure to Spark/Kafka, data security and compliance knowledge, and experience preparing datasets for machine learning and AI.

Required skills

  • Advanced Python (Pandas, PySpark) and expert SQL (stored procedures, analytical functions, performance tuning)
  • Snowflake and Informatica PowerCenter or ICS/IDMC
  • Familiarity with AWS (S3, Lambda, Glue) or Microsoft Azure

What we offer

  • Total Rewards program with competitive compensation, bonuses and flexible benefits
  • Coaching, career advancement and access to learning resources
  • Work on enterprise-scale challenges with a collaborative team, with growing technical leadership roles

Questions fréquentes

Le salaire n'est pas communiqué publiquement par le recruteur. Vous pouvez postuler et négocier directement avec rbc.
Cliquez sur "Postuler maintenant" en haut de la page. Vous pouvez importer votre CV en 1 clic — Jobiglo extrait automatiquement vos informations et postule pour vous.
Source : ats:workday

Why are you reporting this job?

Thank you for your report. We will review this job.

Apply in 30 seconds

Enter your email to apply. An account will be created automatically.

Apply now →

By continuing, you accept our terms of use.

Already have an account? Login

A question about this job?

Ask it here: you will get the full job summary by e-mail, right away.

Published 2 days ago

Expires 1 month from now

8 views · 0 interested

Boost your chances

Upload your CV — we will match you with relevant openings.

Analyzing your CV...

rbc

745 Thurlow St:vancouver