Data Migration Analyst

Aatom Recruitment

Halifax, UK

4 days ago

Apply on www.collegerecruiter.com

Prepare application

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.collegerecruiter.com

Tech stack

Data Analysis Spreadsheets Databases Data Migration Data Mining RAID Oracle SQL Developer SQL Databases Information Technology Software Version Control Legacy Systems

Job description

To carry out the data extraction work from the legacy systems working collaboratively with the nominated CMBC ICT&D 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

Requirements

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. Nice to have., * 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