Data Engineer

Union: Non-Union
Number of vacancies: 1
New or Replacement Position: New
Site: 700 University Avenue (Princess Margaret Cancer Foundation)
Department: Digital PMO
Reports to: Director
Hours: 37.5 hours per week
Salary: $38.01 - $57.01 per hour 
Status: Temporary Full Time
Closing Date: March 31 2026

Position Summary

An exciting opportunity is available to showcase your talents as a Data Engineer supporting the Princess Margaret Cancer Foundation (PMCF) Corporate Priorities portfolio.  This position will deliver solutions that are data-driven bring value to our stakeholders and achieve UHNs business objectives. As a Data Engineer reporting to the Director of Data Engineering you will work with the Princess Margaret Cancer Foundation (PMCF) UHN Digital PMO and 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 etc.) in a secure efficient and effective manner.

Duties

• Developing supporting and maintaining ETL processes leveraging tools like Microsofts 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 the ability to automate end to end processes from source system to destination leveraging ETL technology.
• Applying Medallion architecture as a data design pattern for structured and scalable data lakehouse development.
• 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 APIs 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
• Implementing and enforcing data security measures in the Data Warehouse to protect sensitive information
• Writing technical documentation

Qualifications :

• Bachelors degree in computer programming computer science or a related field.
• 5 years or more 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
• Experience designing and implementing data pipelines using the Medallion architecture (Bronze Silver Gold layers) as a standard data design pattern
• Experience using Bitbucket for source code management version control and collaboration
• 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 / Princess Margaret Foundation Information Systems strongly preferred
• Experience with Blackbaud CRM Shopify ecommerce and Netsuite ERP solutions is a plus
• 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.

Additional Information :

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 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 UHNs 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.

Remote Work :

No

Employment Type :

Contract