UHN is Canada’s #1 hospital and the world’s #1 publicly funded hospital. With 10 sites and more than 44,000 TeamUHN members, UHN consists of Toronto General Hospital, Toronto Western Hospital, Princess Margaret Cancer Centre, Toronto Rehabilitation Institute, The Michener Institute of Education and West Park Healthcare Centre. As Canada's top research hospital, the scope of biomedical research and complexity of cases at UHN have made it a national and international source for discovery, education and patient care. UHN has the largest hospital-based research program in Canada, with major research in neurosciences, cardiology, transplantation, oncology, surgical innovation, infectious diseases, genomic medicine, and rehabilitation medicine. UHN is a research hospital affiliated with the University of Toronto.
UHN’s vision is to build A Healthier World and it’s only because of the talented and dedicated people who work here that we are continually bringing that vision closer to reality.
www.uhn.ca
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: May 26, 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
- Bachelor’s 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.
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.
