Data Migration Analyst

Data Migration Analyst
Initial contract 6 months subject to 3 monthly review - The duration of the project is 18 months so there is the potential for the role to be extended beyond the initial six month contract
Hybrid working - remote and onsite if required
Daily rate - £500 per day
Outside of IR35
Must be available for immediate start
Key requirements will be:

* Understanding of migration principles, in particular migration of social care systems.
* Knowledge and understanding of Adults and/or Children's Services process and procedures and the likely related statutory reporting requirements
* Experience with writing database extracts, analysing tables and writing extraction procedures in a variety of technologies e.g OraclePL/SQL, experience of writing database extracts, analysing tables and writing extraction procedures, specifically Oracle PL/SQL.
* Good understanding of source control principles and version
* Detailed knowledge and experience of working in IT projects and ability to contribute to and/or manage relevant documentation (RAID, migration scope etc)
* Ability to analyse and interpret data and to produce high-quality written reports summarising data, complex issues, and risks.

Desirable:

* Extensive experience of social care case management and finance migrations with an excellent understanding of finance data issues, forms and workflows - with the ability to analyse, interpret and advise on the reconciliation of those issues.
* Ability to communicate with stakeholders from a variety of audiences and technical understanding (eg be able to translate complex migration issues for non-technical people)
* High level of competence in the use of IT systems; able to self-teach and assist / mentor others in the use of IT systems and processes in relation to Data Migration

Key deliverables:

* To carry out the data extraction work from the legacy systems working collaboratively with the nominated team members ensuring appropriateness, adequacy and within the timeframe required.
* Responsible for the mapping and extraction of data in the required format from the in-house social care and finance systems (CASS and CIS) and other relevant data sources, such as spreadsheets and other databases.
* Liaising with the business representatives, developers, and Project Leads to identify and address any data which fails to meet the minimum migration standards
* Ensuring that the required data is extracted and provided to the Data Migration Specialist, for transformation activities, in line with project plan timeframes