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 lead 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

The proposed Resource(s) should have the following qualifications and have experience fulfilling the following job requirements:
Expert knowledge of:
• Oracle and SQL Server Database Management Systems and tools.
• ETL and data pipeline development experience; providing technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.
• Computer programming languages such as PL/SQL, R, Python.
• Operating systems such as Unix, Linux, and Windows.
• Shell Scripting language.
• Data Application Programming Interface (API).
• Algorithms and data structures.
Extensive experience with:
• Information management, logic modeling, conceptual, business process, and workflow design.
• Requirements gathering, analysis, plan, design, develop, implement and maintain Data Management systems.
• Critical, constructive and creative problem-solving skills that involve issue identification, development of objectives, development of an action plan overseeing what needs to done, while identifying the resources required to ensure quality products.
• Cloud platform for data management.
Plus:
• Microsoft Certified: Azure Data Engineer Associate would be considered an asset.
• Experience working with healthcare data would be considered an asset.