hirly

Camis

Staff Data Engineer

Guelph, Ontario

hirly Pro

Get in front of the people hiring at Camis

  • Reach the hiring manager at Camis on LinkedIn, from your own account
  • hirly applies to this job for you, with unlimited applications
  • A resume and cover letter written for this job, unlimited
  • The hiring manager and recruiter at Camis, with contact details
Get Pro for this job →

$49 a month · ₹1,999 for 30 days in India · cancel any time

See how you match this job — and similar ones. Free.

Upload your resume and hirly scores it against this role at Camis first, then against similar open jobs, and shows where you fit and why.

PDF or DOCX, up to 12MB. No sign-up to see your matches.

Get past the screening software and onto a recruiter's desk

hirly rewrites your resume for this job — matching the keywords and skills in the posting, moving your most relevant experience to the top, and writing a cover letter to fit. About 30 seconds.

  • Keywords matched to this posting
  • Fit score before you apply
  • Cover letter included

Matched against 2.9M live jobs from 220,000+ employers in 200+ countries.

Tailor my resume for this job →

Apply from your AI assistant

Connect hirly to Claude or ChatGPT and ask it to apply to this job. hirly tailors your resume, fills the employer’s form and asks before sending.

Some employer sites stop an application at a CAPTCHA or sign-in and hand it back with a link. Applying needs a paid plan. Works with any assistant that supports MCP.

hirly's read of this role

Role family
Data & ML
Seniority
Lead / management
Country
CA
Work mode
On-site / unstated
First seen by hirly
18 Nov 2026

Derived automatically from the posting. Upload your resume above to see how the role scores against it.

the posting

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 Opportunity

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 judgment to platform roadmap decisions.

Act as steward for sensitive data, owning PII classification, masking policies, data dictionaries, right-to-erasure processing, and the scrubbing of non-production database copies.

Support client onboarding and offboarding, including data imports, data generation, and transition-out projects.

Write and maintain design documents and incident reviews, and take part in design reviews, code reviews, and estimation across engineering.

What you'll bring

Demonstrable, hands-on experience using AI coding tools (Claude Code, GitHub Copilot, Cursor, or comparable) to deliver production SQL, dbt, Python, and Terraform work, not experimentation or hobby use. You can speak concretely about which practices earn their keep in data engineering and which do not, and how you measure the impact on your own velocity and defect rate. You are rigorous about guardrails: PII handling, scrubbing, right-to-erasure, and production schema changes never rely on unreviewed AI output. The Camis AI tooling policy will be shared and discussed during the interview.

8+ years in software or data engineering, including 5+ years of hands-on Azure SQL work (or SQL Server at comparable scale) on large production OLTP databases, with prior experience in a multi-tenant SaaS or enterprise B2B context.

Expert T-SQL and a record of performance tuning you have measured: execution plans, statistics and cardinality, parameter sniffing, and index design. Practical diagnostic skill with Query Store, Extended Events, DMVs, wait statistics, blocking, and deadlocks.

Experience changing large, FK-heavy tables safely on live multi-tenant systems, using zero-downtime patterns (expand, migrate, contract) and leading schema releases through SSDT, DACPAC, and SqlPackage.

3+ years building production ELT on Snowflake with dbt: incremental models, SCD2, macros, tests, and dimensional or medallion modelling, plus Snowflake administration (RBAC, masking and tag policies, network policies, warehouse sizing, and cost attribution).

Solid Python for pipeline code and tooling, with experience using an orchestrator such as Dagster or Airflow, Docker, Git, CI/CD (GitHub Actions or similar), and infrastructure-as-code, ideally Terraform.

A track record of data governance work, including PII classification, access control and masking, and retention and deletion requests, with working knowledge of PIPEDA and Canadian provincial equivalents, and CCPA and comparable US state privacy frameworks.

Working command of C# / .NET data access patterns, enough to review, advise on, and occasionally contribute to the persistence layer where it meets Azure SQL.

Experience leading and mentoring a technical group, and the ability to explain a root cause or a trade-off to developers, non-technical stakeholders, and executives alike.

Bachelor's degree or equivalent diploma/certification in Computer Science, Software Engineering, or a related field.

Assets:

Experience with Meltano and Singer taps and targets, and with maintaining open-source Python packages.

Deep Power BI semantic model and template authorin

Original posting on Camis's site ↗

Listed on hirly, a job board. hirly is not the employer: Camis is hiring for this role.

Browse similar roles

Want this one?

Upload your resume and hirly rewrites it for this job and writes the cover letter — in about thirty seconds, before you sign up.

Tailor my resume for this job