Sr. Hyperion Administrator

C&S Wholesale Grocers - Keene, NH

Full-time - Mid Level

Remote - Keene, NH

Merchant Wholesalers, Nondurable Goods

About the position

As a Senior Hyperion Administrator, you will play a crucial role in managing and supporting Hyperion applications, including Essbase and OBIEE, for Corporate Finance. Your responsibilities will encompass daily management reporting application support, report development, and end-user assistance. You will also 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 and BSO cubes, outlines, dimensions, and data loading processes.
• Administer Hyperion Essbase, including planning and reporting, system tuning, backups, 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.
• Recognize system deficiencies and implement effective solutions.
• Develop complex rule files to adjust mainframe feeds for data loading and dimension building.
• Develop new calc scripts according to business requirements and modify existing scripts to reduce calc run time.
• Perform all month-end, quarter-end, and 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 and 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)

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