Oracle Fusion Reporting Consultant (BIP, OTBI, OAC, FAW)

Job Title: Oracle Fusion Reporting Consultant (BIP, OTBI, OAC, FAW)

Location: Remote (US)

Job Type: Contract

Overview:

This role supports enterprise reporting and analytics within clients large-scale Oracle Fusion transformation program. Initial engagement is aligned with the Discovery phase, with strong potential for extension. Consultants will deliver reporting, dashboards, and analytics solutions, collaborating across functional, integration, and offshore teams.

Responsibilities:

• Facilitate reporting workshops to capture business and functional requirements.
• Design and develop solutions using BI Publisher (BIP), OTBI, Oracle Analytics Cloud (OAC), and FAW.
• Build operational/statutory reports with complex SQL and templates.
• Develop OTBI dashboards and real-time reporting solutions.
• Create analytical dashboards and semantic models in OAC.
• Utilize ADW and ODI for data modeling, pipelines, and performance optimization.
• Implement and extend Fusion Analytics Warehouse (FAW).
• Ensure data security, governance, and role-based access.
• Support SIT/UAT testing, reconciliation, and reporting validation.
• Assist with cutover, go-live, and hypercare reporting activities.

Qualifications:

• 10-15+ years reporting/analytics experience, with 7+ years in Oracle Fusion.
• Strong expertise in BIP, OTBI, OAC, and Fusion reporting tools.
• Experience with ADW, ODI, and enterprise data integration.
• Advanced SQL skills for complex reporting and performance tuning.
• Proven experience with Fusion Analytics Warehouse (FAW).
• Strong knowledge of data models, subject areas, and reporting architecture.
• Familiarity with REST APIs, FBDI, and reporting integrations.
• Excellent communication and stakeholder management skills.
• Oracle Analytics Cloud certification preferred.