Camis is a recognized industry leader in reservation and park management technology. We connect people to a world of memorable experiences through our robust, user-friendly reservation software and best-in-class call center services. Trusted by over 1,300 government-operated parks, campgrounds, harbors, and marinas across North America, Camis is dedicated to delivering innovative solutions that make it easier for visitors to discover, book, and enjoy the most beautiful landscapes.
We believe work should be fun, fulfilling, and flexible—and we're looking for friendly, motivated people to join us
Visit www.camis.com for more information on our products, services, and clients.
The Prospect
We are committed to building software that stands the test of time, and we're looking for a Staff Data Engineer to own how data is stored, moved, modelled, and governed across our Parks & Recreation platform.
This is a hands-on, staff-level engineering role reporting to the CTO. You will own two connected parts of the Camis business: the performance and health of our Azure SQL production databases (Core), and the Snowflake data platform built on top of them. When the two compete for attention, Core comes first, because Core is production.
You will be the senior escalation point for Azure SQL production issues, the owner of our multi-tenant ELT platform (Meltano to Snowflake via dbt, orchestrated by Dagster on Azure Container Apps), and the steward of sensitive data, including PII classification, masking, right-to-erasure, and the scrubbing of non-production database copies.
You will also be the formal technical leader of our Data Work Group, a cross-functional team of analysts, DevOps engineers, and co-op students. You'll set the engineering standards for SQL, dbt,
and pipeline work, and partner with product, finance, and leadership to turn questions into trusted metrics.
AI-assisted development is part of how we work at Camis. You will use AI coding tools in your day-to-day SQL, dbt, Python, and Terraform work, and apply rigorous guardrails so that changes involving personal data or production databases never rely on unreviewed AI output.
Our platform processes millions of reservations and transactions annually for agencies including Parks Canada, Ontario Parks, BC Parks, and Mississippi State Parks. The data systems you own will serve more than 30 production clients across our Canadian and US environments, and underpin real experiences for millions of visitors exploring some of North America's most treasured outdoor destinations.
What you'll be doing
- Act as the senior escalation point for Azure SQL production issues, stepping in on complex incidents that need staff-level diagnostic depth (DevOps owns first-line response).
- Tune reporting and transactional stored procedures and indexes across a large, multi-tenant Core database fleet, with hundreds of tables and thousands of stored procedures.
- Own data lifecycle jobs, index and statistics maintenance, and the SQL Elastic Jobs that run them across the fleet.
- Extend in-database monitoring using Query Store baselines, deviation alerts,
and Extended Events sessions for long-running queries, timeouts, and deadlocks.
- Review schema changes and migration scripts from other teams and guide SSDT / DACPAC deployments, with formal authority to block changes that would damage Core production or ELT reliability.
- Support the C# data-access layer, including persistence code, retry and circuit-breaker policies, and transaction scopes.
- Own the multi-tenant ELT platform end to end: Meltano extracts from each client's Azure SQL database, AWS Athena, and public APIs; dbt loads into Snowflake through staging, intermediate, and mart layers; Dagster orchestrates on Azure Container Apps.
- Build and evolve dbt models on Snowflake, handling the hard parts: incremental loads without CDC, delete detection, SCD Type 2 history, and backfills.
- Manage releases to the Canadian and US production environments and triage nightly run failures and dbt warnings.
- Keep Snowflake costs under control through warehouse sizing, a per-tenant cost-allocation model, and pruning unused models.
- Maintain the Terraform for Azure and Snowflake and the GitHub Actions CI/CD pipelines.
- Maintain the two open-source PyPI packages Camis publishes, elt-dagster-ext and elt-dagster-meltano.
- Support cross-client aggregations and the Power BI templates used by analysts and clients, along with smaller Azure Data Factory integrations.
- Lead the Data Work Group as its formal technical leader: assign technical work, provide input to performance reviews, mentor one-on-one, run team meetings, and set standards for SQL, dbt, and pipeline work.
- Partner with the CTO on technical direction for data at Camis and contribute staff-level
📌 Staff Data Engineer (Guelph)
🏢 Camis
📍 Guelph