Insurance Data Engineer Jobs in Toronto, ON (NOW HIRING)

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

Additional Job Details

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.

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.