Senior Case Costing Analyst

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
• Experience summarizing results and producing management reports
• Experience producing and delivering communications to the Executive Level
• Excellent analytical and problem solving skills, with strong attention to details
• Outstanding attention to detail and adherence to deadlines
• Demonstrate ability to multi-task with an eye for detail within a fast-paced environment
• Ability to work effectively, both independently and as a member of a team
• Ability to “think outside the box” while identifying problems and developing creative solutions
• Demonstrate a commitment to customer service when dealing with patients, colleagues, volunteers and other members of the community and public
• Demonstrates values consistent with SHN’s Code of Conduct and is committed to fostering a healthy and positive work environment in accordance with Health & Safety policy and legislation.
• Utilize protective equipment provided and identify and reports hazards
• Engages in ethical conduct and strives to understand and appreciate the diversity of our patient/staff population and community
• Excellent work performance and attendance

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

This opportunity is posted to support the recruitment of an existing vacant position.

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.

Learn more about our exciting opportunities by following SHNCareers on Instagram, Twitter, and Facebook.