Data Engineer
Calgary, AB, Canada13h ago
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.
How well do you match this job?
Skills
Experience
Level
Title
Location
Salary
Freshness
Similarity
Key details
- Location
- Calgary, AB, Canada
- Work style
- Onsite
- Level
- Senior
- Experience
- 5–8 yrs
- Function
- Data & ML
- Focus area
- Data engineering & Analytics
- Posted
- 13h ago
Skills
.netairflowazure data factorybigqueryc#code reviewsdagsterdata engineeringdata qualitydatabricksdbtehrgitmicrosoft fabricmicrosoft windowsnetsuitepower bipythonrbacredshiftsmartsheetsnowflakesqltest automation
About the role
Data Engineer
Passion Dental Group | Calgary, AB
About the roleWe’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 role is based in Calgary, and applicants must be located in Calgary to be considered.
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 an 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
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.
Passion Dental Group | Calgary, AB
About the roleWe’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 role is based in Calgary, and applicants must be located in Calgary to be considered.
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 an 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
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.