Analyst 3, Case Costing & Statistical Analysis
Top Benefits
About the role
About The Ottawa Hospital Inspired by research and driven by compassion!
The Ottawa Hospital (TOH) is one of Canada's largest learning and research multi-campus hospitals. With more than 1,100 beds and approximately 12,000 staff members, we deliver specialized care to the Eastern Ontario region.
From the compassion of our people to the relentless pursuit of new discoveries, The Ottawa Hospital never stops seeking solutions to the most complex health-care challenges while continually engaging with the community to support our vision for better patient care.
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.
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 (advanced level) and comprehension (advanced level).
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. Upon request, accommodations due to a disability are available throughout the recruitment process.
About The Ottawa Hospital
The Ottawa Hospital is one of Canada’s largest learning and research hospitals, with more than 1,100 beds, approximately 12,000 staff members and an annual budget of about $1.2 billion.
Our focus on learning and research helps us develop new and innovative ways to treat patients and improve care. As a multi-campus hospital affiliated with the University of Ottawa, we deliver specialized care to the Eastern Ontario region, but our techniques and research discoveries are adopted around the world. We engage the community at all levels to support our vision for better patient care.
From the compassion of our people to the relentless pursuit of new discoveries, The Ottawa Hospital never stops seeking solutions to the most complex health-care challenges.
L’Hôpital d’Ottawa Inspiré par la recherche. Guidé par la compassion.
L’Hôpital d’Ottawa est l’un des plus importants hôpitaux d’enseignement et de recherche au Canada. Il est doté de plus de 1 100 lits, d’un effectif de quelque 12 000 personnes et d’un budget annuel d’environ 1,2 milliard de dollars.
L’enseignement et la recherche étant au cœur de nos activités, nous possédons les outils qui nous permettent d’innover et d’améliorer les soins aux patients. Affilié à l’Université d’Ottawa, l’Hôpital fournit sur plusieurs campus des soins spécialisés à la population de l’Est de l’Ontario. Cela dit, nos techniques de pointe et les fruits de nos recherches sont adoptés partout dans le monde. Notre vision consiste à améliorer la qualité des soins et nous mobilisons l’appui de toute la collectivité pour mieux y parvenir.
Par la compassion de son personnel et la quête perpétuelle de nouvelles découvertes, L’Hôpital d’Ottawa cherche sans relâche des solutions aux défis les plus complexes en santé.
Analyst 3, Case Costing & Statistical Analysis
Top Benefits
About the role
About The Ottawa Hospital Inspired by research and driven by compassion!
The Ottawa Hospital (TOH) is one of Canada's largest learning and research multi-campus hospitals. With more than 1,100 beds and approximately 12,000 staff members, we deliver specialized care to the Eastern Ontario region.
From the compassion of our people to the relentless pursuit of new discoveries, The Ottawa Hospital never stops seeking solutions to the most complex health-care challenges while continually engaging with the community to support our vision for better patient care.
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.
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 (advanced level) and comprehension (advanced level).
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. Upon request, accommodations due to a disability are available throughout the recruitment process.
About The Ottawa Hospital
The Ottawa Hospital is one of Canada’s largest learning and research hospitals, with more than 1,100 beds, approximately 12,000 staff members and an annual budget of about $1.2 billion.
Our focus on learning and research helps us develop new and innovative ways to treat patients and improve care. As a multi-campus hospital affiliated with the University of Ottawa, we deliver specialized care to the Eastern Ontario region, but our techniques and research discoveries are adopted around the world. We engage the community at all levels to support our vision for better patient care.
From the compassion of our people to the relentless pursuit of new discoveries, The Ottawa Hospital never stops seeking solutions to the most complex health-care challenges.
L’Hôpital d’Ottawa Inspiré par la recherche. Guidé par la compassion.
L’Hôpital d’Ottawa est l’un des plus importants hôpitaux d’enseignement et de recherche au Canada. Il est doté de plus de 1 100 lits, d’un effectif de quelque 12 000 personnes et d’un budget annuel d’environ 1,2 milliard de dollars.
L’enseignement et la recherche étant au cœur de nos activités, nous possédons les outils qui nous permettent d’innover et d’améliorer les soins aux patients. Affilié à l’Université d’Ottawa, l’Hôpital fournit sur plusieurs campus des soins spécialisés à la population de l’Est de l’Ontario. Cela dit, nos techniques de pointe et les fruits de nos recherches sont adoptés partout dans le monde. Notre vision consiste à améliorer la qualité des soins et nous mobilisons l’appui de toute la collectivité pour mieux y parvenir.
Par la compassion de son personnel et la quête perpétuelle de nouvelles découvertes, L’Hôpital d’Ottawa cherche sans relâche des solutions aux défis les plus complexes en santé.