ETL Developer (Senior Specialist Application) - Tft

ETL DEVELOPER (Application Specialist)

Job Posting # : 924444

Site : MaRS, Princess Margaret Cancer Research Tower

Department : UHN Digital / Research Application Development

Reports to : Senior Manager

Hours : 37.5 hours per week

Salary : $38.09 - 47.61 hourly (Commensurate with experience and consistent with UHN compensation policy)

Status : Temporary full time (approximately 6 months)

Posted Date : September 13, 2023

Closing Date : Until filled

The University Health Network, where "above all else the needs of patients come first", 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 "Transforming lives and communities through excellence in care, discovery and learning", the University Health Network (UHN), Canada's 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.

Position Summary

As an ETL Developer, you will be well-versed in Data preparation, Data Migration and ETL processes. You will apply business analysis and technical skills to migrate enterprise content by extracting information from data sources, transforming format and loading documents and data to the new systems.

Qualifications

• Undergraduate Degree in Computer Science, Math, Engineering, or related field or recognized equivalent.
• 3 to 5 years of relevant experience in Extract Transform and Load (ETL) development.
• Experience in data migration / conversion processes from legacy systems to a new vendor-based solution.
• Ability to focus on timely delivery, troubleshooting technical challenges and enabling data migration.
• Experience in data cleansing, migrating, validating, and auditing processes.
• Hands-on experience in complex SQL query writing and data analysis.
• Good understanding of ETL, Reporting, and Data Warehouse concepts.
• Experience working in a PL / SQL and Oracle environment.
• Experience with ETL tools such as Azure Data Factory, SSIS or similar.
• Ability to develop data profiling, quality and cleansing requirements.
• Experience in programming and analysis; specialized software package support.
• Ability to collaborate with IT Professionals throughout the Software Development Life Cycle.
• Passion for knowledge sharing, process documentation, and data governance.
• Collaboratively engage with relevant business stakeholders / SMEs.
• Experience in creating automated solutions.
• Hands-on experience with data security best practices.
• Excellent organization and prioritization skills, demonstrated by the ability to manage multiple tasks effectively.
• Strong written and verbal communication skills, including technical writing and presentations.
• Able to work effectively independently and as part of a team.

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.

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

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