Oracle Fusion Reports Analyst

Description

The Oracle Fusion Reporting Analyst is responsible for designing, developing, and maintaining reports and dashboards using Oracle Fusion reporting tools. This individual will work closely with business stakeholders to understand requirements, analyse data and select appropriate reporting tool. The role requires proficiency in Oracle Fusion reporting tools like BI Publisher, OTBI, Oracle Smart View, and FRS, to develop comprehensive reporting.

- Hybrid working in the Birmingham area (1-2 days on site but flexible)

- £550 p/d Inside IR35 (Through Umbrella)

Key Responsibilities

Design and develop reports & dashboards using Oracle Reporting tools such as BI Publisher, OTBI (Oracle Transactional Business Intelligence), FRS (Financial Reporting Studio), Smart View

Build complex data models and data extracts to meet business requirements, ensuring high performance and data integrity.

Create dashboards and interactive visualisations for users to analyse real-time data.

Work closely with stakeholders to gather and analyse reporting requirements, including purpose and performance.

Provide support and training to business users and in house reporting team.

Document report specifications, data sources, and business logic to ensure long-term maintainability and scalability.

Coach/Train junior members of team for Financial reporting.

Maintain and update existing reports, based business requirements.

Ensure adherence to data governance policies and best practices for data security and compliance.

Technical Expertise

Proficiency in Oracle Fusion Cloud applications modules: HCM, Finance, Procurement and Projects (Application and Database tables)

In-depth knowledge of Oracle reporting tools: BI Publisher, OTBI, FRS and Oracle Smart View.

Expertise with SQL, PL/SQL, and database structures for creating data models and queries.

Expertise with performance tuning the report queries.

Good understanding of security model on Fusion Application and Reports.

Proficiency in MS Office toolset specially Word and Excel to make report template as well as perform additional modifications to report outputs e.g. Pivot, vlookups, formula

Excellent communication skills, with the ability to work closely with non-technical business users to understand and translate requirements.

Ability to explain technical details to both technical and non-technical stakeholders.

High level of accuracy and attention to detail in reporting to ensure data integrity and report reliability.

Strong organisational skills with the ability to manage multiple tasks and deadlines.

Experience

Minimum 3-5 years of experience in report writing with Oracle Fusion reporting tools.

Hands-on experience with BI Publisher, OTBI, FRS and Oracle Smart View.

Proven experience in SQL, database querying, and building data models

Experience working in cross-functional teams and communicating with business and IT stakeholders

Prior experience in creating reports & dashboard for Fusion Cloud Applications must have.

Proven experience in Oracle Fusion Modules (Fusion + EBS R12): HCM, Finance, Procurement and Projects.

What you need to do now

If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.

If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion about your career.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at (url removed)

Ad ID: 5417117204