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