Senior Oracle EPM Systems Analyst

SystemsAccountants Inc.; Illinois; On-site; USD 110,000 - 140,000; Full time

Job summary

SystemsAccountants Inc. seeks a Senior Oracle EPM Systems Analyst to design and optimize Oracle PBCS/PCMCS solutions, implement Groovy scripting, Essbase calculations, and business rules, while aligning planning models with financial processes.

You will partner with Finance, FP&A, Accounting and IT to translate requirements into scalable technical solutions, improve planning workflows, and ensure data integrity across EPM environments.

Qualifications

• 5+ years of experience with Oracle EPM applications, especially PBCS/Planning and PCMCS.
• Strong Groovy scripting, Essbase calc scripts, and business rules development.
• Solid understanding of income statements, balance sheets, cash flow statements, and financial drivers.

Responsibilities

• Develop, maintain, and enhance Oracle PBCS and PCMCS apps, including models, rules, calculations, forms, dimensions, and configs.
• Develop Groovy scripts, Essbase calc scripts, and business rules to automate planning processes and calculations.
• Support budgeting, forecasting, long-range planning and scenario modeling.
• Translate finance requirements into effective EPM solutions; optimize planning models.
• Support profitability and cost management apps, including allocation logic and reporting.
• Manage day-to-day application support; troubleshoot issues; optimize performance and data integrity.
• Maintain data loads, integrations, and mappings between EPM and source systems.
• Collaborate with Finance, FP&A, Accounting and IT to gather requirements.
• Identify opportunities to automate manual processes and improve planning workflows.
• Develop and execute testing for enhancements and validate calculations and outputs.

Skills

Groovy scripting

Essbase calculation

Oracle EPM

PBCS/Planning

PCMCS

Financial modeling

Data integrations

FP&A

Stakeholder communication

Tools

Oracle EPM suite

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.