Senior Healthcare Data Engineer - Remote

TEEMA; Regina; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A healthcare analytics organization is looking for a Senior Data Engineer with expertise in Informatica and a minimum of five years of experience. This role involves developing ETL processes, refining data requirements, and ensuring compliance with data governance standards. The candidate will contribute to analytics projects, working closely with a dynamic team. Remote work is an option, but candidates must be located in Canada. A bachelor's degree in IT or equivalent experience is required.

Qualifications

• Minimum of five years of proven experience working as a Data Engineer.
• Expert knowledge in Informatica software in an integrated support environment.
• Must be located and permitted to work in Canada.

Responsibilities

• Design and build the required infrastructure for data extraction using Informatica.
• Architect relational and multi-dimensional databases.
• Identify and implement internal process improvements.
• Build analytics tools for actionable insights.
• Analyze datasets for compliance with data guidelines.

Skills

Informatica expertise

SQL

ETL development

Data Pipeline Development

Mentorship

Cloud platforms

Problem-Solving

Education

Bachelor’s degree in Information Technology

Diploma in related data management stream with 3 years experience

Tools

SQL Server

Oracle

Python

Shell Scripting

Job description

Job Description

Job Description

Senior Data Engineer - (Informatica and Healthcare Analytics Focus)

A leading organization in the healthcare sector is seeking up to two (2) highly skilled and experienced Senior Data Engineers to join our team. This is a highly visible, busy, and challenging role focused on supporting major analytics projects across the healthcare domain.

The successful candidate(s) will be crucial in refining data requirements with customers, developing robust data models, and designing and building optimal data extraction, transformation, and loading (ETL) infrastructure. You will work with diverse healthcare data, ensuring deliverables are met on time and on budget.

This role reports to the Manager of Data Management and will work closely with a project team led by a Project Manager.

Work Arrangement

• Contract Term: Initial contract runs from December 1, 2025 to March 31, 2026, with expected renewals based on performance and project needs beyond the fiscal year end.

• Remote Resource(s) can be proposed and can be located anywhere in Canada.

• Remote resources selected will be expected to occasionally travel to the main work location, with travel costs covered by the Successful Supplier.

Key Duties & Responsibilities

The successful candidate(s) will be responsible for, but not limited to, the following tasks:

• Data Pipeline Development: Design and build the required infrastructure for optimal extracting, transformation, and loading of data from a wide variety of data sources using Informatica (Power Centre, Integration Services, IDMC, TDM), SQL, SQL Server Integration Services (SSIS), Application Programming Interfaces (API), and other technologies.

• Data Architecture: Architect relational and multi-dimensional databases from structured, semi-structured, and unstructured data, utilizing development techniques including star and snowflake schemas, ETL, Slowly Changing Dimensions (SCD), and Fact and Cube development within an established data platform infrastructure.

• Process Improvement: Identify, design, and implement internal process improvements, focusing on automating manual processes, optimizing data delivery, and re-designing data pipelines for enhanced scalability.

• Analytics Enablement: Build analytics tools that leverage the data pipeline to provide actionable insights into key business performance metrics, such as customer acquisition and operational efficiencies.

• ETL Management: Develop, maintain, optimize, troubleshoot, debug, monitor, and manage backup and recovery operations for the ETL environment.

• Data Governance: Analyze datasets to ensure compliance with data sharing agreements, legislative restrictions, and alignment with data architecture guidelines.

• Mentorship: Mentor, support, and train Information Analyst and Junior Data Management resources, as required.

Mandatory Resource Qualifications/Requirements

The proposed Resource(s) must meet the following criteria:

• Experience: A minimum of five (5) years of proven experience working as a Data Engineer or similar role.

• Education: Possess a Bachelor’s degree in Information Technology, Engineering, or Computer Science, OR a diploma in a related data management/information technology stream with an additional three (3) years of experience (total of eight years) working as a Data Engineer or similar role.

• Informatica Expertise: A minimum of two (2) years of proven experience using Informatica software (i.e., Power Centre, Integration Services, Workflow Manager, IDMC, and TDM) in an integrated support environment.

• Location: Must be located and permitted to work in Canada.

Highly Desired Qualifications and Experience

The proposed resource(s) should possess the following qualifications and have experience fulfilling the corresponding job requirements:

A. Expert Knowledge

The successful candidate must possess expert-level knowledge in the following technical areas:

• Database Management Systems (DBMS): Expert knowledge of Oracle and SQL Server Database Management Systems and associated tools.

• ETL and Data Pipelines: Expert-level ETL and data pipeline development experience, including providing technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.

• Computer Programming Languages: Expert knowledge of programming languages such as PL/SQL, R, and Python.

• Operating Systems: Expert knowledge of operating systems such as Unix, Linux, and Windows.

• Shell Scripting: Proficiency in Shell Scripting language.

• Data APIs: Expert knowledge of Data Application Programming Interface (API) development and utilization.

• Theoretical Foundations: Expert knowledge of Algorithms and data structures.

B. Extensive Experience

The successful candidate must have extensive practical experience in the following areas:

• Information Management & Design: Extensive experience with information management, logic modeling, conceptual design, business process design, and workflow design.

• System Lifecycle: Extensive experience in requirements gathering, analysis, planning, design, development, implementation, and maintenance of Data Management systems.

• Problem-Solving: Extensive experience with critical, constructive, and creative problem-solving skills that involve issue identification, development of objectives, development of an action plan overseeing what needs to be done, while identifying the resources required to ensure quality products.

• Cloud Platforms: Extensive experience working with Cloud platforms for data management (e.g., Azure, AWS, GCP).

C. Valuable Assets (Plus, not required)

The following qualifications and experience would be considered a significant asset:

• Certification: Possessing a Microsoft Certified: Azure Data Engineer Associate certification.

• Industry Experience: Experience working specifically with healthcare data.