Lead Data Migration Analyst
Job Description
Job title: Lead Data Migration Analyst
Company: University of Cambridge
Job description: The implementation of the new finance system is a once in a lifetime opportunity to make a difference to the way in which University departments process and manage their financial transactions. As lead data migration analyst, you will be responsible for planning and delivering the Finance systems data migration strategy under the Finance Transformation Programme. You will be required to work effectively and successfully with implementation partners and internal stakeholders to determine and perform the extract and transformation of data and perform migration and testing of static data and transaction data from one core system to another.
The Role
The successful candidate will be required to perform data migration audit, reconciliation and exception reporting and lead on designing, planning and managing the data migration process and perform source system data analysis in order to manage source to target data mapping.
Key activities for this role include the production of data mapping (entities, attributes and relationships), and domain data model documents as deliverables with the responsibility for creating data catalogs, data dictionary, data mapping documents, and for defining the data models and data integrations.
The role requires management of resources needed for data migration to avoid bottlenecks and conflicting demands alongside the preparation of data migration plans including migration risk, milestones, quality, and business sign-off details.
Your Skills
You will be able to demonstrate a logical and pragmatic approach to data migration with the ability to adapt to meet the delivery needs.
You will be able to demonstrate you have experience of data reconciliation and reconciling migrated data with Oracle EBS and Fusion data structures alongside excellent inter-personal, analytical and communication skills.
Alongside these you will possess:
- Excellent analytical and problem solving skills with strong attention to detail
- Extensive knowledge of Relational Data Models (conceptual, logical and physical data models), Dimensional Data Models, Database design, Data Dictionary and Metadata
- The ability to identify and pro-actively manage important risks, issues and problems effectively
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
- Discounts on shopping
- Rental deposit scheme
- Public transport season ticket loans
- 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.
The Finance Division has embraced hybrid working and individuals are currently working with their team three days a week from a university site, principally Greenwich House, and two days worked remotely (for those working a standard Mon to Fri week). 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 for 3 years in the first instance.
Applications are welcome from internal candidates who would like to apply for the role on the basis of a secondment from their current role in the University.
Click the ‘Apply’ button below to register an account with our recruitment system (if you have not already) and apply online.
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
If you have any questions the application process, please contact
Closing Date: 11th February 2024
Interview Date: 19th February 2024
Please quote reference AG40219 on your application and in any correspondence about this vacancy.
The University actively supports equality, diversity and inclusion and encourages applications from all sections of society.
The University has a responsibility to ensure that all employees are eligible to live and work in the UK.
Further information
Expected salary: £61198 – 64914 per year
Location: Cambridge
