Data Migration Lead

Data Migration Lead £600 per day Outside IR35 Duration- 12 months Hybrid (Remote but with office working as needed) Knowledge and experience of migrating data from legacy systems (Capita Open Housing) The data migration lead 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. The range of responsibilities (along with experience, knowledge, and skills) under this role are included but not limited to the following: • 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 multiple legacy systems to one/two target systems. • Flexible yet methodical and logical approach to carry out data migration working closely with other workstreams of the project, business and supplier. • Data protection acumen as data dealt with will be personal data. • Experience of working as data migration lead 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