Senior Case Costing Analyst

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

Benefits offered by this job

Defined Benefits pension plan

Comprehensive benefits package

Tuition Assistance

Employee wellness programs

Employee discounts

Job summary

Scarborough Health Network seeks a Senior Case Costing Analyst to elevate our case costing data capabilities. You will partner with FP&A to link patient-level costs with budgeting and funding analyses, delivering insights for operations and strategy across multiple sites.

You will extract, validate and model costing data, build reports, and support annual Ontario Case Costing processes while communicating complex findings to management and clinical stakeholders.

Qualifications

• Experience with Ontario Case Costing methodology and submission.
• CPA designation and in good standing.
• OHRS Guidelines knowledge preferred.
• 5+ years of related experience including variance analysis, budgeting and forecasting.
• Healthcare setting experience preferred.
• Strong data extraction and data manipulation skills.
• Knowledge of SQL and relational databases.

Responsibilities

• Support the annual Ontario Case Costing process, including data extraction, validation, cost allocation and timely submission.
• Maintain and enhance the case costing model and data feeds from hospital source systems.
• Analyze and report patient-level cost and clinical data to support operational and strategic decisions.
• Support funding analysis from QBP and other activity-based funding sources.
• Design and develop standard and ad-hoc reports for internal/external stakeholders.
• Assist in budgets and forecast development applying costing insights.
• Prepare variance analysis and commentary on financial and operational results.
• Build complex Excel financial models, including scenario analysis.
• Present analyses to clinical/organizational stakeholders and executives.

Skills

SQL

Excel (Advanced)

Power BI

PowerPoint

MS SQL Server

Data analysis

Data visualization

Harris Affinity

Education

Undergraduate degree (Commerce/Accounting/Health Admin/ Business Admin)

Master's in Health/Business Admin

Tools

Harris Affinity (MedAsset)

EPIC reporting

SAP reporting

Job description

Job Number: JR107449 Job Title: Senior Case Costing Analyst Union: Union: Job Category: Professional Hospital Location: Consilium Place Job Type: Permanent, Full time Number of Positions: 1 Minimum - Maximum Hourly Rate: $52.97 - $61.407 Hours: Days 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

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

  Asset

  • Masters in Health/Business Administration, Epidemiology or Statistics or equivalent
  • Excellent knowledge creating and editing SQL programs
  • Knowledge of EPIC and SAP reporting system preferred
  • Experience with Power BI or other data visualization tools

  Accommodation and Diversity Statement

  Scarborough Health Network (SHN) embraces and celebrates our community’s unique multicultural heritage and diversity. SHN is an equal opportunity employer, dedicated to a culture of inclusiveness and diversity reflecting our diverse patients, staff and community alike. We are committed to fostering an environment of equity and inclusivity where every person can work and receive care safely, openly and honestly. All qualified applicants will receive consideration for employment without regard to race, colour, religion, gender, gender identity or expression, sexual orientation, nation of origin, genetics, disability, age, veteran status, marital or family status, belief system, or other factors related to one’s personal identity and/or values. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs.

  Perks

  • Defined Benefit pension plan through the Healthcare of Ontario Pension Plan
  • Comprehensive insured benefits package including health and dental benefits
  • New Graduate Initiative
  • Enroute Program
  • Critical Care Sponsorship Program
  • Employee Discount and Incentive Programs
  • Employee and Family Assistance Program (EFAP), along with other comprehensive wellness offerings, including our Spiritual Care team of registered psychotherapists for spiritual, religious or emotional care; mental health supports; and on-site wellness rounding
  • Recognition events
  • Leadership Development and Learning Programs
  • Tuition Assistance Program