BI Developer

Description

BUSINESS INTELLIGENCEDEVELOPER

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

Department/Section

Criticall

Employment Status

Permanent Full Time

Targeted Salary Range

$86,281-$102,459

Work Mode

Hybrid (2 Days Per Week)

Existing Vacancy

Yes

Location

1725 Upper James Street, Hamilton

Hours of Work

Monday to Friday, 37.5 hours per week

Posting Open Date

Tuesday February 24, 2026

Posting Close Date

Tuesday March 3, 2026

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 and .
• 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.