Hyperion Planning

Job Summary

We are looking for an experienced Essbase Developer / Consultant with strong hands-on experience in Oracle Essbase OLAP (ASO/BSO) and financial reporting solutions. The candidate will be responsible for designing, developing, testing, supporting, and optimizing Essbase applications and reporting solutions.

The role requires strong technical expertise in Essbase, financial reporting, database modeling, Unix/Linux scripting, and production support.

Key Responsibilities

• Design, develop, test, debug, document, and maintain Essbase solutions using Agile development practices.
• Manage the complete lifecycle of multidimensional financial reporting and analytical applications, including requirements gathering, design, development, testing, deployment, and maintenance.
• Develop and support Oracle Essbase ASO/BSO applications.
• Work extensively with:
• Essbase Outline Design
• Load Rules
• MaxL Scripts
• Calculation Scripts
• Partitions
• Security
• Performance Tuning and Optimization
• Smart View / Excel Add-in
• Design and maintain financial reporting and analytical solutions.
• Work with Star Schema design and relational database modeling using Oracle or SQL Server.
• Source hierarchy and fact data from file-based and relational data sources.
• Work with metadata management systems such as DRM (Data Relationship Management).
• Develop Unix/Linux shell scripts to automate Essbase database outline builds, data loads, and aggregations.
• Build and maintain automation processes using CA AutoSys.
• Troubleshoot and resolve complex technical issues in Essbase applications.
• Provide production and on-call support when required.
• Ensure quality, security, and compliance requirements are met.
• Collaborate with business users, finance teams, and technical stakeholders.
• Document technical solutions, processes, and application changes.

Mandatory Skills

• 7+ years of overall IT/application development experience.
• 5–7 years of hands-on experience with Oracle Essbase OLAP.
• Strong experience with Essbase ASO and BSO.
• Hands-on experience with Outline Design, Load Rules, MaxL, Calc Scripts, Partitions, Security, and Performance Tuning.
• Strong experience with Smart View / Excel Add-in.
• Experience with financial reporting and multidimensional analytical applications.
• Experience with Oracle or SQL Server databases.
• Strong knowledge of Star Schema and relational database modeling.
• Experience with Unix/Linux Shell Scripting.
• Experience with CA AutoSys.
• Experience supporting production environments and providing on-call support.
• Strong communication and stakeholder management skills.

Position Summary

This is a key role supporting the day‑to‑day operation of one of our esteemed customers' core financial systems across the organization. In this role, you will support application configuration and best practices for systems including Hyperion, PeopleSoft, Concur, Oracle Transportation Management (TMS), Planview, Lucernex, and Coupa. The scope of this role will continue to expand as additional finance systems are shared across multiple business processes and application modules.

Reporting to the Finance Systems Manager and working closely with multiple business stakeholders as well as functional and technical application support teams across the enterprise, you will be responsible for ensuring the ongoing integrity, stability, and effectiveness of application functionality across the Customer's systems landscape.

This position provides an excellent opportunity to support change within a cross‑functional, multi–business unit environment, with exposure to all areas of Finance operations. The role offers a fast‑paced and challenging work environment, with regular interaction and visibility across multiple levels of management.

What you will do:

• Query, script and reporting writing within Finance applications such as Hyperion, PeopleSoft, Concur, Oracle Transportation Management (TMS), Planview, Lucernex, and Coupa
• Application configuration to support core business functionality of procure to pay (P2P)
• Ensure Finance standards are consistently achieved and proactively monitored within our core finance applications
• Engage with broader Finance Systems and Data Governance team members to perform root-cause analysis related to Finance application integrity and/or data fixes resulting from upstream system integrations
• Engage with broader Finance Business Analysts members to support in application enhancements and improvement initiatives.

What we are looking for:

• Demonstrated experience supporting financial and/or operational business processes, such as:
• Record-to-Report (close, consolidation, reporting)
• Procure-to-Pay (requisition → PO → invoice)
• Lease/real estate management and/or portfolio delivery processes
• Proven track record in incident/problem/change management with practical experience leading triage, RCA, and release coordination.
• Ability to elicit requirements and convert them into configuration recommendations and well-defined work items.
• Hands-on leadership of UAT, including test planning, execution, defect management, and go-live readiness.
• Strong understanding of integrations from a functional support standpoint (how data flows, common failure modes, reconciliation).

What you will bring:

• 5+ years in functional application support or functional analyst roles supporting enterprise applications (ERP/EPM/SaaS).
• Bachelor’s degree in business, Finance, Information Systems, Supply Chain, or equivalent experience.
• Strong functional support mindset: restore service quickly, prevent repeat issues, and improve stability over time
• Functional support experience with one or more of:
• Coupa (P2P, catalog/invoicing, supplier enablement, matching rules)
• Lucernex (leases, escalations, CAM, critical dates, lease reporting)

Good to have any of the following skills:

• PeopleSoft Financials (ChartFields, AP, GL, workflow, batch processes)
• Concur (expense policy, audit rules, corporate card feeds, ERP posting)
• OTM/TMS (tendering, execution, rating, freight settlement/audit)
• Planview (demand intake, portfolio/resource mgmt., governance workflows)
• Hyperion (planning, consolidation, metadata/hierarchies, Smart View support)
• Ability to read and validate file layouts/mapping documents, troubleshoot integration logs, and run basic queries (SQL) for investigation.
• Experience with structured intake forums, prioritization frameworks, product ownership, or ITIL-based service management.
• Experience partnering with data governance teams or supporting data quality controls and stewardship processes.

Work time: Eastern time zone (US Shift)