Data Migration Engineer- Clinical Data

The role is for a Data Migration Engineer to work within an Application Management team. The work supports the Clients new healthcare platform.

The objectives and outputs from the role include the following:

• The role is to provide Data Engineering support for InterSystems HealthShare (HFS) components including the EMPI (enterprise master patient index), HPD (healthcare provider directory), Portal and Data Quality reports, and any other related project components added during this period.
• Assist with the implementation of the data migration pipeline for the Authority's Health Record based on InterSystems IRIS. This will include design, development, testing, and monitoring.
• Configuration, deployment, and testing of the supporting infrastructure and environments required for data migration, including populating and making available a terminology server, agreeing Firewall rules, and implementing ETL and analysis tooling based on the Cloud Azure platform.
• Creation and maintenance of data mappings and transformation logic for the data migration pipelines, ensuring alignment with the target data model and business rules. This will include analysis and implementation of clinical terminology mappings, the segregation of data into multiple migration targets, and the redaction of sensitive data.
• Tune performance for high-volume patient data and ensure resilient batch orchestration and environment promotion practices
• Handling coded clinical data including SMOMED/Local code mapping
• Develop staging-layer pipelines in IRIS
• Configure and optimise extraction and ingestion processes across heterogeneous clinical source systems and target environments (eg, InterSystems IRIS/HealthShare)

• Analytical/problem solving skills.
• Team working, personal networking skills.
• Able to influence even when not in a position of authority.
• Adaptable, self-motivated and with an ability to quickly understand technical concepts.
• Able to identify and develop database improvements.
• Work under pressure while remaining decisive.
• Able to communicate all needs, instructions and decisions clearly.

Previous experience and skill set:

• Demonstrable knowledge Data Migration and Data modelling
• Experience of ETL Development (Clinical Coded Data/InterSystems IRIS-HealthShare) Design
• Required - experience of development in InterSystems HealthShare and HealthConnect with a strong understanding of EMPI, PD, Integration engine and IRIS.
• Preferable - experience of development with Azure, Microsoft .Net, Ansible, Terraform
• Ability to work in an Agile way as part of an Agile team.
• Nice to have - experience of Jira and/or Azure DevOps.