Sr. Data Engineers to work with data from across the spectrum of healthcare domains, refining r[...]

Annex Consulting Group; Winnipeg; On-site; CAD 85,000 - 110,000; Full time

Job summary

A consulting firm in Winnipeg is seeking a Senior Data Engineer to work on healthcare data projects. The ideal candidate should have extensive experience in ETL processes and database management systems, with proven ability to lead and communicate effectively. A bachelor's degree in IT or a related field is mandatory, and familiarity with Informatica and SQL is required. This is a challenging role that requires strong analytical and problem-solving skills.

Qualifications

• Minimum of five years of experience as a Data Engineer or similar role.
• Experience with Cloud platforms for data management.
• Microsoft Certified: Azure Data Engineer Associate (nice to have).

Responsibilities

• Design and build infrastructure for data extraction and transformation.
• Architect databases using ETL techniques.
• Identify and implement internal process improvements for data pipelines.
• Build analytics tools for business performance insights.
• Mentor junior data management resources.

Skills

Experience with Informatica software

Expert knowledge of Oracle

Expert knowledge of SQL Server

ETL and data pipeline development

PL/SQL

Python

Unix/Linux/Windows operating systems

Data APIs

Algorithms and data structures

Requirements gathering

Education

Bachelor's degree in Information Technology

Tools

SQL Server Management Studio

Informatica PowerCenter

SQL Server Integration Services

Job description

Overview

Our client is looking for 2 Sr. Data Engineers t o 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.

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.

Mandatory

• 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

Must Have's

• Experience using Informatica software (i.e., Power Centre, Integration Services, Workflow Manager, Intelligent Data Management Cloud (IDMC) and Test Data Management (TDM) in an integrated support environment.
• Expert knowledge of Oracle and SQL Server Database Management Systems and tools
• Expert knowledge of 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
• Information management, logic modeling, conceptual, business process, and workflow design
• Requirements gathering, analysis, plan, design, develop, implement and maintain Data Management systems.
• Cloud platform for data management

Nice to Have's

• Microsoft Certified : Azure Data Engineer Associate
• Experience working with healthcare data

Responsibilities

The Successful Suppliers 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, 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, Extract, Transform, Load (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 analysts and junior data management resources, as required.