Data Engineer (Microsoft Azure) – contract – outside IR35 – 1st July start – Ref: 25035

Join to apply for the Data Engineer (Microsoft Azure) – contract – outside IR35 – 1st July start – Ref: 25035 role at Howard Lock Consulting Ltd Join to apply for the Data Engineer (Microsoft Azure) – contract – outside IR35 – 1st July start – Ref: 25035 role at Howard Lock Consulting Ltd Howard Lock Consulting Ltd provided pay range This range is provided by Howard Lock Consulting Ltd. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range Job title: Data Engineer Start date: Must be available to start 1st July for 6 weeks initially, then fractional Location: Remote + some travel to Ipswich (as and when required) Job Ref: 25035 Overview: As part of the CLIENT strategic redevelopment programme, there is a requirement for a Senior Data Engineer to lead on data mapping, transformation, and synchronisation activities between the legacy Swift Internet-hosted database and a newly provisioned Azure-based solution. The legacy system presents several data quality and structural challenges — for example, data relating to \’County\’ may be found in columns labelled \’Country\’. Column naming conventions and data storage practices are inconsistent, and the schema is poorly documented. To gain a complete understanding of the data model and its usage, the Data Engineer will need to: Review and interpret the existing PHP codebase to identify how data is handled, populated, and transformed within the application Work independently to assess the current data structure within the legacy SQL Server/MySQL database Design a clean, normalised target data model within Azure (e.g., Azure SQL or similar) Define a robust mapping and transformation approach Collaborate with CLIENT stakeholders to validate and sign off the proposed data model and transformation logic Once approved, the engineer will transition to the implementation phase, including: Developing ETL pipelines using Azure-native tooling (e.g., Azure Data Factory or Synapse Pipelines) Establishing synchronisation between legacy and new systems Supporting delta updates and ensuring both systems remain aligned throughout the transition Assisting developers with ad hoc queries, transformation logic, and data reconciliation efforts Delivery Timeline & Resource Commitment: Sprints 0–2 (Full Time): Discovery, schema review, mapping design, and ETL development (30 days) Sprints 3–11 (Part Time): Ongoing support for developer-led integration and data sync (reduced involvement) – max 2 days a week, please note there are 2 week gap weeks every 6 weeks. Required Skills & Experience: Strong SQL knowledge (MySQL and/or SQL Server) Hands-on experience with data modelling and ETL development in Azure Proven ability to reverse-engineer data flows from code (specifically PHP-based applications) Experience collaborating with business stakeholders to define and validate data structures Understanding of legacy-modern system integrations and ongoing synchronisation challenges Familiarity with Microsoft Azure’s data services (e.g., Azure SQL, Data Factory) is highly desirable. Seniority level Seniority level Associate Employment type Employment type Contract Job function Industries Software Development Referrals increase your chances of interviewing at Howard Lock Consulting Ltd by 2x Get notified about new Data Engineer jobs in Ipswich, England, United Kingdom . Acton, England, United Kingdom 2 weeks ago Tan Office, England, United Kingdom 15 hours ago Ipswich, England, United Kingdom 4 days ago Suffolk, England, United Kingdom 4 weeks ago Martlesham, England, United Kingdom 1 week ago Ipswich, England, United Kingdom 2 weeks ago Head of Data and Analysis – Hybrid – Retail Ipswich, England, United Kingdom 5 months ago Tan Office, England, United Kingdom 2 weeks ago Ipswich, England, United Kingdom 6 days ago Ipswich, England, United Kingdom 17 hours ago Acton, England, United Kingdom 2 weeks ago Stowmarket, England, United Kingdom £27,000.00-£32,000.00 4 weeks ago Ipswich, England, United Kingdom 2 days ago PMO Data Analyst/Administrator – 24 month FTC Colchester, England, United Kingdom 3 hours ago Colchester, England, United Kingdom 1 week ago Ipswich, England, United Kingdom 1 day ago Stowmarket, England, United Kingdom 2 days ago Ipswich, England, United Kingdom 5 hours ago Colchester, England, United Kingdom 5 hours ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr