Role Title: Data Migration Engineer
Location: Bath (2-3 days per week)
Clearance Required: Active SC Clearance
Duration: 6 Months
Day Rate: £485 (Outside IR35)
We are seeking a Data Migration Engineer to join our Application Management team. This role is essential in supporting the Client's new healthcare platform.
Responsibilities:
- 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, as well as other related project components added during this period.
- Assist in implementing the data migration pipeline for the Authority’s Health Record based on InterSystems IRIS, involving design, development, testing, and monitoring.
- Configure, deploy, and test the supporting infrastructure and environments required for data migration, including setting up a terminology server, agreeing on firewall rules, and implementing ETL and analysis tooling on the Cloud Azure platform.
- Create and maintain data mappings and transformation logic for the data migration pipelines, ensuring alignment with the target data model and business rules, including clinical terminology mappings, segregation of data into multiple migration targets, and redaction of sensitive data.
- Handle coded clinical data, including SMOMED / Local code mapping.
- Develop staging-layer pipelines in IRIS.
- Configure and optimise extraction and ingestion processes across various 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 practises.
Previous Experience and Skillset:
- Demonstrable knowledge of Data Migration and Data Modelling.
- Experience in ETL Development (Clinical Coded Data / InterSystems IRIS–HealthShare) Design.
- Required: Experience in development with InterSystems HealthShare and HealthConnect, with a strong understanding of EMPI, PD, Integration engine, and IRIS.
- Preferable: Experience in development with Azure, Microsoft .Net, Ansible, and Terraform.
- Ability to work in an Agile manner as part of an Agile team.
- Nice to have: Experience with Jira and/or Azure DevOps