Data Engineer: Snowflake, dbtCore, AWS | Hybrid

Aviva plc; Markham; Hybrid; CAD 100,000 - 125,000; Full time

Benefits offered by this job

Health benefits

Share plan

Retirement savings

Hybrid work model

Volunteer opportunities

Job summary

Aviva Canada is seeking a Data Engineer to power analytics and AI initiatives on our Snowflake platform. You will build robust data pipelines, implement governance, and collaborate across cross-functional teams to deliver scalable data solutions.

Bring 6+ years of data project experience, 3+ years with Snowflake and dbt, strong SQL/Python skills, and a customer-centric mindset. Hybrid work model and competitive benefits are provided.

Qualifications

• Six+ years delivering data projects from inception through warranty.
• Three+ years with Snowflake, dbt Core/Cloud and AWS Cloud.
• Expert in SQL, Python, Shell, and Terraform with performance focus.

Responsibilities

• Lead design and implementation of high-performance data pipelines with dbt and Snowflake.
• Write and maintain clean, reusable code in SQL, Python, Shell, and Terraform.
• Champion data quality, governance, and cataloging; review test plans.
• Perform root cause analysis and implement solutions for complex data issues.
• Lead agile ceremonies and ensure timely delivery of data initiatives.
• Mentor Data Engineers and project team members to raise engineering quality.
• Collaborate with architects, designers, QA, and delivery teams on data products.
• Produce and maintain technical documentation for implementation and knowledge sharing.

Skills

Snowflake

dbt Core/Cloud

AWS Cloud

SQL

Python

Data pipelines

Data governance

Tools

dbt Core/Cloud

Terraform

Airflow

Snowsight

Job description

Aviva Canada is seeking a Data Engineer to power analytics and AI initiatives on our Snowflake platform. You will build robust data pipelines, implement governance, and collaborate across cross-functional teams to deliver scalable data solutions.

Bring 6+ years of data project experience, 3+ years with Snowflake and dbt, strong SQL/Python skills, and a customer-centric mindset. Hybrid work model and competitive benefits are provided.