Oracle Report Writer (Oracle Fusion & OAC Reporting Tools)

Job Description

Report Writer (Oracle Fusion & OAC Reporting Tools)

Job Type: Contract
Day Rate: £300/day [Inside IR35]
Duration: 6 months
Work Location: London, United Kingdom

Note: Candidate should be immediately available.
SC cleared staff strongly preferred.

Please ensure the following criteria are met before sharing any profile:

1. Candidate should be keen to travel twice a week to the London office.
2. Rate: mentioned against Job description (inside IR35) - Please do not share any profiles above the range.
3. Consultant needs to be SC cleared and please share the following details while sharing profile:

Mandatory details:

1. SC certificate/Snapshot
2. Name:
3. Contact No:
4. Email Id:
5. Total Years of Experience:
6. Vendor Name:
7. Worked with BOE: Yes/No
8. If yes - Reason for leaving BOE:
9. SC Status: Active/Eligible/Lapse
10. SC Ref number:
11. UKSV Snapshot:
12. SC Issuing Authority:
13. SC last used:
14. SC Date of issue & Date of expiry:
15. Notice Period:
16. Willing to work in client location- 2 days onsite:
17. Email confirmation from candidate before client interview:
18. Visa:
19. Day Rate/Salary:
20. Current Location:
21. Current Company:
22. Open for Permanent/Contract:
23. Current offers/Interviews in pipeline:
24. Interview availability:
25. Holidays booked:

Role Profile: Report Writer (Oracle Fusion & OAC Reporting Tools)

Job Purpose:
The Report Writer (Oracle Fusion) is responsible for designing, developing, and maintaining reports and dashboards across all Oracle Fusion reporting tools. The individual will work closely with business stakeholders to understand reporting requirements, analyse data sources, and deliver actionable insights. The role requires proficiency in Oracle Fusion applications reporting tools like BI Publisher, OTBI, Oracle Smart View, and FRS, to develop comprehensive reporting solutions that support strategic business decisions. Requires good experience in Oracle Analytics Cloud (OAC) data modelling, dashboard, and report activities.

Key Responsibilities:

Report Development:
Design and develop reports & dashboards using Oracle Reporting tools such as BI Publisher, OTBI (Oracle Transactional Business Intelligence), FRS (Financial Reporting Studio), Smart View, and OAC (Oracle Analytics Cloud).
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.

Stakeholder Collaboration:
Work closely with business units to gather and analyse reporting requirements, ensuring a clear understanding of data needs, report specifications, and usability requirements.
Translate business needs into technical requirements and effective report designs.
Provide support and training to business users on reporting tools, dashboards, and data interpretation.

Data Analysis & Validation:
Perform data analysis and validation to ensure the accuracy and consistency of report outputs.
Troubleshoot data inconsistencies and discrepancies, working with IT and functional teams to resolve data quality issues.
Refine reports for better performance and usability.

Documentation & Maintenance:
Document report specifications, data sources, and business logic to ensure long-term maintainability and scalability.
Maintain and update existing reports based on evolving business requirements or Oracle Fusion updates.
Ensure adherence to data governance policies and best practices for data security and compliance.

Key Skills & Competencies:

Technical Expertise:
Proficiency in Oracle Fusion Cloud applications and modules landscape (Financials, Procurement, etc.)
In-depth knowledge of Oracle reporting tools: BI Publisher, OTBI, FRS, Oracle Smart View, Narrative Reporting and OAC.
Familiarity with SQL, PL/SQL, and database structures for creating data models and queries.
Good understanding of the security model on Fusion Application and OAC platform to ensure that reports are delivered in a secure manner.

Desirable: Knowledge of how to connect external reporting tools like Power BI and QlikSense with EPM data sources.
Knowledge of Narrative Reporting and how to leverage its capabilities to build rich narrative-driven reports.

Analytical Skills:
Strong analytical and problem-solving skills to identify reporting needs, data patterns, and business trends.
Ability to synthesise complex data into actionable insights and present them in a clear, understandable format.

Communication & Collaboration:
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.
Strong collaboration skills to work within cross-functional teams including IT, Finance, HR, and other departments.

Attention to Detail:
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.

Qualifications & Experience:

Education:
Bachelor's degree in Computer Science, Information Systems, Business, or related field.
Oracle Fusion certifications (not mandatory).

Experience:
Minimum 3-5 years of experience in report writing with Oracle Fusion Cloud and associated reporting tools.
Hands-on experience with BI Publisher, OTBI, FRS, Oracle Smart View and OAC.
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 & dashboards for Fusion Cloud Applications is essential.

Desirable Skills:
Experience in archive data reporting (not mandatory).
Familiarity with additional Oracle Fusion tools like HCM Extracts, Financial Analytics, and Oracle Data Visualization.
Experience with reporting tools outside Oracle Fusion (e.g., Power BI, Tableau) for comparative data visualization skills.
Knowledge of cloud computing and understanding of Oracle Autonomous Data Warehouse (ADW), Oracle Data Integrator (ODI) marketplace and Oracle Cloud Infrastructure (OCI) would be beneficial.
Good understanding of how data is extracted from Fusion Cloud to OAC using BICC Connectors.
Good understanding of EPM modules, particularly Financials, Workforce, and Projects.
Understanding of EPM dimensionality and how it can be enhanced through attributes and UDAs.