Senior Oracle EPM Systems Analyst (Greater Chicago Area)

We are seeking a Senior Oracle EPM Systems Analyst with strong hands-on experience across Oracle Planning and Budgeting Cloud Service (PBCS) and Profitability and Cost Management Cloud Service (PCMCS). This role combines Oracle EPM application development, systems support, and financial planning expertise, requiring an individual who can develop and enhance planning applications while understanding the underlying financial processes they support.

The successful candidate will bring a strong technical background in Oracle EPM, including Groovy scripting, Essbase calculation scripts, and business rule development, alongside a solid understanding of financial statements, cash flow forecasting, budgeting, and financial modeling.

Working closely with Finance, FP&A, Accounting, and IT stakeholders, this individual will translate complex business requirements into effective technical solutions, optimize planning models, and drive continuous improvements across the organization's EPM environment.

Responsibilities

• Develop, maintain, and enhance Oracle PBCS and PCMCS applications, including planning models, business rules, calculation scripts, forms, dimensions, and application configurations.
• Develop and maintain Groovy scripts, Essbase calculation scripts, and business rules to automate planning processes, streamline workflows, and support complex financial calculations.
• Support budgeting, forecasting, long-range planning, and scenario modeling processes, ensuring applications align with business requirements and financial planning objectives.
• Apply a strong understanding of income statements, balance sheets, cash flow statements, and financial drivers to develop and maintain accurate financial planning models.
• Support and enhance profitability and cost management applications, including allocation logic, cost modeling, profitability analysis, and financial performance reporting.
• Manage day-to-day application support, troubleshoot technical issues, optimize system performance, and ensure the reliability and integrity of planning applications.
• Maintain and troubleshoot data loads, integrations, and mappings between Oracle EPM and source systems, ensuring the accuracy and integrity of financial data.
• Partner with Finance, FP&A, Accounting, and IT stakeholders to gather business requirements and translate financial processes into effective technical solutions.
• Identify opportunities to automate manual processes, enhance calculation logic, improve planning workflows, and increase the efficiency of financial planning activities.
• Develop and execute testing for application enhancements, validate calculation logic and financial outputs, support deployments, and document technical solutions and system processes.

Required Qualifications

• 5+ years of experience working with Oracle EPM applications, with strong hands-on expertise in PBCS/Planning.
• Experience supporting and enhancing Oracle Profitability and Cost Management Cloud Service (PCMCS).
• Demonstrated development experience with Groovy scripting, Essbase calculation scripts, and Oracle EPM business rules.
• Strong understanding of Essbase calculation logic, planning dimensions, metadata, forms, and application architecture.
• Experience developing, debugging, and optimizing scripts and calculations to support complex planning and financial modeling requirements.
• Strong finance or FP&A background, with a working knowledge of financial statements, including income statements, balance sheets, and cash flow statements.
• Understanding of budgeting, forecasting, financial planning, and scenario analysis.
• Experience with data integrations, data loads, mappings, and financial data reconciliation.
• Ability to translate finance and business requirements into technical specifications and effective EPM solutions.
• Strong analytical, troubleshooting, and stakeholder communication skills.