Description | Salary £44,711 - £49,764 per annum | Fixed-term contract to 31/01/2026 | Full Time, 37 hours per week | Preston, Lancashire International Sponsorship – this role is not open to international sponsorship We are looking for an experienced Data Migration Lead for a 12-month short-term contract to oversee our data migration project. The successful candidate will be responsible for managing and coordinating the data migration project, ensuring it adheres to the agreed scope and timeline. This role involves creating and maintaining the project plan, setting up the Data Migration Working Group (DMWG), and ensuring successful project delivery. Working for a local government organisation delivering ICT services, you will benefit from public sector terms and conditions of employment, whilst working in a fast-paced technical environment. The role Project Management and Coordination: Manage and coordinate the data migration project, including creating and maintaining the project plan, setting up the DMWG, and ensuring adherence to the agreed scope and timeline. Data Analysis and Mapping: Analyse the data to be migrated, propose a high-level data migration scope, create data migration mapping documents and data catalogue and directories. Development of Migration Scripts: Create migration scripts, matching processes, and data transformations required to migrate data to new highways asset management system. Data Quality Management: Develop a data quality reporting process to alert staff of any data quality issues that need attention. Testing and Validation: Create migrated data and work with the Test Manager to ensure data accuracy and integrity. Reconciliation: After each migration iteration, create reconciliation reports to document what has been migrated, ensure the right data is being migrated, and compare to expected outcomes. Risk Management: Identify and manage risks associated with the data migration project. Communication and Reporting: Communicate with stakeholders, discuss issues and risks, confirm decisions, and provide updates on project progress. About you Knowledge of data engineering technologies and tools. Proficiency in SQL for data manipulation and querying. Experience in designing and implementing highly available, performant, and secure data pipelines aligned with availability and disaster recovery strategies. Proficiency with orchestration and management tools, data system monitoring, administration, compliance, and capacity planning. Experience in data security, privacy, integrity, and performance testing. Commitment to continuous improvement and self-development. Experience or the ability to lead, manage, mentor, and motivate a technically focused team in an enterprise environment, including delivery of technical workshops and hands-on guidance. Experience working with other technical and non-technical teams to support project delivery. About us Lancashire County Council is the fourth largest local authority in England and covers a huge geographic area and a wide range of communities both urban and rural. The council's remit is substantial, varied and complex, delivering a wide range of services to the 1.2 million people who live here. Digital Services serves as a single source for all ICT requirements to over 15,000 customers within the council and other beneficiaries. This is an exciting time to join Lancashire County Council, with plenty of interesting projects in the pipeline as we work to support our digital agenda. This post offers a real opportunity to make a difference to the delivery of public services across Lancashire. The Benefits We value our staff as individuals and aim to help them achieve their full potential while working for us. We offer a work environment that encourages staff engagement, team working and problem solving, and we recognise the importance and benefits of a good work life balance. In return for your passion and expertise we offer all our staff a generous benefits package equal to the terms and conditions enjoyed by all council staff. These are just some of the benefits you could enjoy: Flexible working hours (37 hrs per week) along with opportunities for agile working Extremely generous Local Government Pension Scheme with generous employer contribution, death in service payments, life assurance and dependents pensions Great Holiday Entitlement: 26 days annual leave entitlement rising to 32, after five years' continuous service. Eight bank holidays and two further additional statutory days during the Christmas and New Year period Family friendly employer: Help to balance family commitments, including generous maternity leave, paternity leave and support for working carers adoption and parental leave. Childcare voucher scheme. Great location, just a short walk from the train station and main bus route Further information: For an informal chat please contact Vishal Mistry on 01772 532672. Closing Date: 01 December 2024 Interviews: Interviews are likely to be held within 2 weeks of the closing date. If you're already a Lancashire County Council employee you must apply via the internal vacancies option on Oracle Fusion. You can do this by logging into Oracle Fusion and then going to Me - Current Jobs. Please ensure you have uploaded and attached your supporting statement to evidence how you meet the criteria for the role. We are looking for candidates who meet and exceed the requirements listed in the person specification attached to this advert. The panel may be unable to shortlist you for interview without this evidence. In return Lancashire County Council offers a range of benefits, which can be found on LCC Vacancies website. We reserve the right to close down a vacancy early, before the closing date, if we receive sufficient applications. Job Description and Person Specification