SummaryeHealth Saskatchewan (eHealth) is currently looking for two (2) Senior Data Engineers to work
with data from across the spectrum of healthcare domains, refining requirements with
customers, developing 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 Engineers 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.
Duties & Responsibilities
The Successful Supplier will undertake the subsequent assigned tasks and responsibilities,
which include but are not limited to the following:
● Design and build the infrastructure required for optimal extracting, transformation, and
loading of data from a wide variety of data sources using Informatica, SQL, SSIS, 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 Resource Qualifications/Requirements
The proposed Resource must have the following qualifications/requirements:
● Possesses a bachelor’s degree in information technology, Engineering or Computer
Science.
● Minimum of five (5) years of proven experience working as a Data Engineer or similar
role.
Rated Resource Qualifications/Requirements
The ideal Resource(s) will have the following qualifications and have experience fulfilling the
following job requirements:
● Experience using Informatica software (i.e., Power Centre, Integration Services,
Workflow Manager, IDMC and TDM) in an integrated support environment.
The ideal Resource(s) should have 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.
The ideal Resource(s) should have 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.
It would be an asset for the ideal Resource(s) to have:
● Microsoft Certified: Azure Data Engineer Associate would be considered an asset.
● Experience working with healthcare data would be considered an asset.