Accessability Links

Data Migration Analyst

  • Location: South East
  • Salary: £35000 - £55000 per annum + benefits
  • Job type: Permanent
  • Sector: IT & Information Security
This vacancy has now expired.

Data Migration Analyst needed to join Capita Data Services, which sits within Capita Application Services division and part of the Capita Software business. Data Migration Analyst will be joining a Centre of Excellence within Capita Group providing a highly professional sales, support, project and consultancy services for over 85 internal and external clients.

We support well in excess of 4000+ database server instances across multiple database technologies and versions, including the provision of end to end solution design capability through to business as usual support services. Data Services cover Database Administration and Consultancy, BI and Analytics, Data Warehousing and Data Migration services.

We are seeking to bolster the team in Chippenham or Reading and looking for talented and experienced Data Migration Analyst to work alongside Data Architect and Development DBA roles.

The roles will report to the SQL projects team leader and will primarily be based out of Chippenham or Reading within the devOPS teams. Candidates may be expected to travel within the UK on an ad-hoc basis

The role requires any candidate to have the ability to attain SC level clearance.

Responsibilities

  • Work with customers in gathering business requirements for data migration needs.
  • Work across multiple functional projects to understand data usage and implications for data migration.
  • Assist in designing, planning and managing the data migration process.
  • Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.
  • Prepare data migration plans including migration risk, milestones, quality and business sign-off details.
  • Manage assigned risks and monitor potential impacts as part of the data migration plan.
  • Develop best practice, processes, and standards for effectively carrying out data migration activities.
  • Perform source system data analysis in order to manage source to target data mapping.
  • Perform migration and testing of static data and transaction data from one core system to another.
  • Perform data migration audit, reconciliation and exception reporting.
  • Manage cross-program data assurance for physical data items in source and target systems.

Skills/Experience

Key Skills

  • In depth Understanding of RDBMS and database structure principles
  • Experience of Data Migrations
  • Experience gathering and analyzing system requirements
  • Ability to work with multiple data sources (SQL, Access, VBA, PostgreSQL, CSV, Excel etc)
  • Ability to manage multiple work streams and projects concurrently
  • SQL Querying
  • Proficiency in MS Excel
  • Proven analytical skills
  • Problem-solving attitude
  • The ability to analyse, model and interpret data
  • A methodical and logical approach
  • The ability to plan work and meet deadlines
  • Accuracy and attention to detail
  • Interpersonal skills
  • Teamworking skills
  • Written and verbal communication skills

Desirable skills:

  • Exposure to Dynamics and Dynamics 365
  • Understanding of Data Transfer tools (SSIS, Scribe)
  • Exposure to cloud environments (Azure, AWS)
  • Data Warehousing and Reporting Tools
  • R Scripting
  • Dimensional Modelling
  • Understanding of Cloud Technologies (Azure, AWS)
  • Understanding of Virtualisation Technologies
  • Experience of PowerShell
  • MS SQL Server Certification

Personal Attributes

  • Excellent written and verbal communication (English)
  • Excellent customer interaction skills
  • Excellent organisation and ability to prioritise time
  • Self-motivated and enthusiastic with a proactive approach to work
  • Able to work under pressure and to tight timescales
  • Analytical mind with a problem-solving aptitude

Capita IT Resourcing is acting as an Employment Agency in relation to this vacancy.

Start your search again

Similar jobs
1st Line Support Analyst - Inside IR35
Chelmsford, Essex £0.00 - £150 per day
Apply
2nd Line Support Analyst
Chelmsford, Essex £0.00 - £200 per day
Apply
2nd Line Support Analyst - INSIDE IR35
Chelmsford, Essex £0.00 - £200 per day
Apply
Back to Top