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
MEADOWVALE BUSINESS PARK, 6880 FINANCIAL DR:MISSISSAUGA
Mississauga
Canada
37.5
Full time
TECHNOLOGY AND OPERATIONS
Regular
Salaried
2026-06-22
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.