Oracle Business Intelligence Consultant

Job Title: Oracle Fusion Reporting Lead

Job Type: Permanent

Location: Nottingham

Salary: £80,000 – £90,000 + benefits

We have an exciting role for youas an Oracle Fusion Reporting Lead for one of the worlds biggest and best consultancy’s!

One of our best clients is growing again! They are a purpose-led transformation company, built on belief. “We do not just help businesses to transform through technology. We support them in making a meaningful difference to the people and communities they serve – our clients include some of the biggest brands in the UK and worldwide.” For you, it means more to make an impact that matters, through challenging projects which demand ambitious innovation and thought leadership.

• Gain access to endless learning opportunities.
• Lead a team and their technical growth.
• Collaborate with customers and stakeholders.

The Role

As an Oracle Fusion Reporting Lead, you will be responsible for creating, managing and optimising reporting solutions and analytics tools within the Oracle Cloud ecosystem.

Key Responsibilities:

• Design, develop OTBI reports and dashboards to meet business requirements.
• Leverage OTBI subject areas to create ad hoc queries, analyses and dashboards.
• Ensure data accuracy and relevancy in OTBI Outputs.
• Create and maintain BI Publisher reports using XML, RTF templates, and SQL queries.
• Maintain clear documentation for all reports, dashboards and BI processes.
• Develop pixel-perfect reports and format outputs for printing or distribution.
• Optimize report performance and troubleshoot issues.
• Analyze business requirements and translate them into data models or reporting solutions.
• Collaborate with functional teams to understand key performance indicators (KPIs) and reporting needs.
• Integrate OTBI and BI Publisher with Oracle Fusion SaaS modules (e.g., HCM, ERP, SCM).
• Work with Oracle Data Models and subject areas specific to Oracle SaaS applications.
• Optimise SQL queries and report designs for performance.

Your Profile

Key skills/knowledge/experience:

• Expertise in Oracle OTBI and BI Publisher.
• Strong SQL and PL/SQL skills.
• Familiarity with Oracle Fusion SaaS modules (e.g., HCM, ERP, SCM)/
• Experience in data modelling, subject areas and schema design.

Desirable skills/knowledge/experience:

• Strong analytical and problem-solving skills.
• Effective communication and collaboration with cross-functional teams.
• Ability to understand and translate business requirements into technical solutions.