Oracle Reporting Analyst

What if you could work with remarkable people on extraordinary things? What if the end result was something a little bit special? What if your role was mission critical?

For nearly 70 years, AWE has been at the forefront of nuclear weapons research and development. We have a critical mission: to provide the warheads for the UK’s ultimate deterrent – Trident. We also use our unique skills to provide wider UK government with counter-terrorism and nuclear threat reduction solutions.

It takes a special sort of person to work at AWE. What if that person was you?

Information Services and Security have a vital role to play in a crucial national mission.  We’re here to enable the organisation to deliver through the use of technology.  As AWE transforms itself to meet the needs of the UK’s next-generation nuclear deterrent, we need to adapt to deliver data-driven decision making, flexible and future-proofed IT services, adaptable cyber security, support to a multi-billion Pound building programme, and many more. 

The scale might be daunting to some, but you’ll find it stimulating.  We’ve got a long journey that we’ve only just started and we’re looking for motivated people who can take us in the right direction.  Your role will contribute directly to that shared mission.  We won’t deceive you, in some areas we’re starting from a low base, but within ten years this organisation will look very different, and you can help make that happen.  This is a role where you’ll contribute to a legacy of national security for decades to come.  So come and join us.

An experienced Oracle Fusion Reporting Analyst or Functional Consultant is required to provide day to day production support across the Oracle Fusion modules. 

In this role, you should be able to provide Functional, Technical and SQL knowledge focusing on Oracle Fusion Reporting.

AWE’s core ERP business system is Oracle Fusion utilising Financial Management, Projects, Procurement, EPM and Analytics.  We require an Analyst or Functional Consultant who is passionate about reporting who can clearly demonstrate how we can develop and exploit this capability to its full potential.

Within this role, you will be expected to support Oracle Fusion Reporting from within the IS function.

You will join a highly qualified and experienced team to help us deliver future changes and improvements always looking at ways to improve and exploit the capability on Oracle Fusion Reporting.

To be considered for the role, you will be an accomplished Oracle Fusion Reporting Analyst or Functional Consultant.

Location – Reading area

Package - £48,250 - £60,000 subject to skills and experience

As part of our People Promise, AWE (one of the best 25 big companies to work for in the UK) has a range of benefits to suit you. These include:

• Time to recharge your batteries with 270 hours of annual leave (plus every other Friday off work)
• Consideration for flexible working arrangements so that your work may fit in with your lifestyle. Just let us know on your application if you wish to work part time
• Opportunities for Professional Career Development that include funding for the annual membership of a relevant professional body, access to mentors and training
• Employee Assistance Programme and Occupational Health Services
• A generous defined contribution Group Personal Pension (we will pay between 9% and 13% of your pensionable pay depending on your own contribution)
• Life Assurance
• Discounts – access to savings on a wide range of everyday spending
• Special Leave Policy including paid time off for volunteering, public service (including reserve forces) and caring for your family
• A host of voluntary & core benefits to suit your health and wellbeing – more information available on our careers site

The Role:

• Understand from the business (working with Directors, Programme Managers, Resource Managers etc.) what information they require to deliver their requirements.
• Identify and interrogate source code within Oracle and other sources that will deliver raw data.
• Delivery of accurate information through appropriate mechanisms to senior management.
• Acts as the leading Oracle technical expert for BI capability.
• Provide practical assistance and expert advice in all aspects of business intelligence (“BI”) across AWE.
• Develop and deliver training to all areas of the Business in order to aid their understanding of the significance and limitations of reporting.
• Foster best practice within the business by creating and actively supporting a BI Community of Practice and providing guidance to users and information owners influencing their approach and requirements.
• Review, learn and improve BI processes, ensuring full integration with corporate business processes, enabling appropriate performance reporting and governance.
• Lead and manage cross-company virtual teams (including external subject matter experts) to deliver business requirements.
• Assessing safety and security implications of the information delivered through BI across the business and ensuring appropriate action is taken.
• Maintain and promote high personal standards in environment, safety, health, security and quality and be a great team player.

• Delivery of ongoing improvements to existing Oracle Fusion Reports inline with Oracle Fusion configuration across the modules.
• Develop training material, deliver training at all levels of the business.
• Establish Review, Learn and Improve (RLI) activities to increase the effectiveness of reporting processes and procedures against business requirements.
• Provide support to and mentor the role of embedded BI analysts in the business- giving a corporate view and expert advice to those analysts in the business.
• Provide proactive help to resolve problems or issues identified within existing delivered business reports.
• Acting as a corporate authority on the effective display of information through dashboards, scorecards and their components.
• The Company may require you to fulfil any other reasonable duties aligned to your position from time to time in line with business needs.

The Candidate:

• Degree level education or the equivalent experience is preferred.

• Good business knowledge of Oracle Fusion Reporting across different functional areas.
• Proven experience developing and building OTBI and BI Publisher reports within Oracle Fusion.
• Experience of using Fusion Analytics Warehouse and developing reports, preferred but not essential.
• Experience using Oracle EPM (EPBCS) would be helpful not essential.
• The successful candidate will have a track record of working in a similar role as an Oracle Reporting Analyst or Functional Consultant.
• Strong understanding of Oracle Fusion Reporting across different functional areas.
• Ability to communicate with stakeholders (internal and external) at all levels.
• Essential advanced SQL knowledge and ability to define, fix and change complex queries.
• Proactive identification of opportunities for developing and improving BI across the business.
• Ability to manage conflicting priorities while maintaining positive working relationships.
• Initiating improvements and driving change to achieve positive results for the business.
• Strong written, verbal and presentational skills.
• Experienced in working within a Change Management environment.
• Personal credibility.
• Good understanding of Data Protection Act requirements.

All Candidates must be willing and able to obtain and maintain the necessary security clearance for the role.

Please note that you must be a British Citizen to apply for a role with us.

Our ambition is to create workplaces where we recognise and celebrate differences, encourage diverse contributions and our employees feel able to be themselves at work. We strive to create a genuine culture of openness and inclusion and encourage diverse applicants. Any inclusion information you provide us will be used to encourage and support you through the application process and will be held only for this purpose in accordance with GDPR.