Description

Manage Essbase administration and data integration during a fiscal year transition to a calendar year cycle.

Responsibilities

• Modify and update data connections, integrations, and reports to accommodate fiscal year changes.
• Manage and maintain approximately 8 Essbase cubes within an on-prem environment.
• Develop and automate data loading processes and cube calculations.
• Debug incorrect data and resolve issues within the cube farm.
• Assist in the Essbase upgrade process and transition toward increased automation.

Required Skills

• 5+ years of experience in Hyperion Essbase administration.
• Strong proficiency in SQL and writing SQL queries.
• Hands-on experience with SSIS and Visual Studio integrations.
• Competency in Visual Basic (VB) and VB Script/VBA coding.
• Experience managing both ASO and BSO cube calculations.
• Ability to manage data loading and drill-down concepts.
• Experience working with SQL Server databases and stored procedures.
• Proficiency with Smartview and Excel.

Preferred Skills

• Experience integrating Hyperion Essbase with Lawson.

Key Skills

Education

Any Graduate