Who We Are
HealthPRO Canada is the country’s national solutions partner, supporting over 2,100 publicly funded healthcare organizations. Beyond optimizing procurement, we advance system innovation, strengthen supply resilience, and unlock capacity so health systems can support better care to Canadians. We put decades of knowledge and the purchasing volumes of more than 2,100-member healthcare facilities across Canada to work.
Job Description
We are looking for a Senior Data Engineer who will take ownership of our data platform, working hands-on with data pipelines, dimensional models, and integration processes that support decision-making across the organization.
You will work closely with an experienced delivery team through structured pair programming and hands-on collaboration during your onboarding period. You will learn the architecture, patterns, and design decisions firsthand. From there, you will be responsible for extending the platform to additional systems, onboarding new data sources, maintaining data quality, and supporting the organization's growing analytics needs.
This is an opportunity to be a key part of HealthPRO Canada's data engineering function and to shape the analytics infrastructure for the organization.
Responsibilities
- Design, build, test, and deploy data pipelines and integration processes across our analytics platform.
- Develop and maintain solutions using Azure Data Factory, Azure Synapse Analytics, and Microsoft Fabric.
- Implement transformation logic, orchestration workflows, scheduling, monitoring, and error handling for reliable data processing.
- Onboard new data sources, including internal enterprise systems and external third-party sources (e.g., supplier feeds, member systems, external platforms).
- Build and maintain incremental and delta load patterns for all source system integrations.
- Work with Kimball dimensional modeling patterns, including conformed dimensions, fact tables at transactional grain, and slowly changing dimensions (SCD Type 1 and Type 2).
- Maintain and extend the enterprise data model as new systems and subject areas are integrated.
- Perform data validation, reconciliation, and data quality checks to ensure accurate and trusted outputs.
- Support data governance processes, including data classification, lineage documentation, and metric certification in Power BI.
- Troubleshoot production issues, resolve pipeline failures, and optimize performance and reliability.
- Create and maintain technical documentation including source-to-target mappings, pipeline specifications, transformation rules, runbooks, and operational procedures.
- Own monitoring dashboards for pipeline health, data quality scores, and data freshness.
- Collaborate with business stakeholders and analysts to ensure data solutions align with reporting and analytics requirements.
Qualifications
Required
- 5+ years of hands-on experience in data engineering, data integration, or data warehouse development.
- Strong hands-on experience with Azure Data Factory, Azure Synapse Analytics, or Microsoft Fabric.
- Strong SQL skills and experience building ETL/ELT pipelines, transformation logic, and orchestration workflows.
- Hands-on experience with Kimball dimensional modeling, including star and snowflake schemas, conformed dimensions, fact tables, and slowly changing dimensions.
- Experience with Power BI, including semantic models, certified datasets, and row-level security.
- Experience with data quality controls, reconciliation processes, and monitoring.
- Experience creating and maintaining technical documentation (source-to-target mappings, runbooks, pipeline specs).
- Strong problem-solving skills and ability to work independently after an initial ramp-up period.
Preferred
- Experience working with enterprise systems such as Dynamics 365, Business Central, or similar CRM and finance platforms.
- Experience integrating external or third-party data sources (supplier feeds, partner systems, industry data platforms).
- Experience with CI/CD pipelines for data platform deployment.
- Experience with data governance practices, data classification, and metric governance.
- Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent practical experience.
Why Join Us
Most data engineering roles are narrowly scoped. This one gives you real ownership.
You will work alongside an experienced delivery team during your onboarding, learning the architecture through hands-on pair programming rather than just reading documentation. You will understand not just what exists, but why every design decision was made.
From there, you will take ownership. You will extend the platform to additional systems, onboard new data sources, and evolve the analytics capabilities for an organization that is investing seriously in data-driven decision-making. This is a role with real accountability and long-term impact.
Recruitment Process
AI tools may be used during parts of the recruiting process to support screening and evaluation.
This is a newly created role. We are actively reviewing applications.
At HealthPRO Canada, we believe diverse perspectives and meaningful inclusion strengthen our team. We welcome qualified candidates from all backgrounds, lived experiences, and identities to apply.
Pay: $120,000.00-$140,000.00 per year
Benefits:
- Company events
- Company pension
- Dental care
- Disability insurance
- Employee assistance program
- Extended health care
- Life insurance
- On-site parking
- Paid time off
- Vision care
- Wellness program
Ability to commute/relocate:
- Oakville, ON L6H 6K8: reliably commute or plan to relocate before starting work (preferred)
Application question(s):
- What are your salary expectations for the role?
- Do you have Bachelor's degree in Computer Science, Information Systems, Date Engineering, or a related field?
- Do you have at least five years of hands-on experience, in data engineering, date integration, or date warehouse development?
- Do you have hands on experience with Azure Data Factory, Azure Synapse Analytics, or Microsoft Fabric?
- Do you have hands-on experience with Kimball dimensional modeling, including star and snowflake schemas, conformed dimensions, fact tables, and slowly changing dimensions?
Work Location: Hybrid remote in Oakville, ON L6H 6K8
