Data migration specialist

Corporate accountabilities: 1. To work with colleagues to achieve service plan objectives and targets 2. To comply with data protection legislation and the council #39;s Information Security Policy, including supporting policies 1. To be willing and able to work in a flexible and agile way with regard both to hours of work and location of work, including remote and home working, as required, subject to service needs and requirements 1. To participate in performance development, talent reviews and one-to-ones and to contribute to the identification of your own and team development needs and goals 2. To actively promote and comply with the council #39;s diversity and equality policies 3. To ensure full compliance with the Health and Safety at Work Act 1974 etc., the council #39;s Health and Safety Policy and all locally agreed safe methods of work 4. To fully understand and be aware of the commitment to Section 17 #39;Duty of the Crime and Disorder Act 1998 to prevent crime and disorder #39; 5. At the discretion of the senior management, to undertake other activities as, from time to time, may be agreed consistent with the grade and nature of the role 6. To undertake and maintain relevant mandatory training in line with legislation Key service accountabilities: * 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. Effective communication and presentation skills Written Communication Customer Focussed- able to build relationships at all levels Planning/Scheduling Application Integration and upgrades Proven understanding SQL Broad knowledge of Council applications Proven understanding of Childrens Social Care applications Previous experience of migrating EHCP data into EHM Experience in performing data matching Data quality management experience