Data Migration Analyst

Free-Work; Milton Keynes; Hybrid; GBP 55,000 - 74,000; Full time

Job summary

Free-Work in the United Kingdom is seeking a Data Migration Analyst with 3–5 years of data analysis experience to support data migration to NetSuite edERP. You will help ensure data quality and assist with extraction processes.

You will review legacy data for issues, coordinate with users to resolve them, and participate in at least two major data migration projects while applying ETL practices and strong Excel skills.

Qualifications

• 3–5 years experience as a Data Analyst or equivalent.
• 3+ years experience of systems implementation.
• Experience with extraction & cleansing of legacy data.
• Involvement in at least 2 major data migration projects.
• Strong Excel skills and ETL data migration methodology.

Responsibilities

• Support Data Migration Lead in migrating legacy data to NetSuite edERP per project plan.
• Review legacy data for quality issues: missing fields, coherence, valid formatting.
• Coordinate with users to resolve data quality issues.
• Perform data extractions from legacy system into Excel for migration.
• Liaise with schools during data preparation and ensure safeguarding compliance.

Skills

Data analysis

Data cleansing

Interpersonal skills

Excel

SQL

Tools

Excel VBA

T-SQL

Job description

Data Migration Analyst

Our Client is looking to recruit a seasoned Data Migration Analyst with excellent Data Analyst skills - at least 3 to 5 years experience as a Data Analyst.

Provide support to the data migration Lead in the data migration of legacy data into NetSuite edERP in accordance with the project plan

Review the legacy data to identify data quality issues

Review non-legacy data for data quality & resolve issues

Liaison with the schools throughout the data preparation stages

Perform data extractions from the legacy system into Excel

Review the legacy data to identify data quality issues such as;

• missing mandatory fields
• data not coherent & correctly cross-referenced
• data not valid i.e. formatted correctly, consistent with NetSuite requirements
• potential functional shortfalls of NetSuite

Co-ordinate with Users to resolve issues identified with the quality of the data.

Co-ordinate with Users in the preparation of other data that are not in the legacy system that is required for NetSuite, such as;

• email addresses
• third party payers
• fees, discounts & academic calendar
• pricing master header & lines
• NetSuite contracts

Review non-legacy data for data quality & resolve issues with users, where necessary obtaining acceptance from the project team and/or the Business.

To comply with safeguarding policies, procedures and code of conduct and demonstrate a personal commitment to safeguarding and student/colleague wellbeing.

Ensure that any safeguarding concerns or incidents are reported appropriately in line with policy and engage in safeguarding training when required.

Must have at least 3 to 5 years experience of data analysing and/or cleansing and at least 3+ years experience of systems implementation.

Have experience of extraction & cleansing of legacy data.

Being involved in at least 2 major Data migration projects.

Should have strong Excel user skills along with data migration ETL methodology.

Must have excellent interpersonal skills.

English as primary language.

" T-SQL"

" Excel VBA"

" Accounting"

ETL Methodology

The Client is based in Milton Keynes various offices across the UK. The role will based remotely at present with the need to attend the office as and when required.

The rate for this role will be circa £300 to £400 per day.

The duration for this contract assignment will be 6 months.