Senior Decision Support Analyst

Job Description

Job Description

Overview and Purpose of the Role

Reporting to the Decision Support Manager, the Senior Decision Support Analyst serves as the technical authority for Schroeder Ambulatory Centre’s (SAC’s) Meditech data and analytics architecture, responsible for building, validating, and maintaining the organization’s decision support foundation. The incumbent will work towards ensuring the accurate, secure, and automated extraction, transformation, and reporting of clinical, operational, and financial data to support regulatory compliance and executive decision-making. Senior Decision Support Analyst will also translate strategic objectives into high-integrity data structures and provide the core technical infrastructure that enables enterprise reporting, analytics, and a culture of data-informed decision-making.

Key Duties & Responsibilities :

• Serve as the technical authority for the Meditech Data Repository (DR) and Business and Clinical Analytics (BCA) module
• Design, write, and optimize complex T-SQL queries to build automated extraction pipelines for internal reporting and mandatory external submissions
• Map clinical workflows to Meditech Expanse data structures to ensure source-to-target accuracy across reporting outputs
• Act as the primary BCA Dataset Creator, developing and maintaining custom datasets to support organizational dashboards and self-service analytics
• Validate Meditech BCA dashboards and reports against EHR data to ensure accuracy and alignment with Ontario reporting standards
• Develop and maintain standardized data models, schemas, and master mappings to support a single source of truth
• Build, automate, and maintain executive and operational dashboards using Meditech BCA and business intelligence tools
• Support CIHI, Ministry of Health, and Ontario Health reporting requirements by producing accurate, timely, and auditable datasets
• Engineer automated validation scripts to identify and correct data errors (e.g., missing diagnosis or intervention codes) prior to submission
• Partner with the Decision Support Manager, Privacy Leads, and Meditech Super Users to troubleshoot data issues and resolve anomalies
• Support data governance by implementing secure access controls and adhering to privacy and data security standards
• Participate in audits, data quality reviews, and validation exercises as required.
• Perform additional duties and special projects as assigned

Financial and Budgetary Accountability

Corporate Responsibilities

Skills & Qualifications :

Join Our Team : Schroeder Ambulatory Centre is a non-profit medical facility dedicated to enhancing the quality of life for Ontarians through accessible, outpatient healthcare. The Centre will offer a comprehensive range of clinical, diagnostic, and surgical services in alignment with its mission to reduce pain, improve mobility, and streamline healthcare delivery.

In collaboration with hospital and academic partners, Schroeder Ambulatory Centre aims to strengthen public health capacity and drive innovation in care, ensuring a more efficient and compassionate healthcare experience for the community.

At Schroeder Ambulatory Centre, we are committed to fostering an inclusive and accessible recruitment experience for all candidates. If you require accommodations at any stage of the hiring process due to a disability or medical condition, please let us know. We will work with you to ensure your needs are met in a respectful and confidential manner.

We appreciate all applications; however, only those selected for an interview will be contacted.

This posting is for a current vacancy