Location: Toronto, ON
Salary: $80.00 CAD Hourly - $83.91 CAD Hourly
Description
Snowflake Data Engineer
Location: Toronto, ON - 5 Days onsite
1+ Year Contract to Hire
About The Role
We are seeking a highly skilled Snowflake Data Engineer to design, build, and optimize enterprise‑scale data platforms. You will lead Snowflake architecture development, build robust ELT/ETL workflows, implement governance and security, and drive automation, observability, and performance improvements across the data ecosystem.
Responsibilities
Snowflake Architecture & Development
Design and implement Snowflake data architectures including schemas, data vault, star models, materialized views, and zero‑copy cloning strategies.
Build scalable ETL/ELT pipelines using Snowpipe, Snowpark, Streams & Tasks, and modern ingestion tools (Streamsets, dbt, Fivetran, Matillion, Airbyte, etc.).
Develop Snowflake-native tools including Snowpark for Python, UDFs, external functions, and automation utilities.
Performance & Optimization
Tune query performance and cost via clustering, partitioning strategies, warehouse sizing, workload isolation, and resource monitoring.
Apply best practices for modeling, pipeline efficiency, and scalable data processing.
Governance, Security & Compliance
Implement RBAC, masking policies, lineage tracking, object tagging, and audit logging to meet governance and compliance requirements.
Maintain secure, well‑structured data environments across teams and use cases.
Automation & DevOps
Automate infrastructure deployments using Terraform or equivalent IaC tools.
Implement CI/CD pipelines (GitHub Actions, Jenkins, etc.) and automated testing for SQL and Snowpark code.
Build monitoring, alerting, incident playbooks, and cost/usage dashboards.
Leadership & Collaboration
Mentor engineers and support architectural decision‑making.
Partner with cross‑functional teams to influence platform roadmap and Snowflake best practices.
Provide operational support and continuously improve Snowflake platform reliability.
Required Qualifications
Strong hands-on experience designing and operating Snowflake in production environments.
Expertise in Snowflake features: Snowpark, Streams & Tasks, Snowpipe, Time Travel, cloning, materialized views, UDFs, external functions.
Experience developing ELT/ETL workflows with dbt, SQL, and ingestion tools (Streamsets, Fivetran, Matillion, Airbyte, Kafka connectors, etc.).
Proficiency in Python (Snowpark/connector) and advanced SQL performance tuning.
Experience with IaC and automation (Terraform, GitHub Actions, Jenkins, or similar).
Knowledge of cloud ecosystems (AWS, Azure, or GCP) and Snowflake integrations.
Strong understanding of medallion architecture, data modeling patterns, governance, and secure data sharing.
Experience implementing CI/CD and production operational best practices for data workloads.
Preferred Qualifications
Snowflake SnowPro Core or Advanced certifications.
Experience with dbt (core or Cloud).
Familiarity with data catalogs, virtualization, and lineage tools.
Experience integrating Snowflake with BI platforms (Looker, Tableau, Power BI).
Experience building internal engineering tools or Snowpark‑based data applications.
By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.
Contact: kjones05@judge.com
This job and many more are available through The Judge Group. Find us on the web at www.judge.com
