Oracle EPM Cloud Consultant

Spencer Thomas Group (STG) is currently looking to add to our team of consultants under our Oracle practice.

• 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.
• 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.

Oracle EPM

• EPM Automate Scripting

• Calculation scripts
• 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)
• Process & Governance
• Strong understanding of SDLC (Agile) methodologies
• Experience with Change Management processes
• Knowledge of SOX compliance, controls, and audit support

This is a project‑based consulting opportunity with an initial 3‑month duration, with the possibility of extending.

Full time, onsite in Chicago, IL Tues‑Thu and remote Mondays and Fridays

8am‑5pm CST