Oracle EPM Cloud Expert

Stefanini Group•Chicago, IL

1d•Hybrid

About The Position

Stefanini Group is hiring an Oracle EPM Cloud Expert for a hybrid role. The position requires strong functional and technical expertise in Oracle Planning (EPBCS), with deep knowledge of ASO and BSO architectures, calculation and Groovy scripting, batch processing, troubleshooting, and data reconciliation. The role involves designing, developing, and supporting Oracle EPM Planning, optimizing Essbase cubes, and collaborating with finance, IT, and business stakeholders. The candidate will participate in Agile SDLC activities and ensure compliance with SOX controls and documentation standards.

Requirements

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)
Advanced expertise in: Calculation scripts
Groovy scripting
Performance tuning and optimization
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)
Strong understanding of SDLC (Agile) methodologies
Experience with Change Management processes
Knowledge of SOX compliance, controls, and audit support
Excellent communication and stakeholder management skills
Ability to work independently in a staff augmentation model

Responsibilities

Design, develop, and support Oracle EPM Planning (EPBCS).
Demonstrate deep expertise in Essbase ASO and BSO concepts, including performance optimization.
Develop and maintain business rules, calculations, and Groovy scripts.
Create, execute, and troubleshoot Windows batch scripts for EPM automation processes.
Monitor, execute, and troubleshoot batch jobs and integrations.
Analyze and resolve data discrepancies across EPM, source systems, and downstream reporting.
Perform data reconciliation between Oracle EPM, Snowflake, SAP, and other upstream/downstream systems.
Write and troubleshoot Snowflake SQL queries to support data validation and issue resolution.
Collaborate with SAP teams and leverage knowledge of SAP Central Finance (CFIN) to troubleshoot integration and data flow issues.
Participate in Agile SDLC activities, including sprint planning, stand-ups, reviews, and retrospectives.
Support change management, deployments, and production releases.
Ensure compliance with SOX controls, documentation standards, and audit requirements.
Work closely with finance, IT, and business stakeholders to resolve issues and improve system reliability.