Senior Data Engineer - ETL Pipelines, Snowflake & Informatica
rbc · 745 Thurlow St:vancouver
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
Why are you reporting this job?
Explore further
Salaries, guides and searches in Canada.
Salaries by job title
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
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
Related job offers
-
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