Job summary
Oracle Business Analyst
Barts Health and BHRUT NHS organisations based in East London have formed a consortium, with Barts Health as the hosting body; this was formed based on implementing the full range of Oracle Financial ledger software and other compatible software. The primary purpose of the role is to assist the Systems Manager to ensure the integrity of systems and the data for all trusts, and that all processes follow best practice ensuring that the trusts are keeping up to date with the latest systems versions.
Main duties of the job
The main duties to be thePrimary point of contact with oracle financial users to record, resolve and escalate issues (financial, functional & technical) within Oracle Core Financials, V1 Scanning & Qlik Sense whilst at the same time adhering to agreed service level agreements in an efficient and effective manner.
Communicate with the users within the consortium and external partners such as, Version 1, V1, Qlik, NHS Logistics, GHX, Assmia & Alemba.
About us
Barts Health is one of the largest NHS trusts in the country, and one of Britain's leading healthcare providers.
The Barts Health group of NHS hospitals is entering an exciting new era on our improvement journey to becoming an outstanding organisation with a world-class clinical reputation. Having lifted ourselves out of special measures, we now have the impetus and breathing space to chart a fresh course in which we are continually striving to improve all our services for patients.
Our vision is to be a high-performing group of NHS hospitals, renowned for excellence and innovation, and providing safe and compassionate care to our patients in east London and beyond. That means being a provider of excellent patient safety, known for delivering consistently high standards of harm-free care and always caring for patients in the right place at the right time. It also means being an outstanding place to work, in which our WeCare values and behaviours are visible to all and guide us in how we work together.
We strive to live by our WeCare values and are committed to promoting inclusion, where every staff member has a sense of belonging. We value our differences and fully advocate, cultivate and support an inclusive working environment.
We particularly welcome applications from Black, Asian and minority ethnic candidates as they are underrepresented within Barts Health at this band.
Job description
Job responsibilities
The main duties are to ensure that systems are running and functioning as expected for the finance and Procurement teams for Barts Health and BHRUT Trusts
- Extensive knowledge of the Oracle Ebusiness Suite version 12.2.9 + and System Administration functions.
- Knowledge of Qlik Sense reporting tool & BI Reporting.
- XML Document Management Create and Amend outputs (AR Invoices, Statements, Dunning Letters, AP Remittances & Purchase Orders & Cheques
- Monitor and solve any issues with transmission of output Documents (Email and XML)
- V1 Archiving of AP & AR invoices, Customer / Supplier Details and Journal Backing documentation.
- Maintain and support the V1 OCR Scanning Software for loading documents into the Oracle system.
- Knowledge of Alemba helpdesk software and suggestions on improving the quality of responses and solutions to raised tickets.
- Provide online training via Assima, helping to develop and enhance the training lessons that we provide to our Finance Users and Budget Holders
- Communicating with users regarding issue tickets, system changes & downtime.
- Continually working towards service improvements and efficiencies.
- Maintaining oracle multi-org chart of accounts in accordance with the agreed Trusts SLAs and guidelines.
- Resolution of Level 2/3 Oracle issue tickets as per SLA.
- Assist the systems Manager in developing and maintaining System Administration procedures and protocols.
- Full life cycle management of allocated Oracle projects.
- Problem solving and solution provider within areas of expertise.
- Attendance and guidance in oracle financial modular subgroups.
- Attendance of oracle management group boards as and when required.
- Develop and write reports for the consortium using (BI Reports, XML Publisher, Qlik Sense etc)
- Offsite support for the solving of oracle user issues.
- Mentor the Support Analysts through issues and resolutions of level 2/3 issues including knowledge transfer.
- Train level 1 analysts on report writing.
- Line Manage the Oracle Business Analyst
- Maintain existing interfaces and develop new interfaces for Pharmacy, Stores, Payroll, and inventory systems.
- Add DFFs to enable the Trusts to be able to hold extra information for reporting purposes.
- Train level 1 analysts in using APIs (Application Program Interface)
- Train level 1 analysts in the maintenance and development of interfaces
- Keep up to date with the specialist knowledge of all Oracle modules for current and future developments within the Oracle Software suite.
- Keep up to date with new and future development tools that can be used with Oracle. (Qlik Sense, V1).
The interviews will be held on the 20th of August 2024
The full job description provides an overview of the key tasks and responsibilities of the role, and the person specification outlines the qualifications, skills, experience, and knowledge required. For both documents, please view the attachment/s below.
Job description
Job responsibilities
The main duties are to ensure that systems are running and functioning as expected for the finance and Procurement teams for Barts Health and BHRUT Trusts
- Extensive knowledge of the Oracle Ebusiness Suite version 12.2.9 + and System Administration functions.
- Knowledge of Qlik Sense reporting tool & BI Reporting.
- XML Document Management Create and Amend outputs (AR Invoices, Statements, Dunning Letters, AP Remittances & Purchase Orders & Cheques
- Monitor and solve any issues with transmission of output Documents (Email and XML)
- V1 Archiving of AP & AR invoices, Customer / Supplier Details and Journal Backing documentation.
- Maintain and support the V1 OCR Scanning Software for loading documents into the Oracle system.
- Knowledge of Alemba helpdesk software and suggestions on improving the quality of responses and solutions to raised tickets.
- Provide online training via Assima, helping to develop and enhance the training lessons that we provide to our Finance Users and Budget Holders
- Communicating with users regarding issue tickets, system changes & downtime.
- Continually working towards service improvements and efficiencies.
- Maintaining oracle multi-org chart of accounts in accordance with the agreed Trusts SLAs and guidelines.
- Resolution of Level 2/3 Oracle issue tickets as per SLA.
- Assist the systems Manager in developing and maintaining System Administration procedures and protocols.
- Full life cycle management of allocated Oracle projects.
- Problem solving and solution provider within areas of expertise.
- Attendance and guidance in oracle financial modular subgroups.
- Attendance of oracle management group boards as and when required.
- Develop and write reports for the consortium using (BI Reports, XML Publisher, Qlik Sense etc)
- Offsite support for the solving of oracle user issues.
- Mentor the Support Analysts through issues and resolutions of level 2/3 issues including knowledge transfer.
- Train level 1 analysts on report writing.
- Line Manage the Oracle Business Analyst
- Maintain existing interfaces and develop new interfaces for Pharmacy, Stores, Payroll, and inventory systems.
- Add DFFs to enable the Trusts to be able to hold extra information for reporting purposes.
- Train level 1 analysts in using APIs (Application Program Interface)
- Train level 1 analysts in the maintenance and development of interfaces
- Keep up to date with the specialist knowledge of all Oracle modules for current and future developments within the Oracle Software suite.
- Keep up to date with new and future development tools that can be used with Oracle. (Qlik Sense, V1).
The interviews will be held on the 20th of August 2024
The full job description provides an overview of the key tasks and responsibilities of the role, and the person specification outlines the qualifications, skills, experience, and knowledge required. For both documents, please view the attachment/s below.
Person Specification
Qualifications
Essential
- Bachelor's degree and extensive working experience within a customer facing/business environment.
- ECDL or Equivalent
Desirable
- Oracle Core Financial Courses.
Experience
Essential
- Highly competent in one or more of the Oracle financial reporting tools -BI/XML/Qlik Sense
- Highly experienced in call to ticket resolution utilising a help-desk escalation platform.
- Experience of working under pressure to strict deadlines and prioritising workload
- Extensive knowledge in Oracle 12.2.9 + functional system administration or 6+ years' experience of the same
Desirable
- Experienced or qualified in management/financial accounting theories. AAT/ACCA/CIMA, any stage a plus.
- Highly competent in one or more of the Oracle financial reporting tools -BI/XML/Qlik Sense
Knowledge
Essential
- Extensive knowledge in Oracle 12.2.9 + functional system administration or experience of the same
- Knowledge of Helpdesk Procedures
Skills
Essential
- Outstanding organisational skills, in particular communicating and monitoring key issues through full life cycle.
- Outstanding communication skills and the ability to do so at all levels.
- Working in a highly pressured environment and the ability to prioritise in such.
- Highly competent analytical skills with the ability to identify and resolve a range of problems, e.g. Oracle system errors, bugs, etc.
- Delivery of Oracle functional 12.2.9+ training to all levels.
- Ability to lead level 1 analyst's in all aspects of that predefined role.
- Ability to train the level 1 analysts in report writing tools and how to analyse the users' requirements.
- Highly competent in the use of MS Office suite/Outlook or ECDL.
- Ability to influence people at all levels of the business.
- Demonstrable desire of ability to learn.
Desirable
- Advanced problem solving through known methodologies.
Other
Essential
- Motivated and enthusiastic
- Able to initiate and support change within the department
- Committed to on-going personal development Adaptable & flexible person
- Dedicated to providing a quality service and assign value
- Ability to work on own initiative
- Ability to remain focused under pressure
- Confident individual person and a team player
- Able to keep to procedures and attention to detail
- Able to resolve problems through effective liaison with staff, patients and suppliers
- Assertive with good interpersonal skills
- Able to communicate at all levels both within the trust and externally
- The post holder will be required to work shifts, between 08:00 - 17:00 on a shift pattern.
- Sufficient to perform the duties of the post with any aids and adaptations
Person Specification
Qualifications
Essential
- Bachelor's degree and extensive working experience within a customer facing/business environment.
- ECDL or Equivalent
Desirable
- Oracle Core Financial Courses.
Experience
Essential
- Highly competent in one or more of the Oracle financial reporting tools -BI/XML/Qlik Sense
- Highly experienced in call to ticket resolution utilising a help-desk escalation platform.
- Experience of working under pressure to strict deadlines and prioritising workload
- Extensive knowledge in Oracle 12.2.9 + functional system administration or 6+ years' experience of the same
Desirable
- Experienced or qualified in management/financial accounting theories. AAT/ACCA/CIMA, any stage a plus.
- Highly competent in one or more of the Oracle financial reporting tools -BI/XML/Qlik Sense
Knowledge
Essential
- Extensive knowledge in Oracle 12.2.9 + functional system administration or experience of the same
- Knowledge of Helpdesk Procedures
Skills
Essential
- Outstanding organisational skills, in particular communicating and monitoring key issues through full life cycle.
- Outstanding communication skills and the ability to do so at all levels.
- Working in a highly pressured environment and the ability to prioritise in such.
- Highly competent analytical skills with the ability to identify and resolve a range of problems, e.g. Oracle system errors, bugs, etc.
- Delivery of Oracle functional 12.2.9+ training to all levels.
- Ability to lead level 1 analyst's in all aspects of that predefined role.
- Ability to train the level 1 analysts in report writing tools and how to analyse the users' requirements.
- Highly competent in the use of MS Office suite/Outlook or ECDL.
- Ability to influence people at all levels of the business.
- Demonstrable desire of ability to learn.
Desirable
- Advanced problem solving through known methodologies.
Other
Essential
- Motivated and enthusiastic
- Able to initiate and support change within the department
- Committed to on-going personal development Adaptable & flexible person
- Dedicated to providing a quality service and assign value
- Ability to work on own initiative
- Ability to remain focused under pressure
- Confident individual person and a team player
- Able to keep to procedures and attention to detail
- Able to resolve problems through effective liaison with staff, patients and suppliers
- Assertive with good interpersonal skills
- Able to communicate at all levels both within the trust and externally
- The post holder will be required to work shifts, between 08:00 - 17:00 on a shift pattern.
- Sufficient to perform the duties of the post with any aids and adaptations
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
UK Registration
Applicants must have current UK professional registration. For further information please see
NHS Careers website (opens in a new window).
Additional information
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
UK Registration
Applicants must have current UK professional registration. For further information please see
NHS Careers website (opens in a new window).
