linkedin
Analyst 3, Case Costing & Statistical Analysis
The Ottawa Hospital
Ottawa, CAN
Full Time
Mid
Onsite
Yesterday
Microsoft ExcelMicrosoft AccessPower BICrystal ReportsSQLData Analysis
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
Microsoft ExcelMicrosoft AccessPower BI
About the Role
The Ottawa Hospital is looking for an Analyst to support case costing and statistical reporting. The role involves analyzing financial and patient activity data, developing reports, and collaborating with stakeholders.
Key Skills for This Role
Microsoft ExcelMicrosoft AccessPower BICrystal ReportsSQLData Analysis
Responsibilities
- Understand end user requirements and identify data solutions using multiple data sources to respond to requests
- Support data driven decision making through analyzing, summarizing and presenting financial and statistical information to management and stakeholders
- Support regular tasks of processing financial and patient activity data to deliver consistent, accurate, and timely information to the General Ledger and case costing system
- Perform detailed analysis of source data systems and collaborate with other departments to develop and maintain efficient processes
- Support regular tasks of monthly and quarterly statistical reporting, including monthly financial statement preparation and quarterly reporting
- Assess, develop, and implement strategies to enhance data quality and ensure data meets standards
- Support various projects such as MOH & CCO case costing investigation, implementation of new data extracts
- Prepare, edit and maintain workflows, processes, procedures and documentation
Requirements
- University degree in financial management, business administration, or health informatics and a minimum of two years recent related work experience OR equivalent combination
- Experience and knowledge of Microsoft Suite tools (Excel, Access, PowerPoint, Power BI, SharePoint, Teams)
- Demonstrated experience with Report Writers (e.g. Crystal Reports, WebI, SQL) and strong understanding of databases
- Experience performing complex costing and statistical analysis with attention to detail
- Excellent communication and interpretation skills
- Eligible to work in Canada
Full Job Posting
About The Ottawa Hospital
- The Ottawa Hospital (TOH) is one of Canada's largest learning and research multi campus hospitals.
- With more than 1,400 beds and approximately 17,000 staff, physicians, residents and volunteers.
- Delivers specialized care to Eastern Ontario, Western Quebec and Eastern Nunavut regions.
Position Information
- Understand end user requirements and identify data solutions using multiple data sources (financial, statistical, coding, MoH guidelines, etc) to respond to requests
- Support data driven decision making through analyzing, summarizing and presenting financial and statistical/utilization information to internal operational management, senior management, clinicians, finance department, QBP working groups, and external stakeholders
- Support the regular tasks of processing financial and patient activity data to deliver consistent, accurate, and timely information to the General Ledger and case costing system, including issue resolution and reconciliation
- Perform detailed analysis of source data systems and collaborate with other departments to develop and maintain efficient processes to transform data for use in Case Costing and Statistical Reporting
- Support the regular tasks of monthly and quarterly statistical reporting, including monthly financial statement preparation and quarterly reporting to Ontario Health and Ministry of Health
- Assess, develop, and implement strategies to enhance data quality and ensure data meets Ministry and TOH standards
- Support various projects such as MOH & CCO case costing investigation, implementation of new data extracts, etc
- Prepare, edit and maintain workflows, processes, procedures and documentation
Basic Requirements
- University degree in financial management, business administration, or health informatics and a minimum of two years recent related work experience OR an equivalent combination of education and experience in the health care environment
- Experience and knowledge of the Microsoft Suite tools (Excel, Access, PowerPoint, Power BI, SharePoint, Teams, etc.)
- Demonstrated experience with Report Writers (e.g. Crystal Reports, WebI, SQL) and a strong understanding of databases
- Familiarity with Hospital Information Systems (EPIC preferred)
- Experience performing complex costing and statistical analysis with attention to detail, accuracy and ability to summarize results (healthcare preferred)
- Experience with validating and auditing data and understanding data governance principles
- Excellent communication and interpretation skills for dealing with hospital management on a daily basis
- High level of flexibility, organizational skills, teamwork and a demonstrated ability to analyze and resolve issues
- Ability to multi task and meet conflicting deadlines
- Must be able to work independently and in group situations
- Eligible to work in Canada
Preferred Qualifications
- Experience interpreting and applying CIHI Management Information System (MIS) Standards
- Familiarity with General Ledger reporting tools (Oracle and Hyperion Smartview) for the financial and statistical data
- Experience with data flows/data views, linking tables, querying databases, and building reports and dashboards with Power BI
- EPIC proficiency and/or certification
- Knowledge of the OCC (Ontario Case Costing) Standards
- Knowledge of Ministry of Health reporting as well as the Ontario specific methodologies (e.g. Ontario Healthcare Reporting Standards, Quality Based Procedures)
- Knowledge and use of various data sources regarding the utilization of clinical resources (e.g. CIHI's databases; DAD, NACRS, OMHRS, NRS and grouping methodologies: CMG, CACS, SCIPP, and RPG)
- Certification with the Canadian College of Health Information Management (CCHIM)
- Active member of the Canadian Health Information Management Association (CHIMA)
- Familiarity with Activity Based Costing
- Proficiency in English and French oral expression (level 4 advanced) and comprehension (level 4 advanced)
What You Can Expect From Us
- Attractive and equitable compensation package including comprehensive benefits, Defined Benefit Pension (DBP) plan, and insurance protection
- Discounts from choice providers on a variety of products and services
- Health and Wellness resources as well as opportunities for personal and professional development
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at The Ottawa Hospital
Analyst 3, Financial Planning & Analysis (FP&A)
Ottawa, CAN
MidTemporary
The Ottawa Hospital seeks a Financial Analyst to provide expert financial analysis, budgeting, and reporting. The role supports clinical and non-clinical programs with variance analysis and strategic decision-making. Can
2 days agoView →
Analyst 3, Case Costing & Statistical Analysis
Ottawa, CAN
MidFull Time
The Ottawa Hospital is looking for an Analyst 3 in Case Costing & Statistical Analysis to support data-driven decision making by analyzing financial and statistical information. The role involves processing data, prepari
3 days agoView →