Sr. Hyperion Administrator

C&S Wholesale Grocers - Keene, NH

Full-time - Mid Level

Remote - Keene, NH

5,001-10,000 employees

Merchant Wholesalers, Nondurable Goods

About the position

As a Senior Hyperion Administrator, you will be responsible for managing and supporting Hyperion applications, including Essbase and OBIEE, for Corporate Finance. This role involves daily management reporting application support, report development, and end-user assistance. You will oversee data loads, calculations, and system consolidations while developing and maintaining Hyperion Essbase applications and providing technical administration for budgeting and forecasting processes.

Responsibilities

• Serve as point person for Finance-Hyperion/OBIEE IT projects by understanding requirements, delegating tasks, prioritizing work, and reviewing results.
• Develop, implement, and maintain ASO, BSO cubes, Outlines, dimensions, loading data, calculating data, and aggregation techniques.
• Administer Hyperion Essbase, including planning and reporting, system tuning, backups and recovery, and troubleshooting system issues.
• Research and resolve issues with metadata and GL balances, create and maintain hierarchies, and write or modify basic calc scripts or business rules.
• Execute processes such as deploying data and updating variables, assign security roles, create/modify web forms, and maintain mapping of source data from local source systems to Hyperion Essbase target databases.
• Recognize system deficiencies and implement effective solutions.
• Develop complex rule files to adjust mainframe feeds for data loading, dimension building, and modify existing rule files.
• Develop new calc scripts according to business requirements and modify existing scripts to reduce calc run time.
• Perform all month-end/quarter-end/year-end close processes needed in the system to report timely and accurate financial statements, forecasts, and budgets.
• Maintain and support EPBCS metadata, Business Rules, and data loads, automating integrations to support Forecast/Budget cycles.
• Maintain and support ARCS, including security and GL balances data load integrations.

Requirements

• 3-5 years of experience with Hyperion
• Bachelor's degree required
• Proficient in Windows and Unix operating systems
• Experience with writing Shell and batch scripts to automate processes
• Experience with Oracle or Microsoft SQL Queries
• Experience with data integration concepts between source systems and target Essbase applications
• Experience in building new integrations using EPBCS data management tools
• Good understanding of Oracle Infrastructure Cloud (OCI)

Nice-to-haves

• Exposure to Oracle Analytics Cloud (OAC) preferred

Benefits

• Weekly Pay
• Benefits available from day 1 (medical, dental, vision)
• Company matched 401k
• PTO and Holiday Pay offered
• Career Progression Opportunities
• Tuition Reimbursement
• Employee Health & Wellness program
• Employee Discounts / Purchasing programs
• Employee Assistance Program