Job
Description
Job Description: 5+ years of experience with Hyperion Essbase (ASO and BSO cubes). Design, develop, and maintain Essbase 21c cubes (BSO/ASO) to support financial planning, forecasting, and reporting processes. Build and manage Essbase calculation scripts, business rules, load rules, and report scripts. Integrate Hyperion Essbase with Hyperion Planning, Smart View, and other reporting tools. Automate data loads and metadata updates using MaxL scripts, batch scripting, and SQL jobs. Write efficient SQL queries to extract, transform, and load (ETL) data from relational databases (Oracle, SQL Server, etc.) into Essbase applications. Strong proficiency in SQL (including complex joins, subqueries, and performance tuning). Excellent analytical, communication, and problem-solving skills. Work with cross-functional teams including finance, data engineering, and IT to understand data requirements and provide analytical support. Perform performance tuning of cubes, queries, and load processes. Monitor, troubleshoot, and optimize Essbase processes and system performance. Ensure data accuracy, integrity, and reconciliation across systems.
