Oracle Data Administrator

Name - Oracle Data Administrator
Hybrid
3 Months Contract

1. JOB PURPOSE:

• Monitor and maintain the accuracy and integrity of all master data held in the Oracle system, ensuring compliance with internal control frameworks and external regulatory requirements across Finance, HR and Procurement functions
• Action all standing master data changes to the Oracle system including staff, positions, supervisory hierarchy customer accounts and supplier registration in line with agreed processes and approval workflows.
• Support the Data, Control and Reporting Manager in the development of a reporting and data analytics framework including the ongoing production of reports and dashboards to meet the requirements of the functional support teams and wider organisation.
• Support the functional services and wider organisation in the use of Oracle Enterprise Performance Management (EPM) ensuring they utilise the system to deliver their reporting requirements.

2. DESCRIPTION OF DUTIES:

• Collate timely and accurate data for ad hoc requests, in-year compliance and year-end reporting, audits, statutory returns, public inspections and FOI requests providing the data to the relevant SME for review and submission.
• Support the design, maintenance and regularly produce Oracle Fusion and EPM reports for system professional and end users, senior managers and leadership team providing related support and advice Council-wide where required, using all available tools including OTBI and SQL.
• Maintain the suite of Oracle reports and dashboards providing recommendations for improvement and feeding back any issues to ensure reports remain fit for purpose.
• Support the Data, Control and Reporting manager in embedding and maintaining the Oracle data management framework supporting consistency, accuracy and security in data handling within Oracle.
• Ensure the data management framework for Oracle is monitored, adhered to, and data remains accurate by completing regular data reviews and cleansing activities to drive compliance across all environments reporting areas of concern and providing recommendations for improvement.
• Support data compliance monitoring for key HR and Financial controls including Chart of Accounts, hierarchies, naming conventions, and quality of journal transfers. Identify issues and risks and provide suggestions for improvement to Oracle Support Leadership team.
• Identify and report any significant failures in control procedures, risks and change impact assessments to the Data, Reporting and Analytics Manager.
• Support the monthly/quarterly update testing cycles for Oracle modules working closely with Oracle Support and functional colleagues to support product improvements delivered from the Oracle Improvement Roadmap.
• Promote self-service and shift left principles by enabling others to effectively and confidently utilise system data in their roles.
• Responsible for the setup, maintenance, and changes for AR customer accounts, SM supplier registration (including bank detail verification when requests for change are made), HR records, organisation structures and other data administration applying verification and validation in line with business processes and ensuring the highest level of data accuracy.
• Support the development and ongoing maintenance of HCM, ERP and EPM in system screens, dashboards, and reports.
• Provide recommendations to improve data and reporting related content on the Finance, HR, Oracle Support and Procurement Hubs, intranet and website pages ensuring content is relevant and up to date.
• Ensure GDPR and other information governance requirements are met through access restrictions and control over data output from reports produced from Oracle and report and challenge breaches e.g. use of personal information by requisitioners in document description lines as well as accurate redaction of bank documentation.
• Update configuration workbooks, solution design documents and process maps when changes are made to the system highlighting any areas of concern with processes.
• Maintain Oracle hierarchies, Chart of Accounts Code Segments, Cross validation rules and approval groups within the main account system ERP modules, through agreed authorisations and workflows.
• Ensure all work undertaken is compliant with the Council's regulations, policies and practices, and statutory requirements, promoting best practices across all modules of the Oracle system through regular monitoring of activities.
• Support training and development of guidance materials to support staff and stakeholders in effective data management, quality control and reporting practices.
• Engage with your personal development and CPD through self-service supervision, performance appraisal, maintaining close working relationships with colleagues within the Oracle Support Service and wider functional teams.

The duties and responsibilities outlined in this job profile are indicative of the role, however they are not exhaustive and may be subject to change. In addition, you will be required to undertake other reasonable duties as directed by your manager.

SELECTION CRITERIA/PERSON SPECIFICATION

Conditions to Note:

The person specification outlines the essential requirements the post holder or applicant must meet to fulfil the role and the duties outlined.

Guidant, Carbon60, Lorien & SRG - The Impellam Group Portfolio are acting as an Employment Business in relation to this vacancy.