Senior Case Costing Analyst

Scarborough Health Network; Toronto; On-site; CAD 73,000 - 85,000; Full time

Job summary

Scarborough Health Network is seeking a Senior Case Costing Analyst to elevate our case costing data capabilities and reporting. You will work with the FP&A team to link patient-level data to budgeting, forecasting, and funding analyses, providing insights for operational and strategic decisions.

The role requires strong analytical skills, experience with health-care costing methodologies, and the ability to present to executives.

Qualifications

• 2 years of experience with Ontario Case Costing methodology and submission process.
• 5+ years of related work experience including variance analysis, financial accounting, financial reporting, data interpretation, forecasting, planning and budgeting.
• Excellent knowledge of the OHRS (MIS) Guidelines as prepared by the MOHLTC preferred.
• Experience with Case Mix and HIG Methodology, DAD & NACRS, OMHRS, CCRS and NRS.
• Working knowledge of data stored in hospital source systems with extraction and manipulation skills
• Knowledge of SQL and relational databases
• Advanced experience in Microsoft Office suite, particularly expert Excel and advanced PowerPoint skills, as well as Access and MS SQL Server Management Studio
• Extensive knowledge of data quality methodologies

Responsibilities

• Support the annual Ontario Case Costing process, including data extraction, validation, cost allocation and timely submission in line with provincial standards.
• Maintain and enhance the case costing model and related data feeds from hospital source systems.
• Analyze, interpret and report patient-level cost and clinical data to support operational and strategic decision making.
• Use case costing data to support funding analysis, including QBP and other activity-based funding sources.
• Design and develop standard and ad-hoc reports for internal and external stakeholders.
• Support budget and forecast development, applying case costing insights to project and track volumes, costs and financial metrics.
• Prepare variance analysis and commentary on financial and operational results.
• Build complex financial models in Excel, including scenario analysis.
• Interact frequently with clinical and organizational stakeholders to present analyses and discuss recommendations.
• Prepare clear, concise summaries and presentations for management and executive audiences

Skills

Communication skills

Interpersonal skills

Self-starter

Analytical mindset

Client-focused

Education

Undergraduate degree

CPA designation

Tools

SQL

MS SQL Server Management Studio

Excel

PowerPoint

Access

Harris Affinity

Job description

Job Description

Position overview: We are recruiting for a Senior Case Costing Analyst to take our knowledge and use of case costing data to the next level.

Reporting to the Senior Manager, Financial Planning & Analysis and Case Costing, you will support the development, implementation and maintenance of the case costing initiative and ensure all reporting requirements are met. You will support the hospital's information and analysis needs by analyzing, interpreting and reporting clinical information on both a regular and ad-hoc basis to meet internal and external reporting requirements. You will provide insight in the use of case costing data for operational and strategic decision making through various analytic avenues.

This role also works closely with the Financial Planning & Analysis (FP&A) team, linking patient-level cost data to budgeting, forecasting and funding analysis. The successful candidate will be a self-starter who can work independently in a fast-paced environment, with excellent communication and interpersonal skills and a client-focused approach.

Key Responsibilities

• Support the annual Ontario Case Costing process, including data extraction, validation, cost allocation and timely submission in line with provincial standards
• Maintain and enhance the case costing model and related data feeds from hospital source systems
• Analyze, interpret and report patient-level cost and clinical data to support operational and strategic decision making
• Use case costing data to support funding analysis, including QBP and other activity-based funding sources
• Design and develop standard and ad-hoc reports for internal and external stakeholders
• Support budget and forecast development, applying case costing insights to project and track volumes, costs and financial metrics
• Prepare variance analysis and commentary on financial and operational results
• Build complex financial models in Excel, including scenario analysis
• Interact frequently with clinical and organizational stakeholders to present analyses and discuss recommendations
• Prepare clear, concise summaries and presentations for management and executive audiences

Requirements

• Undergraduate Degree (Commerce/Accounting/Health Care Administration/ Business Administration) preferred.
• Designated Chartered Professional Accountant and in good standing.
• 2 years of experience with Ontario Case Costing methodology and submission process.
• Excellent knowledge of the OHRS (MIS) Guidelines as prepared by the MOHLTC preferred.
• 5+ years of related work experience including variance analysis, financial accounting, financial reporting, data interpretation, forecasting, planning and budgeting.
• Experience in a Health Care setting preferred.
• Exceptional technical skills related to working with large data sets
• Experience with Case Mix and HIG Methodology, DAD & NACRS, OMHRS, CCRS and NRS
• Working knowledge of Harris Affinity software (formerly MedAsset).
• Knowledge of the data stored in hospital source systems with extraction and manipulation skills
• Knowledge of SQL and relational databases
• Advanced experience in Microsoft Office suite, particularly expert Excel and advanced PowerPoint skills, as well as Access and MS SQL Server Management Studio
• Extensive knowledge of data quality methodologies
• Experience preparing analyses of operational, clinical and quality measures
• Demonstrated experience in designing and developing standard and ad-hoc reports
• Experience supporting budgets, forecasts and variance analysis
• Experience summarizing results and producing management reports
• Experience producing and delivering communications to the Executive Level
• Excellent analytica

Job Details

Job Type: Permanent, Full time

Number of Positions: 1

Minimum – Maximum Hourly Rate: $52.97 – $61.407

Hours: Days

About Scarborough Health Network

Across our three hospitals and eight satellite sites, Scarborough Health Network (SHN) is shaping the future of care. Our many programs and services are designed around the needs of one of Canada's most vibrant and diverse communities. We are home to North America’s largest nephrology program, as well as the designated cardiac care and spine centre for Scarborough and surrounding communities to the east. We are proud to be a community‑affiliated teaching site for the University of Toronto and partner with a number of other universities and colleges, helping to train the next generation of health care professionals. SHN is the recipient of the 2021 Excellence in Diversity and Inclusion Award, from the Canadian College of Health Leaders, for our leading edge work on Communities of Inclusion, Inclusion Calendar, Health Equity Certificate Program and much more. We are also proud to be named Canada's Most Admired Corporate Cultures for 2023‑2025 and Greater Toronto’s Top Employers for 2026. Learn more at shn.ca