Oracle Data Analyst (Oracle HCM)

Posted 9 days agoExpires in 18 hours
Westminster, London
Fixed Term Full Time
£36,781 rising to £40,250 after probation

The People System and Data Project will bring together people data, systems and processes from across the Church of England.

The People System and Data Project require a Data Analyst to join the team to assist with the migration of data into a new cloud-based HR system.

Initially you will be be focused on the creation of a data set, comprising all data fields expected to be migration. The data will mirror key user cases we have but populated with test data.

You will also assist with a data quality exercise to clean the data to the required level prior to migration. Once these two objectives are complete, you will concentrate on the main upload of data to the HR system and perform the tasks to upload, error correct, and validate data in the HR system.

This is a fixed term contract expected to last until the end of December 2020.

The Role

  • Provide Oracle HCM Cloud Fusion functional payroll, HR query resolution to our internal team.
  • Create and maintain a data set of Configuration Items using;
    • data acquired from source systems;
    • master data management definitions;
    • new data structures defined as part of the Project;
  • Create and maintain a test data set of 1,000 people records, based on real user cases;
  • Assist with the data cleansing of source-system data;
  • Undertake the tasks required to successfully upload data to the HR system;
    • Preparing data for upload;
    • Monitoring upload process and correction of any data upload errors;
    • Post-upload validation of data within the HR system;
  • Validate configuration and data for Oracle HCM Cloud project

The Requirements

  • Strong communication and interpersonal skills.
  • Builds confidence and trust with stakeholders and project team
  • Displays effective analytical skills
  • Preparing, consolidating and maintaining large data sets from multiple data sources;
  • Build working relationships with source-system owners and local experts to ensure accurate data is maintained and migrated;
  • Play a key role in supporting data cleansing for migration via a SQL database solution;
  • Engaging with source-system owners to clean and validate inaccurate data;
  • Identify potential errors and drive continuous improvement in legacy system data;
  • Use technical knowledge of Excel and SQL to create, and track data accuracy in preparation for migration to new system. Adding automation where possible;
  • Understand the process of uploading data to the HR system to be able to monitor progress and correct any errors that occur;
  • Member of a core team providing specialist knowledge of gathering, interpreting & manipulating data;
  • Interpret data and use insight to suggest changes to processes that may have caused data inaccuracies
  • Experience of handling high volumes of data for large and complex organisations;
  • Advanced level Excel skills and confident in SQL;
  • A background or understanding of HR and Payroll data;
  • Experience of uploading data to a SaaS system;

We in the National Church Institutions support the mission and ministries of the Church all over England. We work with parishes, dioceses (regional offices), schools, other ministries and our partners at a national and international level.

Excellence, Respect, Integrity

We follow these three values in everything we do, whether we are of Christian faith, another faith or no faith. To learn more about working for National Church Institutions and our benefits, please click here

As we are a member of the Armed Forces Covenant, we welcome all applications from those you have served in our Armed Forces and their families

We are committed to building a culturally diverse workforce. As part of this commitment, we welcome applications from people, regardless of their background. As a Disability Confident committed employer, it is important to note that there may be occasions where it is not practical or appropriate to interview all disabled applicants who meet the minimum criteria* due to high volume. We limit the amount of interviews conducted to five applicants per open post we advertise.

*Where applicable depending on post requirements.