Senior Data Engineer - ETL Pipelines, Snowflake & Informatica
rbc · 745 Thurlow St:vancouver
Description du poste
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
Pourquoi signalez-vous cette offre ?
Aller plus loin
Salaires, guides et recherches au Canada.
Salaires par métier
Postulez en 30 secondes
Entrez votre email pour postuler. Un compte sera cree automatiquement.
En continuant, vous acceptez nos conditions d'utilisation.
Deja un compte ? Connexion
Une question sur cette offre ?
Posez-la ici : vous recevrez le récapitulatif de l'offre par e-mail, tout de suite.
Publie il y a 2 jours
Expire dans 1 mois
7 vues · 0 interesses
Boostez vos chances
Importez votre CV : nous vous proposons les offres qui matchent votre profil.
Analyse de votre CV en cours...
rbc
745 Thurlow St:vancouver
Offres similaires
-
Director & Principal Engineer, AI/ML & MLOps Platform
rbc 745 THURLOW ST:VANCOUVER -
Lead, Full Stack Engineer - AI Engineering
rbc 745 THURLOW ST:VANCOUVER -
Senior Manager, AI Engineering (AML & Fraud)
rbc 745 THURLOW ST:VANCOUVER -
Software Applications Engineer 4
hp Vancouver -
Technical Account Manager
Axon Canada; Canada