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 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 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 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.

#J-18808-Ljbffr
Vacancy posted 3 hours ago
Similar jobs that could be interesting for youBased on the Staff Data Engineer in Guelph, ON vacancy
  •  ..., 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... 
    Suggested
    Contract work
    Internship
    Manual labor
    Flexible hours
    Night shift

    Camis Inc

    Guelph, ON
    3 hours ago
  • 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

    Guelph, ON
    3 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

    Guelph, ON
    3 hours ago
  • $69.66k - $116.1k per year

     ...our purpose. The best part is that you will work with people that care passionately about you, our clients and our communities. As a Data Scientist on the Farm Pricing and Risk Assist team, you will lead non-pricing initiatives and collaborate with business partners to... 
    Suggested
    Full time
    Work at office
    Local area
    Flexible hours

    Co-operators

    Guelph, ON
    1 day ago
  • $24 - $26 per hour

     ...Our client, a leading global machinery supplier, is seeking a Data Entry Administrator for a contract role to start immediately. The successful employee will be working 40 hours per week, fully onsite in Guelph, ON. The ideal candidate should have experience with purchase... 
    Suggested
    Contract work
    For contractors
    Work at office
    Immediate start
    Monday to friday

    Randstad Canada

    Guelph, ON
    7 days ago
  • $40 - $50 per hour

     ...Consultants is a nationally recognized engineering and environmental consulting...  ...Intune Remote Help) Manage Engine Soft Skills: Provides...  ...to the Helpdesk team and staff Excellent verbal and written...  ...more information about how your data is processed, please contact... 
    Work at office
    Remote work
    Flexible hours
    Afternoon shift

    GEI Consultants, Inc.

    Guelph, ON
    9 days ago
  •  ...Job Title: Manufacturing Engineer  Job Summary:  Reporting to the Engineering Supervisor, the successful candidate will plan and design...  ...existing and new projects while working with the manufacturing support staff.  Investigate new manufacturing and tooling methods.  Help in... 
    Internship
    Local area

    Linamar Career Site - New

    Guelph, ON
    10 days ago
  • $85k - $110k per year

     ...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... 
    Permanent employment
    Full time
    Local area
    Immediate start

    Magna International

    Guelph, ON
    9 days ago
  •  ...Job Title: Engineering Manager  Job Summary  The Engineering Manager leads Engineering teams, managing projects, budgets and resources...  ...Excellent problem-solving skills and ability to analyze complex data.   Team oriented with good ability to work cross-functionally.... 
    Internship
    Local area

    Linamar Career Site - New

    Guelph, ON
    10 days ago
  •  ...Job Title: Engineer - Project Job Summary  Work as an independent engineer, under guidance of a program manager, assigned to a task,...  ...reduce waste/rejects, and minimize downtime/cycle time Utilize data analysis techniques to identify trends, troubleshoot issues and make... 
    Internship
    Work at office
    Local area

    Linamar Career Site - New

    Guelph, ON
    10 days ago
  • $80k - $95k per year

     ...Immediate opening - $80,000 - $95,000 annual compensation - Engineering degree or comparable post-secondary education or equivalent work...  ...traditional mail to comply with GDPR requirements and your local Data Privacy Law. AI-Assisted Screening Disclosure As part of... 
    Permanent employment
    Local area
    Immediate start

    Magna International

    Guelph, ON
    10 days ago
  •  ...Job Title: Programming Engineer   Exciting opportunity available - grow your career in this dynamic role where your contributions matter...  ...decision-making Integrate plant systems with equipment, PLC data sources, and enterprise platforms Lead troubleshooting and... 
    Internship
    Local area

    Linamar Career Site - New

    Guelph, ON
    10 days 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 the...  .... Prepare datasets: cleaning, enrichment and feature engineering Assist with model integration, deployment, monitoring and retraining... 
    Contract work
    Internship
    Flexible hours

    Hammond Power Solutions

    Guelph, ON
    1 day ago
  • $45k - $50k per year

    Job Responsibility: About the Role: We are seeking a detail-oriented and organized Junior Data Entry Clerk to join our Purchasing and Logistics team. In this role, you will be responsible for accurately and efficiently entering and managing data related to orders & shipments... 
    Full time
    Casual work
    Work at office
    Monday to friday
    Flexible hours
    Shift work
    Day shift

    Fast Track

    Guelph, ON
    1 day ago
  •  ...Job Title: Senior - Automation Engineer   Job Summary The Senior Automation Engineer designs, integrates, programs, and improves...  ...timing, and performance targets. Analyze equipment performance data including failures, mean time between failures, downtime, and labour... 
    For contractors
    Internship
    Seasonal work
    Work at office
    Local area
    Monday to friday

    Linamar Career Site - New

    Guelph, ON
    10 days ago
  • $33.53 - $37.26 per hour

     ...Completion of high school and post – secondary education in Engineering. Min. 2-year technician level. Minimum one year of previous experience...  ...mail to comply with GDPR requirements and your local Data Privacy Law. AI-Assisted Screening Disclosure As part of our... 
    Hourly pay
    Permanent employment
    Local area
    Immediate start

    Magna International

    Guelph, ON
    10 days ago
  • $80k - $120k per year

     ...Immediate, open position $80,000 - $120,000 Bachelor’s degree in engineering, Materials Science, Polymer/Composite Technology, Chemical...  ...downstream process interfaces using PPSR, 8D, root cause analysis and data-driven validation, to address paint, surface appearance, cure-... 
    Permanent employment
    Full time
    Interim role
    Local area
    Immediate start

    Magna International

    Guelph, ON
    9 days ago
  • $78k - $107k per year

     ...Job Title: IoT Software Engineer  Job Summary  Reporting to the LMMS Supervisor, the IoT Software Engineer is responsible for the development...  ...support of manufacturing software solutions that leverage IoT data to improve operational performance and decision-making. The role... 
    Internship
    Local area

    Linamar Career Site - New

    Guelph, ON
    10 days ago
  •  ...Design & Validation Engineer – R&D   Position Summary: Skyjack is seeking a Design and Validation Engineer to join our Design Development...  ..., and power discharge profiles. Custom Validation Fixture & Data Acquisition Engineering: Design specialized evaluation fixtures... 
    Internship
    Local area
    Immediate start

    Linamar Career Site - New

    Guelph, ON
    10 days ago
  • $60k - $75k per year

     ...working in a manufacturing environment. Do you possess mechanical engineering experience or field tech experience? Do you love to manage...  ...Liaison between customer and company for all project objectives and data, commercial and technical requirements. Communicate with all... 
    Permanent employment
    Full time
    Casual work
    Internship
    Remote work
    Relocation
    Monday to friday
    Flexible hours

    Daltec Process Fans

    Guelph, ON
    4 days ago
  • $105.5k - $130k per year

     ...Job Responsibilities: About the Role The Paint Process Engineering Group Leader is responsible for supporting and leading the Paint...  ...implementation. Continually improve existing processes through data analysis, engineering trials, corrective actions, and continuous... 
    Permanent employment
    Full time
    For contractors
    Local area
    Immediate start
    Flexible hours

    Magna International

    Guelph, ON
    9 days ago
  •  ...Job Title: Mechanical Design Engineer  Exciting opportunity available - grow your career in this dynamic role where your contributions matter!   Job Summary  Responsible for designing new products and improving/maintaining existing products. The ideal candidate will... 
    Internship
    Local area

    Linamar Career Site - New

    Guelph, ON
    10 days ago
  •  ...Description Engineer Program Manager The Engineer Program Manager Position is responsible for independently working as a manager assigned to a task or project acting as a key customer contact to develop a clear understanding of all customer standards and scope of... 
    Full time
    Internship
    Work at office
    Local area

    Linamar

    Guelph, ON
    18 days ago
  •  ...Description Reporting to the Engineering Supervisor the successful candidate will plan and design complex manufacturing processes in an industrial plant. May improve production methods determine manufacturing capacity and set up production schedules. They will provide support... 
    Full time

    Linamar

    Guelph, ON
    9 days ago
  •  ..., services, and user experiences. Role Overview We’re inviting individuals from all backgrounds, including those searching for data entry clerk roles, to express interest in joining upcoming consumer research studies. These may include online interviews, product evaluations... 
    Part time
    Casual work
    Remote work
    Flexible hours

    ApexFocusGroup

    Guelph, ON
    more than 2 months ago
  •  ...network of Recurrent IT professionals and O&M staff, the Compliance Manager will plan,...  ...NERC compliance programs Perform periodic data submittals on behalf of clients Manage...  ...Qualifications and Experience: Bachelor's degree in engineering or technologist diploma in a related... 
    Full time
    Contract work
    Flexible hours
    Afternoon shift

    Recurrent Energy

    Guelph, ON
    7 days ago
  •  ...providing guidance and support to production staff.   Monitor production metrics and...  ...skills and ability to analyze production data.   Excellent communication and leadership...  ...global manufacturer, renowned for its advanced engineering and innovative product development across... 
    Internship
    Work at office
    Local area

    Linamar Career Site - New

    Guelph, ON
    10 days ago
  •  ...consulting firm specializing in planning, engineering, environmental science, and management. With...  ...and technical and administrative support staff. Assist with fieldwork on an as needed...  ...construction observation, monitoring and data collection activities. Ensure quality control... 
    Full time
    Work at office
    Flexible hours

    Dillon Consulting

    Guelph, ON
    5 days ago
  • $99k - $150k per year

     ...systems, developing frontline leaders, using data to improve performance, and leading change...  ...~ Post-secondary degree in Engineering, Operations, Business, or a related discipline...  ...pension plan Health Care Spending Account Staff Recognition Awards Employee and Family... 
    Long term contract
    Full time
    Immediate start
    Shift work

    Original Composites and Fibers

    Guelph, ON
    a month ago
  • $62k - $65k per year

     ...SUMMARY: THIS POSITION IS TRAIN, SUPERVISE AND WORK WITH ALL KITCHEN STAFF TO PREPARE, COOK AND PRESENT FOOD PER HOTEL STANDARD RECIPES TO...  ...~ PREPARES REPORTS, AS REQUESTED, TO DEVELOP A MORE INFORMATIVE DATA BASE FOR IMPROVED MANAGEMENT DECISION MAKING AND CRITICAL... 
    Immediate start

    Hotel Equities Group, LLC

    Guelph, ON
    14 days ago

Do you want to receive more vacancies?

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