Lead Portfolio Data Engineer

RBC Insurance; Toronto; On-site; CAD 110,000 - 130,000; Full time

Job summary

As a Lead Portfolio Data Engineer at RBC Insurance, you will support the development of scalable data stores that supply big data needed for business analysis. The role requires in-depth knowledge of data engineering, particularly in Snowflake, along with skills in SQL and data modeling.

Benefits

Comprehensive Total Rewards Program including bonuses and flexible benefits

Access to RBCI software tools

Support for professional development

Work in a high-performing team

Opportunities for career progression

Qualifications

• 3+ years of experience in data engineering.
• Strong SQL skills.
• Experience with Snowflake schema design and data modeling.

Responsibilities

• Design, build, and maintain data extraction pipelines.
• Develop scalable data models in Snowflake.
• Implement data quality frameworks in snowflake pipelines.

Skills

Big Data Management

Cloud Computing

Data Mining

Database Development

Data Warehousing

ETL Processing

Education

Bachelor’s or master’s degree in computer science, data science, information systems or related field

Tools

Snowflake

Tableau

Job description

Join to apply for the Lead Portfolio Data Engineer role at RBC Insurance

1 week ago Be among the first 25 applicants

Join to apply for the Lead Portfolio Data Engineer role at RBC Insurance

Get AI-powered advice on this job and more exclusive features.

What is the opportunity?

As a Lead Portfolio Data Engineer, you will support the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. You will apply extensive, in-depth knowledge, skills, and practices to perform complex assignments.

Job Summary

Job Description

What is the opportunity?

As a Lead Portfolio Data Engineer, you will support the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. You will apply extensive, in-depth knowledge, skills, and practices to perform complex assignments.

What will you do?

• Design, build, and maintain extracts and design pipelines to ingest and transform data from investment and ALM systems (e.g. Bloomberg, custodians, etc)
• Structure data for optimal Tableau performance using Snowflake as the core data platform.
• Clean, enrich and normalize investment data such as holdings, inventory, benchmarks, dealers’ pricing, and risk metrics for analysis.
• Develop and maintain scalable data models and schema design in snowflake to support various analytics
• Implement data quality frameworks, validation and exception rules in snowflake pipelines.
• Leverage features in Snowflake for automation, recovery and auditing.
• Partner with Tableau Developers, machine learning developer, and other function partner to translate business requirements into reliable, well-structured data models.
• Automate and optimize query performance and data refresh cycles to meet the business requirement for dashboard and reports.
• Develop reusable pipelines for recurring process such as benchmark imports, yield curve updates, and daily position update.
  
  

What do you need to succeed?

Must-have

• Bachelor’s or master’s degree in computer science, data science, information systems or related field.
• 3+ year of experience in data engineering with working with Snowflake.
• Strong SQL skills and advanced experience in Snowflake schema design, data modeling, and performance tuning
• Experience pulling data from Bloomberg AIM
• Experience integrating investment data into BI environments like Tableau.
  
  

Nice-to-have

• Programming proficiency in Python, R, or similar for model development and data analysis.
• Understanding investment data concepts, such as holdings, prices, risk metrics.
• Excellent communication skills and ability to collaborate across investment, risk and other functional partners.
  
  

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including bonuses and flexible benefits and competitive compensation
• RBCI software tools to boost your productivity
• Leaders who support your development through coaching and managing opportunities
• Work in a dynamic, collaborative, progressive, and high-performing team
• Opportunities to take on progressively greater accountabilities
• Access to a variety of job opportunities across business and geographies
  
  

Job Skills

Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Quality Management, Requirements Analysis

Additional Job Details

Address:

RBC CENTRE, 155 WELLINGTON ST W:TORONTO

City:

TORONTO

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

INSURANCE

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2025-05-23

Application Deadline:

2025-06-06

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At 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

Seniority level

• Seniority level

  Not Applicable

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Insurance, Banking, and Financial Services

Referrals increase your chances of interviewing at RBC Insurance by 2x

Sign in to set job alerts for “Data Engineer” roles.

Mississauga, Ontario, Canada CA$110,000.00-CA$130,000.00 2 weeks ago

Richmond Hill, Ontario, Canada 1 month ago

Software Engineer, Backend (All Levels / All Teams)

Toronto, Ontario, Canada CA$120,000.00-CA$190,000.00 2 weeks ago

Mississauga, Ontario, Canada CA$70,000.00-CA$85,000.00 1 month ago

Ai and Data - Senior - Data Engineer - Toronto and Ottawa

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.