Senior Functional Analyst (Essbase) at Old Mutual

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, Gaps 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

• 04 December 2025