Data Migration Analyst
Role details
Job location
Tech stack
Job description
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;
o missing mandatory fields
o data not coherent & correctly cross-referenced
o data not valid i.e. formatted correctly, consistent with NetSuite requirements
o 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;
o email addresses
o third party payers
o fees, discounts & academic calendar
o pricing master header & lines
o 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.
Requirements
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