Senior Developer, Business Intelligence

Ontario Health; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

Ontario Health is seeking a Senior BI Developer in Toronto to drive impactful BI solutions across multiple health program areas. Candidates should possess extensive experience in BI tools, particularly Power BI, and a solid background in healthcare informatics. This role involves close collaboration with stakeholders to enhance and develop BI applications, requiring strong analytical skills and project management expertise. Enjoy a hybrid working model and numerous employee benefits while contributing to the improvement of health outcomes across the province.

Benefits

Fully paid medical, dental and vision coverage

Health care spending account

Three weeks’ vacation to start (increasing after two years)

Wellness program

Participate in Communities of Inclusion

Qualifications

• Minimum 5-7 years of BI experience in healthcare preferred.
• Experience with data modeling and BI solution deployment required.
• Strong problem-solving skills and attention to detail.

Responsibilities

• Analyze business requirements for BI projects.
• Design and implement BI solutions according to business needs.
• Produce technical documentation related to BI solutions.

Skills

DAX

SQL

Power BI

Data visualization

Agile project management

Education

Bachelor’s or Master’s degree in healthcare informatics

Tools

Microsoft Power BI

Power Platform

Azure services

MicroStrategy

Job description

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

Three personal days and two float days annually

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

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

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 [emailprotected] 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.

J-18808-Ljbffr

Create a job alert for this search