Hyperion / Essbase Developer - ERP

Job Title :

Key Responsibilities :

- Lead the design, development, and maintenance of Hyperion Essbase cubes and Hyperion Planning applications to support financial planning, budgeting, and forecasting.

- Collaborate with financial analysts and business stakeholders to gather requirements, translating business needs into efficient technical solutions.

- Develop and optimize calculation scripts, business rules, forms, and data load rules in Hyperion Planning and Essbase.

- Perform financial modeling in Hyperion Planning, ensuring the accuracy and scalability of budgeting and forecasting processes.

- Support data integration between Essbase, Planning, and external systems (e.g., Oracle, SAP, and other ERPs).

- Provide ongoing support for the financial close process, consolidations, and variance analysis.

- Troubleshoot performance issues in Essbase cubes and optimize system performance for better user experience and data processing efficiency.

- Implement and maintain SmartView reports and templates for business users to generate on -demand financial reports.

- Ensure security and data integrity across the system by managing user access and ensuring compliance with financial regulations.

- Provide training and support to finance teams on how to use the planning and reporting tools effectively.

- Document technical designs, configuration settings, and best practices to ensure knowledge sharing and ease of system maintenance.

Required Qualifications :

- 5+ years of hands -on experience in Hyperion Essbase development and Hyperion Planning.

- Expertise in designing and optimizing Essbase cubes for financial planning and reporting.

- Strong experience with Hyperion Planning, including calculation scripts, business rules, and data integration.

- Deep understanding of financial processes such as budgeting, forecasting, variance analysis, and consolidations.

- Proficiency in using SmartView for reporting and analysis.

- Solid experience in data integration between Essbase/Planning and external systems (Oracle, SAP, etc.).

- Knowledge of SQL and data extraction techniques to enhance integration and reporting capabilities.

- Strong understanding of financial/accounting principles and how they relate to planning and budgeting models.

- Excellent problem -solving and troubleshooting skills.

- Strong communication skills, with the ability to work closely with finance and IT teams.

Preferred Skills :

- Experience with Oracle EPM Cloud or Hyperion Financial Management (HFM).

- Hands -on experience in upgrading or migrating Hyperion systems.

- Knowledge of PL/SQL for advanced data manipulation and reporting.

- Experience with financial reporting and variance analysis in large organizations.