Data Engineer

KEY FUNCTION:

Enable the organization’s evolving enterprise data strategy and support the long-term modernization of its analytics infrastructure. Support a diverse range of data systems related to clinical care, business, research, and organizational operations, to inform and advance healthcare delivery and decision-making. Provide technical and subject matter expertise in data engineering and database administration as part of a multidisciplinary team to solve complex and emerging challenges.

REPORTING:

Under the general direction of the Data/Information Strategist, Software and Data Engineering.

DUTIES:

1. Design, develop, and maintain, well-structured data architectures, including SQL Server–based data models and pipelines.
2. Design, develop, and maintain data warehousing solutions and models using dimensional, relational, and other techniques to support data analytics, reporting, and integration.
3. Build and maintain robust Extract, Transform, Load (ETL) processes and data pipelines to support the integration, transformation, and delivery of data across systems.
4. Design, develop, and support custom data systems and business intelligence solutions to meet diverse clinical, business, and operational needs.
5. Use industry-standard tools (e.g., Microsoft Azure DevOps, ManageEngine ServiceDesk Plus) for source control, work tracking, service management, and collaborative solution delivery.
6. Lead or participate in systems and business analysis to identify source systems, inform architecture, and support the full lifecycle of data solutions.
7. Configure, administer, and optimize enterprise data platforms (e.g. Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Power BI Report Server (PBIRS)).
8. Monitor and tune performance across the enterprise data ecosystem to ensure high availability, reliability, accuracy, and security.
9. Ensure strong adherence to relevant regulatory and data governance policies and standards (e.g. Personal Health Information Protection Act (PHIPA), Freedom of Information and Protection Act (FIPPA)) and organizational policies and standards.
10. Support data quality and governance initiatives through validation, metadata documentation, and adherence to enterprise data standards.
11. Apply both agile and traditional project management methodologies to coordinate solution delivery (e.g. user acceptance testing (UAT), documentation, and stakeholder engagement).
12. Research emerging technologies and data practices to inform continuous improvement and modernization initiatives.
13. Collaborate with business units, vendors, and technical teams to define service expectations, develop service level agreements (SLAs), and prepare statements of work, cost estimates, and timelines.
14. Provide end-user support, training, and troubleshooting for developed solutions.
15. Maintain up-to-date knowledge of relevant legislation, standards, and best practices, in privacy, security, and healthcare data governance.
16. Participate in after-hours support as required.
17. Determine and align improvement projects with HSN’s Strategic Plan; monitor and adjust to achieve goal outcomes.
18. Participate in education and training specific to current, relevant federal and provincial health and safety legislation, standards and guidelines.
19. Educate and promote health, safety and wellness in the work place.
20. Represent the department or program on various committees and in meetings as required. 
21. Perform other duties as required.

QUALIFICATIONS

EDUCATION AND TRAINING: 

1. Minimum of a three (3) year college diploma in Computer Science, Information Technology, Data Engineering, or a related field from an accredited college.
2. Additional certifications in relevant technologies (e.g., Microsoft Certified, etc.) is preferred.
3. Ministry of Labour “Worker Health and Safety Awareness in 4 Steps” training certificate is required

EXPERIENCE:  

1. Minimum of five (5) years experience in data engineering, database administration, and custom data system development in a production environment.
2. Advanced experience with SSIS, including development, deployment, troubleshooting, and performance optimization of complex ETL workflows is required.
3. Experience with data performance monitoring and optimization using industry standard tooling is preferred.
4. Experience in healthcare or other highly regulated environments is preferred.

KNOWLEDGE/SKILLS/ABILITIES: 

1. Demonstrated expertise in SQL Server-based platforms, including the development of ETL pipelines, data models, and business intelligence solutions.
2. Demonstrated strong understanding of Transact-SQL (T-SQL) for query development, optimization, stored procedures, and automation scripts.
3. Demonstrated proficiency in data modeling techniques (e.g. relational, non-relational, dimensional, flat file, etc.) for data analytics and warehousing.
4. Demonstrated competency with C# for developing custom components in SSIS, scripting tasks, or system integrations.
5. Demonstrated advanced knowledge and experience with Microsoft SQL Server, including configuration, security, performance tuning, and high-availability deployments in a production environment.
6. Demonstrated proficient in SQL Server Reporting Services (SSRS) and Power BI Report Server (PBIRS), including administration, configuration, report deployment, data source configuration, and scheduled data refreshes.
7. Demonstrated experience managing source control, release pipelines, and development workflows using Microsoft Azure DevOps.
8. Demonstrated proficiency in data ecosystem performance monitoring and tuning.
9. Demonstrated familiarity with unstructured and semi-structured data formats (e.g., JSON, XML) and platforms.
10. Demonstrated knowledge of cloud-based data services (e.g., Azure SQL, Azure Data Factory) is preferred.
11. Demonstrated strong understanding of enterprise data architecture and data lifecycle management.
12. Demonstrated ability to perform systems analysis and business analysis.
13. Demonstrated knowledge of project management and solution delivery methodologies Agile and traditional.
14. Demonstrated knowledge of PHIPA, FIPPA, and best practices for securing personal and health data.
15. Demonstrated knowledge of data governance, data quality and metadata management best practices.
16. Demonstrated knowledge of Hospital Information Systems (HIS) and healthcare data workflows if preferred.
17. Demonstrated training, experience or utilization of quality improvement methodology for process improvement.
18. Demonstrated ability to independently identify issues, plan improvements, measure success and continue improvement.
19. Demonstrated excellent computer skills with proficiency in Microsoft Office software (e.g. Word, Excel, Power Point and Outlook) and patient information systems.
20. Demonstrated superior interpersonal and communication skills, both written and verbal.
21. Demonstrated ability to manage routine correspondence, multiple tasks/projects, diversified workload and rapidly changing priorities and challenging deadlines.
22. Demonstrated discretion and maturity when handling confidential information.
23. Demonstrated commitment to the safety of co-workers and patients.

PERSONAL SUITABILITY:

1. Ability to work collaboratively in a multidisciplinary technical environment.
2. Effective self-management, adaptability, and initiative in a high-volume technical setting.
3. Ability to work independently in both remote and on-site settings.
4. Demonstrated commitment to ongoing professional development.
5. Demonstrated professionalism in dealing with confidential and sensitive issues.
6. Demonstrated positive work record and excellent attendance record.
7. Ability to meet the physical and sensory demands of the job.
8. 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.
 

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.

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