Job Number: JR107449Job Title: Senior Case Costing AnalystUnion:Union:Job Category: ProfessionalHospital Location: Consilium PlaceJob Type: Permanent, Full timeNumber of Positions: 1Minimum - Maximum Hourly Rate: $52.97 - $61.407Hours: Days
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.
Learn more about our exciting opportunities by following SHNCareers on Instagram, Twitter, and Facebook.
