DECISION SUPPORT ANALYST II

Competition #
8508
Job Title
Decision Support Analyst II
Department
Decision Support
Status
Permanent
Work Type
Full-time
Affiliation
Non Union
Shift Assignment
Days
Bilingualism Required
No
Police Check Requirement
N/A
Site
RLHC-Non Union Non Managment
Salary Information
$42.69-$50.23/hour
Application Closing Date
July 30, 2025

EDUCATION AND TRAINING:

• Minimum of a three (3) year Bachelor’s Degree in a related discipline (Computer Science, Health Informatics, Health Administration, Business, Economics, Health Sciences or Engineering) from an accredited post secondary institution.
• Ministry of Labour “Worker Health and Safety Awareness in 4 Steps” training certificate is required.

EXPERIENCE:

• Minimum of three (3) years’ experience working with data in a healthcare support context and writing, reading and interpreting advanced SQL code.
• Experience using Power BI for the development of dashboards is preferred.

KNOWLEDGE/SKILLS/ABILITIES:

• Demonstrated advanced understanding and excellent working knowledge of essential computer science concepts (i.e. data structures and algorithms).
• Demonstrated advanced ability in writing Structured Query Language (SQL) scripts.
• Demonstrated superior reporting skills with the ability to use software tools such as SQL Server Reporting Services (SSRS), Microsoft Automate, and Power BI.
• Demonstrated ability to quickly learn any new similar software as the industry evolves.
• Demonstrated advanced proficiency in Hospital Information Systems (HIS) databases.
• Demonstrated excellent judgment and proven analytical skills.
• Demonstrated problem solving, adaptability and resourcefulness, including the ability to troubleshoot efficiently when presented with unfamiliar situations and scenarios.
• Demonstrated training, experience or utilization of quality improvement methodology for process improvement.
• Demonstrated ability to independently identify issues, plan improvements, measure success and continue improvement.
• Demonstrated excellent computer skills with proficiency in Microsoft Office software (e.g. Word, Excel, Power Point and Outlook) and patient information systems.
• Demonstrated superior interpersonal and communication skills, both written and verbal.
• Demonstrated ability to manage routine correspondence, multiple tasks/projects, diversified workload and rapidly changing priorities and challenging deadlines.
• Demonstrated discretion and maturity when handling confidential information.
• Demonstrated commitment to the safety of co-workers and patients.

• Extract data from databases to derive insights, identify trends and monitor performance.
• Implement quality assurance activities and manage data integrity and accuracy.
• Utilize SQL, Excel, Power BI and other analytical tools or software programs to extract, visualize and manipulate data.
• Automate processes to transcribe data from multiple systems to SQL data server and generate reports.
• Work with stakeholders to gather requirements and develop Business Intelligence products, including Power BI reports.
• Analyze and learn the context and circumstances of the data to determine statistical relevance.
• Probe clinical subject-matter experts to gain adequate knowledge and intelligence behind the data in order to produce meaningful tools and products to the clients.
• Assist in the application of advance analytic techniques to predict and monitor hospital activity, including wait times, length of stay and other key metrics.
• Assist vendors in adapting software/reports to meet the needs of Ministry and local requirements and standards.
• Develop in-house solutions, resource tools and/or utilities that facilitate critical processes within the department and maintain as required.
• Use relational database functions and features to efficiently extract, manipulate, interpret, analyze, and present data from internal and external sources (e.g. Canadian Institute for Health Information (CIHI), Meditech, Mosaiq, Med2020, IntelliHEALTH, NRS, CyberREN etc.).
• Maintain and adapt existing reports as provisioning standards and subject requirements evolve.
• Work collaboratively with data producers/owners and Information Technology (IT) to develop methodologies for streamlining and automating manual processes.
• Provide guidance and expertise regarding indicator and metric development for performance monitoring.
• Recognize datasets from different sources, and create ways to integrate information to find underlying trends and opportunities.
• Maintain data dictionaries, maps and functions across various SQL Server databases.
• Provide expertise and support to meet data queries and information validation requirements of external stakeholders (e.g. Ontario Health: Local Health Integration Network (LHIN), Cancer Care Ontario (CCO)).
• Act as a data lead for new and existing initiatives, and for external data requests.
• Provide on-going education to all levels of staff on various topics, including the importance of data quality.
• Provide on-going guidance, training, and maintenance of Decision Support tools.
• Work collaboratively with decision makers, system owners, and end users to facilitate evidence-based decision-making and reporting requirements that align with HSN’s strategic directions.
• Determine and align improvement projects with HSN’s Strategic Plan; monitor and adjust to achieve goal outcomes.
• Participate in education and training specific to current, relevant federal and provincial health and safety legislation, standards and guidelines.
• Educate and promote health, safety and wellness in the work place.
• Represent the department or program on various committees and in meetings as required.
• Perform other duties as required.