Oracle Fusion Reporting Consultant

Job Title: Oracle Fusion Reporting Consultant (BIP, OTBI, OAC, FAW)
REMOTE
Tax Term: 1099

Additional Notes:
This is part of a large-scale Oracle Fusion transformation program (2+ years).
Initial engagement will align to Discovery phase with strong potential for long-term extension.
This role will focus on enterprise reporting, analytics, and dashboarding across Oracle Fusion.
Strong collaboration required across functional, integration, and offshore teams.
This is part of an ongoing enterprise transformation initiative.
Job description:
The Opportunity: Oracle Fusion Reporting Consultant
We’re seeking an experienced Reporting Consultant to design, build, and support enterprise reporting and analytics solutions across Oracle Fusion. This individual will work closely with business and technical teams to deliver high-quality reporting, dashboards, and data insights.
Key Responsibilities
Lead reporting workshops to gather business and functional requirements
Design and develop reporting solutions using BI Publisher (BIP), OTBI, Oracle Analytics Cloud (OAC), and FAW
Build operational and statutory reports using BI Publisher with complex SQL and templates
Develop OTBI dashboards and real-time reporting solutions
Design analytical dashboards and semantic models in OAC
Leverage ADW and ODI for data modeling, pipelines, and performance optimization
Implement and extend Fusion Analytics Warehouse (FAW) for enterprise analytics
Ensure data security, governance, and role-based access across reporting solutions
Support testing (SIT/UAT), reconciliation, and reporting validation
Support cutover, go-live, and hyper care reporting activities
Qualifications
10–15+ years of reporting and analytics experience with 7+ years in Oracle Fusion
Strong hands-on experience with BIP, OTBI, OAC, and Fusion reporting tools
Experience with ADW, ODI, and enterprise data integration tools
Strong SQL skills with experience in complex reporting logic and performance tuning
Experience implementing and extending Fusion Analytics Warehouse (FAW)
Strong understanding of data models, subject areas, and reporting architecture
Experience with REST APIs, FBDI, and reporting data integrations
Strong knowledge of data security and reporting governance
Excellent communication and stakeholder management skills
Oracle Analytics Cloud certification preferred