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 UHN’s 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 Microsoft’s 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 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
- Implementing and enforcing data security measures in the Data Warehouse to protect sensitive information
- Writing technical documentation