Russell Tobin's client, an American multinational food company, is hiring an Oracle EPM Developer in Chicago, IL
Apply Now!
Employment Type: Contract/Hybrid
Location: Chicago, IL 60601 (Hybrid)
Duration: 3+ months with possible extension
Pay range: $110/hr - $117/hr W2
Schedule: M-F 8:00 am-5:00 pm CST (onsite Tues-Thurs)
Job Description:
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.
Key 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.
Required Skills & Qualifications
Oracle EPM
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)
Process & Governance
- Strong understanding of Agile SDLC methodologies
- Experience with Change Management processes
- Knowledge of SOX compliance, controls, and audit support
Must-Have Qualifications
- Strong hands-on experience with Oracle EPM Planning (EPBCS)
- Deep expertise in Essbase (ASO and BSO cubes)
- Advanced SQL skills (Snowflake preferred)
- Experience with calculation scripts and Groovy scripting
- Proven ability to troubleshoot data issues and perform reconciliation across systems
- Experience with EPM automation (EPM Automate, batch scripting)
Soft Skills
- Strong analytical and troubleshooting mindset
- Excellent communication and stakeholder management skills
- Ability to work independently in a staff augmentation model
Benefits that Russell Tobin offers:
Russell Tobin and it's affiliates offers eligible employee's comprehensive healthcare coverage (medical, dental, and vision plans), supplemental coverage (accident insurance, critical illness insurance and hospital indemnity), 401(k)-retirement savings, life & disability insurance, an employee assistance program, legal support, auto, home insurance, pet insurance and employee discounts with preferred vendors.
Equal Employment Opportunity
Russell Tobin and it's affiliates are an equal opportunity employer. We do not discriminate on the basis of the race, religious creed, color, national origin, ancestry, physical disability, mental disability, reproductive health decision making, medical condition, genetic information, marital status, sex, gender, gender identity, gender expression, age, sexual orientation, veteran or military status, or any other characteristic protected by applicable federal, state, or local law.
Fair Chance Employment
Russell Tobin and it's affiliates are a Fair Chance employer. We consider all qualified applicants, including those with criminal histories, in a manner consistent with applicable state and local Fair Chance laws and ordinances, including, the California Fair Chance Act and all applicable local Fair Chance ordinances.
Accommodations
We are committed to providing reasonable accommodations to applicants and employees with disabilities. If you require a reasonable accommodation to participate in the application or interview process, or to perform the essential functions of this role, please contact us.
Only applicable for San Francisco Candidates Under the San Francisco Lactation in the Workplace Ordinance, we will provide written notice of lactation accommodation rights, and this notice will automatically be given upon hiring, any inquiry of parental leave or lactation accommodation.