Snowflake Data Engineer

Job Title: Snowflake Data Engineer

Location:
Toronto, ON (Hybrid – 3 Days Work from Office)

Duration:
6–12 Months Contract

Role Overview

We are seeking an experienced
Snowflake Data Engineer
to design, develop, and support scalable data solutions within a cloud-based data ecosystem. The ideal candidate will bring strong expertise in
Snowflake, DBT, and Enterprise Data Warehousing (EDW)
, along with hands-on experience in
production support and batch scheduling tools
. Experience in the
Property & Casualty Insurance domain
and Agile delivery environments is highly preferred.

Key Responsibilities

- Design, develop, and maintain data pipelines and solutions using the
Snowflake cloud data platform
.
- Develop and optimize
stored procedures, functions, UDFs, and window functions
in Snowflake.
- Utilize
DBT (Data Build Tool)
for modular SQL development, testing, and deployment.
- Write complex, efficient, and scalable
SQL/PLSQL queries
for data transformation and analysis.
- Design and implement
ETL/ELT processes
to support enterprise data warehousing solutions.
- Provide
production support
for data pipelines and resolve issues in a timely manner.
- Manage and schedule batch processes using tools such as
Control-M
.
- Collaborate with cross-functional teams to deliver
data-driven business solutions
.
- Participate in Agile ceremonies including sprint planning, stand-ups, and retrospectives.
- Maintain code versioning and deployment using
Git / Azure DevOps
.
- Mentor junior team members and promote knowledge sharing within the team.
- Stay current with the latest
Snowflake features, best practices, and industry trends
.

Required Skills & Qualifications

- 5+ years of experience working with the
Snowflake data platform
.
- 3+ years of hands-on experience with
DBT
.
- Strong expertise in
SQL/PLSQL
with the ability to write complex queries.
- Experience with
Enterprise Data Warehousing (EDW)
concepts and implementations.
- Hands-on experience with
cloud platforms
such as AWS or Azure.
- Experience in
production support
within data warehousing environments.
- Proficiency in
batch scheduling tools
such as Control-M.
- Experience with
version control tools
(Git, Azure DevOps).
- Strong understanding of
Agile methodologies
.
- Excellent analytical, problem-solving, and communication skills.

Preferred Qualifications

- Experience in the
Property & Casualty Insurance domain
.
- Knowledge of
Python scripting
.
- Familiarity with
DevOps practices and automation frameworks
.

Additional Requirements

- Willingness to provide
weekend support on a rotational basis
.

Keywords

Snowflake, DBT, Data Engineering, SQL, PL/SQL, ETL/ELT, Control-M, Azure, AWS, EDW, Agile, Data Warehousing