Job Description
Key Responsibilities
Develop interactive dashboards and reports using OAC Data Visualization DV
Integrate OAC with Oracle EPM Cloud PBCS EPBCS Planning etc
Configure connections between OAC and EPM Essbase REST API Data Management
Design and implement data models datasets and data flows in OAC
Work with Finance and Business teams to gather reporting requirements
Develop calculated measures hierarchies Gen1Gen4 and custom KPIs
Implement rowlevel security and application roles
Optimize dashboard performance and Essbase query performance
Support environment migration DEV TEST PROD
Troubleshoot connectivity integration and performance issues
Required Skills
Strong experience in Oracle Analytics Cloud OAC DV
Handson experience with Oracle EPM Cloud modules Planning FCCS etc
Experience working with Essbase cubes
Strong SQL knowledge
Experience with Data Flows Data Sets and Data Blending in OAC
Experience in creating Pivot tables hierarchical columns and drilldown reports
Knowledge of REST API integration
Good understanding of Financial reporting and Planning processes
Preferred Skills
Experience with OBIEE OAC
Experience integrating OAC with Snowflake or other cloud data platforms
Knowledge of IDCS OCI security configuration
Experience in crosstenancy federation between OAC and EPM
Understanding of Financial Consolidation and Planning processes
This job is provided by Shine.com
