Business Intelligence Developer, Enterprise Analytics

SHN Scarborough Health Network; Toronto; On-site; CAD 110,000 - 130,000; Full time

Benefits offered by this job

Defined Benefit pension plan

Health benefits

Tuition Assistance Program

Job summary

Scarborough Health Network (SHN) is seeking a Business Intelligence Developer to design and deliver enterprise BI solutions. You will build dashboards, data models, and automated reports to support clinical, operational, and executive decision-making across SHN's hospitals and satellite sites.

You will work with healthcare leaders and IT teams, leveraging Power BI, SQL Server, and SSIS/SSRS to transform complex data into actionable insights and drive performance improvements across SHN.

Qualifications

• Bachelor's degree or equivalent in CS/IT/Data Analytics/IS/Math/Stats or related field.
• Minimum three years of BI, reporting and analytics experience.
• Advanced experience building interactive dashboards and analytics using Power BI or similar tools.
• Strong knowledge of SQL Server, SSRS/SSIS, Excel, and data integration.

Responsibilities

• Design, develop, implement, and maintain enterprise BI solutions, dashboards, reports, scorecards, and data visualizations.
• Develop interactive reporting and analytics using Power BI for stakeholders.
• Create and maintain data models, datasets, and data quality measures across systems.
• Develop ETL processes with SSIS and Power Query for automated reporting.
• Collaborate with stakeholders to gather requirements and translate them into scalable analytics.

Skills

Communication

Stakeholder management

Analytical thinking

SQL

Power BI

DAX

Power Query

Excel

Data modeling

Education

Bachelor's degree

Tools

Power BI

SSIS

SSRS

Power Query

SQL Server

Excel

SharePoint

Job description

Job Information

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. SHN is a culture that empowers and inspires.

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 enterprise analytics, reporting, and business intelligence projects.


• Perform other duties and responsibilities as assigned.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Data Analytics, Information Systems, Mathematics, Statistics, or a related discipline, or an equivalent combination of education and experience.


• Minimum three (3) years of progressive experience developing and supporting business intelligence, reporting, and analytics solutions.


• Advanced experience developing, deploying, and maintaining interactive dashboards, scorecards, and analytical solutions using Power BI or comparable business intelligence platforms.


• Strong knowledge of Microsoft SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SharePoint, Microsoft Excel, and the integration of these technologies.


• Demonstrated experience with SQL development, database design, data extraction, transformation and loading (ETL), scripting, automation, and SQL performance optimization.


• Advanced experience with DAX, Power Query (M), data modeling, and business intelligence solution development.


• Strong analytical and problem-solving skills, including the ability to work with complex datasets, identify data quality issues, and develop meaningful visualizations and insights.


• Demonstrated experience gathering business requirements, documenting specifications, and translating business needs into reporting and analytics solutions.


• Experience developing standardized reporting frameworks, performance dashboards, and enterprise reporting tools.


• Excellent communication, presentation, stakeholder engagement, and relationship management skills.


• Strong attention to detail and commitment to delivering high-quality solutions from concept through implementation.


• Demonstrated ability to manage multiple priorities and deadlines while working independently in a fast-paced environment.


• Proven ability to quickly learn new technologies, business processes, and analytics methodologies.

Accommodation and Diversity Statement

Scarborough Health Network (SHN) embraces and celebrates our community’s unique multicultural heritage and diversity. SHN is an equal opportunity employer, dedicated to a culture of inclusiveness and diversity reflecting our diverse patients, staff and community alike. We are committed to fostering an environment of equity and inclusivity where every person can work and receive care safely, openly and honestly. All qualified applicants will receive consideration for employment without regard to race, colour, religion, gender, gender identity or expression, sexual orientation, nation of origin, genetics, disability, age, veteran status, marital or family status, belief system, or other factors related to one’s personal identity and/or values. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs.

Culture

At Scarborough Health Network (SHN), our people are our greatest asset. They come from all over the world and bring diverse perspectives to enhance the compassionate and innovative care we provide our patients and their loved ones. We celebrate what makes people unique and believe that a safe, fulfilling and balanced work environment is just the start. We recognize and reward our teams, prioritize access to continuing education and create meaningful opportunities for growth and development. At SHN, you can enhance your career while by opening doors to new experiences and possibilities within our vibrant and inclusive community. We are proud to be an inclusive, equitable and accessible workplace, where everyone feels valued, respected, supported, and has a rich sense of belonging through our organizational drive to build and sustain an exceptional work environment where healthcare professionals can flourish both personally and professionally. SHN is proud to be named one of Greater Toronto’s Top 2026 Employers by Mediacorp Canada Inc., the organization behind the prestigious Canada’s Top 100 Employers project. This honour celebrates organizations that create exceptional workplaces, and we are thrilled to among them. We are a culture that empowers and inspires. This means everyone feels welcomed, respected, supported and valued and able to fully participate in the workplace. We are doing this through by creating awareness, providing education resources, empowering staff-led Communities of Inclusion, and providing growth and career opportunities. We are proud to offer mentorship programs to encourage collaboration and to support international employees, and our EnRoute training and career advancement programs designed to provide hands‑on experience to fast‑track certifications and placements in different care units.

Perks and Benefits

• Defined Benefit pension plan through the Healthcare of Ontario Pension Plan


• Comprehensive insured benefits package including health and dental benefits


• New Graduate Initiative Enroute Program


• Critical Care Sponsorship Program


• Employee Discount and Incentive Programs


• Employee and Family Assistance Program (EFAP)


• Comprehensive wellness offerings, including our Spiritual Care team of registered psychotherapists for spiritual, religious or emotional care; mental health supports; and on-site wellness rounding


• Recognition events


• Leadership Development and Learning Programs


• Tuition Assistance Program