Lead Data Engineer

0000055739 RBC Insurance Agency Ltd.; Toronto; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading financial institution in Toronto is seeking a Data Engineering Lead to design and implement data solutions. The ideal candidate excels in big data technologies, particularly Python and Apache Spark, while fostering engineering best practices. This role requires strong technical leadership and experience with both SQL and NoSQL databases. Join us in enhancing our data capabilities and making an impact in the financial sector.

Qualifications

• Proficient in Python and big data concepts.
• Experience with data engineering and technical leadership.
• Understanding of SQL, NoSQL, and graph databases.

Responsibilities

• Lead the design and deployment of data engineering solutions.
• Collaborate with project teams to enhance data platforms.
• Develop ETL/ELT workflows for analytics and reporting.

Skills

Python (Programming Language)

Big Data Engineering

Apache Spark

Data Warehouse Modeling

Technical Leadership

Cloud Engineering

Tools

Snowflake (Platform)

Hadoop

Databricks

Docker

Kubernetes

Job description

We’re looking for an enthusiastic engineering lead who’s excited by the opportunity of being at the forefront of machine learning technology and working on extremely challenging problems.
As a Data Engineering Lead, you’ll be responsible for owning and delivering data engineering solutions to Borealis AI project teams and its customers. Supports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies extensive, in-depth knowledge, skills, and practices to perform complex assignments.

Key Responsibilities:

• Lead the design, implementation and deployment of data engineering solutions.
• Lead efforts in extracting, transforming and loading massive datasets using distributed computing framework technologies (Hadoop, Spark etc.).
• Exposure to distributed computing frameworks (e.g. Hadoop, Spark) as well as SQL, NoSQL and graph databases.
• Have experience with writing modular, robust, scalable software in one of the modern languages such as C++, C#, Java, Python.
• Have experience with Snowflake or Databricks platforms.
• Have knowledge of professional software engineering best practices for the full software development life cycle, including testing methods, coding standards, code reviews and source control management.
• Experience with scaling and performance of large systems.
• Experience in working with business, product and other technical teams.
• Experience taking a leading role in building complex software products, fostering career growth of software engineers, and establishing software engineering best practices within your team.
• Creating software for retrieving, parsing and processing structured and unstructured data.
• Defining and building scalable ETL/ELT workflows for reporting and analytics.
• Supporting project team to scale, monitor and operate data platforms for very high availability and performance.
• Developing scripts and programs for converting various types of data into usable formats.

Must Have:

• Python (Programming Language)
• Data Warehouse Modeling
• Snowflake (Platform)
• Software Development
• Technical Leadership

Nice to Have:

• Experience with Agile development methodologies and version control systems such as Git
• Experience with containerization using Docker and Kubernetes
• Certifications in software engineering, data engineering or a related field

#TECHPJ

#Ll-POST

Job Skills

Apache Spark, Apache Spark, Big Data Concepts, Big Data Engineering, Big Data Management, Big Data Platforms, Cloud Computing, Cloud Engineering, Database Development, Data Mining, Data Modeling, Data Warehouse Modeling, Data Warehousing (DW), Dimensional Data Modeling, ETL Processing, Group Problem Solving, Microsoft Azure, Object-Oriented Software Development, Python (Programming Language), Python for Data Analysis, Python Frameworks, Python Software Development, Quality Management, Relational Data Modelling, Requirements Analysis {+ 3 more}

Job Summary

Job Description

Data Engineer

What is the opportunity?

We’re looking for an enthusiastic engineering lead who’s excited by the opportunity of being at the forefront of machine learning technology and working on extremely challenging problems.
As a Data Engineering Lead, you’ll be responsible for owning and delivering data engineering solutions to Borealis AI project teams and its customers. Supports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies extensive, in-depth knowledge, skills, and practices to perform complex assignments.

Key Responsibilities:

• Lead the design, implementation and deployment of data engineering solutions.
• Lead efforts in extracting, transforming and loading massive datasets using distributed computing framework technologies (Hadoop, Spark etc.).
• Exposure to distributed computing frameworks (e.g. Hadoop, Spark) as well as SQL, NoSQL and graph databases.
• Have experience with writing modular, robust, scalable software in one of the modern languages such as C++, C#, Java, Python.
• Have experience with Snowflake or Databricks platforms.
• Have knowledge of professional software engineering best practices for the full software development life cycle, including testing methods, coding standards, code reviews and source control management.
• Experience with scaling and performance of large systems.
• Experience in working with business, product and other technical teams.
• Experience taking a leading role in building complex software products, fostering career growth of software engineers, and establishing software engineering best practices within your team.
• Creating software for retrieving, parsing and processing structured and unstructured data.
• Defining and building scalable ETL/ELT workflows for reporting and analytics.
• Supporting project team to scale, monitor and operate data platforms for very high availability and performance.
• Developing scripts and programs for converting various types of data into usable formats.

Must Have:

• Big Data Engineering
• Big Data Concepts
• Relational Data Modelling
• Python (Programming Language)
• Data Warehouse Modeling
• Snowflake (Platform)
• Software Development
• Technical Leadership
• Cloud Engineering
• Apache Spark

Nice to Have:

• Experience with Agile development methodologies and version control systems such as Git
• Experience with containerization using Docker and Kubernetes
• Certifications in software engineering, data engineering or a related field

#TECHPJ

#Ll-POST

Job Skills

Apache Spark, Apache Spark, Big Data Concepts, Big Data Engineering, Big Data Management, Big Data Platforms, Cloud Computing, Cloud Engineering, Database Development, Data Mining, Data Modeling, Data Warehouse Modeling, Data Warehousing (DW), Dimensional Data Modeling, ETL Processing, Group Problem Solving, Microsoft Azure, Object-Oriented Software Development, Python (Programming Language), Python for Data Analysis, Python Frameworks, Python Software Development, Quality Management, Relational Data Modelling, Requirements Analysis {+ 3 more}

Additional Job Details

Address:

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO

City:

TORONTO

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2025-07-30

Application Deadline:

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 .

About Us

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 84,000+ employees who bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada’s biggest bank, and one of the largest in the world based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to more than 16 million clients in Canada, the U.S. and 34 other countries. Learn more at rbc.com .

We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at rbc.com/community-social-impact .