Senior Decision Support Analyst

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.

• 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 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

• Provide analytical and technical input to support funding, volume, and performance analysis
• Support accurate reporting to mitigate financial risk associated with data quality or compliance issues

• Participate in all mandatory training requirements and work in compliance with the Occupational Health and Safety Act and Regulations, company Policies and Procedures, as well as established industry guidelines
• Adhere to data governance, privacy, and security standards when accessing, extracting, and reporting information
• Support organizational audits, regulatory reviews, and accreditation processes through accurate and validated data outputs

• University degree in Computer Science, Data Science, Health Informatics, or a related field
• Minimum 5–7 years of relevant experience in data architect or senior analyst roles, preferably within a Meditech environment
• Demonstrated expertise in T-SQL, relational database design, and modeling
• Proficient in using universal SQL clients (e.g., DBeaver)
• Strong working knowledge of Meditech Data Repository structures and schema navigation
• Technical understanding of CIHI abstracting and coding standards (e.g., NACRS)
• Familiarity with the Wait Time Information System (WTIS)
• Excellent verbal and written communication skills, able to communicate complex ideas clearly and concisely to diverse audiences, including senior leadership and external stakeholders
• Strong organizational skills to manage multiple projects and deadlines simultaneously
• Superior interpersonal skills, with the ability to work effectively in a team environment
• Demonstrated decision-making ability for daily tasks within established guidelines and procedures
• Proven ability to work independently…