Time since we first saw it
Day 12
Similar jobs usually come down between day 6 and day 56.
From 14,766 similar postings that came down. Coming down is not always a hire.
Vancouver, British Columbia, Canada
Actively hiring, first seen by us 12 days agoDesign and maintain batch and near-real-time ETL/ELT pipelines into Snowflake
Build and optimize Informatica mappings, task flows and transformations
Manage and tune Snowflake environments for performance and cost
Develop Python components and PySpark scripts for processing and validation
Implement dimensional models and SCD Type 1 and Type 2 logic
Design, build, and maintain robust batch and near-real-time ETL/ELT pipelines to ingest and transform data from diverse enterprise sources
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)
Actively hiringFirst seen by us 12 days ago, still listed, and not a repost of an earlier posting.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Day 12
Similar jobs usually come down between day 6 and day 56.
From 14,766 similar postings that came down. Coming down is not always a hire.
21 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Hiring recordAdd your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
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?
- 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
- 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
- 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).
- 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
- 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).
- 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.)
- 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
- 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
- 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
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)
- Experience with one of cloud platforms (AWS, Azure, or GCP) - Exposure to big data tools (Spark, Kafka, etc.) - Understanding of data security and compliance
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
- 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
Complete your application on rbc.wd3.myworkdayjobs.com. The employer’s form will show what is required.
Already applied? Track this application
Yes. We’ve followed one other Senior Data Engineer job there since November 2026. It is still up.
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?
WHAT DO YOU NEED TO SUCCEED?
Must Have:
Nice-to-Have:
WHAT'S IN IT FOR YOU?
#LI-POST
#TechPJ
Job Skills
Collaboration, Cross-Functional Teamwork, Data Analysis, Data Analytics, Data Architecture Development, Data Development, Data Governance, Data Management, Data Processing, ETL Processing, Quality ManagementAdditional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
Our Employment Opportunities
At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One RBC. We believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.
Join our Talent Community
Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.
Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.
RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.
New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Vancouver, British Columbia, Canada
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.