Sr. Data Engineers to work with data from across the spectrum of healthcare domains, refining requirements with customers, developing data models, extract

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

Overview:

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.