Senior Data Engineer

Job Description

What is the opportunity?

Join RBC Insurance Online Experience squad to design and maintain enterprise data solutions for our customer data platform and online analytics. You'll work with technology professionals delivering scalable analytics infrastructure for the Insurance business and our clients. We embrace Agile development, DevOps, and modern cloud-native tools. This role offers the opportunity to make a real difference by architecting data pipelines, optimizing ETL processes, and enabling analytics that directly impact RBC's success. You'll partner across IT and business lines to solve complex data challenges while building resilient, high-performance systems that serve RBC staff and clients.

What will you do?

• Understand and support our Tealium Customer Data Platform (CDP) and Amplitude analytics tooling.

• Build and optimize ETL/ELT pipelines to ingest, transform, and load data from multiple sources

• Utilize enterprise data warehouse platforms, including Snowflake and Teradata solutions.

• Develop and maintain data models, dimensional schemas, and data transformation logic to support business intelligence and analytics

• Implement data governance, quality checks, and performance tuning across warehouse environments

• Collaborate with cross-functional teams including analytics, business stakeholders, and IT to ensure data availability and integrity

• Troubleshoot and resolve technical issues related to data ingestion, transformation, and query performance

• Develop and maintain comprehensive documentation of data architectures, lineage, and technical configurations

What do you need to succeed?

Must Have

• 3+ years of experience in data engineering, data warehousing, or analytics with focus on enterprise platforms

• Strong hands-on experience with Snowflake and/or Teradata, including data modeling, performance tuning, and system optimization

• Knowledge of CDP and online analytics tools and concepts

• Proficiency in SQL and at least one programming language (Python, Java, or Scala)

• Experience designing and implementing ETL/ELT processes and data pipelines

• Strong understanding of data governance, data quality, security, and compliance principles

• Proven problem-solving skills with ability to troubleshoot complex technical issues

Nice to Have

• Experience with cloud platforms (AWS, Azure, or Google Cloud) and modern data stack tools

• Familiarity with agile development methodologies and version control systems (e.g., Git)

• Snowflake or Teradata certifications

• Familiarity with Salesforce applications including Salesforce Financial Services cloud and Salesforce Marketing cloud.

• Demonstrated adaptability, critical thinking skills, and a growth mindset

What's in it for you?

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable

• Leaders who support your development through coaching and career opportunities

• Ability to make a difference and create lasting impact. Work in a dynamic, collaborative, progressive, and high-performing team

• A world-class training program in financial services Flexible work/life balance options

• Opportunities to do challenging work

• Opportunities to take on progressively greater accountabilities

• Opportunities to building close relationships

• Access to a variety of job opportunities across business and geographies

#LI-Post

#TechPJ

Job Skills

Cloud Computing, Data Architecture Development, Database Development, Data Mining, Data Modeling, Data Pipelines, Data Warehousing (DW), ETL Processing, Extract Transform Load (ETL), Group Problem Solving, Quality Management, Requirements Analysis

Additional Job Details

Address:

MEADOWVALE BUSINESS PARK, 6880 FINANCIAL DR:MISSISSAUGA

City:

Mississauga

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-06-22

Application Deadline:

2026-07-31

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.