Data Engineer

On behalf of our healthcare client, Affinity Healthcare Solutions is looking for 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 several 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 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.

Responsibilities:

• 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 Qualifications:

• 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.

Qualifications:

• Experience using Informatica software (i.e., Power Centre, Integration Services, Workflow Manager, IDMC and TDM) in an integrated support environment.

• 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.

• 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.

Nice to have:

• Microsoft Certified: Azure Data Engineer Associate would be considered an asset.

• Experience working with healthcare data would be considered an asset.

Affinity Earn:

Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity:

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 12202