Bi Developer

Description:

BUSINESS INTELLIGENCE DEVELOPER

Reference #2026-33
Strong. Proud. Uplifting.

At Ornge, we believe that ordinary people can do extraordinary things.

Each day, we connect communities with critical care across Ontario, Canada. In the air and by land, our teams deliver equity in emergency response, uplifting the lives of those in our care.

We are excited to onboard individuals who bring energy, enthusiasm, and professionalism to our growing group of difference-makers and life-changers.

Discover Ontario, Canada, and an exciting career with Ornge.

Position Title

Business Intelligence Developer

The targeted salary range is supplemented by a competitive total rewards package. The salary offered to the successful candidate will consider a wide array of factors such as the individual’s skillset, level of experience applicable to the role and internal equity considerations.

Uplifting Your Career at Ornge

We are seeking a skilled Business Intelligence (BI) Developer to design, develop, and maintain the data and reporting solutions that support critical decision‑making within Ontario’s healthcare system. In this role, you will build interactive dashboards, create and optimize data models, enhance BI system performance, and ensure the reliability and accuracy of information used across the organization.

This is an excellent opportunity for a technically strong, analytical professional who enjoys solving complex problems and contributing to impactful healthcare operations.

Key Accountabilities:

BI Development

• Develop and maintain advanced BI reporting solutions, dashboards, and data visualizations.
• Integrate new data sources into the data warehouse and design efficient ETL and data transfer processes.
• Conduct thorough unit and system testing to ensure accuracy, reliability, and functionality.
• Troubleshoot technical issues, optimize report performance, and propose system improvements.
• Build proof‑of‑concept reporting solutions to demonstrate value and explore emerging BI tools.

System Support

• Diagnose and resolve BI system issues to ensure stability and high performance.
• Support system upgrades, coordinate user acceptance testing, and deliver training.
• Collaborate with internal teams and external vendors to resolve technical or infrastructure-related challenges.

Operational Effectiveness

• Engage with internal business stakeholders to gather requirements and translate them into actionable BI solutions.
• Develop queries, data models, and reporting applications that support insights and forecasting.
• Ensure solutions align with organizational priorities and enable accurate, timely decision-making.

Qualifications:

• Post‑secondary degree or diploma in Computer Science, Information Technology, or a related field, or equivalent work experience.
• 3–4 years of experience in Business Intelligence, data warehousing, analytics development, or similar technical roles.
• Experience working in healthcare, aviation, or other regulated environments is an asset.
• Advanced proficiency with Microsoft SQL Server (2020 or later), including Reporting Services (SSRS), Analysis Services (SSAS), and Integration Services (SSIS).
• Strong experience developing and optimizing complex SQL queries, stored procedures, and user‑defined functions.
• Experience designing, implementing, and validating ETL processes with a focus on data quality and integrity.
• Familiarity with programming and development tools such as Visual Studio (C# or VB.NET) and ASP.NET.
• Strong understanding of BI environments and cloud technologies, including AWS, Amazon QuickSight, Azure, and Power BI Service.