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, Women’s and Children’s 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.

Come be part of our vision as CMH leads in innovation and compassion!  To learn more about CMH, please visit our website at www.cmh.org.

Why Should You Apply to CMH?

• 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
• Career Development & Education Grant
• Wellness, & Wellbeing Program
• Diversity, Equity and Inclusion Initiatives

Salary Range: $53.69 - $63.92      

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-site work.

Responsibilities:

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

Analytics and reporting

• Maintain and adapt existing reporting, performance dashboards and KPIs
• Ensure continuity of external reporting requirements such as CIHI
• 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-flows post 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
• Advance the use of predictive and prescriptive models to enhance decision making

Skills and Qualifications: 

• 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, Master’s 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-care setting is an asset
• Self directed and strong collaborative skills
• Able to manage multiple priorities
• 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
• Proficiency in ETL tools: 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
• Expert problem solving skills
• Strong ability to tell a story with data
• Excellent written and verbal communication skills
• Demonstrated ability to present project and performance information clearly and concisely
• Superior critical thinking skills and an ability to generate ideas and fresh perspectives
• Proven track record managing competing demands and excellent organization skills
• Strong familiarity with CIHI and Cancer Care Ontario data required (i.e. DAD, NACRS, OMHRS, NRS, ALR, SETP, WTIS)
• Experience utilizing national and provincial Business Intelligence Tools (i.e. Intellihealth, IDS, CIHI Insight, iPort)
• Advanced knowledge of Health System Funding Reform, QBP methodologies and HBAM Weighted Case Funding Methodologies
• The ability to thrive on change, work in a consultative and customer oriented capacity with others,
• Demonstrated ability to attend work on a regular basis is required.
• 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 acknowledge and are grateful for the opportunity to meet, work and offer healthcare on what is the traditional territories for the Anishinaabe, the Haudenosaunee and the Chinnonton.

We are committed to providing and fostering a respectful, caring, and inclusive workplace; one that generates belonging.  We want a work culture where people are free to express their authentic selves and are able to bring their best daily. That includes a workplace that is free from violence, harassment and discrimination of any kind.

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.  We promise to ask if needed, and to provide reasonable accommodation to you during the recruitment and selection process to ensure an equitable experience.

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. We encourage you to reflect upon our inclusive commitment to you as we welcome and encourage you to explore a promising future career at CMH.

Mari Iromoto Executive Champion Diversity, Equity and Inclusion

Susan Toth, Director of Human Resources

We thank all those who apply, however only those selected for an interview will be contacted.

Cambridge Memorial Hospital (CMH) proudly integrates AI-based technologies into its applicant screening process to enhance recruitment. These tools are designed to reduce bias and uphold fair hiring practices based on skills, education, and experience. CMH’s AI serves to assist, not replace, human decision-making, with results audited to ensure quality and equity. This initiative reinforces the hospital’s  commitment to Equity, Diversity, and Inclusion, ensuring the best talent is selected while adhering to its core values.