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 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.
- Experience in parks and recreation, reservations, permitting, ticketing, events, e-commerce, payments at scale, or public-sector SaaS is considered a strong asset.
Why join Camis
- Competitive base salary.
- Comprehensive group benefits: extended health, dental, vision, and paramedical coverage.
- RRSP matching program.
- Ongoing professional development support, including conferences, certifications, and continuous learning opportunities.
- Opportunity to influence the technical direction of a platform used by leading parks and recreation agencies across North America.High-impact work solving meaningful, real-world challenges at enterprise scale.
- A collaborative engineering culture that values innovation, technical excellence, and continuous improvement.
How To Apply
- Please submit your application through Camis's careers portal, including your résumé and a brief cover letter.
- Applications will be reviewed on a rolling basis. Only candidates selected for an interview will be contacted.
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.