Website Home and Community Care Support Services HNHB

Home and Community Care Support Services HNHB, a leader in home & community health, links people of all ages to a range of health and support services at home and in the community through information, coordination, and professional support. We do this through the provision of services in both official languages in accordance with applicable legislation and with cultural sensitivity to the populations we serve.

We offer meaningful work, in a team based environment, competitive total compensation and programs to support work-life balance. We are an equal opportunity employer.

Solutions Technician
Permanent Full Time – Burlington, ON
Competition #U.21/22.55-E

Responsible for the creation and maintenance of software and solutions under the direction of the Manager, IT Projects and Solutions.



·         Supplies timely and accurate reports/statistics for all levels of staff and/or create ad hoc reports as requested, utilizing the HNHB BI Platform

·         Provides first level support to HCCSS HNHB staff and external partners as needed on reporting platforms and related Data systems in use by, or populated by, the organization

·         Provides regular extracts to the Ministry of Health, and approved external Integrated Data Stores (IDS) compiled from the applications’ databases and related systems in use by the organization as needed

·         Plays an active role in recommending enhancements to reports and related systems to better meet the organization’s needs. Administer any ongoing development requests by providing detailed requirements analysis and system design specifications

·         Identifies, detects and solves related problems

·         Fully utilizes the IT Help Desk System as required

·         Develops necessary materials and deliver training and orientation on related reports

·         Ensures change management processes are followed to ensure solutions and reporting integrity

·         Performs other related duties as assigned


·         Fulfills any ongoing development requests by providing detailed requirements analysis and system design specifications, development, testing, and implementation of a programming or reporting solution

·         Ensures change management processes are followed to ensure solutions and reporting integrity

·         Follows generally accepted best practices for software development with a structured release cycle and UAT testing

·         Manages data integrity at a business process and technical level; identifies and remedies any software and design errors; reports and recommends solutions for any errors; tests data conversion from existing systems; generates reports and statistical analysis

·         Assists Manager, IT Projects and Solutions to document and maintain business processes to ensure process alignment from a systems perspective and relevance of functionality and reporting; provides specialized applications knowledge and information and recommends new methods/systems that can better serve the HCCSS HNHB business process in the automated system

·         Supports SharePoint 2010, 2013 or newer including designer and BI components, administration and support

Other Related Activities

·         Assists with Data Validation activity to ensure the integrity of HNHB data, regardless of storage location (local, remote IDS)

·         Assists the Solutions Team in validating, approving and running data related tasks such as changes to IDS and importing and exporting data from and to external stakeholders

·         Provides backup support for the Facilities Department as required

·         Provides minimal applications Technician backup as required in exceptional circumstances

·         Reporting and Solutions act as backup to each other in all areas as necessary

Patient Safety

·         Promotes patient safety in alignment with the Vision, Mission, Values and Strategic Directions of the HCCSS HNHB

·         Works within the basic principles of patient safety by doing the right thing for the right patient, using the right method at the right time

·         Adheres to HCCSS HNHB’s patient safety plan



  • 3 year Post Secondary Diploma or Degree in Computer Systems/Science
  • MCITP Certification (preferably in Business Intelligence Developer stream) is required or equivalent Information Technology certification deemed acceptable by Management

Preferred Experience       

  • 2 to 3 years’ experience in support of health care patient database solutions is an asset
  • 2 to 3 years’ experience creating custom reports using Microsoft Business Intelligence solutions (SQL2008 R2, SQL2016 or the most current version, SSMS, SSDT, SSIS, SSAS, SSRS, report version control) and Power BI (or the most current version) are required
  • Software development experience in Visual Studio 2010, 2012 or better is required
  • SharePoint 2010 Designer and 2013 BI components (or the most current version) are required
  • PowerShell is an asset

Skills & Abilities:  

  • Excellent communication skills (both oral and written)
  • The ability to work with highly confidential information
  • Strong troubleshooting skills and detailed oriented
  • Knowledge of Database Structures
  • Demonstrated organizational skills and must be able to adapt quickly in a fast paced environment
  • Driven to succeed and seek out new opportunities and areas for improvement within the Department and within the Organization
  • Patient, competent and displays empathy to the user
  • A proven team player
  • Valid driver’s license with own reliable transportation

Hours of Work: Monday – Friday, 8:30am – 4:30pm

To apply for this job please visit

Solutions Technician