Job Description

DATA ENGINEER Job Posting #: 918364
Union: Non-Union or CUPE, OPSEU, ONA, etc.
Site: Toronto General Hospital
Department: Data Operations - Clinical Support & Performance
Reports to: Senior Manager, Data Engineering Solutions
Hours: 37.5 hours per week
Wage range $34.62 - $43.28 hourly (Commensurate with experience and consistent with UHN compensation policy)
Status: Temporary Full-Time (12 months)
Posted Date: April 27, 2023
Closing Date: May 12, 2023

The University Health Network, where \xe2\x80\x9cabove all else the needs of patients come first\xe2\x80\x9d, 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 \xe2\x80\x9cTransforming lives and communities through excellence in care, discovery and learning\xe2\x80\x9d, the University Health Network (UHN), Canada\xe2\x80\x99s 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.

UHN Data & Analytics supports UHN\xe2\x80\x99s growing demand for data, data-driven insights and helps TeamUHN ensure the needs of the patients come first. Our collective goal is to better see, understand and use data to help UHN become a data-driven organization, which will help us achieve UHN\xe2\x80\x99s strategic goals and ultimately advance care, research and education. UHN Data & Analytics supports UHN in data-driven decisions, data literacy, performance improvement, data governance, analytics, and automation as well as advances these capabilities through collaboration across the organization.

Position Summary

As a Data Engineer reporting to the Senior Manager of Data Engineering, you will work with the Princess Margaret Cancer Foundation (PMCF), UHN Data & Analytics teams to continue building our data warehouse to allow for more efficient reporting and analysis done by the Business Intelligence team. The primary responsibility will be automating the Extraction, Transformation and Load (ETL) processes across multiple data sources (Blackbaud CRM, NetSuite, MailChimp) in a secure, efficient, and effective (quality) manner.

Duties

• Developing, supporting, and maintaining ETL processes leveraging tools like Microsoft\xe2\x80\x99s SQL Server Integration Services (SSIS)
• Writing advanced / complex SQL queries and scripts to pull data sources
• Creating / maintaining data models, processes and ETL package to feed various data destinations
• Understanding database management systems, including Microsoft SQL Server in support of the movement of data between systems
• Developing automation tools for daily tasks. Specifically, has the ability to automate, end to end, processes from source system to destination leveraging ETL technology.
• Has experience in maintaining and troubleshooting scripts to ensure repeatable and reliable implementations whether they are new or enhancements
• Providing tuning expertise to ETL packages
• Pulling data from REST API\'s including HL7-FHIR / XML / JSON
• ELT solutions in cloud based / data lake data storage technologies
• Performing data validation by creating and executing testing plans and routines to ensure integrity of data
• Ensuring data can be fluidly and securely shared across the enterprise
• Fulfilling Data Warehouse maintenance responsibilities including data requests
• Writing technical documentation

Qualifications

• Bachelor\xe2\x80\x99s degree in computer programming, computer science, or a related field.
• 2 years of extensive ETL/ELT building and monitoring experience for data warehouses and / or data lakes required.
• Familiarity with database technology such as MicroSoft SQL Server, MS Azure SQL database.
• Familiarity or experience with ETL technology such as MS SSIS
• Masterful SQL, PL/SQL, T-SQL, shell scripting and programming skills
• Fluency or understanding of specific languages, such as Python, C#, .Net and operating systems.
• Working knowledge of Microsoft Power BI is an asset.
• Experience with design and development of API is an asset.
• Experience in Healthcare / Foundation Information Systems strongly preferred
• Microsoft Azure experience, including Azure Data Factory preferred
• Focus on efficiency, user experience, and process improvement.
• Excellent project and time management skills.
• Strong problem solving and verbal and written communication skills.
• Ability to work independently or with a group.

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

) * 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.

Vaccines (COVID and others) are a requirement of the job unless you have an exemption on a medical ground pursuant to the Ontario Human Rights Code.

UHN is a respectful, caring, and inclusive workplace. We are committed to championing accessibility, diversity and equal opportunity. Requests for accommodation can be made at any stage of the recruitment process. Applicants need to make their requirements known in advance. Any information received related to an accommodation will be addressed confidentially.

University Health Network thanks all applicants, however, only those selected for an interview will be contacted

University Health Network