Business Intelligence (BI) Developer

SmartRecruiters, Inc.; Toronto; Hybrid; CAD 82,000 - 102,000; Full time

Benefits offered by this job

HOOPP pension

Transit access

Flexible work environment

Development opportunities

Employee discounts

Job summary

University Health Network (UHN) seeks an experienced BI Developer to build and maintain Power BI dashboards and reports for the People & Culture department, turning workforce data into actionable insights. You will own Workday and UKG reporting during the HRIS transformation, partnering with P&C and Enterprise Data teams to translate stakeholder needs into scalable dashboards.

You will influence the evolving data model, serving as the main link to shape reporting requirements and data

Qualifications

• Bachelor's degree in Human Resources, Business Management, analytics-related field, or equivalent.
• 2–3 years of practical experience building Power BI dashboards on governed semantic models.
• Strong understanding of Power BI, Fabric architecture, DAX, and semantic models.
• Preferred knowledge of Microsoft Fabric and Medallion Architecture for reporting on semantic models.
• Microsoft PL-300 and/or DP-600 certifications are strong assets.
• Excellent requirements gathering and stakeholder engagement skills for translating business needs into dashboards.
• Working understanding of People Analytics concepts and metrics.
• Experience using Workday and/or UKG as data sources is a strong asset.
• Healthcare or regulated environment experience is an asset.

Responsibilities

• Design, build and maintain Power BI dashboards and reports for People & Culture, using strong DAX and data visualization practices.
• Serve as liaison between People & Culture and Enterprise Data Team on data infrastructure needs.
• Lead reporting requirements for Microsoft Fabric as part of HRIS transformation, including technical specs for people data metrics.
• Provide input into semantic model design and ensure analytics endpoints meet reporting needs.

Skills

Power BI

DAX

Semantic models

Stakeholder engagement

Workday data

UKG data

Healthcare domain

Fabric/Meta data

Education

Bachelor's degree in HR/Business Analytics or related field

Tools

Microsoft Fabric

Medallion Architecture

Workday

UKG

Job description

• Compensation: CAD 81,549 - CAD 101,951 - yearly

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:New
Site: Princess Margaret Cancer Centre
Department:People & Culture - Business Intelligence & Reporting
Reports to:Senior Manager, Business Intelligence & Reporting
Salary: $81,549 to $101,951 annually
Hours: 37.5 hours per week
Status:Permanent Full-time
Closing Date:October 21, 2026

Position Summary

Build the Power BI dashboards and reports that turn workforce data into decisions for University Health Network's People & Culture (P&C) department - from turnover trends to workforce planning across one of Canada's largest health networks. As a BI Developer, you'll own Workday and UKG reporting for our HRIS transformation, working directly with P&C and operational stakeholders to translate what they need into dashboards built on certified semantic models.

This role comes with real influence over how our P&C data model evolves. You'll be the primary link between P&C and our Enterprise Data Team, shaping what the underlying data needs to support, without owning the pipeline yourself. You'll need strong Power BI, DAX, and Microsoft Fabric skills, plus the ability to translate a stakeholder's problem into something buildable. In return: ownership of the reporting layer, a real voice in the data model's direction, and a front-row seat to a major HR systems transformation as UHN moves to Workday and UKG.

Duties

• Design, build, and maintain Power BI dashboards and reports as trusted, adopted data products for P&C, applying strong DAX and data visualization practices, and manage report deployment, testing, and ongoing support across production releases.
• Act as the day-to-day liaison between P&C and the Enterprise Data Team on data infrastructure requirements.
• Lead reporting requirements gathering for Microsoft Fabric as part of the HRIS transformation project, supporting go-live and stabilization, including technical specifications for people data metrics across organizational layers and roles.
• Provide subject-matter input into semantic model design owned by the Enterprise Data Team and validate that analytical endpoints meet P&C reporting needs.

Qualifications

• Bachelor's degree in Human Resources, Business Management, an Analytics-related field, or recognized equivalent.
• 2 to 3 years of practical, related experience building Power BI dashboards and reports on certified/governed semantic models required.
• Strong understanding of Power BI/Fabric architecture, DAX, and semantic model concepts required.
• Preferred technical knowledge of Microsoft Fabric and Medallion Architecture (Bronze/Silver/Gold) to build reporting solutions on certified semantic models and to provide informed input into data model design.
• Completion of Microsoft PL-300 and/or DP-600 certifications are considered strong assets.
• Excellent requirements gathering and stakeholder engagement skills; ability to translate business needs from non-technical stakeholders into realistic, scalable reporting specifications.
• Working understanding of People Analytics data concepts and metrics.
• Experience with using Workday and/or UKG as data sources is a strong asset.
• Prior experience in healthcare or another regulated environment is an asset.

Additional Information

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