Data Architect in London

Data Architect – Mainframe Migration & Modernisation (Contract) We’re recruiting an experienced Data Architect to lead a critical mainframe data migration and modernisation programme for a large enterprise environment. This is a hands-on, delivery-focused role working on complex Db2 on z/OS systems and migrating data to modern cloud-based relational platforms. You’ll be responsible for designing and delivering Change Data Capture (CDC) pipelines, ensuring accurate, low-risk data movement with zero-surprise cutovers. The role involves deep involvement across data modelling, integration architecture, validation, reconciliation, and event-driven design. Key Responsibilities * Design and operate CDC pipelines (IBM CDC, Precisely or equivalent) * Migrate data from Db2 / mainframe (z/OS) to PostgreSQL / Aurora * Build Kafka-based integration pipelines and event-driven architectures * Deliver dual-run migrations, cutover planning, rollback and reconciliation * Perform logical and physical data modelling (OLTP and analytics trade-offs) * Ensure strong data quality, validation and governance controls Essential Skills * Proven experience as a Data Architect or Data Migration Architect * Strong Db2 and mainframe (z/OS) knowledge * Hands-on CDC design and delivery * Kafka and event-driven integration experience * PostgreSQL / Aurora data modelling * Strong SQL and data validation mindset Nice to Have * IBM CDC / Precisely * COBOL copybooks or VSAM exposure * Financial services or large-scale enterprise environments This role suits a senior, hands-on architect who enjoys owning complex data migrations end to end