Lead Data Migration Analyst

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. 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.

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

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 closing date for applications is 28th July 2024. The interview date for the role is planned for Tuesday 13th July 2024.

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

Advert information