Data Engineer
Passion Dental Group | Calgary, AB
About the role
We’re looking for a Data Engineer to own the pipelines that bring data from our clinics’ practice management, finance and HR systems into our Snowflake warehouse. You’ll be the second engineer on a small, high-impact data team, reporting to the Lead Data Engineer, and your work will support clinic and regional leadership as well as the AI tools our whole organization uses to ask questions of the data in plain language.
This is a hands-on role. You’ll build and run integrations, take ownership of an in-house software agent that extracts data from on-premises practice management systems, and make reconciliation to source a standard part of every pipeline. This is a senior individual contributor role with no direct reports.
What You’ll Love About This Opportunity
- Real ownership. You’ll own the ingestion layer and our in-house Dentrix agent.
- Visible impact. Your pipelines feed the Power BI reports leaders use every day.
- A say in the standards. You’ll help define what a “done” integration looks like.
- A modern stack. Snowflake, Microsoft Fabric, Python, and Snowflake Cortex AI, already in production.
- Variety. Every new clinic can bring new systems, time zones and data.
- Room to grow. Expand your scope and ownership as the network grows.
What you’ll do
- Design, build and maintain pipelines from practice management systems (ClearDent, Curve Hero, Dentrix), NetSuite, Dayforce and Smartsheet into Snowflake, using Microsoft Fabric Data Factory and Python
- Onboard each newly acquired clinic onto the platform, end-to-end
- Take over our in-house Dentrix data agent (a C# application deployed to clinics), including deployment, upgrades and per-clinic reconciliation
- Own Fabric orchestration, including our daily multi-clinic sync across four provinces and multiple time zones, with solid logging, alerting and retry behaviour
- Build data quality checks into every pipeline: row count and total reconciliation, freshness and completeness, schema-drift detection, and duplicate and timezone handling
- Share responsibility for Snowflake and Fabric administration, service accounts, cost monitoring and the platform support rotation
- Work in Git with code review and CI, document what you build, and help define what “done” means for an integration
- Raise the team’s engineering standard through code review and pairing
What you bring
- 3-5 years in data engineering, including at least 2 years owning production pipelines end to end
- Strong Python and SQL, used daily
- Production experience integrating third-party APIs and application databases into a cloud warehouse (pagination, rate limits, incremental loads, schema changes)
- Hands-on experience with Snowflake or a comparable warehouse (BigQuery, Redshift, Databricks), including RBAC and service accounts
- Production experience with an orchestration tool such as Microsoft Fabric Data Factory, Azure Data Factory, Matillion, Airflow or Dagster
- A track record of reconciling loaded data against source systems and treating it as part of “done”
- Solid engineering practice: Git, code review, automated testing, CI
- Comfort working with on-premises or Windows-hosted systems and the people who run them
- Clear written communication, including explaining a failure to a non-technical audience
Nice to have
- Microsoft Fabric experience, including OneLake and pipeline orchestration patterns
- C# or .NET
- Healthcare, dental or multi-site retail data, especially practice management or EHR systems
- Multi-location or multi-time-zone data handling
- dbt or another testing framework for warehouse models
- Matillion, our main transformation and modelling tool
- Experience in a fast-growing environment where new entities are onboarded regularly
Why Passion Dental Group?
Passion Dental Group is a Canadian dental support organization with 80+ clinics across Alberta, British Columbia, Ontario and Saskatchewan, and we’re still growing. Every clinic that joins brings new systems and new data, which makes data engineering central to how our business runs.
We're also Great Place to Work® certified, based on real feedback from our team about trust, leadership, culture, and feeling valued. It's something we're proud of and keep working to earn.
Sound like your kind of place?
Apply today and tell us a bit about what you're looking for in your next role; we'd love to chat.
