Business Intelligence Developer, Enterprise Analytics

shn; Toronto; On-site; CAD 73,000 - 85,000; Full time

Job summary

Scarborough Health Network (SHN) is seeking a Senior Business Intelligence Developer for Enterprise Analytics. The role focuses on designing and delivering enterprise BI, reporting, and analytics solutions to enable data-driven decisions across clinical, operational, and executive domains.

The candidate will develop interactive dashboards, data models, automated reporting, and analytical products, collaborating with clinical leaders and IT teams to transform complex healthcare data into

Qualifications

• Design, develop, implement, and support enterprise BI solutions.
• Create dashboards, reports, scorecards, and data visualizations.
• Build complex SQL queries, datasets, and data models.

Responsibilities

• Design, develop, implement, and maintain BI solutions across the enterprise.
• Develop dashboards and analytics using Power BI for clinical, operational, and executive use.
• Create and optimize SQL queries, data models, and reporting structures.
• Develop ETL processes using SSIS and Power Query for data integration.
• Collaborate with stakeholders to translate requirements into scalable analytics.
• Maintain data models with governance, performance, and usability in mind.
• Document specifications, data dictionaries, and development standards.

Skills

Power BI

SQL

SSIS

DAX

Data modeling

ETL

Tools

Power Query

SSMS

Job description

Job Number: JR106914

Job Title: Business Intelligence Developer, Enterprise Analytics

Union:

Union:

Job Category: Professional

Hospital Location: Consilium Place

Job Type: Permanent, Full time

Number of Positions: 1

Minimum - Maximum Hourly Rate: $52.97 - $61.407

Hours: Days

Across our three hospitals and eight satellite sites, Scarborough Health Network (SHN) is shaping the future of care. Our many programs and services are designed around the needs of one of Canada's most vibrant and diverse communities. We are home to North America's largest nephrology program, as well as the designated cardiac care and spine centre for Scarborough and surrounding communities to the east. We are proud to be a community-affiliated teaching site for the University of Toronto and partner with a number of other universities and colleges, helping to train the next generation of health care professionals. SHN is the recipient of the 2021 Excellence in Diversity and Inclusion Award, from the Canadian College of Health Leaders, for our leading edge work on Communities of Inclusion, Inclusion Calendar, Health Equity Certificate Program and much more. We are also proud to be named Canada's Most Admired Corporate Cultures for 2023 - 2025 and Greater Toronto's Top Employers for 2026. Learn more at shn.ca

Job Description:

Position Overview

Reporting to the Manager, Enterprise Analytics, the Business Intelligence Developer is responsible for the design, development, implementation, and support of enterprise business intelligence, reporting, and analytics solutions that enable data-driven decision-making across the organization. The role develops interactive dashboards, data models, automated reporting solutions, and analytical products that transform complex healthcare and operational data into actionable insights for clinical, operational, and executive stakeholders. The Business Intelligence Developer collaborates with healthcare leaders, subject matter experts, and technical teams to build scalable reporting and analytics solutions that support organizational performance, strategic planning, operational excellence, and continuous improvement initiatives. The role leverages advanced business intelligence technologies, data integration tools, and reporting platforms to deliver accurate, timely, and meaningful information across the enterprise.

Responsibilities

• Design, develop, implement, and maintain enterprise business intelligence solutions, dashboards, reports, scorecards, and data visualizations that support operational, clinical, and strategic decision-making.
• Develop interactive reporting and analytics solutions utilizing Power BI and other business intelligence technologies to deliver meaningful insights to stakeholders across the organization.
• Design, build, and maintain complex SQL queries, datasets, data models, stored procedures, and reporting structures to support enterprise analytics initiatives.
• Develop, optimize, and support ETL processes, data integration workflows, and automated reporting solutions utilizing SQL Server Integration Services (SSIS), Power Query, and related technologies.
• Extract, transform, validate, and integrate data from multiple clinical, financial, operational, and administrative systems to support reporting and analytics requirements.
• Analyze complex datasets to identify trends, patterns, opportunities, and insights that support organizational planning, performance improvement, and business decision-making.
• Collaborate with business stakeholders to gather requirements, analyze reporting needs, document specifications, and translate business requirements into scalable analytics solutions.
• Create and maintain robust enterprise data models utilizing best practices for performance, scalability, governance, and usability.
• Develop and maintain advanced DAX calculations, Power Query transformations, and business logic to support analytical reporting requirements.
• Monitor and optimize database, query, report, and dashboard performance to ensure efficient and reliable delivery of analytics solutions.
• Identify, investigate, and resolve data quality, integrity, and consistency issues across multiple source systems and reporting environments.
• Develop visual summaries, presentations, and analytical products that effectively communicate complex information to both technical and non-technical audiences.
• Develop and maintain technical documentation, report specifications, data dictionaries, development standards, and support procedures.
• Collaborate with Information Technology Services teams, clinical leaders, operational stakeholders, and external partners to support enterprise reporting, analytics, and data governance initiatives.
• Ensure compliance with organizational policies, privacy legislation, information security standards, and data governance requirements related to healthcare information and reporting.
• Participate in the design, testing, implementation, and ongoing support of enterpris