Technical Specialist

University Health Network

Toronto

On-site

CAD 66,000 - 99,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Competitive offer packages
HOOPP pension plan
Transit access
Flexible work environment
Development opportunities
Corporate discounts

Job summary

University Health Network in Toronto is seeking a Technical Specialist within the Data & Analytics Department to design, build, and optimize enterprise data assets. You will collaborate with BI Developers, Data Engineers, and clinical teams to deliver scalable data platforms using Python, SQL, Spark, and Microsoft Fabric.

You will own end-to-end data pipelines, support governance, and enable enterprise reporting and analytics across clinical, research, and administrative domains at UHN.

Qualifications

  • Bachelor's degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or related discipline.
  • Minimum 5 years of relevant experience in data engineering, software development, enterprise data integration, or data warehouse development.
  • Demonstrated hands-on experience developing production-grade data solutions using Python, SQL, and modern data engineering technologies.
  • Practical experience working with Microsoft Fabric and/or comparable enterprise cloud-based data platforms.
  • Experience supporting complex enterprise datasets involving multiple source systems and business domains.
  • Demonstrated ability to independently troubleshoot technical issues and deliver reliable, maintainable data solutions.

Responsibilities

  • Design, develop, implement, and maintaining scalable, reliable, and governed enterprise data solutions.
  • Proven ability to design and build end-to-end ETL/ELT processes, from source extraction through staging, transformation, and reporting layers.
  • Strong understanding of dimensional modelling, including star schemas, fact and dimension tables, grain definition, and surrogate keys.
  • Work with stakeholders to translate business requirements into robust technical solutions for enterprise reporting and analytics.

Skills

Python
PySpark
Spark SQL
SQL
Microsoft Fabric
ETL/ELT
Dimensional modelling
Data quality rules
REST APIs
Stakeholder communication

Education

Bachelor's degree in Computer Science / Software Engineering / Data Engineering

Tools

Microsoft Fabric
Azure SQL
Azure Data Factory
Azure Functions
Azure DevOps
Delta Lake
Power BI
Informatica IDMC

Job description

  • Compensation: CAD 47.83 - CAD 71.75 - hourly
Company Description

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.

Union:Non-Union
Number of Vacancies:1
New or Replacement Position:New
Site:Toronto General Hospital
Department:Data Engineering
Reports to:Senior Manager
Salary:$47.83 to $71.75 per hour
Hours:37.5 hours per week
Status:Permanent Full-Time
Closing Date:November 25, 2026

Position Summary

The Technical Specialist work closely with other Business Intelligence (BI) Analyst and Developer, Data Engineers, Clinical/SME teams and Other Epic Application Team, this position is responsible for designing, developing, implementing, and maintaining scalable, reliable, and governed enterprise data solutions that support UHN's clinical, research, education, and enterprise operations. The role provides advanced technical expertise in data engineering, data integration, data transformation, data modelling, and performance optimization to enable the delivery of high-quality, reusable, and certified enterprise data assets.

Working within UHN's Data & Analytics Department, the Technical Specialist supports the development and ongoing evolution of Enterprise Intelligence Platform through Microsoft Fabric and other approved enterprise technologies. The position plays a critical role in implementing metadata-driven data pipelines, medallion data architecture, common data models, dimensional modelling, and standardized engineering practices.

The incumbent collaborates with Data Engineers, BI Developers, Data Architects, Data Analysts, governance teams, and clinical and operational stakeholders to translate business requirements into robust technical solutions that enable enterprise reporting, operational intelligence, advanced analytics, and AI.

Here’s what you get to do

  • Strong proficiency in Python, including writing modular, reusable, and well-tested code. Experience with pandas, error handling, logging, and unit testing.
  • Hands-on experience with PySpark and Spark SQL for large-scale data transformation and performance tuning.
  • Advanced SQL skills (T-SQL and/or Spark SQL)
  • Practical experience with Microsoft Fabric, including Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, Notebooks, and OneLake.
  • Proven ability to design and build end-to-end ETL/ELT processes, from source extraction through staging, transformation, and reporting layers.
  • Strong understanding of dimensional modelling, including star schemas, fact and dimension tables, grain definition, and surrogate keys.
  • Ability to define and enforce data quality rules for completeness, accuracy, consistency, validity, uniqueness, and timeliness.
  • Experience ingesting data from REST APIs and SaaS platforms.
  • Work closely with stakeholders, subject matter experts, and end-users to understand the reporting content requirements, and analyze the needs of data consumers;
Qualifications
  • Bachelor's degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or a related discipline, or an equivalent combination of education and experience.
  • Minimum 5 years of relevant experience in data engineering, software development, enterprise data integration, or data warehouse development.
  • Demonstrated hands-on experience developing production-grade data solutions using Python, SQL, and modern data engineering technologies.
  • Practical experience working with Microsoft Fabric and/or comparable enterprise cloud-based data platforms.
  • Experience supporting complex enterprise datasets involving multiple source systems and business domains.
  • Demonstrated ability to independently troubleshoot technical issues and deliver reliable, maintainable data solutions.
  • Experience in a healthcare, hospital, academic health sciences, or similarly complex regulated environment is preferred.
  • Familiarity with clinical data and healthcare information systems, such as Epic, HL7, FHIR, or other healthcare integration standards is preferred.
  • Experience with Microsoft Azure services, including Azure SQL, Azure Data Factory, Azure Functions, and Azure DevOps is preferred.
  • Knowledge of Informatica IDMC, enterprise metadata management, data cataloguing, and data lineageis preferred.
  • Experience with Delta Lake, metadata-driven frameworks, and common data model implementationis preferred.
  • Familiarity with Power BI semantic models and enterprise reporting architecturesis preferred.
  • Experience with real-time data ingestion, event-driven integration, or streaming frameworksis preferred.
  • Relevant Microsoft certifications, such as Fabric Data Engineer Associate, or equivalent demonstrated expertiseis preferred.
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 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.

UHN uses email to communicate with selected candidates. Please ensure you check your email regularly.At University Health Network (UHN), artificial intelligence technologies may be used to assist in the screening, assessment, and selection of candidates for this position.
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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Technical Specialist, Techna (Data Engineer)
Technical Specialist, Techna (Data Engineer)

University Health Network • Toronto

On-site
CAD 92,000 - 138,000
HOOPP pension plan
Transit access nearby
Flexible work environment
Epic Application Analyst - Patient Flow
Epic Application Analyst - Patient Flow

University Health Network • Toronto

On-site
CAD 58,000 - 72,000
Competitive offer packages
HOOPP Pension Plan
Transit access and shuttle
+3
Cogito Business Intelligence Developer, Cogito Reporting
Cogito Business Intelligence Developer, Cogito Reporting

University Health Network • Toronto

On-site
CAD 58,000 - 72,000
HOOPP pension
Transit access
Flexible work environment
+2
Data Science Analyst (Data Integration)
Data Science Analyst (Data Integration)

University Health Network • Toronto

On-site
CAD 50,000 - 75,000
Competitive offer packages
HOOPP pension plan
Transit access and shuttle service
+1
Coordinator, Patient Data (Cardiac Registry)
Coordinator, Patient Data (Cardiac Registry)

University Health Network • Toronto

On-site
CAD 41,000 - 51,000
HOOPP pension plan
Transit accessibility
Flexible work environment
+2
Business Intelligence (BI) Developer
Business Intelligence (BI) Developer

University Health Network • Toronto

On-site
CAD 82,000 - 102,000
Competitive offer packages
HOOPP pension plan
Transit access
+3
Analytics Lead
Analytics Lead

University Health Network • Toronto

On-site
CAD 90,000 - 135,000
HOOPP pension plan
Transit access
Flexible work environment
+2
Clerical Assistant II
Clerical Assistant II

University Health Network • Toronto

On-site
CAD 29,000 - 37,000
Financial Analyst III
Financial Analyst III

University Health Network • Toronto

On-site
CAD 82,000 - 123,000
Competitive offer packages
HOOPP pension plan
Close access to Transit and UHN shuttl
+2
Talent Acquisition Coordinator
Talent Acquisition Coordinator

University Health Network • Toronto

On-site
CAD 45,000 - 49,000
Competitive package
HOOPP pension
Transit access
+3