Business & Data Analyst

Job summary

The role involves providing advanced data analytics, validation, and visualization support to Finance-led special projects to drive executive decision-making. Responsibilities include integrating complex datasets, developing dashboards, and performing financial analysis to support operational efficiency and strategic initiatives.

Job details

Business & Data Analyst Location: Toronto-661 University 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 Group:Ontario Public Service Employees Union 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 HR_Inquiries@oahpp.ca. 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.

What you’ll do

The role involves providing advanced data analytics, validation, and visualization support to Finance-led special projects to drive executive decision-making. Responsibilities include integrating complex datasets, developing dashboards, and performing financial analysis to support operational efficiency and strategic initiatives.

Requirements

Candidates must hold a Bachelor’s degree in Finance, Business, or a related field and possess 5–7 years of experience in data analysis within complex environments. Proficiency in advanced Excel and data visualization tools like Power BI is required, with SQL knowledge considered an asset.

Listed skills

• Data visualization · Preferred
• Power BI · Preferred
• Process Optimization · Preferred
• SQL · Preferred
• Problem solving · Preferred
• Data Validation · Preferred
• Microsoft Excel · Preferred
• Communication · Preferred
• Reporting · Preferred
• Financial analysis · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data Analytics
• Data Validation
• Data Visualization
• Financial Analysis
• Power BI
• Excel
• SQL
• Data Modeling
• Reporting
• Variance Analysis
• Cost-benefit Analysis
• Strategic Planning
• Process Optimization
• Data Governance
• Communication
• Problem-solving
• Business Metrics
• Data Quality Assessment
• Cross-Functional Collaboration
• Operational Efficiency
• Reporting Processes
• Planning
• Data Analysis
• Reconciliation
• Business Analysis
• Dashboard
• Management
• Decision Making
• Data Integration
• Data Integrity
• Data Manipulation
• Decision Support Systems
• Finance
• Financial Management
• Financial Statements
• Forecasting
• Governance
• Leadership
• Interpersonal Communications
• Problem Solving
• Operational Data Store
• Operations
• Performance Metric
• Presentations
• SQL (Programming Language)
• Verbal Communication Skills
• Advising
• Detail Oriented

Job areas

• Data & Analytics
• Finance & Accounting
• Government & Public Sector
• Healthcare
• Technology
• Business Data Analyst
• Business Analyst (General)
• Management and Organization Analysts
• Management Analysts