Job Description

Are you Decision Support Technical Specialist professional with a strong background in contributing to a culture of quality improvement, performance effectiveness and accountability by providing analysis, interpretation and reporting. Do you have a passion for innovation and collaboration? Are you looking to help make a difference in healthcare in your community? You are looking in the right place!

Take a look at this rewarding career opportunity working alongside a supportive and collaborative team of over 8,000 regulated health care and other professionals. We are amid a momentous time for health care in Ontario as we move to a more connected health care system through the Ontario Health Teams model of care.

What do we offer?

We know wellness is supported with work-life balance. In an inclusive culture committed to support your passion for continuous learning, growth and innovation, we offer: \xe2\x80\x8b

• Attractive comprehensive compensation packages and benefits\xe2\x80\x8b
• Valuable development opportunities\xe2\x80\x8b
• Membership in a world class defined benefit pension plan
• Flexible work location \xe2\x80\x8bwith hybrid opportunity

As a valued member of our Decision Support team, the Decision Support Technical Specialist is responsible for designing, validating, and supporting the implementation of decision support products, including complex reports, cubes and ETL processes across a suite of Decision Support tools and environments. This role will also support Home and Community Care Support Services Mississauga Halton (HCCSS MH) and Home and Community Care Support Services Toronto Central (HCCSS TC) organizations through improving existing reporting, aggregating common data, and developing data structures that make existing processes and analysis more efficient.

What will you do?

• Analyze current and future data reporting, analysis and dissemination needs, and identify the best tools and technology within Home and Community Care Support Services Mississauga Halton Decision Support tool set to achieve high performing, easily maintainable data delivery
• Design, develop, troubleshoot, debug, test and support implementation of efficient, high performing, and maintainable ETL processes, cubes, dashboards, ongoing and ad-hoc reports from multiple datasets.
• In conjunction with Manager, Decision Support, review existing Decision Support operational reporting processes, to prioritize processes for redevelopment to improve quality, efficiency and maintainability of the processes to improve the reliability and timeliness of operational reporting
• Improve the speed, reliability, and maintainability of Decision Support operational processes
• Work with other Decision Support team members to improve overall team use of best practice in decision of ongoing operational processes, reports and data structures
• Develop tools and data structures that simplify access to data and analysis of data from a variety of data sources

What do you need?

• University degree in health information management, management information systems, engineering, statistics or computer science (or equivalent combination of education and experience)
• Four (4) to six (6) years related work experience with at least two (2) years\' experience in a complex decision support environment, including designing and building data structures and ETLs that bring together data from multiple data sources
• Experience with multiple BI tools and methodologies, and familiarity with relational and dimensional data models, including reporting (using SQL queries, stored procedures, etc.), relational database management techniques, applications and tools (SQL Management Studio, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), PerformancePoint etc.);
• Knowledge of workbook, report and dashboard design in Tableau a plus

Who are we?

We are Home and Community Care Support Services, ready to serve every person in Ontario. We partner with patients and caregivers, family physicians, hospitals, long-term care and retirement homes, service providers and Ontario Health Teams, to deliver responsive, accessible, integrated, patient-centred care. We empower you to be your best selves, do your best work and deliver the best possible patient experience for the diverse communities we serve.

Committed to Diversity and Inclusion

In line with our fundamental values of collaboration, respect, integrity and excellence, Home and Community Care Support Services is an inclusive employer which respects equity, inclusion, diversity and anti-racism. We are committed to attracting, engaging and developing a workforce that reflects the diverse communities we serve.

We welcome and encourage applications from all qualified applicants. We will provide accommodations throughout the recruitment and selection and/or assessment process to applicants with disabilities.

Home and Community Care Support Services has implemented a mandatory vaccination policy across the province that requires all staff to be fully vaccinated against COVID-19. Applicants being considered for employment will be required to provide proof of vaccination documentation confidentially to Human Resources upon hire. Any medical or human rights exemption requests will be reviewed and validated prior to an offer of employment.

All applications will be reviewed; however, only those selected for an interview will be contacted.

LHIN