Business & Data Analyst

Public Health Ontario; Toronto; On-site; CAD 90,000 - 112,000; Full time

Job summary

Public Health Ontario is seeking an experienced Data Analyst to provide advanced analytics, validation, and visualization support to Finance-led initiatives. The role focuses on transforming clinical, operational, and financial data into actionable insights for executive decision-making and strategic planning.

You will develop dashboards in Power BI, collaborate with Finance, Laboratory Operations, and Digital & Data teams, and support cost-saving and process-improvement projects with rigorous

Qualifications

• Bachelor’s degree in Finance/Business or related field.
• 5–7 years of data analysis experience, preferably in healthcare, public sector, or complex operational environments.
• Advanced Excel including data manipulation, Power Query, and data modeling is required.
• Experience with Power BI or similar visualization tools is preferred.
• Working knowledge of SQL is considered an asset.

Responsibilities

• Integrate and structure clinical, operational, and financial datasets.
• Lead data quality assessment, validation, and reconciliation.
• Analyze data to identify trends, cost drivers, and efficiency opportunities.
• Develop dashboards and visual outputs (Power BI) for senior leadership.
• Support priority initiatives with targeted data analysis.
• Identify opportunities to automate and improve data flows and reporting.
• Collaborate with Finance, Laboratory Operations, and Digital & Data teams.
• Provide business analysis and decision support with forecasts and variance commentary.
• Lead cost/benefit analyses and business cases for operational scenarios.
• Other duties as assigned.

Skills

Advanced Excel

Power BI

SQL

Data analysis

Data visualization

Education

Bachelor’s degree in Finance/Business

Tools

Power Query

Job description

Department: Planning, Reporting & Compliance

This posting is to fill a current vacancy.

The Role

To provide advanced data analytics, validation, and visualization support to Finance-led special projects. This role focuses on transforming clinical, operational, and financial datasets into clear, actionable insights to support executive decision-making, strategic planning, and operational improvement initiatives.

Key Responsibilities-

• Data Integration & Management: Extract, integrate, and structure complex clinical, operational, and financial datasets from multiple systems.
• Data Validation & Governance: Lead data quality assessment, validation, and reconciliation to ensure reliable inputs for executive reporting.
• Advanced Analysis & Insight Generation: Independently analyze data to identify trends, drivers, and opportunities related to cost, performance, and operational efficiency.
• Executive Visualization & Storytelling: Develop dashboards and visual outputs (e.g., Power BI) and translate insights into clear, actionable recommendations for senior leadership.
• Special Projects Delivery: Support priority initiatives (e.g., cost savings, process optimization etc.) through targeted data analysis.
• Process & Reporting Improvement: Identify opportunities to automate, standardize, and improve data flows and reporting processes.
• Cross-Functional Collaboration: Partner with Finance, Laboratory Operations, and Digital & Data teams to define requirements and deliver insights aligned to organizational priorities.
• Business Analysis and Decision Support: Partner with operational leaders and business unit to analyze volume trends, performance metrics, and business data, providing actionable insights that support informed decision-making and operational improvements.
• Provides financial analysis and reporting for assigned programs/departments including advising and supporting the development of forecasts, preparing monthly variance analysis and commentary on spending.
• Leads/Develops cost/benefit analyses and business cases for operational scenarios/special projects.
• Other duties or projects as assigned.

Education And Experience-

• Bachelor’s degree in Finance/ Business or a related field.
• 5–7 years of experience in data analysis, preferably within healthcare, public sector, or complex operational environments.
• Advanced Excel including data manipulation, Power Query, and data modeling is required.
• Experience with Power BI or similar visualization tools is preferred.
• Working knowledge of SQL is considered an asset.

Knowledge And Skills-

• Strong analytical and problem-solving skills with ability to work through complex and ambiguous datasets.
• Ability to translate clinical and operational data into financial and strategic insights.
• Strong communication skills with ability to present insights to non-technical and executive audiences.
• High attention to detail and data integrity.
• Oral communication and interpersonal skills, to provide technical advice and guidance to peers and liaise with all levels of internal and external stakeholders/contacts.
• Written communication skills to prepare commentary on analyses develop and deliver presentations, training documents and procedural guidelines.

Attributes and Competencies-

• Works independently to structure analyses, validate data, and develop insights to support decision-making. Exercises judgment in interpreting data, identifying risks and issues, and recommending solutions to support Finance and operational leadership.
• Identifies and summarizes program/department current month and year-to-date variances and forecast issues and provides resolution to related issues.
• Prepares and reviews cost benefits analyses and business cases on various operational scenarios/ special projects to make recommendations to support management financial decision making.
• Ensures cost centre managers understand their financial reports in support of the financial management of their respective cost centres.

Duration: Permanent

Hours of Work: Full time, 36.25 hours per week

Compensation Range :$47.93 - $59.26

Posting Date: 09-15-2026

Closing Date: 09-25-2026

Please note:

applications will be received no later than 11:59pm on the date preceding the closing date as indicated on the Job Requisition.

Note: Internal candidates will be considered first.

While we thank all applicants for their interest, only those selected to move forward in the recruitment process will be contacted. Any information obtained during the course of recruitment will be used for employment recruitment purposes only, and not for any other purpose.

PHO is committed to ensuring equity in employment. Our goal is to create a diverse, inclusive workforce that reflects the communities we serve and to ensure our services and communications are accessible to all individuals. Any candidate who requires a job posting in an alternative format may email a request to [e-mail]. Once an applicant has been selected for an interview, they can inform PHO about any accommodations they may require at any stage of the interview process.