Data Engineer - Decision Support (97731)

at  Kingston Health Sciences Centre

Title: Data Engineer
Department: Decision Support
Position Number: 50072609
Hours of Work: Full-Time Position; Monday-Friday
Day Shifts: 0800-1600
Pay Band: Band-V $44.96-$49.83
Union: CUPE
Location: Kingston General Hospital Site
In accordance with Article 9.05, where the previous incumbent returns to this position within the thirty (30) day trial period this position shall be deemed not vacant and the posting will be cancelled. Should the vacancy be cancelled, applicants to this posting shall be notified.
Please note, this posting identifies the current shifts that apply to the position control number. However, this does not guarantee the permanence of the shift time or work assignment for the position. The Hospital reserves its Management Rights under the CUPE Collective Agreement to make changes to shift time and work assignment as it deems necessary.

QUALIFICATIONS:

• University Degree in Computer Science or Equivalent combination of education and hospital systems experience.
• 2 years data management experience.
• 2 year of experience working with clinical data.
• 2 year Health Care experience.
• Proficient in a modern programming language and comfortable working in the Windows and Linux command line.
• Experience and familiarity with HIS systems (CERNER, PACS etc), clinical data exchange formats, and data pipeline/DAG frameworks (Apache Airflow, Prefect, Databricks etc)
• Proficient with at least one established and/or emerging SQL and NoSQL solution.
• Familiarity with Python/R data science ML stack (TensorFlow, PyTorch, Scikit Learn, Tidyverse etc)
• Proven ability to attend work regularly.
• Satisfactory criminal reference check and vulnerable sector search required.

PHYSICAL REQUIREMENTS:

The applicant must be able to meet the physical demands of this position.
We thank all applicants, but only those selected for an interview will be contacted. Kingston Health Sciences Centre is committed to inclusive and accessible employment practices.
If you require an accommodation to fully participate in the hiring process, please notify the Recruitment Team.
KHSC is committed to recruitment practices that support and contribute to building a respectful, diverse and inclusive workplace. We welcome all applications from women, racialized persons, persons with disabilities, Indigenous Peoples, persons in the 2SLGBTQIA+ community, and members of other equity deserving groups.

• Build and monitor pipelines for extracting, loading, transforming, and validating clinical and administrative data to populate a corporate data lake house
• Design, implement, and advise on efficient data storage, partition, serving, and visualization strategies—including the use of high-performance (zero-copy) in-memory columnar data formats and distributed computing/file systems where appropriate
• Design, implement, and advise on data security and handling policies including processes for securing data at rest and during transit and implementing data auditing, masking, de-identification, anonymization, and retention/purging strategies where appropriate.
• Troubleshoot and optimize data extraction and integration pipelines for analytical workloads currently in production and assist with the migration of these assets during handover to CERNER, Novari, and Ocean HIS systems. Emphasis on building solutions that maximize data quality/completeness while minimizing impact on services required for safe, effective, and timely delivery of care.
• Collaborate and advise on adoption and deployment of new on-premises or cloud-based data integration and storage platforms suitable for use in a healthcare (PHI containing) analytics environment.
  The above statements reflect the general details considered necessary to describe the principal functions of the job as identified, and shall not be considered as a detailed description of all work requirements that may be inherent in the job.