Isp Data Migration Specialist/Application Support (Interim)

Position: ISP Data Migration Specialist / Application Support (Interim)
Location: Britannia House, Hall Ings, Bradford, BD1 1HX
Start Date: ASAP
Contract Duration: Until 1 January 2027
Working Hours: 37 hours per week, Monday to Friday, 9:00 am–5:00 pm
Pay Rate: £470.30 per day
Job Reference: (phone number removed)

• Lead and support data migration activities throughout the project lifecycle.
• Extract, transform, cleanse, map, validate and load data from legacy systems into the new case management solution.
• Analyse legacy data structures and identify migration requirements.
• Design and maintain ETL processes and data transformation routines.
• Develop and maintain data mapping specifications between source and target systems.
• Profile datasets and identify duplicates, inconsistencies and data quality issues.
• Develop migration scripts and automated processes where appropriate.
• Conduct test, rehearsal and production migrations.
• Perform data reconciliation and validation to confirm accuracy, completeness and integrity.
• Support User Acceptance Testing (UAT) and post-migration verification.
• Provide application support, maintenance, configuration and development where required.
• Investigate system and service issues and support the implementation of corrective and preventative actions.
• Maintain accurate technical, migration and service documentation.
• Work collaboratively with Business Analysts, Project Managers, technical teams, system suppliers and Adult Social Care colleagues.
• Provide progress updates, contribute to risk and issue management, and support delivery within agreed timescales.
• Ensure data is handled securely and in accordance with GDPR, information governance and Council policies.
• Follow relevant IT service management processes and contribute to continuous service improvement.

• Proven experience delivering large-scale or complex data migration projects.
• Strong knowledge of data migration and ETL methodologies.
• Advanced SQL skills, including data extraction, transformation and validation.
• Experience working with relational databases and large datasets.
• Experience in data profiling, cleansing, mapping, reconciliation and validation.
• Strong analytical and problem-solving skills.
• Ability to interpret complex business rules and translate them into migration requirements.
• Experience producing data mapping, migration and technical documentation.
• Experience providing application support within an ICT or business systems environment.
• Knowledge of ITIL principles and IT service management processes.
• Ability to work effectively with both technical and non-technical stakeholders.
• Strong written and verbal communication skills.
• Ability to work independently, manage competing priorities and meet deadlines.
• Strong attention to detail and commitment to data quality.
• Understanding of GDPR, data governance and information security requirements.
• Relevant BTEC National Level qualification or equivalent experience in an ICT/business systems environment.

• Experience delivering data migration projects within Local Government or the NHS.
• Experience of Adult Social Care system migrations.
• Experience with one or more of the following systems:
  • TPP SystmOne
  • System C Liquidlogic LAS
  • ContrOCC
  • Mosaic
  • Frameworki
  • Other social care case management systems
• Experience with Microsoft SQL Server, MySQL, SSIS or Azure Data Factory.
• Experience with Microsoft Fabric or other data migration tools.
• Advanced Microsoft Excel, Power Query, Power BI or Python skills.
• Experience working with Azure or cloud-hosted applications.
• Familiarity with Azure DevOps, Jira, SharePoint, Teams or Microsoft 365.
• Knowledge of social care data standards, statutory reporting and regulatory requirements.
• Relevant degree or equivalent experience in Computer Science, Information Systems, Data Management or a related technical discipline.
• Experience supervising specialist external technical consultants.

Additional Conditions

• Candidates must have the right to work in the UK, with eligibility documentation verified before appointment.
• Relevant qualifications, licences or professional registrations, where legally required, must be verified.
• References covering the required employment period and any employment gaps must be satisfactorily completed.
• The role involves access to confidential, personal, financial and commercially sensitive information; strict confidentiality and information governance requirements apply.
• Candidates should be able to communicate clearly and effectively in English, particularly when explaining complex technical matters to non-technical colleagues.