Hyperion Essbase & Integration Engineer

Ascendion Engineering; Hyderabad; Hybrid; INR 1,400,000 - 2,400,000; Full time

Job summary

Ascendion Engineering is seeking an Essbase specialist to enhance cube design, calculations, and reporting. You will build data integrations with FDMEE/Data Management or ODI and develop calc scripts and MaxL with strong SQL for validation.

You will collaborate with finance and IT teams, participate in on-call rotations, and support Hyperion Planning in conjunction with Essbase to ensure accurate financial reporting across platforms.

Qualifications

• 4–8 years of Essbase experience in enterprise finance/EPM
• Strong experience with calc scripts, MaxL, and business rules
• Hands-on experience with data integration tools such as FDMEE/Data Management or ODI
• Solid SQL skills for data validation and troubleshooting
• Experience supporting Hyperion Planning with Essbase
• Understanding of financial reporting concepts (consolidations, planning cycles)

Responsibilities

• Support and enhance Essbase cube design, calculation logic, and reporting structures
• Build and maintain data integrations between Hyperion Planning/Essbase and upstream/downstream systems (ERP, data warehouses, FDMEE/Data Management, ODI)
• Develop and maintain calc scripts, business rules, and MaxL scripts
• Troubleshoot data load failures, integration breaks, and reporting discrepancies
• Support enhancement requests tied to business/finance reporting needs
• Participate in an on-call rotation for production support
• Collaborate with infrastructure and finance teams to ensure end-to-end data accuracy

Skills

Essbase (BSO/ASO)

Calc Scripts

MaxL

Data Integration

SQL

Hyperion Planning

Financial Reporting concepts

Tools

FDMEE/Data Management

ODI

Job description

Location: US (remote) or India (Hyderabad)

Work hours: Aligned to EST/PST for US-based coverage; overlap hours required for India-based staff

Scope of Work

• Support and enhance Essbase cube design, calculation logic, and reporting structures
• Build and maintain data integrations between Hyperion Planning/Essbase and upstream/downstream systems (ERP, data warehouses, FDMEE/Data Management, ODI, etc.)
• Develop and maintain calc scripts, business rules, and MaxL scripts
• Troubleshoot data load failures, integration breaks, and reporting discrepancies
• Support enhancement requests tied to business/finance reporting needs
• Participate in an on-call rotation for production support
• Collaborate with infrastructure and finance business teams to ensure end-to-end data accuracy

Required Skillset

• 4–8 years working with Essbase (BSO and/or ASO) in an enterprise finance/EPM environment
• Strong experience with calc scripts, MaxL, and business rules
• Hands-on experience with data integration tools such as FDMEE/Data Management or ODI
• Solid SQL skills for data validation and troubleshooting
• Experience supporting Hyperion Planning in conjunction with Essbase
• Understanding of financial reporting concepts (consolidations, planning cycles, etc.)

Nice to Haves

• Oracle Cloud EPM (PBCS/EPBCS) exposure
• EPM Automate / scripting for automated integration jobs
• Experience integrating with ERP systems (SAP, Oracle EBS, etc.)
• Prior experience supporting eCommerce or fintech finance teams
• Experience with large-scale, high-transaction-volume data environments