Senior’s Care and Support Specialist

Join a hospital where everyone makes a difference! Cambridge Memorial Hospital (CMH) is a thriving community hospital that proudly provides acute care services including: Emergency Surgery Medicine Womens and Childrens Health Intensive Care Mental Health and Inpatient Rehabilitation.
Our vision is to creating healthier communities together . Our dedicated and skilled staff are passionate about providing outstanding patient-centred care and an exceptional patient experience to residents of the Waterloo Region and beyond.
To learn more about CMH please visit our website at .

Healthcare of Ontario Pension Plan (HOOPP)
Group benefits including health and dental for full-time employees
Employee and Family Assistance Program
Leadership and Quality Improvement Curriculum
Diversity Equity and Inclusion Initiatives
Cambridge Memorial Hospital is embarking on an exciting digital transformation journey with the implementation of a new Electronic Medical Record System. We are seeking a Senior Decision Support Specialist to play a crucial role in supporting data migration validation and analytics during this transition. The Senior Decision Support Specialist will use their advanced data analytics and statistical expertise to transform data into insight for decision making. The Decision Support department is responsible for compiling accurate timely data into meaningful information to help make informed evidence based operational and strategic decisions. The successful candidate will leverage their expertise in data management health analytics and performance reporting to ensure data integrity enable continuity of reporting and support strategic and operational decision making across the organization.
This is an exciting opportunity to join a leading-edge decision support team in an organization that is embarking on a digital health transformation journey.

This position will have a hybrid working model consisting of remote and on-sitework.

Support Data Migration and Validation
Support the extraction transformation and validation of data from legacy systems to the new HIS
Develop and execute data reconciliation processes to ensure accuracy and completeness
Collaborate with IT clinical and project teams to define data mapping quality rules and migration success criteria
Maintain and adapt existing reporting performance dashboards and KPIs
Provide advanced data analysis and insights to support operational planning
Data modeling
Work with Senior Data Modeller to support development of new data models and reporting structures for integration of new data and work-flowspost go-live
Support training and education of Decision Support Team and end users on new data assets
Support data governance related to migration and integration of data
Continuous Improvement
Optimize data flows
Contribute to the design and implementation of data standards and procedures
~ Lead the statistical analysis for strategic priorities and corporate scorecard metrics

Data Driven Insights
Provide expert analysis and analytics utilizing predictive and prescriptive statistical modeling for key strategic priorities
Program and build automated systems and business intelligence tools to support strategic planning corporate priorities clinical services growth quality improvement and data needs of internal and external stakeholders utilizing SQL data visualization (Power BI) SSRS and other business intelligence tools as needed
Degree in Health Informatics/Information Health Administration Mathematics / Statistics Business Computer Science Data Science Health Administration or other degree with significant hospital experience is required Masters Degree is preferred

• Demonstrated experience with data migration data validation and reporting during a major HIS/EHR implementation
• 3-5 years experience working in performance measurement or Decision Support in a hospital or other health-caresetting is an asset
• Proficient in Microsoft Office suite products (Excel Access Power BI Power Apps) required
• Advanced proficiency in data visualization tools such as Power BI
• Advanced proficiency in Microsoft SQL and SSRS
• SSIS / Azure Data Factory as well as experience designing data ingestion pipelines from cloud to on-prem via secure API SFTP
• Understanding and experience with Oracle Cloud Infrastructure (OCI)
• Experience with R and Python is an asset
• Strong ability to tell a story with data
• Demonstrated ability to present project and performance information clearly and concisely
• Strong familiarity with CIHI and Cancer Care Ontario data required (i.e. Experience utilizing national and provincial Business Intelligence Tools (i.e. The ability to thrive on change work in a consultative and customer oriented capacity with others
• Developed multiple Python/Flask-based internal applications to streamline hospital work-flows automate notifications and support real-time decision making.
• Integrated key hospital systems (HIS UKG/Dimensions Andgo Qualtrics) using secure APIs and built automated data-quality and exception-reporting pipelines.
• Skilled in building automated data-quality and exception-reporting frameworks across HR and clinical datasets.

As part of our commitment to the health and safety of our patients staff and community from COVID-19 subject to any accommodation required by applicable human rights legislation Cambridge Memorial Hospital requires that all staff have received all required doses of a COVID-19 vaccine approved by Health Canada.

The successful external applicant is required to provide the applicable criminal record check as requested by Human Resources in accordance with federal and provincial legislation. Valid criminal record checks are in original format and dated with two months from date of conditional offer from CMH.

CMH Inclusion Statement

At Cambridge Memorial Hospital (CMH) community matters to us. We welcome all applicants and encourage members of equity-deserving groups including Indigenous and LGBTQ2SIA communities regardless of race gender sexual orientation gender identity or expression lifestyle age educational background national origin religion neurodiversity or physical ability. To support all of us in this journey Cambridge Memorial Hospital is an employee partner with the Canadian Centre for Diversity & Inclusion (CCDI) and provides access to all CMH members to CCDI resources and education. Mari Iromoto Executive Champion Diversity Equity and Inclusion
Cambridge Memorial Hospital (CMH) proudly integrates AI-based technologies into its applicant screening process to enhance recruitment. CMHs AI serves to assist not replace human decision-making with results audited to ensure quality and equity. This initiative reinforces the hospitals commitment to Equity Diversity and Inclusion ensuring the best talent is selected while adhering to its core values.
Senior IC