Position: Oracle EPM Cloud Expert
Location: Remote
Duration: 3+ Months
Must haves:
- Strong hands-on experience with Oracle EPM Planning (EPBCS)
- Deep expertise in Essbase (ASO + BSO cubes)
- Advanced SQL (Snowflake preferred)
- Experience with calculation scripts and Groovy scripting
- Proven ability to troubleshoot data issues and reconcile across systems
- Experience with EPM automation (EPM Automate, batch scripting)
Q&A:
Hands-On vs. Functional Ownership
How hands-on do you expect this resource to be in day-to-day development (e.g., Groovy scripting, calc scripts, debugging) versus providing functional or strategic support?
(SK- This role involves hands-on development work, including loading and reloading data in Oracle applications. It also includes validating data accuracy and supporting the business in performing reconciliation.)
Integration & Data Complexity
What are the most critical integrations this role will support (e.g., Snowflake, SAP CFIN), and how complex are the current data reconciliation challenges?
(SK Integrations are from Snowflake; reconciliations are complex but mostly needs Advanced SQL knowledge to help with troubleshooting and reconciliation)
Top Priorities in First 30 Days
What are the immediate priorities this person will be expected to own (e.g., stabilizing batch jobs, resolving data discrepancies, supporting a planning cycle)?
(SK Executing batch jobs, master data updates, calculations updates whenever requirement and resolving data discrepancies)
Role Summary
We are seeking an experienced Oracle EPM Cloud Expert with strong functional and technical expertise in Oracle Planning (EPBCS). The ideal candidate will have deep knowledge of ASO and BSO architectures, strong calculation and Groovy scripting skills, and hands-on experience with batch processing, troubleshooting, and data reconciliation across multiple source systems.
Required Skills & Qualifications
Strong hands-on experience with:
- Oracle Planning (EPBCS)
- Essbase ASO & BSO
- EPM Automate Scripting
Advanced expertise in:
- Calculation scripts
- Groovy scripting
- Performance tuning and optimization
Technical & Integration Skills
- Proficiency in Windows batch scripting
- Experience executing and troubleshooting EPM batch processes
- Strong analytical and problem-solving skills for data discrepancies
- Solid knowledge of Snowflake SQL
- Experience working with SAP CFIN (integration and troubleshooting)