Business Intelligence Developer

$78,682 - $91,808 yearly
  • Ontario Hospital Association
  • Hybrid (Hamilton, ON L8P 1H6, Canada)
  • Nov 25, 2022
Full time Health Care

Job Description

Business Intelligence Developer

Data and Analytics Division

Full-time Permanent (Hybrid: 2 days/week in office, 3 days/week WFH)

Target Hiring Range $78,682 - $91,808


Position Profile:

The Ontario Hospital Association (OHA)’s 2018-2021 Strategic Plan includes a bold new vision for the OHA as an organization that will “improve the availability and effective use of data and analytics to help support better performance”. To that end, OHA now hosts an online platform and suite of data analytics tools for our hospital members and other clients. Going forward, we will continue to strengthen our foundation for achieving this vision, through building additional tools to enable impactful, client-facing analytics solutions.


Integrated Decision Support (IDS) is a leading collaborative solution for sharing and linking health partner data for planning, performance monitoring, analytics, quality improvement, outcome evaluation, and population health management.  As part of the OHA Data & Analytics Portfolio, IDS provides timely, integrated patient level data across the continuum of care to support health sector initiatives. Currently, IDS links patient data for more than 100 health service providers across several regions. It supports 900 plus users as they gather insights derived from the data representing over 149 million encounters from more than 9 million unique patients.


The Position:

Reporting to the Senior Manager, IDS, the Business Intelligence Developer’s primary role is to program and implement new business intelligence solutions, design enterprise-level solutions for medium to large databases, and implement changes to the data warehouse model. Your responsibilities will include:


Solution Development (50%):

·         Collaborate with the IDS interdisciplinary team and other internal or external experts to co-design and develop technical and functional solutions geared toward solving defined business problems

·         Design and develop ETL processes to integrate new data sources into IDS’ dimensional DW

·         Code and implement proof-of-concept solutions, early proving of capabilities before they are made available for wider consumption

·         Execute unit and integrated system testing on programming changes to ensure viability and accuracy by creating test cases

·         Troubleshoot and resolve technical issues, debug, tune and optimize report performance

·         Recommend improvements to provide optimum reporting solutions

System Support (25%):

·         Ensures BI environment is optimized to address business requirements by diagnosing and repairing user and performance issues including: testing, monitoring and tuning software

·         Proposing DW data model changes pertaining to reporting requirements, including report definition, layout, business rules, and documentation

·         Systems upgrade planning and scheduling, user acceptance testing and subject matter expert training in order to deliver effective reporting solutions

·         Analyze Portal and DW data errors/issues/problems, determine cause and initiate corrective action when necessary

Supporting Other Data Analytics Projects as Required (25%):

Collaborate with the IDS Team and other stakeholders on unique projects as they emerge. Understand and gather business requirements, determine business intelligence and data warehousing solutions, translate into queries, models, and BI applications to allow for insightful end-user data analytics and forecasting.


The Candidate:

The ideal candidate must possess the following:

  • University degree or college diploma in Computer Science or related discipline
  • Minimum 3 years of experience in business intelligence and data warehousing application development in an IT or software development organization, healthcare application experience is preferred
  • Advanced knowledge of Microsoft SQL Server 2019, including Reporting Services, Analysis Services and Integration Services 
  • Good working knowledge of Visual Studio 2019 (C# or VB.NET), ASP.NET, AzureDevOps
  • Advanced knowledge of relational databases - advanced SQL and table designing / schema skills
  • Working experience with multidimensional databases.
  • Good understanding of system environment of Windows Server 2012/2019 and IIS, SAN, personal computers and web applications.


You must have excellent interpersonal, facilitation, written and verbal communication skills as well as strong research and analytical skills and proven project management expertise. Working in a team environment, the Business Intelligence Developer will be a highly motivated self-starter who enjoys working in a fast-paced environment, is able to build successful relationships with a variety of stakeholders and enjoys turning detailed data into impactful insights.


Nice to have (non-essential)

Experience working with clinical, financial, or administrative datasets within acute care settings, LHINs, or other healthcare sectors will be an asset.


The ideal candidate is dynamic, positive, collaborative, persuasive, resilient, driven and results-oriented and displays the values of Humility, Discovery, and Passion.


The Organization:

Are you interested in helping build a better health system for Ontario?

The Ontario Hospital Association (OHA) can offer you a fulfilling role, an inspiring and creative place to work, and the opportunity to change the healthcare system for the better, while having a lot of fun in the process. We’re also committed to fostering an environment of inclusivity, where diversity is celebrated.

You may know that employee engagement is key to the success of any business, and that’s why OHA is proud of our 100% employee engagement rate. We’ve also been recognized as one of the Best Workplaces in Canada (five times!). Our 2022 Best Places to Work award from Human Resources Director amplifies our commitment to a culture that upholds DEI, mental wellness, and compassionate leadership.

Who is the OHA?

We’re a not-for-profit association whose purpose is serving Ontario’s hospitals to build a better health system. Our members are at the heart of everything we do. Established in 1924, the OHA serves as the voice of the province’s public hospitals, supporting them through advocacy, knowledge translation and member engagement, labour relations, and data and analytics.

For more information visit or follow us on Twitter.


To Apply:

The OHA is committed to fostering a climate of equity, diversity, inclusion, and accessibility. We welcome and respect the diversity of all members of our community. We welcome applications from Black individuals and Persons of Colour, Indigenous Peoples, women, persons with disabilities, LGBTQ2+ persons, and others who may contribute to the further diversification of ideas within our community. OHA is committed to fair assessment of a candidate’s abilities, and consideration for diversity of thought, method, and experience, including non-traditional career paths.

The successful applicant must be fully vaccinated against COVID-19 (as defined by the Government of Canada) or have a valid vaccination exemption pursuant to the Human Rights Code. Further, they must provide proof of vaccination (or a valid exemption) prior to the start date, provide updated information as necessary, and comply with any ongoing vaccination-related requirements.

Potential applicants are invited to submit a resume and covering letter by December 12, 2022. If contacted for an interview, please inform us should accommodation be required.