CareerPlan

Staff Data Engineer

Guelph, OntarioFull-time2026-11-12 → 2026-11-22

Core

Own the performance, health, and governance of Azure SQL production databases and the Snowflake data platform for a multi-tenant reservation system serving government parks.

Role type

Staff Data Engineer (Hands-on IC)

Builds

Production OLTP databases, multi-tenant ELT pipelines (Meltano/dbt/Snowflake), and data governance frameworks.

Domain

SaaS / Parks & Recreation / Data Engineering

Required skills

Azure SQL (T-SQL, performance tuning, Query Store), Snowflake (dbt, ELT, administration), Python, Terraform, C#/.NET, Data Governance (PII, masking, right-to-erasure), Team Leadership

Preferred skills

Meltano/Singer, Open-source package maintenance, Power BI semantic modeling

Technologies

Azure SQL, Snowflake, Meltano, dbt, Dagster, Terraform, GitHub Actions, C#, Python, Power BI

Responsibilities

Act as senior escalation point for Azure SQL production issues; Tune reporting and transactional stored procedures; Own data lifecycle jobs and index maintenance; Extend in-database monitoring; Review and guide schema changes/migrations; Support C# data-access layer; Own the multi-tenant ELT platform end-to-end; Manage Snowflake costs; Maintain Terraform and CI/CD pipelines; Lead the Data Work Group as technical leader; Act as steward for sensitive data (PII, masking, right-to-erasure); Support client onboarding/offboarding.

Seniority

Staff, hands-on IC with technical leadership