Data Engineer (Contract-Dec 2027)

Economical; Southwestern Ontario; Hybrid; CAD 92,000 - 142,000; Full time

Job summary

Definity is looking for a Data Engineer to design, build, and maintain scalable data pipelines on Google Cloud Platform, partnering with cross-functional teams to empower data-driven decisions. The role emphasizes reusable frameworks, clean code, and cost-aware optimization, with exposure to BigQuery, DataBricks, and related GCP services.

You will contribute to data ingestion, warehousing, and modeling efforts, collaborating with data scientists and analysts while working in a hybrid environment

Qualifications

• Bachelor's or Master's degree in Math, CS, or Software Engineering.
• 3–5+ years of hands-on data engineering on Google Cloud Platform.
• Experience with large-scale data processing and distributed systems.
• Proficiency in SQL and data modeling; Airflow experience is a plus.

Responsibilities

• Design, build, and maintain scalable data pipelines on GCP.
• Develop data warehouses on Google BigQuery for analytics.
• Design scalable data models to support BI and ML applications.
• Create and optimize ETL/ELT processes with GCP tools.
• Collaborate with data scientists and analysts to deliver data solutions.

Skills

GCP BigQuery

Cloud Storage

DataBricks

Dataflow

Airflow DAGs

Python

Apache Beam

Cloud Composer

SQL

Distributed Systems

GCP Certification

Agentic AI

Education

Bachelor's/Master's in Math/CS/SE

Tools

Airflow

Cloud Composer

Apache Beam

Python

SQL

Job description

Definity is the parent company to some of Canada’s most long-standing and innovative insurance brands, including Economical Insurance, Sonnet Insurance, Family Insurance Solutions, and Petline Insurance. Our ambition is to be one of Canada’s leading and most innovative property and casualty insurers. We can’t do that without our people, so we embrace and encourage a culture that’s collaborative, ambitious, rewarding, and empowering.

We offer a flexible, hybrid work experience where employees work from the office and virtually depending on the type of work they are doing and who they are working with. Bring your true self and be a part of our journey. It’s better here.

The Opportunity

The Data Engineer is responsible for designing, building, and maintaining scalable data pipelines and data assets that support data-driven decision making across the organization. Working closely with cross-functional data teams, they integrate new data sources into existing data products while leveraging GCP technologies to manage and process large-scale datasets. The role focuses on developing reusable, configurable, and efficient data pipeline frameworks, as well as producing clean, modular, and well-documented code that enhances collaboration, reduces operational overhead, and accelerates future development.

What to Expect

• Data Ingestion and Processing: Design and implement robust data pipelines to collect, clean, transform, and store large volumes of data using GCP services like BigQuery and Cloud Storage, as well as DataBricks
• Data Warehousing and Analytics: Build and optimize data warehouses on Google BigQuery for efficient data analysis and reporting.
• Data Modeling: Design and implement scalable data models to support strategic data products, business intelligence, and machine learning applications.
• ETL/ELT Development: Develop and maintain Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) processes using GCP tools.
• Performance Optimization: Continuously monitor and optimize data pipelines and queries for performance and cost-effectiveness.
• Collaboration: Work closely with data scientists, analysts, and other stakeholders to understand data requirements and deliver data solutions.
  

What you Bring:

• Google Cloud Platform (GCP): Strong proficiency in GCP data services, including BigQuery, Cloud Storage, and DataBricks. Experience with Dataflow is an asset.
• Bachelor's or Master's degree in Math, Computer Science, Software Engineering, or a related field.
• Minimum 3-5+ years of experience in a hands-on data engineering role, with a focus on pipeline development and data modeling on Google Cloud Platform.
• Experience with large-scale data processing and distributed systems.
• Google Cloud Professional Data Engineer Certification or equivalent is a strong asset for this role.
• Strong data engineering expertise, building and orchestrating scalable data pipelines using Airflow, Cloud Composer, Apache Beam, and Python.
• Advanced SQL and data modeling skills, including complex query development, optimization, schema design, and data analysis.
• Proven ability to develop dynamic Airflow DAGs and robust data solutions that support efficient, reliable data processing.
• Solid understanding of Agentic AI

Salary Range: $92,000-$142,000

Actual salary for the role may vary depending on work location of the successful candidate and other factors including but not limited to, skills, education, experience, working conditions and the local labour market.

This position is being posted to fill an existing vacancy.

Our inclusive work environment welcomes diversity and supports accessibility. If you require accommodation at any time during the recruitment process, please let us know by [e-mail].

As part of Definity’s commitment to reconciliation, we acknowledge that our work, meetings, and travel take place on the lands now known as Canada, and recognize the enduring presence, wisdom, and stewardship of the First Nations, Métis, and Inuit peoples who have long cared for these lands.

Background checks

This role requires successful clearance of a background check (including criminal checks and leadership references).

• Job Identification 9418
• Job Category Data, Analytics and Business Intelligence