Data Engineer – Snowflake

High Tech Genesis; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

High Tech Genesis in Toronto, Canada is seeking a Data Engineer specializing in Snowflake to design and optimize scalable cloud data solutions. You will implement modern data pipelines, leverage Snowflake features, and collaborate with cross-functional teams to deliver secure, cost-efficient data warehousing.

The role emphasizes hands-on development with Python and SQL, Snowflake-native apps, and best practices in data governance.

Qualifications

• Minimum 5+ years of data engineering experience with Snowflake.
• Strong Python and SQL proficiency.
• Experience building scalable data pipelines and warehousing.
• Familiarity with CI/CD and IaC.
• Knowledge of data governance and security best practices.

Responsibilities

• Design and implement scalable Snowflake data architectures.
• Build and maintain ETL/ELT pipelines using Snowpipe, Snowpark, and dbt.
• Develop Snowflake-native apps, UDFs, and automation tools.
• Optimize performance, cost, and security on Snowflake.
• Collaborate with engineering teams and support platform enhancements.
• Implement CI/CD and Infrastructure as Code practices.
• Ensure data governance and quality across platforms.

Skills

Snowflake

Snowpark

Snowpipe

dbt

Python

SQL

ETL pipelines

Cloud platforms

Terraform

CI/CD

Data modeling

Data governance

Query optimization

Tools

Fivetran

Matillion

Airbyte

StreamSets

AWS

Azure

GCP

Job description

Overview

We are looking for a Data Engineer - Snowflake to design, build, and optimize scalable cloud data solutions. The ideal candidate has strong experience with Snowflake, modern data pipelines, Python, SQL, and cloud platforms

Key Responsibilities

• Design and implement scalable Snowflake data architectures.
• Build and maintain ETL/ELT pipelines using Snowpipe, Snowpark, Streams & Tasks, and dbt.
• Develop Snowflake-native applications, UDFs, and automation tools.
• Optimize performance, cost, and security within the Snowflake platform.
• Implement CI/CD, Infrastructure as Code, and data governance best practices.
• Collaborate with engineering teams and support platform enhancements.
• 5+ years of data engineering experience with hands-on Snowflake expertise.
• Strong experience with Snowpark, Snowpipe, Streams & Tasks, SQL, and Python.
• Experience with dbt and ETL/ELT tools such as Fivetran, Matillion, Airbyte, or StreamSets.
• Knowledge of Terraform, CI/CD, and AWS, Azure, or GCP.
• Strong understanding of data modeling, governance, and query optimization.

Nice to Have

• Snowflake SnowPro Certification.
• Experience with Tableau, Power BI, or Looker.
• Knowledge of data lineage or catalog tools.