12 / 01 / 2025 Data Engineer

Senior Data Engineer – Job Description

Contract Duration

Start Date : Immediate upon selection

End Date : March 31, 2027

Extension Option : additional 12‑month term under the same terms and conditions

Overview

This role involves working with data across various healthcare domains, refining requirements with data models, extracting data from various source systems and database formats, and providing data in a number of formats including Extract, Transform, Load (ETL) aligned with Informatica software. The Senior Data Engineer(s) will report to the Manager of Data Management, work with a project team led by a Project Manager and will provide the required leadership and communication to ensure deliverables are met on time and on budget. This is a highly visible, busy, and challenging role that will be focused on supporting major analytics projects.

Key Responsibilities

• Design and build the infrastructure required for optimal extracting, transformation, and loading of data from a wide variety of data sources using Informatica, Structured Query Language (SQL), SQL Server Integration Services (SSIS), Application Programming Interface (API) and other technologies.
• Architect relational and multi-dimensional databases from structured, semi-structured and unstructured data with development techniques including star and snowflake schemas, ETL, Slow Changing Dimensions (SCD), Fact and Cube development in a data management framework in conjunction with the Provincial Data Platform Infrastructure.
• Identify, design and implement internal process improvements : automate manual processes, optimize data delivery, re‑design data pipelines for greater scalability.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiencies, and other key business performance metrics.
• Develop, maintain, optimize, troubleshoot, debug, monitor, backup and recovery operations for the ETL environment.
• Analyze datasets to ensure compliance with data sharing agreements and legislation restrictions, and for alignment with data architecture guidelines.
• Mentor, support and train Information Analyst and Junior Data Management resources, as required.

Mandatory Qualifications

Qualifications / Requirements

Expert Knowledge Of

Extensive Experience With

Plus

Seniority Level

Mid‑Senior level

Employment Type

Contract

Job Function

Information Technology

Industries

IT Services and IT Consulting

#J-18808-Ljbffr