Decision Support Analyst II

Job Responsibility:

Decision Support Analyst II

Competition #

6069

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 to $50.23 per hour

Application Closing Date

July 10, 2024

KEY FUNCTION :

Analyze, interpret, consult, present, design, and develop Decision Support information tools to support a diverse range of strategic and operational initiatives. These tools facilitate the exchange, modification, sharing, and retrieval of clinical and non-clinical information to support Health Sciences North (HSN), its stakeholders, and associated organizations.

REPORTING :

Under the general direction of the Director, Decision Support.

DUTIES :

• Develop tools to mine and extract data for various consumers.

• Develop tools and processes to support data quality, integrity and verification efforts.

• Develop advanced dashboards and automated data-driven reports, made readily accessible for consumers to view at their convenience.

• Develop, maintain and upgrade tools and queries to enable various processes.

• Automate processes to transcribe data from multiple systems to SQL data server and generate reports.

• Act as lead developer for various programs data, reporting and information support requests (i.e. Mosaiq for the North East Cancer Center (NECC) and BCare for Community Mental Health & Addictions).

• 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 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, B-Care, Med2020, IntelliHEALTH, NRS, CyberREN etc.).

• Translate and reinterpret existing tools and scripts between various systems and environments, as required when technology presents differing requirements (i.e. Transcribing Meditech NPR code to function with IPeople ECHO datasets / Meditech Expanse).

• 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), and the Ministry of Health and Long Term Care (MoHLTC)).

• Act as a subject matter expert on Health System Funding Reforms (HSFR) (i.e. Quality Based Procedures (QBP) and Patient Based Funding).

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

QUALIFICATIONS

EDUCATION AND TRAINING:

• Minimum of a four (4) year Bachelor's Degree in a related discipline (Computer Science, Health Informatics, Health Administration, Business, Economics, Health Sciences or Engineering) from an accredited University.

• Master's Degree in a related discipline (Computer Science, Health Informatics, Health Administration, Business, Economics, Health Sciences or Engineering) is preferred.

• 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

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, Excel + Power Query/Data Model; Crystal Reports, Microsoft Access

• Demonstrated ability to quickly learn any new similar software as the industry evolves.

• Demonstrated advanced proficiency in Hospital Information Systems (HIS) databases (e.g. Meditech, BCare, Mosaiq, Clarity, etc.).

• Demonstrated excellent judgment and proven analytical skills.

• Demonstrated training, experience or utilization of lean methodology for process improvement.

• Demonstrated ability to independently identify issues, plan improvements, measure success and continue improvement.

• Problem solving, adaptability and resourcefulness, including the ability to troubleshoot efficiently when presented with unfamiliar situations and scenarios.

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

PERSONAL SUITABILITY:

• Proven ability to work independently and in a team environment.

• Demonstrated commitment to ongoing professional development.

• Demonstrated professionalism in dealing with confidential and sensitive issues.

• Demonstrated positive work record and excellent attendance record.

• Ability to meet the physical and sensory demands of the job.

Selection Process: Candidates will be selected for this position on the basis of their skill, ability, experience and qualifications as identified in the resume and completed Application Form submitted. The Hospital reserves the right to conduct a formal interview where required.

HSN THANKS ALL APPLICANTS. ONLY THOSE SELECTED FOR INTERVIEWS WILL BE CONTACTED. WE WILL NOT ACCEPT APPLICATIONS AFTER THE CLOSING DATE AND TIME.

Health Sciences North is committed to providing accommodations to applicants with disabilities to enable their participation in the recruitment, assessment, selection and hiring stages of employment.