Data Migration Architect

Data Migration Architect

Duration: 4 months (initially)

Location:

Bath – onsite 2/3 days per week

Compensation: £545 per day inside IR35 (umbrella only)

Clearance:
Active SC clearance required

• Own the architecture and design of ETL frameworks for clinical data migrations
• Define migration patterns, tooling strategy, and deployment approach (batch, real-time, hybrid)
• Provide technical governance across all migration work streams
• Lead architecture reviews, design assurance, and technical decision‑making
• Mentor and guide Data Engineers, Architects, and SMEs across the programme

Define end‑to‑end data migration strategy, including:

• Data extraction from legacy clinical systems
• Transformation rules and mapping specifications
• Data validation, reconciliation, and quality control frameworks
• Establish data standards, models, and governance principles aligned to healthcare regulations
• Develop migration roadmaps, including phasing, cutover strategy, and rollback planning

• Apply knowledge of clinical data models, terminologies, and standards (e.g., patient records, diagnostics, outcomes)
• Ensure compliance with healthcare data regulations (e.g., GDPR, NHS data standards if UK‑based)
• Work closely with clinicians, analysts, and stakeholders to validate data interpretation
• Support safe handling of sensitive patient data and ensure auditability

• Design and oversee ETL pipelines for large‑scale structured and unstructured clinical datasets
• Select and implement appropriate tools (e.g., Azure Data Factory, Informatica, SQL‑based tooling)
• Ensure performance, scalability, and resilience of data processing workflows
• Oversee data cleansing, enrichment, and transformation logic

• Define data quality frameworks, including rules, thresholds, and monitoring processes
• Lead data profiling, cleansing, and remediation activities
• Establish reconciliation and verification processes ensuring completeness and accuracy
• Implement audit trails and data lineage capabilities

• Act as the primary technical authority for migration with business and clinical stakeholders
• Translate complex technical concepts into business‑friendly language
• Collaborate with programme managers, vendors, and clinical teams
• Support risk management and issue resolution throughout delivery

• Medical knowledge/background (GCM6 required)