Data Transformation Architect​/Engineer

Position: Data Transformation Architect / Engineer
Location: Halesowen

Data Transformation Architect / Engineer – AWS Glue, ETL & AI/ML London - weekly/fortnightly workshops meetings £550–£725~ per day inside IR35 6-month initial contract, with potential for extension Essential Consulting are working with a global life and health reinsurance company who are looking for an experienced Data Transformation Architect / Engineer to support a major data transformation programme. The business is modernising its legacy data platforms and looking to automate existing data ingestion, mapping and transformation processes using modern cloud technologies and AI/ML capabilities.

This is a hands-on technical role , suited to someone with a strong data engineering background who can design, develop and implement practical solutions rather than focusing purely on high-level architecture.

Key Responsibilities Lead the technical design and delivery of data ingestion, mapping and transformation solutions. Build and enhance ETL pipelines using AWS Glue and other AWS data services. Explore and implement AI/ML solutions to automate data mapping and reduce manual processes. Work closely with engineering teams to modernise legacy data platforms and improve data processing capabilities. Facilitate workshops with business and technical stakeholders to understand requirements and translate them into technical solutions.

Support the development of scalable, efficient and maintainable data transformation processes. What We're Looking For Strong hands-on experience with AWS Glue, ETL, data ingestion and data transformation . Solid background in data engineering , including data mapping, integration and pipeline development. Experience or exposure to AI/ML , particularly applying automation to data processing and transformation. Ability to combine technical architecture knowledge with hands-on engineering and delivery.

Experience working on complex data modernisation or transformation programmes. Strong communication and stakeholder engagement skills, including facilitating technical workshops. Proactive, solutions-focused approach with the ability to take ownership of technical challenges. Previous Insurance or Reinsurance experience would be highly advantageous, particularly working with complex insurance data. This is an excellent opportunity to play a key technical role in a major data transformation programme, helping a global organisation modernise its data capabilities through cloud technologies and intelligent automation.