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
Technical Leadership
- 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 workstreams
- Lead architecture reviews, design assurance, and technical decision making
- Mentor and guide Data Engineers, Architects, and SMEs across the programme
Data Strategy & Planning
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
Clinical Data Expertise
- 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
ETL & Data Engineering
- 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
Data Quality & Governance
- 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
Stakeholder Management
- 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
Requirements
- Medical knowledge/background (GCM6 required)