Data Migration Lead

Posted 24 January 2024
Salary Negotiable
Job type Temporary
Discipline Professional & Technical
ContactHannah Harvey

Job description

Job Title: Data Migration Lead

Location: Remote

Rate of Pay: Up to £550 per day (Umbrella, Outside IR35)

Working Hours: Monday to Friday, 37 hours

Type: Temporary 12 months contract

Opus People Solutions are working with West Northamptonshire Council to recruit for a Data Migration Lead.

The data migration consultant will be responsible for undertaking the analysis of datasets required to migrate data into the target system including contribution to development of the data models and architecture.

Main Responsibilities:

  • Meeting with business (SMEs / Business Leads) and/or users to identify and define data migration needs.
  • Formulate a data migration process which is aligned with the data migration process of the supplier of the target system.
  • Formulate a data migration plan / schedule that is aligned with the overall implementation plan from the supplier of the target system.
  • Undertake an audit of the existing data sources and work in consultation with business (SME/Leads/Users) to define business rules for the migration.
  • Identify all data quality issues and improvements needs to support successful completion of the data migration as per overall delivery plan.
  • Support testing of data migrated, covering unit testing, coordination with suppliers assigned DM consultant for ETL and related testing.
  • Conduct user acceptance testing of each data load, as well as further regular internal loads, this would need coordination with business leads/SMEs, and users.
  • Knowledge of legacy databases as well as ETL process that will be used by the supplier of the target system.
  • Eye for details and accuracy for data extractions from the legacy system to avoid duplication or inaccurate data being migrated to target system.
  • Solution focus attitude to deal with range of data issues that would arise from migration of data from 4 different legacy system to one/two target systems.
  • Flexible yet methodical and logical approach to carry out data migration working closely with other workstreams of the ARISE project, business and supplier.
  • Data protection acumen as data dealt with will be of vulnerable people at risk.
  • Experience of working as data migration consultant independently using ETL framework.
  • Experience of data design, development with experience of SQL, Scripting, data mining techniques to carry out data extraction from the legacy system.
  • Experience of dealing with a wide range of data sources for extraction to one or two target system.


Knowledge and experience of migrating data from legacy systems in use by WNC (Eclipse, Carefirst and Abacus), and ideally with experience of migration to selected target systems for the ARISE project (Liquidlogic and ContrOCC).

For more information or to process your application for this role, please apply online now.