EPM OLAP Cube Administration Lead

hackajob is collaborating with J.P. Morgan to connect them with exceptional professionals for this role.

JOB DESCRIPTION

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 load requirements (data, metadata, dimensionality, lineage, and timing).

• Manage cube build, migration, and maintenance activities across environments, ensuring controlled deployments and robust validation.

• Collaborate with Finance stakeholders to coordinate submission calendars and validation checkpoints, translating business requirements into stable, automated Essbase operations.

• Produce and maintain runbooks and operational documentation, and drive measurable improvements in reliability and cycle-time. 

  Contribute to data modeling efforts and support the design and development of upstream datamarts and database views that source Essbase cube loads, ensuring alignment to Finance dimensionality, reconciliation needs, and reporting requirements.

Required Qualifications, Capabilities and Skills

• Minimum education and experience required: Bachelor's degree in Software Engineering , Computer Science , Computer Information Systems , or related field of study plus 7 years of experience in the job offered or as an Essbase Administrator , OLAP Technical Lead , Business Intelligence Lead , Senior Application Analyst , Solution Architect , Technical Lead , or related occupation.

• Minimum of 7 years of hands-on experience administering Oracle Hyperion Essbase (on-premise) in a production environment with responsibility for stability, performance, and operational execution.

• Advanced proficiency with MaXL scripting , including automation of loads, refreshes, security administration, deployments, and routine operational tasks.

• Advanced proficiency with Essbase calc scripts , Report scripts, MDX scripts including design, optimization, and ongoing maintenance in large-scale BSO/ASO cubes.

• Demonstrated expertise developing and troubleshooting load rules and designing automated data and metadata load workflows with strong control and auditability.

• Deep experience with BSO/ASO cube design , outline management , and performance tuning , including aggregation strategy, memory and caching considerations, and calculation runtime optimization.

• Strong production operations discipline, including incident management, release and change controls, clear runbook documentation, and the ability to execute under tight close-cycle timelines.

Preferred Qualifications, Capabilities and Skills

• Familiarity with Finance planning, budgeting, and reporting cycles, including month-end and quarter-end execution rhythms and stakeholder expectations.

• Experience with automation and integration tooling commonly used alongside on-prem Essbase (for example: scheduling frameworks, scripting, and database procedures) to reduce manual intervention and improve repeatability.

• Prior experience supporting FP&A teams within a large financial institution, including consumer banking lines of business and management reporting requirements.

• Experience with dimensional and data modeling and datamart and views design and development used for OLAP cube sourcing and downstream reporting.

• Familiarity with data lake and lakehouse concepts and tooling (including Databricks) and understanding of ingestion, transformation, and serving patterns (for example: bronze, silver, gold) as they relate to Finance CI/CD pipelines.

ABOUT US

Chase is a leading financial services firm, helping nearly half of America's households and small businesses achieve their financial goals through a broad range of financial products. Our mission is to create engaged, lifelong relationships and put our customers at the heart of everything we do. We also help small businesses, nonprofits and cities grow, delivering solutions to solve all their financial needs. 

We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process. 

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.

Equal Opportunity Employer/Disability/Veterans

ABOUT THE TEAM

Our Consumer & Community Banking division serves our Chase customers through a range of financial services, including personal banking, credit cards, mortgages, auto financing, investment advice, small business loans and payment processing. We're proud to lead the U.S. in credit card sales and deposit growth and have the most-used digital solutions - all while ranking first in customer satisfaction.

The CCB Data & Analytics team responsibly leverages data across Chase to build competitive advantages for the businesses while providing value and protection for customers. The team encompasses a variety of disciplines from data governance and strategy to reporting, data science and machine learning. We have a strong partnership with Technology, which provides cutting edge data and analytics infrastructure. The team powers Chase with insights to create the best customer and business outcomes.