Data Engineer (18 month contract)
Top Benefits
About the role
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 Data Engineer is a critical role responsible for designing, building, and maintaining timely and robust pipelines and data assets that enable data-driven insights and applications.
Working in close collaboration with other data teams, the Data Engineer seamlessly integrates new data assets with existing data products.
The Data Engineer maximizes productivity by developing flexible and reusable data pipeline code through dynamic configuration and templating, enabling rapid adaptation to new data sources and avoidance of development overhead.
The Data Engineer maintains a high level of professional integrity by producing clean, modular, and well-documented code that promotes collaboration, reduces operational overhead, and accelerates future development efforts.
This role requires expertise in Google Cloud Platform (GCP) and its data services to effectively manage and process large-scale datasets.
This is a 18 month contract role.
Key Responsibilities:
-
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.
Required Skills:
-
Google Cloud Platform (GCP): Strong proficiency in GCP data services, including BigQuery, Cloud Storage, and DataBricks. Experience with Data Flow is an asset.
-
Data Engineering Tools: Hands-on experience with Cloud Composer, Apache Beam, Apache Airflow, or similar data pipeline orchestration tools. Ability to author dynamic DAGs in Airflow is a key skill for this role.
-
Programming Skills: Strong proficiency in Python for data processing and pipeline development is essential for this role.
-
SQL: Expert level SQL skills for data analysis, complex query development and optimization.
-
Data Modeling: Expertise in data modeling techniques and schema design.
Problem Solving: Ability to analyze and solve complex data engineering challenges.
Qualifications:
-
Bachelor's or Master's degree in 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.
Preferred Skills:
-
Experience with machine learning and data science workflows.
-
Knowledge of data visualization and reporting tools.
-
Strong communication and collaboration skills.
Understanding of AI
Salary Range : $69,000 - $127,000
#IND1
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.
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: accessibility@definity.com .
Background checks
This role requires successful clearance of a background check (including criminal checks and leadership references).
#LI-Hybrid
About Definity
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.
La Société financière Definity est la société mère de compagnies d’assurance de dommages parmi les plus établies et innovatrices au Canada, soit Assurance Economical, Sonnet Assurance, Family Insurance Solutions et la Compagnie d’assurance Petline. Definity est dévouée à faire évoluer l’assurance pour sa clientèle, ses équipes, son réseau de courtage et ses communautés.
Nous promettons de fournir un environnement de travail collaboratif, ambitieux, valorisant et stimulant. Notre environnement inclusif vous permet d’innover avec vos collègues et de mettre en œuvre de meilleures façons de travailler. Nous investissons dans la croissance et le perfectionnement de nos gens et les aidons à s’épanouir. Grâce à nos options flexibles de travail hybride, notre programme de rémunération globale, notre régime d’actionnariat et l’accent sur l’équilibre travail-famille, vous évoluerez avec nous.
Si vous souhaitez une carrière où votre point de vue sera reconnu, ne cherchez pas plus loin que Definity.
Data Engineer (18 month contract)
Top Benefits
About the role
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 Data Engineer is a critical role responsible for designing, building, and maintaining timely and robust pipelines and data assets that enable data-driven insights and applications.
Working in close collaboration with other data teams, the Data Engineer seamlessly integrates new data assets with existing data products.
The Data Engineer maximizes productivity by developing flexible and reusable data pipeline code through dynamic configuration and templating, enabling rapid adaptation to new data sources and avoidance of development overhead.
The Data Engineer maintains a high level of professional integrity by producing clean, modular, and well-documented code that promotes collaboration, reduces operational overhead, and accelerates future development efforts.
This role requires expertise in Google Cloud Platform (GCP) and its data services to effectively manage and process large-scale datasets.
This is a 18 month contract role.
Key Responsibilities:
-
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.
Required Skills:
-
Google Cloud Platform (GCP): Strong proficiency in GCP data services, including BigQuery, Cloud Storage, and DataBricks. Experience with Data Flow is an asset.
-
Data Engineering Tools: Hands-on experience with Cloud Composer, Apache Beam, Apache Airflow, or similar data pipeline orchestration tools. Ability to author dynamic DAGs in Airflow is a key skill for this role.
-
Programming Skills: Strong proficiency in Python for data processing and pipeline development is essential for this role.
-
SQL: Expert level SQL skills for data analysis, complex query development and optimization.
-
Data Modeling: Expertise in data modeling techniques and schema design.
Problem Solving: Ability to analyze and solve complex data engineering challenges.
Qualifications:
-
Bachelor's or Master's degree in 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.
Preferred Skills:
-
Experience with machine learning and data science workflows.
-
Knowledge of data visualization and reporting tools.
-
Strong communication and collaboration skills.
Understanding of AI
Salary Range : $69,000 - $127,000
#IND1
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.
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: accessibility@definity.com .
Background checks
This role requires successful clearance of a background check (including criminal checks and leadership references).
#LI-Hybrid
About Definity
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.
La Société financière Definity est la société mère de compagnies d’assurance de dommages parmi les plus établies et innovatrices au Canada, soit Assurance Economical, Sonnet Assurance, Family Insurance Solutions et la Compagnie d’assurance Petline. Definity est dévouée à faire évoluer l’assurance pour sa clientèle, ses équipes, son réseau de courtage et ses communautés.
Nous promettons de fournir un environnement de travail collaboratif, ambitieux, valorisant et stimulant. Notre environnement inclusif vous permet d’innover avec vos collègues et de mettre en œuvre de meilleures façons de travailler. Nous investissons dans la croissance et le perfectionnement de nos gens et les aidons à s’épanouir. Grâce à nos options flexibles de travail hybride, notre programme de rémunération globale, notre régime d’actionnariat et l’accent sur l’équilibre travail-famille, vous évoluerez avec nous.
Si vous souhaitez une carrière où votre point de vue sera reconnu, ne cherchez pas plus loin que Definity.