EPM OLAP Cube Administration Lead

Build the platforms that keep finance moving-especially when timelines are tight and accuracy matters most.

In this role, you will lead hands-on modernization and operational excellence for Oracle Hyperion Essbase 21c (on-premise), reducing manual effort through automation and strengthening the stability and performance of critical close and forecasting cycles.

You will collaborate with Finance and technology partners to deliver outcomes that are reliable, auditable, and repeatable, while helping shape how the team scales cube operations for the future.

As an EPM OLAP Cube Administration Lead at JPMorganChase within the Finance Platform & Modernization Team, you will own day-to-day administration of Oracle Hyperion Essbase 21c (on-premise) BSO/ASO cubes, including MaXL automation, calculation scripts, load rules, security, performance tuning, and controlled deployments.

You will serve as the primary technical point of contact for production health, data and metadata movements, and cube processing, partnering with Finance stakeholders, management information systems teams, and technology partners to deliver reliable, auditable, and repeatable outcomes across critical close and forecast cycles.

Job Responsibilities


* Own day-to-day on-premise Essbase cube administration and operations, including cube availability, processing, batch execution, and production readiness during close and forecast cycles.


* Develop, maintain, and standardize MaXL scripts to automate cube operations, security provisioning, data/metadata loads, refresh activities, and controlled maintenance routines.


* Build and maintain Essbase calc scripts to support allocations, currency translation, aggregation strategies, and performance-optimized calculation frameworks aligned to Finance reporting requirements.


* Design, maintain, and troubleshoot Essbase load rules and associated data/metadata load routines to ensure accurate, auditable, and repeatable processing outcomes.

Administer BSO/ASO outline management (dimensions, hierarchies, attributes, UDAs), including controlled hierarchy changes, impact assessment, and reconciliation support for reporting hierarchies.


* Manage Essbase security administration and access controls, partnering with governance stakeholders to enforce least-privilege and ensure timely provisioning and deprovisioning aligned to policy.


* Lead production incident triage and problem management for Essbase processing failures, performance degradation, and data/metadata issues, driving root-cause remediation and preventive controls.


* Partner with database administrators, server administrators, and internal technology teams to resolve infrastructure, connectivity, and performance issues impacting cube execution.

Partner with data engineering and architecture teams working on data lake and lakehouse platforms (including Databricks) to ensure governed ingestion, transformation, and serving layers align with Essbase l...