Time since we first saw it
Day 3
Early. Similar jobs usually come down between day 6 and day 56.
From 14,766 similar postings that came down. Coming down is not always a hire.
Guelph, Ontario, Canada
Actively hiring, first seen by us 3 days agoWork setup in the employer’s posting: RemoteFrom the employer’s posting
Employment type in the employer’s posting: Permanent Full TimeFrom the employer’s posting
Handle complex Azure SQL production incidents as the senior escalation point
Tune stored procedures and indexes across the multi-tenant Core database fleet
Own the multi-tenant ELT platform from Meltano through dbt to Snowflake, orchestrated by Dagster
Build dbt models handling incremental loads, delete detection, SCD Type 2 history, and backfills
Lead the Data Work Group, assigning technical work and mentoring engineers
Act as the senior escalation point for Azure SQL production issues, stepping in on complex incidents that need staff-level diagnostic depth
Tune reporting and transactional stored procedures and indexes across a large, multi-tenant Core database fleet
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.
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.
- 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:
Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Day 3
Early. Similar jobs usually come down between day 6 and day 56.
From 14,766 similar postings that came down. Coming down is not always a hire.
1 open job
Open jobs by the week we first saw them, last 12 weeks.
Hiring recordAdd your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- 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.
- 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.
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 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.
- 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.
Assets: - Experience with Meltano and Singer taps and targets, and with maintaining open-source Python packages. - Deep Power BI semantic model and template authoring, or comparable depth in another BI tool that clients use directly.
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.
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.
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.
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Deep Power BI semantic model and template authoring, or comparable depth in another BI tool that clients use directly. - Deep expertise with Azure Container Apps, Key Vault, Log Analytics, or Azure Data Factory. - A visible record of open-source contributions in the data, dbt, Meltano, or Dagster ecosystems.
- 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.
- 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.
- 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.
- Deep expertise with Azure Container Apps, Key Vault, Log Analytics, or Azure Data Factory. - A visible record of open-source contributions in the data, dbt, Meltano, or Dagster ecosystems. - Experience in parks and recreation, reservations, permitting, ticketing, events, e-commerce, payments at scale, or public-sector SaaS is considered a strong asset.
- 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.
- Experience with Meltano and Singer taps and targets, and with maintaining open-source Python packages. - Deep Power BI semantic model and template authoring, or comparable depth in another BI tool that clients use directly. - Deep expertise with Azure Container Apps, Key Vault, Log Analytics, or Azure Data Factory.
- 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.
Complete your application on camis.bamboohr.com. The employer’s form will show what is required.
Already applied? Track this application
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
What you'll bring
Assets:
Why join Camis
How to Apply
Hiring Process Transparency
We use AI tools to support our recruitment team in reviewing applications and screening responses more consistently. These tools are designed to assist—not replace—human decision-making. They do not independently score, rank, or determine candidacy. All hiring decisions are made by our team.
Compensation
The listed salary range reflects a nationwide benchmark and the broad spectrum of pay for this role. Actual compensation will be determined based on factors such as the role's scope, complexity, and location, as well as the candidate's skills, education, experience, and credentials.
Our Commitment to Diversity & Inclusion
Camis is committed to fostering a diverse and inclusive workplace. We actively focus on attracting and retaining talent from a wide range of backgrounds, increasing awareness of diversity and its benefits, and creating a supportive environment where inclusion is expected and prioritized. We hold ourselves accountable for embedding these principles across our organization and strive to cultivate a culture where all employees feel respected, valued, and a strong sense of belonging.
New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Guelph, Ontario, Canada
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.