Snowflake Data Engineer | DBT & SQL Specialist | P&C Insurance | Hybrid

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading technology company is seeking a Snowflake Data Engineer for a hybrid role in Toronto. The ideal candidate will have extensive experience with the Snowflake cloud data platform and strong SQL skills. Responsibilities include designing data processes, collaborating with teams, and mentoring juniors. This position requires a deep understanding of cloud environments and data management, along with a nice-to-have skill in Python scripting.

Qualifications

• 5+ years of experience with Snowflake cloud data platform.
• 3+ years of strong hands-on experience with DBT for modular SQL development.
• Proficient in writing complex and maintainable SQL queries.
• Experience with cloud environments like Azure and AWS.

Responsibilities

• Design and implement data extraction, transformation, and loading processes.
• Collaborate with cross-functional teams to meet data-driven business objectives.
• Mentor junior resources and share knowledge.

Skills

Snowflake cloud data platform

DBT for SQL development

SQL queries

Cloud environments (Azure, AWS)

Data extraction and transformation

Production support in data warehousing

Property and Casualty Insurance Domain

Git / Azure Devops

IT automation

Python scripting

Job description

A leading technology company is seeking a Snowflake Data Engineer for a hybrid role in Toronto. The ideal candidate will have extensive experience with the Snowflake cloud data platform and strong SQL skills. Responsibilities include designing data processes, collaborating with teams, and mentoring juniors. This position requires a deep understanding of cloud environments and data management, along with a nice-to-have skill in Python scripting.