{bc}
Apply
indeed

Data Engineer

Passion Dental Group
Calgary, CAN
Full-time
Mid-Senior
Onsite
Discovered 2 days ago
Data engineeringPythonSQLProduction data pipelinesThird-party API and application database integrationSnowflake

Full Job Posting

Role overview

Own data pipelines bringing clinic practice management, finance, and HR system data into the Snowflake warehouse.

This hands-on individual-contributor role is the second engineering position on a small team and has no direct reports.

The role supports clinic and regional leaders and organizational AI tools; applicants must be located in Calgary.

Responsibilities

  • Build and maintain pipelines from ClearDent, Curve Hero, Dentrix, NetSuite, Dayforce, and Smartsheet into Snowflake using Fabric Data Factory and Python.
  • Onboard acquired clinics end to end and own the in-house C# Dentrix agent, including deployments, upgrades, and reconciliation.
  • Manage daily Fabric orchestration across clinics, provinces, and time zones, with logging, alerting, and retry behavior.
  • Implement checks for reconciliation, freshness, completeness, schema drift, duplicates, and time-zone handling.
  • Share Snowflake and Fabric administration, service-account management, cost monitoring, and platform support.
  • Use Git, code review, CI, and documentation; define integration standards and improve engineering practice through review and pairing.

Requirements

  • At least 5 years in data engineering, including at least 2 years owning production pipelines end to end.
  • Strong daily Python and SQL experience.
  • Production integrations of third-party APIs and application databases into a cloud warehouse, including pagination, rate limits, incremental loads, and schema changes.
  • Hands-on Snowflake or comparable warehouse experience, including RBAC and service accounts.
  • Production experience with an orchestration tool such as Fabric Data Factory, Azure Data Factory, Matillion, Airflow, or Dagster.
  • Experience reconciling loaded data to source systems and using Git, code review, automated testing, and CI.
  • Comfort with on-premises or Windows-hosted systems and clear written communication for technical and non-technical audiences.

Preferred experience

  • Microsoft Fabric, including OneLake and pipeline orchestration; C# or .NET.
  • Healthcare, dental, multi-site retail, practice management, or EHR data; multi-location or multi-time-zone data handling.
  • dbt or another warehouse-model testing framework; Matillion; and experience onboarding entities in a fast-growing environment.

Workplace

  • The role is based in Calgary, and applicants must be located in Calgary to be considered.

About the company

Passion Dental Group is a Canadian dental support organization with more than 80 clinics across Alberta, British Columbia, Ontario, and Saskatchewan.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Passion Dental Group

Senior Data Engineer

Calgary, CAN

Discovered 3 days agoFull-time

Dental Administrator (Kitchener, Waterloo, or Cambridge)

Kitchener, CAN

Discovered 3 days agoFull Time, Part Time

Experienced Dental Administrator (Toronto and GTA)

Toronto, CAN

Discovered 3 days agoFull Time, Part Time

CDA

Sidney, CAN

Discovered 3 days agoFull-time

Director, DeNovo Development & Onboarding

Toronto, CAN

Discovered 1 weeks agoFull-time

Registered Nurse – Dental Anesthesia & Sedation Services

Toronto, CAN

Discovered 1 months agoFull-time

Dental Administrator

Bragg Creek, CAN

Discovered 1 months agoFull-time