Remote Oracle Fusion Analytics & Reporting Consultant

Ampcus, Inc

New York (NY)

On-site

USD 140,000 - 190,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Ampcus Inc. is seeking an experienced Oracle Fusion Reporting Consultant to lead reporting workshops and deliver enterprise analytics using BIP, OTBI, OAC, FAW, and ADW. Remote-friendly in New York, NY with strong governance and security requirements.

Ideal candidates have 10-15 years of reporting experience, including 7 years in Oracle Fusion Cloud reporting, and are proficient with ODI, REST APIs, and FBDI. Excellent communication and stakeholder management are essential.

Qualifications

Bachelor's degree in Computer Science, Information Systems, Finance, Accounting, Engineering, or related discipline.
10-15 years of overall reporting and analytics experience with 7 years in Oracle Fusion Cloud reporting and analytics.
Strong hands-on experience with BI Publisher (BIP), OTBI, Oracle Analytics Cloud (OAC), and Fusion transactional reporting.
Experience designing enterprise analytics solutions using ADW and ODI (or equivalent data integration tools).
Strong understanding of Fusion data models, subject areas, and transactional-to-analytical data flows.
Hands-on experience with SQL, performance tuning, joins, and complex reporting logic.
Experience implementing and extending Fusion Analytics Warehouse (FAW).
Familiarity with Financials, SCM, or HCM business processes to translate requirements into reporting solutions.
Experience with integrations using REST APIs, FBDI, and reporting data extracts.
Strong understanding of data security, role-based access control, and reporting governance.
Excellent communication, documentation, and stakeholder management skills.
Experience supporting multi-ledger, multi-currency, and multi-region Oracle Fusion environments.

Responsibilities

Lead reporting and analytics workshops to understand business and functional reporting requirements across Oracle Fusion Financials, and EPM modules.
Analyze current-state reporting solutions and design future-state enterprise reporting architecture aligned with Oracle Fusion Cloud and Analytics best practices.
Design, develop, and support reporting solutions using BI Publisher (BIP), OTBI, Oracle Analytics Cloud (OAC), and Fusion Analytics Warehouse (FAW).
Develop pixel-perfect operational and statutory reports using BI Publisher with complex SQL, RTF/EText templates, bursting, and scheduling.
Create and optimize OTBI subject area-based real-time reports and dashboards, including security-aware reporting.
Design analytical dashboards and semantic models in Oracle Analytics Cloud (OAC) for cross-functional and executive reporting.
Leverage Autonomous Data Warehouse (ADW) as a reporting and analytics platform, supporting data modeling and performance optimization.
Design and maintain data pipelines and transformations using ODI or equivalent ELT/ETL tools for analytics use cases.
Implement and customize FAW, including KPI definitions, extensions, and validation of prebuilt dashboards.
Collaborate with functional consultants and integration teams to source data from Fusion transactional tables, REST APIs, FBDI outputs, and upstream systems.
Develop and maintain reporting design documents, data models, KPI definitions, and technical specifications.
Ensure role-based access controls, data security, and compliance in all reporting solutions.
Support reporting data validation, reconciliation, and audit requirements across financial and operational reports.
Create and execute test scenarios for SIT, UAT, regression testing, and performance testing of reporting solutions.
Provide reporting support during cutover, go-live, post-go-live stabilization, and hypercare phases.
Support quarterly Oracle Cloud updates by assessing impact on OTBI, BIP, FAW, and OAC artifacts.