Data Migration Engineer

Role: Data Migration Engineer x 2

Location: Bath (Hybrid working)

Duration: 6 Months

Day rate: £550

Active SC clearance required - preferably MOD SC clearance

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.
• 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 (e.g., InterSystems IRIS/HealthShare)
• Tune performance for high-volume patient data and ensure resilient batch orchestration and environment promotion practices

Previous experience and skillset:

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