Data Engineer

Enabling Healthcare Across Networks of Central East (ENHANCE) Ontario (also referred to here as “EO”) is a not-for-profit corporate entity which will provide centralized IT services to its seven (7) member hospitals (Campbellford Memorial Hospital, Haliburton Highlands Health Services, Lakeridge health, Northumberland Hills Hospital, Peterborough Regional Health Centre, Ross Memorial Hospital, and Scarborough Health Network) to manage and operate a set of shared digital assets. This will enable its 7 member hospitals across 14 sites to deliver high quality and safe patient care using the shared Epic Clinical Information System (“CIS”) to over 1.5 million patients residing in both rural and urban communities located in the Central East region of Ontario.

Job Description:

Position Overview:
We are seeking a Data Engineer to design, build, and operate EO’s new regional data platform using Microsoft Fabric, Delta Lake, Spark, SQL, and modern API- and event-driven data integration patterns.

This role will work closely with the analytics team, infrastructure teams, Epic application teams, and our seven hospital partners to build high-quality ingestion pipelines, medallion-layer models, and shared regional data assets that support analytics across all member hospitals. You will help define engineering standards and contribute directly to the evolution of EO’s regional data strategy as we modernize how data is managed, exchanged, and leveraged across hospitals.

This is a hands-on engineering role suited for someone who enjoys building modern data systems, working across teams, and delivering reliable, secure, and scalable data pipelines in a complex healthcare environment.

Responsibilities:

• Build and optimize data pipelines and transformations using Microsoft Fabric, PySpark, Delta tables, and modern ELT/ETL practices

• Develop reusable ingestion frameworks, templates, and Lakehouse patterns (Bronze/Silver/Gold)

• Support real-time and near-real-time integrations (HL7v2, FHIR APIs, REST, event-driven pipelines, FHIR Subscription standard)

• Maintain high-quality Lakehouse structures through schema management, optimization, and performance tuning

• Support data validation, testing, and monitoring to ensure reliable and accurate data products

• Contribute to analytics-ready modeling using both dimensional models (facts/dims) and healthcare standards (FHIR, OMOP, Epic Clarity/Caboodle)

• Collaborate with Cogito, Epic, infrastructure, privacy/security, and hospital partners to ensure secure and reliable data operations

• Participate in cross-functional meetings and provide clear technical input to support data-driven decision-making

Requirements:

· Bachelor’s degree in Computer Science, Engineering, or a related field (or equivalent practical experience)

· 3-5 years of relevant data engineering experience

· Experience with cloud data platforms (Fabric, Synapse, Databricks, or similar)

· Proficiency in SQL, Python, Spark/PySpark, Delta Lake, and ETL/ELT workflows

· Strong understanding of Lakehouse and medallion architectures (Bronze/Silver/Gold)

· Understanding of healthcare interoperability standards such as HL7v2, FHIR, REST APIs, and event-driven patterns

· Experience working with Epic data sources (Clarity, Caboodle, Chronicles)

· Experience with OMOP or similar analytical data models for research is an asset

· Knowledge of dimensional modeling (fact/dimension tables) and analytics-ready data design

· Experience with data validation, testing, and quality assurance

· Experience with Git, CI/CD pipelines, and modern DevOps practices

· Strong communication skills and ability to work effectively with both technical and non-technical teams

· Understanding of data governance, metadata, lineage, and secure handling practices (PHIPA)

· Epic Cogito, Clarity, or Caboodle certification is an asset

Key Competencies

· Strong problem-solving and analytical skills

· Ability to design scalable and reliable data solutions

· Clear communication and ability to work across teams

· Highly organized with strong prioritization skills

· Ability to work independently and manage multiple initiatives

Accommodation and Diversity Statement:
Enhance Ontario (EO) embraces and celebrates our community’s unique multicultural heritage and diversity. EO is an equal opportunity employer, dedicated to a culture of inclusiveness and diversity reflecting our diverse patients, staff and community alike.

We are committed to fostering an environment of equity and inclusivity where every person can work and receive care safely, openly and honestly. All qualified applicants will receive consideration for employment without regard to race, colour, religion, gender, gender identity or expression, sexual orientation, nation of origin, genetics, disability, age, veteran status, marital or family status, belief system, or other factors related to one’s personal identity and/or values.

We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs.

Learn more about our exciting opportunities by following SHNCareers on Instagram, Twitter, and Facebook.