Data Migration Analyst

University of Cambridge
Cambridge, United Kingdom
4 days ago

Role details

Contract type
Temporary contract
Employment type
Part-time (≤ 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
£ 60K

Job location

Remote
Cambridge, United Kingdom

Tech stack

Microsoft Excel
Business Analytics Applications
Data analysis
Databases
Data Validation
ETL
Data Mapping
Data Migration
Data Mining
Data Structures
Relational Databases
Power BI
PL-SQL
SQL Databases
Tableau
Oracle Ebusiness
Legacy Systems

Job description

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.

Requirements

Do you have experience in Tableau?, 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 & conditions

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

Apply for this position