Jobs › Companies › RBC › Senior Data Engineer

Sobre este puesto de Senior Data Engineer en RBC

RBC · Presencial · 745 THURLOW ST:VANCOUVER

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 Management

Additional Job Details

Address:

745 THURLOW ST:VANCOUVER

City:

Vancouver

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-09-29

Application Deadline:

2026-10-29

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.

¿Listo para postularte en RBC?
Postúlate en RBC

Sobre RBC

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 84,000+ employees who 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 more than 16 million clients in Canada, the U.S. and 34 other countries. Learn more at rbc.com .‎ We are proud to support a broad range of community initiatives through donations, community investments and empl

Ver todos los empleos en RBC →

Empleos similares

Redwood Materials
Senior Battery Data Engineer
Redwood Materials
⚡ Postúlate pronto San Francisco, California, Uni... Presencial $172,500–$198,000
● Nuevo 👁 Visto ✓ Postulado hace 10h
Klaviyo
Senior Software Engineer - Data Automation
Klaviyo
⚡ Postúlate pronto Boston, MA Presencial $148,000–$222,000
● Nuevo 👁 Visto ✓ Postulado hace 15h
Point72
Software Engineer, Data Platform
Point72
⚡ Postúlate pronto Warsaw Presencial
● Nuevo 👁 Visto ✓ Postulado hace 15h
Egen
Lead Data Engineer- GCP
Egen
⚡ Postúlate pronto Hyderabad Híbrido
● Nuevo 👁 Visto ✓ Postulado hace 16h
Accenture
Data Engineer
Accenture
⚡ Postúlate pronto Pune Presencial
● Nuevo 👁 Visto ✓ Postulado hace 17h
Airbus
Data Ops Engineer
Airbus
⚡ Postúlate pronto Getafe Area Híbrido
● Nuevo 👁 Visto ✓ Postulado hace 18h
PwC
IN_Senior Associate_AI Data Engineer -Azure_GCC_Advisory_Bangalore
PwC
⚡ Postúlate pronto Bengaluru Millenia Presencial
● Nuevo 👁 Visto ✓ Postulado hace 18h
Placer.ai
Big Data Engineer
Placer.ai
⚡ Postúlate pronto Ramat Gan, Israel Presencial
● Nuevo 👁 Visto ✓ Postulado hace 20h
Modal
GTM Engineer - Data Platform
Modal
⚡ Postúlate pronto New York Presencial $200,000–$220,000
● Nuevo 👁 Visto ✓ Postulado hace 22h

Regístrate para recibir sugerencias adaptadas a los empleos que abres y las búsquedas que guardas.

Más empleos en RBC

Ver todos los empleos en RBC →

Postúlate ahora
🤖

Un momento — para

JobsRadar se creó para personas reales que están pasando un mal momento en su búsqueda de empleo — no para solicitudes automatizadas. Estás haciendo clic demasiado rápido y ahora estás bloqueado temporalmente.

Vuelve más tarde. Si de verdad estás buscando empleo, cuentas con nosotros — solo compórtate como una persona.

Catch your next role the second it’s posted.

Create a free account and we’ll watch the boards for you — the instant a job matches your search, it lands in your inbox or Telegram. No digging, no refreshing.

Create free account

Free forever · takes 30 seconds · already have one?

Toma ventaja en tu búsqueda de empleo.

Únete a nuestro canal de Telegram para lo que te ayuda a conseguir el puesto — referencias salariales, el pulso semanal del mercado y avisos de nuevas funciones. Sin spam, solo señal.

Únete al canal — es gratis