Job DescriptionWhat 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 SkillsCloud 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 DetailsAddress: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
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.
