Data Engineer

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 the data infrastructure and pipelines that power data-driven insights and applications. This role requires expertise in Google Cloud Platform (GCP) and its data services to effectively manage and process large-scale datasets.

Key Responsibilities:

• Data Ingestion and Processing: Design and implement robust data pipelines to collect, clean, transform, and store massive volumes of data using GCP services like Dataflow, Pub/Sub, and Cloud Storage.
• 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 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, Dataflow, Pub/Sub, Cloud Storage, and DataBricks.
• Data Engineering Tools: Experience with Apache Beam, Apache Airflow, or similar data pipeline orchestration tools.
• Programming Skills: Proficiency in Python or Java for data processing and pipeline development.
• Data Modeling: Expertise in data modeling techniques and schema design.
• SQL: Strong SQL skills for data querying and analysis.
• Problem Solving: Ability to analyze and solve complex data engineering challenges.

Qualifications:

• Bachelor's or Master's degree in Computer Science, Data Engineering, or a related field.
• 5+ years of experience in data engineering, with a focus on Google Cloud Platform.
• Experience with large-scale data processing and distributed systems.

Preferred Skills:

• Google Cloud Professional Data Engineer Certification.
• Experience with machine learning and data science workflows.
• Knowledge of data visualization and reporting tools.
• Strong communication and collaboration skills.
• Understanding of AI 

This Data Engineer role, with its emphasis on Google Cloud Platform expertise, is ideal for individuals passionate about building scalable and efficient data solutions to drive business insights and innovation.

Interested in this role, but don't meet every requirement? We encourage you to apply! We know from experience that a candidate doesn't need 100% of the qualifications listed to bring incredible value to our team. We're actively seeking diverse backgrounds and perspectives to help us make insurance better. At Definity, inclusion, diversity, and equity aren't just "nice to have" — they're essential to our success.

What's in it for you?

• Hybrid work schedule for most roles
• Company share ownership program
• Pension and savings programs, with company-matched RRSP contributions
• Paid volunteer days and company matching on charitable donations
• Educational resources, tuition assistance, and paid time off to study for exams
• Focus on inclusion with employee groups, support for gender affirmation surgery, access to BIPOC counsellors, access to programs for working parents
• Wellness and recognition programs
• Discounts on products and services

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.  In addition to base pay, eligible employees may participate in various incentive plans which are paid out at the discretion of the company and subject to individual and company performance.

Go ahead and expect a lot — you deserve it.
It's better here — but don't take our word for it. Definity was named by Great Place to Work® as one of the Best Workplaces™ in Canada for women, for youth, and for inclusion.

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].

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

#LI-Hybrid