Senior Functional Analyst (Essbase)

Old Mutual; Wes-Kaap; On-site; ZAR 300 000 - 400 000; Full time

Job summary

A leading financial services provider in South Africa is looking for a Senior Function Analyst. The ideal candidate should have strong finance knowledge and a capability to integrate technology to achieve business results. Responsibilities include solution design, business process analysis, and client support. Requires a Bachelor's degree in IT and at least 5 years of experience with Hyperion Planning and SQL development. Join us in driving client success through innovative solutions.

Qualifications

• Minimum of 5 years in IT environment with focus on financial application development.
• 5 years of hands-on experience with Hyperion Planning and Essbase development.
• 5 years of experience in SQL development and data integration.

Responsibilities

• Design, configuration, testing, and implementation of application modules.
• Analyse current business processes and recommend solutions.
• Provide functional expertise and training to clients.

Skills

Problem-Solving Skills

Communication Skills

Time Management

Adaptive Thinking

Analytics Software

Application Development

Education

Bachelor's Degree in IT, IS or related field

NQF Level 7 - Degree, Advance Diploma or Postgraduate Certificate

Tools

Hyperion Planning

Essbase

SQL

Java JDK

WebLogic Server

Job description

Let's Write Africa's Story Together!

Old Mutual is a firm believer in the African opportunity and our diverse talent reflects this.

Job Description

Senior Function Analyst with strong finance knowledge, and solution expertise to effectively integrate technology into the client’s business environment to achieve client expected business results. The incumbent is individually accountable for achieving results through own efforts.

• Solution Design & Implementation - Facilitate the design, configuration, testing, and implementation of application modules to enhance business functionality and performance.

• Business Process Analysis & Optimization - Analyse current business processes and recommend or develop solutions aligned with client needs and industry best practices.

• Client Engagement & Support - Provide functional expertise, guidance, and training to clients during solution implementation and upgrades, ensuring high customer satisfaction.

• Application Maintenance & Upgrades - Manage application versioning, vendor upgrades, and ensure relevance and stability of the system environment.

• Leadership & Collaboration - Lead complex assignments, develop procedures, and guide teams through planning and execution phases.

• Knowledge Management & Training - Create user-friendly documentation, interpret technical manuals, and deliver training across all usage modes of systems and services.

• Data Management & Reporting - Understand the application and database environment to perform data extracts, queries, and support reporting needs

Experience, Skills and Qualifications

• Bachelor's Degree in IT, IS or related field

• Experience: Minimum of 5 in IT environment, with a focus on financial application development; understanding key integration points between business knowledge & process design skills is essential

• Technical Knowledge: 5 years of hands‑on experience with Hyperion Planning, Essbase development (including scripting), and the broader Oracle EPM suite. Proven capability in designing, implementing, and supporting enterprise performance management solutions. (Non‑negotiable)

• 5 years of experience in SQL development and data integration, with strong proficiency in managing complex data environments, optimizing queries, and ensuring seamless data flow across systems.

• Problem‑Solving Skills: Ability to analyse complex issues and drive effective solutions.

• Communication Skills: Excellent written and verbal communication, with the ability to convey technical information to non‑technical stakeholders.

• Time Management: Strong organizational skills and ability to prioritize tasks in a fast‑paced environment.

Preferred Experience

• Experience working in financial services sectors, especially cost allocations and product fund accounting

• Previous experience in a similar Development Lead role within an Agile environment.

• Previous experience in the “Group Finance” function of a financial services company.

• Previous experience with “Oracle EPM SDLC ”.

Recommended Certifications

• Enterprise Performance Management Certifications | Oracle Cloud Certifications

Technology Stack

Core Skills

• Essbase Scripting – Advanced proficiency in developing and maintaining Essbase applications, including calculation scripts and automation.

• SQL Scripting – Strong expertise in writing and optimizing SQL queries for data extraction, transformation, and integration across complex environments.

• Java JDK

• Jython

Platform & Infrastructure

• WebLogic Server – Application server that runs EPM web‑based components.

• Java Runtime Environment (JRE) – Required to support EPM services and WebLogic operations.

• Oracle Database – Stores application modeling data and supports transactional operations.

• Essbase – Multidimensional OLAP engine used for metadata storage, complex calculations, and storing calculated data.

Oracle EPM Application Suite

• Essbase

• Planning and Profitability

• Financial Performance Management

• Financial Reporting

• Smart View for Office

• Data Management

• Analytics/Reporting apps

Skills

Adaptive Thinking, Analytics Software, Application Development, Business Intelligence (BI) Analysis, Computer Literacy, Database Reporting, Data Compilation, Data Controls, Data Modeling, Data Recovery, Evaluating Information, Gap Analysis, IT Architecture, Requirements Development, User Requirements Documentation

Competencies

Action Oriented Business Insight Cultivates Innovation Customer Focus Manages Complexity Optimizes Work Processes

Education

NQF Level 7 - Degree, Advance Diploma or Postgraduate Certificate or equivalent

Closing Date

29 January 2026 , 23:59

The appointment will be made from the designated group in line with the Employment Equity Plan of Old Mutual South Africa and the specific business unit in question.

The Old Mutual Story!