Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Staff Data Engineer

Camis

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 for more information on our products, services, and clients.
The OpportunityWe 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 onAzure 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.
Hiring Process TransparencyWe 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.
CompensationThe 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 & InclusionCamis 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.
#J-18808-Ljbffr
Vacancy posted 5 hours ago
Similar jobs that could be interesting for youBased on the Staff Data Engineer in Courtice, ON vacancy
  • 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... 
    Suggested

    Camis Inc

    Courtice, ON
    5 hours ago
  • Camis is seeking a Staff Data Engineer to own data storage, movement, modeling, and governance for our Parks & Recreation platform. You will oversee Azure SQL production, Snowflake data tooling, and a multi-tenant ELT pipeline, while guiding a cross-functional Data Work Group... 
    Suggested

    Camis

    Courtice, ON
    5 hours ago
  • $95k - $120k per year

     ...SLR Consulting (Canada), an 800+ team of advisory, environmental/engineering, and regulatory professionals across Canada. We deliver...  ...Making Sustainability Happen.As our new Senior Environmental Data Engineer, you will play an important role on a team whose work is... 
    Suggested
    Permanent employment
    Full time

    SLR Consulting

    Courtice, ON
    5 hours ago
  • Build enterprise data solutions with SQL and Python as a Senior Data Integration Specialist at CGIC, working hybrid with two office days weekly.Within Business Intelligence, you will engineer backend solutions across source ingestion, ETL, and data stores through the software... 
    Suggested
    Work at office

    Co-operators

    Courtice, ON
    5 hours ago
  • Build environmental data systems with SLR Consulting using C#, .NET, Azure, and EQuIS while supporting scalable client solutions. This...  ...role focuses on technical delivery.As a Senior Environmental Data Engineer, you will develop tools, reports, and workflows for environmental... 
    Suggested

    SLR Consulting

    Courtice, ON
    5 hours ago
  • Build Microsoft Fabric data pipelines and Power BI solutions in person three days weekly at Semex / Boviteq in Guelph, Ontario.This Business Intelligence Data Engineer reports to the Data Platform Lead within Information Technology. You will design, develop, test, and support... 

    Cmsa Ascv

    Courtice, ON
    5 hours ago
  • $85k per year

     ...an alternative application process. Business Intelligence (BI) Data EngineerAdministration Permanent Full Time Employee Guelph, ON,...  ...world. About the Role We are currently looking for a BI Data Engineer to fill a new role and join our Information Technology team.... 
    Long term contract
    Permanent employment
    Full time
    Temporary work
    Worldwide
    3 days per week

    Cmsa Ascv

    Courtice, ON
    5 hours ago
  • $83.77k - $133.77k per year

     ...by providing our business partners with access to comprehensive data and valuable insights to help our organization achieve operational...  ..., you will autonomously contribute to various initiatives by engineering data solutions for analytics purposes while also supporting the... 
    Long term contract
    Full time
    Work at office
    Local area
    Flexible hours

    Co-operators

    Courtice, ON
    5 hours ago
  • $96.8k - $145.2k per year

     ...technology. We currently have an opening for a Software Developer, Data and AI– 12 month contract, come grow with us! Reporting to...  .... Prepare datasets: cleaning, enrichment and feature engineering Assist with model integration, deployment, monitoring and retraining... 
    Contract work
    Internship
    Flexible hours

    Hammond Power Solutions

    Courtice, ON
    5 hours ago
  • $75k - $120k per year

     ...consulting firm specializing in planning, engineering, environmental science, and management....  ...construction observation, monitoring and data collection activities We empower our teams...  ...Input to the career development of junior staff, including technical direction, training recommendations... 
    Long term contract
    Contract work
    Work at office
    Local area
    Flexible hours

    Dillon Consulting Limited

    Courtice, ON
    5 hours ago
  •  ...drafters and technicians, technical writers, engineering technicians, and machine operators as...  ...while working with the manufacturing support staff. Interface with suppliers of raw...  ...specialized equipment and techniques. Collect data and develop statistics to describe... 
    Full time
    For contractors
    Internship
    Work at office
    Local area
    Shift work

    Linamar Corporation

    Courtice, ON
    5 hours ago
  • $110k - $130k per year

    As Sector Data and Insights Strategist , you’ll work collaboratively with OCAS, Colleges Ontario, and Ontario’s public colleges and polytechnics to identify, advance, and champion strategic data initiatives that strengthen planning, decision‑making, policy development, and... 
    Work at office
    Remote work
    Flexible hours

    OCAS

    Courtice, ON
    5 hours ago
  • Lead the enterprise data strategy as the Enterprise Data Manager at Linamar Corporation. Drive data governance, integration, and effective management of the Microsoft Fabric platform to support business operations. As a key leader in the Mobility Group, you will strategize... 

    Linamar Corporation

    Courtice, ON
    5 hours ago
  • Drive data initiatives as a Sector Data and Insights Strategist with OCAS, focusing on strengthening Ontario's college systems. Collaborate with colleges, analyze trends, and enhance student outcomes through data strategies. In this vital role, you will work collaboratively... 

    OCAS

    Courtice, ON
    5 hours ago
  •  ...resumes for the following position : Project Engineer/Leader Resume Due Date : Wednesday, May...  ...of engineering and other relevant data as required to meet the project objectives...  ...and direct discussions involving internal staff, contractors, manufacturers, suppliers and... 
    Contract work
    For contractors
    Internship
    Work at office
    Immediate start
    Shift work

    Cpus Engineering Staffing Solutions Inc.

    Courtice, ON
    5 hours ago
  •  ...equipment and machinery in conjunction with Engineering and Maintenance. Provide technical...  ...Operators, Maintenance personnel and Engineering staff. Job DescriptionJob Title: Engineer-...  ...RobotStudio and Profinet programs. Track data for performance of the automation and any... 
    Internship
    Local area

    Linamar Corporation

    Courtice, ON
    5 hours ago
  • Elevate your career with Hammond Power Solutions as a Software Developer responsible for data and AI projects. This 12-month contract role is key to creating robust data-driven solutions for effective decision-making. As part of the Software Development team, you'll be pivotal... 
    Contract work

    Hammond Power Solutions

    Courtice, ON
    5 hours ago
  • $84.85k - $134.85k per year

    Intermediate Stormwater Management Engineer Are you someone with strong leadership and technical...  ...guidance and mentorship to junior staff Project Management & Collaboration Fulfill...  ...to identify and incorporate relevant data pertaining to design criteria, hydrologic... 
    Contract work
    Flexible hours

    Dillon Consulting Limited

    Courtice, ON
    5 hours ago
  • $104k - $150k per year

     ...a visionary influencer in Water Resources Engineering who thrives in a fast‑paced consulting environment...  ...to identify and incorporate relevant data pertaining to hydrologic and hydraulic...  ...recommendations, coaching, and mentoring to junior staff. Drive technical innovation by... 
    Long term contract
    Contract work
    Temporary work
    Flexible hours

    Dillon Consulting Limited

    Courtice, ON
    5 hours ago
  •  ...resumes for the following position : Project Engineer, Turbine Commissioning Resume Due Date...  ...of engineering and other relevant data as required to meet the project objectives...  ...and direct discussions involving internal staff, contractors, manufacturers, suppliers, and... 
    Contract work
    For contractors
    Immediate start

    Cpus Engineering Staffing Solutions Inc.

    Courtice, ON
    5 hours ago
  •  ...interwoven and international. Our scientists, engineers, field teams, consultants and...  ...increasing interaction with our multi-disciplinary staff, regulatory agencies and clients. You will...  ...sciences disciplines.Direct and support field data collection exercises as well as data... 
    Contract work
    Work at office
    Work from home
    1 day per week

    LE044 Onterris Canada Inc.

    Courtice, ON
    5 hours ago
  • Job SummaryReporting to the Engineering Supervisor, the successful candidate will plan and design complex manufacturing processes in an industrial...  ...and new projects while working with the manufacturing support staff. Investigate new manufacturing and tooling methods. Help... 
    Internship
    Local area

    Skyjack Inc.

    Courtice, ON
    5 hours ago
  • $98k - $125k per year

    Engineer / Scientist – Environmental Noise & VibrationLocation: Guelph, ONJob Type: Full-Time...  ...projects. Working closely with junior staff to advance their knowledge and abilities. Support field measurement programs and data analysis as required. Applying best practices... 
    Permanent employment
    Full time
    Contract work
    Local area

    FuzeHR

    Courtice, ON
    5 hours ago
  • $75k - $115k per year

     ...Infrastructure Technical Group is looking for a Civil Engineer to fill an existing vacancy within our...  ...Advisory: Act as a trusted advisor to municipal staff, leadership, and stakeholders, translating technical data into actionable investment strategies. Project... 
    Long term contract
    Flexible hours

    Dillon Consulting Limited

    Courtice, ON
    5 hours ago
  • $82.9k - $132.9k per year

    We are seeking a Transportation Engineer to join our Transportation Infrastructure team in a full-time, position based at any of our Ontario...  ...planners, environmental scientists, technical support staff, etc.) Continuous development of technical expertise on a variety... 
    Full time
    Contract work
    Local area
    Flexible hours

    Dillon Consulting Limited

    Courtice, ON
    5 hours ago
  •  ...believe that in the age of AI, a brand is only as strong as the data behind it and the connections within it. As search evolves into...  ...LinkedIn. About the RoleSchema App is looking for a Director of Engineering to partner with our CTO in leading our engineering... 

    Schema App

    Courtice, ON
    5 hours ago
  • $110k - $150k per year

    Description Your role at GEI. The AI Engineer is responsible for the development of AI solutions, typically leveraging pretrained models...  ...cases by implementing AI-based solutions, integrating enterprise data sources, and supporting solution reliability and performance.... 
    Work at office
    Flexible hours

    Urban Ridge Supplies

    Courtice, ON
    5 hours ago
  • $85k - $110k per year

     ...across the world.Job Responsibilities: Job Profile: The Industrial Engineer is responsible for industrialization of new product launches and...  ...traditional mail to comply with GDPR requirements and your local Data Privacy Law.AI-Assisted Screening Disclosure As part of our... 
    Permanent employment
    Local area
    Immediate start

    Magna International

    Courtice, ON
    5 hours ago
  • $75k - $120k per year

    We are currently seeking an Intermediate/Senior Air Quality Engineer to join our Atmospheric Services team. Our team specializes in the...  ...professional development. Drive continuous learning and mentor junior staff in data science and digital project delivery methodologies, developing... 
    Long term contract
    Flexible hours

    Dillon Consulting Limited

    Courtice, ON
    5 hours ago
  •  ...believe that in the age of AI, a brand is only as strong as the data behind it and the connections within it. As search evolves into AI...  .... Visit Schema App at or on LinkedIn. As the Senior IT Engineer, you own Schema App's internal IT function, ensuring our endpoints... 
    Work at office

    Schema App

    Courtice, ON
    5 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Staff Data Engineer. Be the first to apply!