ESSBASE Administrator

Job Title: ESSBASE Administrator

Location: Dallas, TX (Hybrid)

Job Description:
The Essbase Administrator is responsible for administering, maintaining, and optimizing Oracle Essbase environments. This role ensures system reliability, supports financial planning and reporting processes, performs cube maintenance, and partners with Finance, FP&A, and IT teams to deliver stable analytics solutions.

Key Responsibilities
1. Essbase System Administration
• Manage and maintain Essbase cubes (BSO/ASO), including outline updates, metadata management, and cube refreshes.
• Monitor server performance, memory usage, logs, and error conditions.
• Manage application lifecycle activities: Dev → Test → Prod deployments.

2. Security & Access Control
• Administer user roles and provisioning in Shared Services / EPM.
• Coordinate service account management and password rotations (like in your meeting files).
• Ensure compliance with IT governance and audit requirements.

3. Data Load & Integration Management
• Maintain data load rules, MaxL scripts, data pipelines, and job schedules.
• Troubleshoot load failures and validate data completeness and accuracy.
• Work with DBAs, ETL teams, and Finance users to ensure aligned integration.

4. Backup, Performance, and Optimization
• Perform regular backups of cubes, applications, and artifacts.
• Optimize calculation scripts, partitioning, and aggregations.
• Perform patching, upgrades, and environment refreshes.

5. Support & Issue Resolution
• Provide L2/L3 support to Finance and FP&A users during close cycles.
• Troubleshoot calculation issues, user access, and data validation problems.
• Ensure uptime during critical business windows.

6. Project Delivery & Enhancements
• Participate in Essbase upgrades, cloud migrations, and automation initiatives.
• Collaborate with Finance teams to build new cubes, dimensions, or reporting enhancements.
• Document processes, job flows, configurations, and design standards.

Required Skills & Qualifications
Technical Skills
• Strong expertise in Oracle Essbase (BSO/ASO) and EPM/Hyperion suite
• MaxL scripting, Calc Scripts, MDX
• Experience with data integration (SQL Server, ODI, FDMEE, ETL tools)
• Understanding of financial modeling, planning processes, and OLAP concepts

Soft Skills
• Strong analytical and troubleshooting skills
• Clear communication with technical and finance stakeholders
• Ability to work under pressure during financial close cycles
• Organized and documentation-oriented mindset

Preferred Experience
• Experience with Essbase 21c migration.
• Cloud EPM, FCCS, Planning, or PCMCS exposure
• Automation using Python, PowerShell, or similar tools
• Financial systems background (General Ledger cubes, forecasting models, etc.)