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
About UsActual 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.
We also take potential into consideration. If you don’t have this exact experience, but you know you have what it takes, be sure to give us more insight through your application and cover letter.
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 contacting [email protected].
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).
#LI-Hybrid
About the TeamSkills Required
- Bachelor's or Master's degree in mathematics, computer science, software engineering, or a related field
- Minimum 3-5+ years of hands-on data engineering experience focused on pipeline development and data modeling on GCP
- Strong proficiency with Google Cloud Platform data services, including BigQuery, Cloud Storage, and Databricks
- Experience with large-scale data processing and distributed systems
- Data engineering expertise using Airflow, Cloud Composer, Apache Beam, and Python
- Advanced SQL and data modeling skills, including complex query development, optimization, schema design, and data analysis
- Ability to develop dynamic Airflow DAGs and reliable data processing solutions
- Solid understanding of Agentic AI
- Experience with Dataflow
- Google Cloud Professional Data Engineer Certification or equivalent
Definity Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Definity and has not been reviewed or approved by Definity.
-
Healthcare Strength — Coverage begins on the first day and spans medical, prescription-drug, vision, dental, paramedical, and enhanced mental-health services, with additional support for fertility, gender affirmation, life and critical-illness, and disability coverage.
-
Retirement Support — Pension and savings programs include employer-matched RRSP contributions to support long‑term financial security, and share ownership is available with the company matching employee contributions up to $1,500 annually.
-
Leave & Time Off Breadth — Vacation is supplemented by five additional personal Definity Days and two paid volunteer days each year, indicating a broad and supportive time‑off offering.
Definity Insights
What We Do
Definity Financial Corporation is the parent company to some of Canada’s most long-standing and innovative property and casualty insurance brands and companies, including Economical Insurance, Sonnet Insurance, Family Insurance Solutions, and Petline Insurance. We focus on making insurance better for our customers, our employees, our broker partners, and our communities. Our promise to employees is to provide a workplace that’s collaborative, ambitious, rewarding, and empowering. Our inclusive environment provides the space to innovate with colleagues and implement even better ways of doing things. We invest in our employees’ growth and development and help them thrive. With our flexible, hybrid work arrangements, total rewards packages, company share ownership program, and emphasis on work-life balance, it’s better here. If you’re looking for a career where your perspective and expertise are valued, you’ll find it here at Definity.
