Ornge Careers

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.

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.

Total Rewards:

• Comprehensive Health, Dental and Vision Benefit Plan.
• 24/7 Employee and Family Assistance Program.
• Premium Defined Benefits Pension Plan Automatic Enrollment.
• Three Paid Personal Days (Pro-Rated for Year 1).
• Accrued vacation time starting at three weeks per year.
• PERKS! Employee Promotional Programs relating to personal phone plans, furniture, home/car insurance, travel, fitness, attractions and more!
• Tuition reimbursement and opportunities for learning and development.

At Ornge, we are:

• Community connectors.
• Equity in healthcare.
• Strong in our convictions.
• Proud of the services we provide.
• Uplifting in our mission, values, and services.

You can expect us to be:

• Competitive in pay, benefits, vacation time and more.
• Promoters of diversity.
• Champions of inclusivity and accessibility.
• Committed to your career advancement.
• A tight-knit, supportive culture.

A bit about you:

• You are driven by our collective desire to make a difference.
• Excited by problem solving and excels at in-the-moment decision making.
• Teamwork has always been where you thrive.
• You are ready to put your skills into action in a fast-paced environment.

What’s next:

• If you are ready to uplift lives, apply directly online.
• On apply, we’ll send you an email on how to check your application status within Jobvite.
• Ornge is committed to providing accessible accommodations in compliance with Accessibility for Ontarians with Disabilities Act (AODA). Should you require accommodation through any stage of the recruitment process, please email us at [email protected].
• Ornge encourages applications from candidates identifying as a member of a traditionally underrepresented group including First Nations, Métis, Inuit, and urban Indigenous peoples; Francophone persons; Black and racialized persons; members of 2SLGBTQIA+ communities; and persons with disabilities. 
• Ornge communicates with candidates for job openings by email and does not incorporate AI technology in its recruitment process. Applicants are responsible to check their email for updates and ensure they can receive messages from unfamiliar senders. We send time-sensitive information via email; it is important for applicants to check their email frequently. If we do not receive a response from applicants, we will assume that they are no longer interested in the position, resulting in the removal of their application from the competition.

Are you ready to pursue a career that has a profound impact on communities across Ontario, Canada? Join us.

Ornge. Lives uplifted.