Oracle EPM Planning - Hyperion Planning Essbase Developer

ATS Client; Sandton; On-site; ZAR 550,000 - 850,000; Full time

Job summary

Absa Bank Limited is seeking an experienced Oracle Hyperion/EPM Planning professional to design, develop, and support planning solutions that enable robust financial forecasting and reporting. You will bridge business requirements with technical implementation and drive scalable planning models.

The role covers application ownership, development of Essbase cubes, data integrations, and user training, with a focus on governance, security, and performance.

Qualifications

• 2-3 years' experience in Oracle Hyperion / Essbase / EPM Planning development.
• Exposure to financial planning, budgeting, or forecasting processes.
• Experience in end-to-end solution delivery and support.

Responsibilities

• Own the full application lifecycle (design, development, testing, deployment, and support).
• Translate business requirements into EPM Planning solutions and models.
• Drive continuous improvement and evolution of planning models.
• Develop Essbase cubes, outlines, hierarchies, and dimensions.
• Build and maintain business rules, calculation logic, and data forms.
• Optimise application performance (calculation efficiency, cube design).
• Design and maintain data integrations using Data Exchange / FDMEE.
• Enable automated data pipelines between source systems and EPM.
• Ensure data quality, reconciliation, and auditability.
• Maintain metadata, security models, and application configurations.
• Execute regular data loads and manage planning cycles.
• Support upgrades, patches, and environment maintenance.
• Provide ongoing support to Finance users.
• Troubleshoot system, data, and performance issues.
• Gather new requirements and improve user experience.
• Train end-users on planning processes and Smart View usage.
• Maintain technical and functional documentation.

Skills

Oracle EPM Planning

Essbase

Calculation Manager

Data Integration / FDMEE

SQL

Oracle Smart View

OCI / AWS

Groovy scripting

Education

BCom (Informatics) or BSc (Computer Science)

Relevant diploma or equivalent

Tools

FDMEE

Data Exchange

Job description

Empowering Africa's tomorrow, together...one story at a time. With over 100 years of rich history and strongly positioned as a local bank with regional and international expertise, a career with our family offers the opportunity to be part of this exciting growth journey, to reset our future and shape our destiny as a proudly African group.

Job Summary

The primary objective of this role is to design, develop, and support Oracle EPM Planning and Essbase applications to enable financial planning, forecasting, and reporting processes. The role bridges business requirements and technical implementation, ensuring scalable, high-performing, and well-governed planning solutions.

Job Description

1. Application Ownership & Delivery

• Own the full application lifecycle (design, development, testing, deployment, and support)
• Translate business requirements into EPM Planning solutions and models
• Drive continuous improvement and evolution of planning models

2. Application Development

• Develop Essbase cubes, outlines, hierarchies, and dimensions
• Build and maintain business rules, calculation logic, and data forms
• Optimise application performance (calculation efficiency, cube design)

3. Data Integration & Automation

• Design and maintain data integrations using Data Exchange / FDMEE
• Enable automated data pipelines between source systems and EPM
• Ensure data quality, reconciliation, and auditability

4. Application Administration

• Maintain metadata, security models, and application configurations
• Execute regular data loads and manage planning cycles
• Support upgrades, patches, and environment maintenance

5. Application Support & Stakeholder Engagement

• Provide ongoing support to Finance users
• Troubleshoot system, data, and performance issues
• Gather new requirements and improve user experience

6. Training & Documentation

• Train end-users on planning processes and Smart View usage
• Maintain technical and functional documentation

Technical Skills

• Oracle EPM Planning / Hyperion Planning (Cloud and on-prem)
• Essbase (cube design, calc scripts, MDX)
• Calculation Manager (business rules, Groovy scripting advantageous)
• Data integration tools (FDMEE / Data Exchange)
• SQL (PostgreSQL or MS SQL)
• Oracle Smart View (reporting and input templates)
• Cloud platforms:
  • OCI (user management, monitoring)
  • AWS (S3, Glue, RDS)

Experience Required

• 2-3 years' experience in Oracle Hyperion / Essbase / EPM Planning development
• Exposure to financial planning, budgeting, or forecasting processes
• Experience in end-to-end solution delivery and support

Education

• Preferred: BCom (Informatics) or BSc (Computer Science)
• Alternatively: Relevant diploma or equivalent qualification

Bachelor`s Degrees and Advanced Diplomas: Business, Commerce and Management Studies (Required)

Key Competencies

• Strong analytical and problem-solving capability
• Ability to translate functional requirements into technical solutions
• Effective stakeholder engagement and communication
• Attention to detail, governance, and control mindset

Equal Employment Opportunity Statement

Absa Bank Limited is an equal opportunity, affirmative action employer. In compliance with the Employment Equity Act 55 of 1998, preference will be given to suitable candidates from designated groups whose appointments will contribute towards achievement of equitable demographic representation of our workforce profile and add to the diversity of the Bank.

Absa Bank Limited reserves the right not to make an appointment to the post as advertised.