Staff Data Engineer: Azure SQL & Snowflake ELT Leader

Camis

Guelph

Hybrid

CAD 130,000 - 170,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Competitive base salary
Group benefits including extended健康
RRSP matching
Professional development support
Open-source encouragement

Job summary

Camis is seeking a Staff Data Engineer to own data storage, movement, modeling, and governance for our Parks & Recreation platform. You will oversee Azure SQL production, Snowflake data tooling, and a multi-tenant ELT pipeline, while guiding a cross-functional Data Work Group.

You will apply AI tools with strict guardrails to ensure data privacy and production safety, supporting millions of users across North America.

Qualifications

  • 8+ years in software or data engineering with 5+ years Azure SQL work.
  • Proven T-SQL performance tuning with Query Store, Extended Events, and indexing.
  • Experience with zero-downtime schema changes in multi-tenant systems.
  • 3+ years building production ELT on Snowflake with dbt and SCD2.
  • Strong Python for pipelines and familiarity with Dagster or Airflow.
  • Experience with CI/CD and infrastructure-as-code (Terraform).
  • Data governance experience including PII masking and retention, with PIPEDA/CCPA knowledge.
  • Bachelor's degree in CS/SE or related field.

Responsibilities

  • Act as the senior escalation point for Azure SQL production issues and lead complex incidents.
  • Tune reporting and transactional stored procedures across a large multi-tenant Core fleet.
  • Own data lifecycle jobs, index maintenance, and SQL Elastic Jobs across the fleet.
  • Extend in-database monitoring with Query Store baselines and Extended Events sessions.
  • Review schema changes and migrations; block harmful changes to Core production or ELT reliability.
  • Support C# data-access layer including persistence, retry, and transaction scopes.
  • Own the multi-tenant ELT platform end-to-end: Meltano extracts, dbt loads to Snowflake, Dagster orchestrates.
  • Build and evolve dbt models on Snowflake with SCD2 and incremental loads.
  • Manage releases to prod environments and triage nightly dbt warnings.
  • Maintain Terraform for Azure and Snowflake and GitHub Actions CI/CD pipelines.
  • Maintain open-source PyPI packages elt-dagster-ext and elt-dagster-meltano.
  • Support cross-client aggregations and Power BI templates; Azure Data Factory integrations.
  • Lead the Data Work Group; mentor, set standards, and influence platform roadmap.

Skills

Azure SQL
Snowflake
dbt
Python
Dagster
Terraform
Power BI
C#
Data governance

Education

Bachelor's degree in Computer Science/Software Engineering or related field

Tools

Meltano
dbt
Dagster
Azure Container Apps
Terraform
GitHub Actions
Power BI
Azure Data Factory
SQL Server / T-SQL

Job description

Camis is seeking a Staff Data Engineer to own data storage, movement, modeling, and governance for our Parks & Recreation platform. You will oversee Azure SQL production, Snowflake data tooling, and a multi-tenant ELT pipeline, while guiding a cross-functional Data Work Group.

You will apply AI tools with strict guardrails to ensure data privacy and production safety, supporting millions of users across North America.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Staff Data Engineer
Staff Data Engineer

Camis Inc • Guelph

On-site
CAD 120,000 - 180,000
Comprehensive group benefits
RRSP matching
Professional development opportunities
+1
Staff Data Engineer
Staff Data Engineer

Camis • Guelph

Hybrid
CAD 130,000 - 170,000
Competitive base salary
Group benefits including extended健康
RRSP matching
+2
Remote Data Platform Engineer — Greenfield Snowflake & AI
Remote Data Platform Engineer — Greenfield Snowflake & AI

Race Roster • London

Hybrid
CAD 140,000 - 190,000
Senior Snowflake Data Engineer - Pipelines, SQL & Cloud
Senior Snowflake Data Engineer - Pipelines, SQL & Cloud

Compunnel Inc. • Toronto

On-site
CAD 100,000 - 130,000
Senior Data Engineer
Senior Data Engineer

Compunnel Inc. • Montreal

On-site
CAD 90,000 - 120,000
Data Engineer
Data Engineer

Compunnel Inc. • Toronto

On-site
CAD 100,000 - 130,000
Senior Software Engineer (Snowflake)
Senior Software Engineer (Snowflake)

Drillo.AI • Toronto

On-site
CAD 80,000 - 120,000
Senior Data Platform Engineer: Real-Time Snowflake
Senior Data Platform Engineer: Real-Time Snowflake

BuildOps • Toronto

Hybrid
CAD 120,000 - 197,000
Equity grant
Benefits package
Hybrid work schedules
+5
Senior Data Architect — Snowflake & Cloud Data Solutions
Senior Data Architect — Snowflake & Cloud Data Solutions

HRB • Toronto

On-site
CAD 120,000 - 160,000
Senior Snowflake Data Platform Engineer (AWS)
Senior Snowflake Data Platform Engineer (AWS)

Cvent, Inc. • Fredericton

Hybrid
CAD 90,000 - 150,000