Senior Oracle EPM Systems Analyst

SystemsAccountants Inc.; Chicago (IL); On-site; USD 120,000 - 165,000; Full time

Job summary

SystemsAccountants Inc. is seeking a Senior Oracle EPM Systems Analyst to lead development and support for Oracle PBCS and PCMCS, combining financial planning expertise with hands-on technical work.

You will implement planning models, business rules, and calculation scripts while collaborating with Finance, IT, and FP&A stakeholders to optimize the EPM environment.

Qualifications

• 5+ years of experience with Oracle EPM, including PBCS/Planning.
• Experience with PCMCS.
• Experience developing Groovy scripts, Essbase calculations, and business rules.
• Strong understanding of Essbase calculation logic and planning dimensions.
• Experience with data integrations and financial data reconciliation.
• Ability to translate finance requirements into technical specifications.
• Strong analytical and stakeholder communication skills.

Responsibilities

• Develop and maintain Oracle PBCS and PCMCS applications and configurations.
• Develop Groovy scripts and Essbase calculations to automate planning processes.
• Support budgeting, forecasting, and scenario modeling.
• Translate financial processes into effective technical EPM solutions.
• Manage data loads and mappings between EPM and source systems.

Skills

Oracle EPM

PBCS/Planning

PCMCS

Groovy scripting

Essbase calculations

Business rules

Financial planning

Data integration

Stakeholder communication

Job description

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.