Analyst 3, Case Costing & Statistical Analysis
Top Benefits
About the role
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, we deliver specialized care to the Eastern Ontario, Western Quebec and Eastern Nunavut regions. At The Ottawa Hospital, we don't just serve our community, we belong to the community. That insight is at the heart of our ambitious plan to reshape the future of healthcare for our community.
From the compassion of our people to the relentless pursuit of new discoveries, The Ottawa Hospital never stops seeking innovative solutions to the most complex health care challenges while continually engaging with the community to support our vision to provide each patient with the kind of care and compassion we would want for our loved ones.
Working together with its research institute, the University of Ottawa, and other partners, the hospital is continually gaining national and international recognition for high-quality patient care, teaching and research, while striving to meet the needs of the culturally diverse community we serve.
Position Information
Under the supervision of the Manager of Case Costing and Statistical Reporting, the analyst will be responsible for the following:
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 (e.g. clinical managers/directors), the senior management team, clinicians, finance department, QBP working groups, and external stakeholders such as the Ministry of Health and Ontario Health; 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 (e.g. Trial Balance Reporting); 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.
Rotation/Shifts
Days, 8 hour shifts.
For information purposes only - The Hospital reserves the right to change.
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).
The Ottawa Hospital uses a 5-level language proficiency scale to define the required level of language skills in English and in French for positions at the Hospital, and to evaluate job candidate language skills. Language proficiency requirements are based on the nature of the position and the level of interaction with French and English speaking clients.
Click here for additional information on The Ottawa Hospital's language proficiency levels.
What You Can Expect From Us
The Ottawa Hospital is committed to providing a healthy, safe, and inclusive work environment for everyone. We are driven by our purpose to provide each patient with the world-class care, exceptional service and compassion we would want for our loved ones.
We offer an attractive and equitable compensation package including a comprehensive benefits package, a Defined Benefit Pension (DBP) plan, and insurance protection. We also offer discounts from choice providers on a variety of products and services.
The Ottawa Hospital provides various Health and Wellness resources as well as opportunities for personal and professional development opportunities from our in-house Learning and Leadership Development team to help align your goals with your career objectives.
Interested? Apply today!
If you are passionate about what you do, motivated by improving the health of the community, excited by leading-edge medical technology, and as committed to excellence, quality and patient safety as we are, we would like to hear from you. Please submit an on-line application for the position you are interested in. We thank all those who apply but only those selected for further consideration will be contacted.
The Ottawa Hospital is an equal opportunity employer and is committed to providing an inclusive work environment. Candidates are encouraged to request accommodations throughout all stages of the recruitment process. These accommodation requests will be kept confidential. To request an accommodation or if you have any questions regarding accessibility, please contact TOHRecruitment@toh.ca.
Similar Jobs
Analyst 3, Case Costing & Statistical Analysis
Top Benefits
About the role
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, we deliver specialized care to the Eastern Ontario, Western Quebec and Eastern Nunavut regions. At The Ottawa Hospital, we don't just serve our community, we belong to the community. That insight is at the heart of our ambitious plan to reshape the future of healthcare for our community.
From the compassion of our people to the relentless pursuit of new discoveries, The Ottawa Hospital never stops seeking innovative solutions to the most complex health care challenges while continually engaging with the community to support our vision to provide each patient with the kind of care and compassion we would want for our loved ones.
Working together with its research institute, the University of Ottawa, and other partners, the hospital is continually gaining national and international recognition for high-quality patient care, teaching and research, while striving to meet the needs of the culturally diverse community we serve.
Position Information
Under the supervision of the Manager of Case Costing and Statistical Reporting, the analyst will be responsible for the following:
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 (e.g. clinical managers/directors), the senior management team, clinicians, finance department, QBP working groups, and external stakeholders such as the Ministry of Health and Ontario Health; 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 (e.g. Trial Balance Reporting); 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.
Rotation/Shifts
Days, 8 hour shifts.
For information purposes only - The Hospital reserves the right to change.
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).
The Ottawa Hospital uses a 5-level language proficiency scale to define the required level of language skills in English and in French for positions at the Hospital, and to evaluate job candidate language skills. Language proficiency requirements are based on the nature of the position and the level of interaction with French and English speaking clients.
Click here for additional information on The Ottawa Hospital's language proficiency levels.
What You Can Expect From Us
The Ottawa Hospital is committed to providing a healthy, safe, and inclusive work environment for everyone. We are driven by our purpose to provide each patient with the world-class care, exceptional service and compassion we would want for our loved ones.
We offer an attractive and equitable compensation package including a comprehensive benefits package, a Defined Benefit Pension (DBP) plan, and insurance protection. We also offer discounts from choice providers on a variety of products and services.
The Ottawa Hospital provides various Health and Wellness resources as well as opportunities for personal and professional development opportunities from our in-house Learning and Leadership Development team to help align your goals with your career objectives.
Interested? Apply today!
If you are passionate about what you do, motivated by improving the health of the community, excited by leading-edge medical technology, and as committed to excellence, quality and patient safety as we are, we would like to hear from you. Please submit an on-line application for the position you are interested in. We thank all those who apply but only those selected for further consideration will be contacted.
The Ottawa Hospital is an equal opportunity employer and is committed to providing an inclusive work environment. Candidates are encouraged to request accommodations throughout all stages of the recruitment process. These accommodation requests will be kept confidential. To request an accommodation or if you have any questions regarding accessibility, please contact TOHRecruitment@toh.ca.