Data Migration Analyst (Fixed Term)

As a data migration analyst, you will be part of a team who will be playing a crucial role in ERP implementation to ensure the accurate and complete transfer of data from the source systems to cloud, which is fundamental to the new system's success and a university's business continuity. Be responsible to ensure the current consolidate data from multiple disparate legacy systems into the new ERP's unified database, which requires mapping, transforming, and standardizing the data.

The Role 

The successful candidate will be working closely with existing data migration team, will involve in coordinating and performing the data validation checks & reconciliations within strict timelines, and troubleshoot issues promptly. 

Key activities for this role include supporting data mapping, transformation, and validation of data from legacy systems. able to perform source system data analysis in order to manage source to target data mapping. Involve in developing scripts in SQL/PL-SQL, and automated processes for data extraction, transformation, and loading (ETL) ensuring data quality and integrity throughout the migration process. 

Your Skills 

You will be able to demonstrate you have experience of data reconciliation and reconciling migrated data with Oracle EBS and Fusion data structures alongside these you will possess: 

• Experience (8+ yrs) working in ERP implementation projects, at least 1 end-to-end
• Experience in data analysis & data quality with proficiency in SQL or PL/SQL
• Comfortable writing and reading SQL queries to compare/validate datasets
• Knowledge of using data analytical tools like Power BI, Tableau, advanced Excel etc
• Strong understanding of data structures, relational databases, data object relationships and validation methods
• Translate functional requirements into actionable technical insights
• Understanding of core business entities such as COA, GL accounts, vendors/customers, Projects, etc
• Excellent analytical and problem-solving skills with strong attention to detail
• The ability to identify and pro-actively manage important risks, issues and problems effectively
• Excellent interpersonal and communications skills

Benefits

The University offers an excellent benefit package including:

• 41 days annual leave, inclusive of Bank Holidays
• Defined benefits pension schemes
• Flexible working options
• Family-friendly initiatives
• Career development opportunities
• Support for health & mental wellbeing
• Tax-efficient bicycle and charity-giving schemes

Location

The University is supportive of hybrid working, where some work is undertaken on university premises and some in a remote working environment. The aim of our approach is to enable as many staff as possible to work in a hybrid way if they wish and where their role allows. This arrangement is subject to change and will not form a part of the contractual terms of the role.

Fixed-term: The funds for this post are available until 30 September 2027 in the first instance.

To apply online for this vacancy and to view further information about the role, please click 'Apply' above. 

Once an offer of employment has been accepted, the successful candidate will be required to undergo a basic disclosure and a security check. We welcome applications from individuals who wish to be considered for part-time working or other flexible working arrangements. 

If you would like more information about this role, informal enquiries can be directed by email to Michelle.Bond@admin.cam.ac.uk. 

If you have any questions the application process, please contact a Recruitment Administrator at Finhr_recruitment@admin.cam.ac.uk. 

The interviews date for the role are planned for w/c 12th January 2026.

The University actively supports equality, diversity and inclusion and encourages applications from all sections of society.

Advert information