Snowflake Data Engineer - SQL, DBT, P&C Insurance

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

Job Description: Snowflake Data Engineer Toronto - Hybrid (3 Days WFO)

6-12 months

Key Accountabilities

• Deep understanding of the Snowflake cloud data platform - writing procedures, functions, UDFs, window functions etc. (5+ years)
• Strong hands‑on experience with DBT for modular SQL development, testing, and deployment. (3+ years)
• Proficient in writing complex, efficient, and maintainable SQL queries.
• Experience with cloud environments (Azure, AWS etc.) and data management technologies.
• Proven ability to design and implement data extraction, transformation, and loading processes.
• Proven experience in Production support in Data warehousing.
• Experience in Property and Casualty Insurance Domain.
• Proficiency in using Git / Azure Devops for version control of code.
• Experience with IT automation, batch scheduling using tools such as Control M and DevOps principles.
• Collaborate with cross‑functional teams to meet data‑driven business objectives.
• Mentor junior resources and share knowledge, work as a team to get requirements delivered.
• Stay updated with the latest Snowflake features and best practices.
• Nice to have skills: Python scripting.