Data Engineer - Digital Health Platform (Dhp)

The University Health Network, where "above all else the needs of patients come first", encompasses Toronto General Hospital, Toronto Western Hospital, Princess Margaret Cancer Centre, Toronto Rehabilitation Institute and the Michener Institute of Education. The breadth of research, the complexity of the cases treated, and the magnitude of its educational enterprise has made UHN a national and international resource for patient care, research and education. With a long tradition of ground breaking firsts and a purpose of "Transforming lives and communities through excellence in care, discovery and learning", the University Health Network (UHN), Canada's largest research teaching hospital, brings together over 16,000 employees, more than 1,200 physicians, 8,000+ students, and many volunteers. UHN is a caring, creative place where amazing people are amazing the world.

Union: Non-Union
Site: Toronto General Hospital
Department: UHN Digital, Digital Health Platform (DHP) Team
Reports to: Information Management Manager
Work Model: Hybrid
Grade: H0:06
Hours: 37.5 per week
Salary: $71,955 to $89,953 annually (To commensurate with experience and consistent with UHN compensation policy)
Status: Temporary Full-Time (Contract), 12 Months
Closing Date: Open until filled

Position Summary

The DHP is a data lake that aggregates, curates and exports data sources across the hospital. It is a robust and scalable platform that facilitates research and quality of care improvement initiatives across UHN. Our data sources span everything from standard electronic medical record entries and lab results to DNA sequencing data and diagnostic imaging. Our goal is to provide a platform that effectively integrates and facilitates the analysis of big data for these purposes.

As a member of the DHP team, you will have the opportunity to participate in the decision-making process during the design and development of our applications. You will specialize in importing data from hospital application into UHN DHP and delivering aggregate data to help clinicians and scientists streamline clinical workflows and research, enabling faster and better treatments through the use of computational and statistical methods. We have a heavy preference for using open-source tools to build in-house software solutions. Our architecture favours the microservice design pattern, with JSON for data-interchange format. Our primary data-store is a MongoDB cluster, though we also make use of SQL and MinIO. Your experience in other programming languages such as Python may be applicable. Our platform environment is managed by Kubernetes, and applications are run in Docker-based containers.

Are you collaborative, analytical and passionate about technology in the healthcare industry? The DHP Team is currently recruiting a Data Engineer. Principle responsibilities include building and running SQL queries for efficiently pulling data from hospital database systems, as well as setting up database views for projects that require access to regularly updated data. The Data Engineer will liaise across various UHN stakeholders to ensure that projects follow UHN policies, have the appropriate approvals, and meet all project specifications. The candidate for this role will possess a diverse skill set including advanced knowledge of databases, excellent communication and interpersonal skills, as well as a background in data & analytics within a hospital environment.

Key Responsibilities

• Collaborate with internal/external resources to acquire data from Epic Clarity & Caboodle
• Build or modify Epic Clarity & Caboodle database views for projects that require regularly updated data
• Build or modify database queries to pull data from non-Epic databases and NoSQL MongoDB
• Identify and troubleshoot data quality issues
• Act as a primary support contact for Epic reporting needs
• Review peer reports for validity, accuracy and completeness
• Identify, communicate, and resolve risks related to Epic Cogito data extract activities and initiatives

• Certification in Cogito Fundamentals, Clarity Data Model, Caboodle Data Model, Clinical Data Model certifications is strongly preferred
• If not already certified, then certification must be completed during the probationary period
• Familiarity with database technology such as Microsoft SQL Server and Oracle DB
• Advanced knowledge of building and optimizing SQL queries
• Intermediate knowledge of NoSQL MongoDB databases is strongly preferred
• Experience in data & analytics within a health care environment strongly preferred
• Knowledge of healthcare data sources and standards is preferred
• Ability to lead requirements gathering sessions, document user requirements and translate them into useful solutions
• Ability to analyze data, problem-solve, and clearly communicate solutions to both technical and non-technical stakeholders
• Ability to effectively work both independently and in a team-oriented environment
• Strong project management skills
• Experience working in a fast-paced, dynamic environment
• Python/pandas experience preferred for data processing/cleaning?

Why join UHN?

In addition to working alongside some of the most talented and inspiring healthcare professionals in the world, UHN offers a wide range of benefits, programs and perks. It is the comprehensiveness of these offerings that makes it a differentiating factor, allowing you to find value where it matters most to you, now and throughout your career at UHN.

• Competitive offer packages
• Government organization and a member of the Healthcare of Ontario Pension Plan (HOOPP https://hoopp.com/)
• Close access to Transit and UHN shuttle service
• A flexible work environment
• Opportunities for development and promotions within a large organization
• Additional perks (multiple corporate discounts including: travel, restaurants, parking, phone plans, auto insurance discounts, on-site gyms, etc.)

Current UHN employees must have successfully completed their probationary period, have a good employee record along with satisfactory attendance in accordance with UHN's attendance management program, to be eligible for consideration.

All applications must be submitted before the posting close date.

UHN uses email to communicate with selected candidates. Please ensure you check your email regularly.

Please be advised that a Criminal Record Check may be required of the successful candidate. Should it be determined that any information provided by a candidate be misleading, inaccurate or incorrect, UHN reserves the right to discontinue with the consideration of their application.

UHN is an equal opportunity employer committed to an inclusive recruitment process and workplace. Requests for accommodation can be made at any stage of the recruitment process. Applicants need to make their requirements known.

We thank all applicants for their interest, however, only those selected for further consideration will be contacted.

All applications must be submitted before the posting close date.

UHN uses email to communicate with selected candidates. Please ensure you check your email regularly.

Please be advised that a Criminal Record Check may be required of the successful candidate. Should it be determined that any information provided by a candidate be misleading, inaccurate or incorrect, UHN reserves the right to discontinue with the consideration of their application.

UHN is an equal opportunity employer committed to an inclusive recruitment process and workplace. Requests for accommodation can be made at any stage of the recruitment process. Applicants need to make their requirements known.

We thank all applicants for their interest, however, only those selected for further consideration will be contacted.