We are currently recruiting a Decision Support Technical Specialist
Competition Number: FY1718-253
Date Posted: April 2, 2018
Date Closed: Until Filled
Portfolio: Finance, Performance and Corporate Services
Department: Decision Support
Team: Decision Support
Reports To: Manager, Decision Support
Category: Temporary Full-Time until April 30, 2019
Primary Assigned Location: Etobicoke – 401 The West Mall, Ste 1001
Reporting to the Manager, Decision Support, the Decision Support Technical Specialist is responsible for designing, validating, and supporting 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 the organization through improving existing reporting, aggregating common data, and developing data structures that make existing processes and analysis more efficient.
DUTIES & RESPONSIBILITIES
Analyze current and future data reporting, analysis and dissemination needs, and identify the best tools and technology within the MH LHIN 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
Understands components of the data to provide direction on the data elements required for decision-making, and on investigating data issues
Education, Training & Experience:
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 source
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
To apply for this vacancy please submit a resume with covering letter referencing FY1718-253 via the following link www.lhinjobs.ca or visit the Mississauga Halton LHIN Career Opportunity page at lhinjobs.ca Please note, only those candidates selected for an interview will be contacted.
Mississauga Halton LHIN is a respectful, caring and inclusive workplace, committed to Employment Equity. We welcome diversity in the workplace, and encourage applications from all qualified individuals including women, members of visible minorities, aboriginal persons, and persons with disabilities. We will provide accommodations throughout the recruitment and selection and/or assessment process to applicants with disabilities. Applicants need to make their accommodation needs known when contacted.
To receive any Mississauga Halton LHIN document required by the Accessibility for Ontarians Disability Act (AODA) and its standards, or to receive any public document on our website in an alternate format, please contact our Communications Department at 905-855-9090 or 1-877-336-9090.