Data Engineer
Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Union: Non-Union
Number of vacancies: 1
Site: Toronto General Hospital
Department: UHN Data & Analytics
Reports to: Director Data Engineering
Hours: 37.5 hours per week
Status: Temporary Full-Time 12 months
Closing Date: July 17 2025
Position Summary
UHN Data & Analytics supports UHNs 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 UHNs 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.
As a Data Engineer reporting to the Director 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 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 has 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.
- 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 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
- Implement and enforce 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.
- 2 - 3 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
- 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 / 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.
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 :
Full-time
Employment Type
Full-time
