Own Azure SQL performance and Snowflake data platforms at Camis, applying T-SQL, dbt, Python, and Terraform in a hands-on staff-level role.
Reporting to the CTO, this Staff Data Engineer leads production database reliability and multi-tenant ELT. You will govern sensitive data, guide schema changes, and support C# data access. The role also sets standards across SQL, dbt, and pipeline engineering.
Key Responsibilities: Escalate complex Azure SQL production incidents
Tune stored procedures, indexes, statistics, and query performance
Own Meltano, dbt, Snowflake, and Dagster ELT workflows
Lead Data Work Group standards, mentoring, and technical assignments
Govern PII classification, masking, deletion, and database scrubbing
Requirements: 8+ years in software or data engineering
5+ years hands-on Azure SQL or comparable SQL Server experience
Expert T-SQL, Query Store, Extended Events, DMVs, and diagnostics
3+ years production Snowflake and dbt ELT experience
Production AI coding tools, Python, CI/CD, and infrastructure-as-code experience
Bring measured database tuning, Snowflake engineering, data governance, and technical leadership to Camis’s reservation platform.
#J-18808-Ljbffr
📌 Staff Azure SQL Data Engineer (Ontario)
🏢 Camis
📍 Ontario