Senior Developer, Business Intelligence

Ontario Health; Old Toronto; Hybrid; CAD 70,000 - 110,000; Full time

Job summary

Join a forward-thinking health organization as a Senior Developer in Business Intelligence. This role offers the chance to create impactful BI solutions that enhance healthcare outcomes across Ontario. You will work closely with various stakeholders to analyze requirements, design and implement BI solutions, and ensure effective delivery of services. With a commitment to innovation and collaboration, this position provides an exciting opportunity to contribute to a healthier future for all. Embrace a hybrid working model and enjoy a comprehensive benefits package, including paid medical coverage and generous vacation time. If you are passionate about making a difference in healthcare, this role is for you.

Benefits

Fully paid medical, dental and vision coverage

Health care spending account

Premium defined benefit pension plan

Three personal days and two float days annually

Three weeks’ vacation to start

Career development opportunities

Collaborative team culture

Wellness program

Qualifications

• 5-7 years of experience in BI and analytics projects.
• Proven track record in healthcare BI solutions development.

Responsibilities

• Analyze and design BI solutions for various healthcare programs.
• Collaborate with stakeholders to implement BI services across domains.

Skills

Microsoft Power BI

DAX

SQL

Power Query

Agile project management

Data visualization

Python

Azure services

MicroStrategy

SSIS / SSRS

Education

Bachelor’s or Master’s degree in healthcare informatics

Equivalent experience in a related field

Tools

Microsoft Power BI Desktop

Tabular Editor

DAX Studio

VertiPaq Analyzer

Power Platform

Job description

Senior Developer, Business Intelligence

Apply locations Ontario Health – Toronto, ON time type Full time posted on Posted 3 Days Ago time left to apply End Date: January 18, 2025 (22 days left to apply) job requisition id R107415

At Ontario Health, we are committed to developing a strong organizational culture that connects and inspires all team members across the province. Our vision is that together, we will be a leader in health and wellness for all. Our mission is to connect the health system to drive improved and equitable health outcomes, experiences and value. How we work together is reflected through our five values: integrity, inspiration, tenacity, humility and care.

What Ontario Health offers:

• Fully paid medical, dental and vision coverage from your first day

• Health care spending account

• Premium defined benefit pension plan

• Three personal days and two float days annually

• Three weeks’ vacation to start (for individual contributors), increasing to four weeks after two years

• Career development opportunities

• A collaborative values-based team culture

• A wellness program

• A hybrid working model

• Participation in Communities of Inclusion

Want to make a difference in your career? Consider this opportunity.

Reporting to the Manager, Business Intelligence (BI), the Senior BI Developer will work closely with the Technical and Operational Leads to perform development activities supporting both new development and enhancements for multiple BI projects supporting OH programs. The team focuses on delivering and facilitating BI solutions for multiple OH program areas including Cancer, Access to Care and other Domains. The Senior Developer will create significant impact across the organization by engaging with and providing BI services to stakeholders from any of the 40 business Domains or program areas. The team also supports enterprise initiatives related to BI platforms, governance and provision of services in the context of hub-and-spoke model. The BI solutions could include new projects, enhancements to existing projects and customizations to address business requirements. The Senior BI Developer will work with OH program stakeholders in addition to corporate service partners to design, prototype, develop, test, and implement comprehensive BI solutions. As part of this role, the Senior BI Developer would understand requirements, design, and document BI solution, develop, support the testing, and help deliver final solutions to production. The Senior BI Developer will also facilitate and advise regarding the development and publication of BI solutions created by other teams within OH.

Here is what you will be doing:

• Analyze business requirements for new projects and enhancement requests.

• Estimate overall effort considering interdependencies among applications.

• Design, prototype, develop, and implement BI solutions, including standard processes and technologies.

• Facilitate and advise regarding the development and publication of BI solutions created within the team and by other teams within OH.

• Create substantial impact across the organization by framing BI solution patterns for various use cases that can also be used by reporting teams from various domains and program areas.

• Customize BI platform to meet the business requirements.

• Apply extensive software engineering, change management and project management knowledge to project delivery.

• Make recommendations for BI application development based on industry best practices and standards.

• Support troubleshooting of production related issues, coordinating the involvement of IT operations, EDW team and any other required personnel.

• Produce technical documentation related to BI solutions and associated processes.

• Keep abreast of new technology trends and standards. Proactively learn new BI functionality and BI platform components.

• Establish good working relationships with team members and people from different departments with varying degrees of business and/or technical experience.

• Ability to work independently with minimal supervision.

• Provide direct support to the Manager, BI, to ensure delivery of BI solutions to OH programs and other groups as required.

• Additional roles & responsibilities may evolve, and change based on need of stakeholders and the portfolio.

Here is what you will need to be successful:

Education and Experience

• Bachelor’s or Master’s degree in healthcare informatics, Health Administration or similar discipline, or equivalent experience.

• Proven track record in designing, developing, and implementing business intelligence and analytics solutions in healthcare is preferred.

• Minimum 5-7 years of related experience, including experience leading, managing, developing and deploying business intelligence and analytics projects.

Knowledge and Skills:

• Extensive experience in Microsoft Power BI Desktop, Microsoft Power BI Dataflows, Microsoft Power BI Report Builder, Tabular Editor, DAX Studio and VertiPaq Analyzer

• Proficient in DAX, M, Power Query, SQL and performance optimization

• Experience in developing and implementing Power BI solutions. This includes data modelling, designing, development and testing of reports.

• Experience with other BI tools such as MicroStrategy, Dundas BI, SSIS / SSRS is an asset.

• Experience with Power Platform (e.g. Power Automate, Power Apps)

• Experience with Azure services (including Synapse), cloud, data lake and big data technologies.

• Experience working with tools or platforms related to data visualization, analytics & business intelligence (Python, R, SAS).

• Strong expertise with the entire Software Development Life Cycle involved in designing, developing, testing, deploying, and maintaining Business Intelligence solutions.

• Expert in Agile project management approaches

• Strong communication skills with experience interpreting, synthesizing analytic and technical information, and presenting to key stakeholders and leaders.

• Experience working with stakeholders from Program areas as well as key corporate services such as Enterprise Data Warehouse, Data Architecture, Data Engineering, Quality Assurance, Security, Privacy, Product Management and Business Intelligence teams to develop and deploy business intelligence solutions.

• Advanced problem-solving capability with excellent attention to detail.

• Ability to work effectively both autonomously and as a part of a team.

• Knowledge of Ontario’s health care environment and OH initiatives is an asset.

#LI-hybrid

#LI-RN

Location: Toronto, Ontario (currently hybrid; subject to change)

Employment Type: Permanent Full time

Contract Length: N/A

Salary Band: Band 6

External Application Deadline Date: January 17, 2025

All applicants must be a resident of Ontario to be considered for roles at Ontario Health.

Ontario Health encourages applications from candidates who are First Nations, Métis, Inuit, and urban Indigenous; Francophone; members of Black and racialized groups; 2SLGBTQIA+ communities; trans and nonbinary individuals; and people living with disabilities.

Ontario Health is an accessible employer, and we offer accommodation in all aspects of employment, including the recruitment process. If you require a disability related accommodation in order to participate in the recruitment process, please email [e-mail] and a member of the team will connect with you within 48 hours.

Get in Touch

Introduce yourself to our Talent Acquisition team and we will get in touch if there is a role that seems like a good match.

About Us

Ontario Health is the provincial agency responsible for ensuring Ontarians receive high-quality health care services where and when they need them. Since it was established in June 2019, Ontario Health has brought together the strengths of many existing health care organizations to work together to build a better health care system for all Ontarians. Building on the expertise and knowledge of our people, we are committed to applying the best of what we collectively do, and in partnership with others, to transform the health system and improve the quality and delivery of care for patients, families, and health care providers.