Decision Support Analyst II (Hybrid)

Competition #

10169

Job Title

Decision Support Analyst II (Hybrid)

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

$44.96 - $52.90 / hour

Application Closing Date

Posted until filled

KEY FUNCTION:

Help drive decision making through data extraction, advanced analytics and reporting of key metrics to hospital staff and senior leaders. Work with programs and services across the hospital to better understand health service utilization and needs of HSN patients and support ongoing reporting of activity.

REPORTING:

Under the general direction of the Manager, Decision Support.

DUTIES:

1. Extract data from databases to derive insights, identify trends and monitor performance.
2. Implement quality assurance activities and manage data integrity and accuracy.
3. Utilize SQL, Excel, Power BI, Crystal Reports and other analytical tools or software programs to extract, visualize and manipulate data.
4. Automate processes to transcribe data from multiple systems to SQL data server and generate reports.
5. Work with stakeholders to gather requirements and develop Business Intelligence products, including Power BI reports.
6. Analyze and learn the context and circumstances of the data to determine statistical relevance.
7. 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.
8. Assist in the application of advance analytic techniques to predict and monitor hospital activity, including wait times, length of stay and other key metrics.
9. Assist vendors in adapting software/reports to meet the needs of Ministry and local requirements and standards.
10. Develop in-house solutions, resource tools and/or utilities that facilitate critical processes within the department and maintain as required.
11. 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.).
12. Maintain and adapt existing reports as provisioning standards and subject requirements evolve.
13. Work collaboratively with data producers/owners and Information Technology (IT) to develop methodologies for streamlining and automating manual processes.
14. Provide guidance and expertise regarding indicator and metric development for performance monitoring.
15. Recognize datasets from different sources, and create ways to integrate information to find underlying trends and opportunities.
16. Maintain data dictionaries, maps and functions across various SQL Server databases.
17. 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)).
18. Act as a data lead for new and existing initiatives, and for external data requests.
19. Provide on-going education to all levels of staff on various topics, including the importance of data quality.
20. Provide on-going guidance, training, and maintenance of Decision Support tools.
21. 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.
22. Determine and align improvement projects with HSN's Strategic Plan; monitor and adjust to achieve goal outcomes.
23. Participate in education and training specific to current, relevant federal and provincial health and safety legislation, standards and guidelines.
24. Educate and promote health, safety and wellness in the work place.
25. Represent the department or program on various committees and in meetings as required.
26. Perform other duties as required.

QUALIFICATIONS

EDUCATION AND TRAINING:

1. 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.
2. Ministry of Labour "Worker Health and Safety Awareness in 4 Steps" training certificate is required.

EXPERIENCE:

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

KNOWLEDGE/SKILLS/ABILITIES:

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

PERSONAL SUITABILITY:

1. Proven ability to work independently and in a team environment.
2. Demonstrated commitment to ongoing professional development.
3. Demonstrated professionalism in dealing with confidential and sensitive issues.
4. Demonstrated positive work record and excellent attendance record.
5. Ability to meet the physical and sensory demands of the job.
6. Ability to travel between local sites.

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. This posting is for an existing vacancy.

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