Posted 10 hours ago
Senior Data Engineer
@ Royal Bank of Canada
Vancouver, British Columbia
Overview
Royal Bank of Canada, through its CNB (City National Bank) subsidiary, is hiring a Senior Data Engineer to build scalable cloud ETL/ELT pipelines on Informatica and Snowflake. The role is full time, salaried, and based in Vancouver, with 37.5 hours per week.
Responsibilities:
- Design and maintain batch and near-real-time ETL/ELT pipelines into Snowflake
- Build Informatica mappings, task flows and transformations
- Tune Snowflake environments and optimize costs
- Develop Python components, PySpark scripts and automated data validation
- Implement dimensional models and SCD Type 1 & 2 structures
Requirements summary:
- 7 to 10+ years in data engineering and enterprise data warehousing
- 5+ years with Informatica PowerCenter or IICS/IDMC
- 5+ years with Snowflake, including Snowpark
- Advanced Python and expert-level SQL
- Git and automated deployment experience
Tools & skills
Source and dates
Employer career site / ATS feed · phenom
- Employer posting date
- 2026-11-09
- First seen by our source
- 2026-10-09
- Source record updated
- 2026-11-10
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Software development |
| Experience | 7+ years |
| Hours per week | 37.5 |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
| Perks mentioned | Flexible hours, Performance bonus |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Royal Bank of Canada
Stock listing: TSX:RY · NYSE:RY · Source checked: 2026-11-02
Saved company profile
Historical company information from a saved The Jobs API profile (LinkedIn/Crunchbase fields). It is not live-verified; figures may have changed. Missing values remain unknown.
Full company description
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 94,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada's biggest bank and one of the largest in the world, based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our more than 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com. We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at www.rbc.com/community-social-impact. http://rbc.com/legalstuff. La Banque Royale du Canada est une institution financière mondiale définie par sa raison d'être, guidée par des principes et orientée vers l'excellence en matière de rendement. Notre succès est attribuable aux quelque 94 000+ employés qui mettent à profit leur créativité et leur savoir faire pour concrétiser notre vision, nos valeurs et notre stratégie afin que nous puissions contribuer à la prospérité de nos clients et au dynamisme des collectivités. Selon la capitalisation boursière, nous sommes la plus importante banque du Canada et l'une des plus grandes banques du monde. Nous avons adopté un modèle d'affaires diversifié axé sur l'innovation et l'offre d'expériences exceptionnelles à nos plus de 17 millions de clients au Canada, aux États Unis et dans 27 autres pays. Pour en savoir plus, visitez le site rbc.com/francais Nous sommes fiers d'appuyer une grande diversité d'initiatives communautaires par des dons, des investissements dans la collectivité et le travail bénévole de nos employés. Pour de plus amples renseignements, visitez le site www.rbc.com/collectivite-impact-social. https://www.rbc.com/conditions-dutilisation/
- LinkedIn followers
- 932,626
- People associated on LinkedIn
- 96,867
- Reported office locations
- 200 Bay Street, Toronto, Ontario M5J 2J5, CA
- 1 Place Ville-Marie, Montreal, QC H3B 1Z3, CA
- 2 Park St, Sydney, NSW 2000, AU
- 100 Bishopsgate, London, England EC2N 4AA, GB
- Persiaran Apec, Cyberjaya, Selangor 63000, MY
- 60 S 6th St, Minneapolis, MN 55402, US
- Business categories
- Wealth Management
- Commercial Lending
- Finance
- Banking
- Payments
- Asset Management
- Insurance
- Lending
- Financial Services
- Financial Exchanges
- Other recorded names
- Royal Bank of Canada
- RBC
- Specialties
- finance
- banking
- investing
- insurance
- financial planning
- wealth management
- and capital markets
- Profile identifies a recruitment agency
- No
- Reported total investment
- 22,251,000
Currency and observation date were not supplied; this is not a current valuation or a funding round.
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 94,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada's biggest bank and one of the largest in the world, based on market…
| Field | Value |
|---|---|
| Industry | Banking |
| Company size | 10,001+ employees |
| Headquarters | Toronto, Ontario |
| Organization type | Public Company |
| Specialties | financebankinginvestinginsurancefinancial planningwealth managementand capital markets |
| Open jobs on Jobsy | 1,128 |
| View page |
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?
- 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
WHAT DO YOU NEED TO SUCCEED?
Must Have:
- 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.
WHAT'S IN IT FOR YOU?
- 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
#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:
745 THURLOW ST:VANCOUVERCity:
VancouverCountry:
CanadaWork hours/week:
37.5Employment Type:
Full timePlatform:
TECHNOLOGY AND OPERATIONSJob Type:
RegularPay Type:
SalariedPosted Date:
2026-09-29Application Deadline:
2026-12-07Note: 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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.