Hyperion Analyst

Role – Hyperion Analyst

Location – Remote

Duration – Long term

Role Summary:

We are seeking an FP&A(Financial Planning & Analysis) professional who combines strong financial acumen with advanced Excel and Hyperion technical skills to build, automate, and maintain the financial models and reporting infrastructure that drive budgeting, forecasting, and executive decision-making. This role sits at the intersection of finance and technical automation  extensively using the Hyperion Excel Add-in to pull live data, and VBA to transform manual reporting processes into one-click, refreshable report packages.

Key Responsibilities:

• Build and maintain complex financial models using the Hyperion Excel Add-in to support budgeting, forecasting, and ad-hoc executive reporting
• Design and develop VBA (Visual Basic for Applications) macros integrated with Hyperion functions to automate recurring report packages, enabling one-click refresh capability
• Write and optimize ad-hoc multidimensional grid queries (Hyperion Smart View / Essbase-style queries) to efficiently retrieve large, complex datasets
• Pull live data from Hyperion into Excel-based models to ensure reporting reflects real-time financial actuals and forecasts
• Partner with FP&A leadership and business stakeholders to translate reporting requirements into automated, scalable Excel/Hyperion solutions
• Troubleshoot and maintain existing VBA-driven report automation, ensuring reliability and accuracy of refreshed outputs
• Support monthly, quarterly, and annual budgeting and forecasting cycles with accurate, timely data extraction and model updates
• Generate ad-hoc executive-level reports and analyses on demand, often under tight turnaround times
• Document report logic, VBA macros, and data query structures to ensure continuity and knowledge transfer
• Continuously identify opportunities to streamline and automate manual, repetitive reporting tasks

Required Qualifications & Skills:

• Hyperion Excel Add-in: Hands-on, extensive experience using the Hyperion Excel Add-in (Smart View or equivalent) for financial modeling, live data retrieval, and reporting
• VBA Proficiency: Strong working knowledge of VBA to build macros that integrate with Hyperion functions and automate report generation and refresh
• Multidimensional Query Writing: Demonstrated ability to write ad-hoc multidimensional grid queries against Hyperion/Essbase cubes to pull large datasets efficiently
• Advanced Excel Skills: Deep Excel expertise including complex formulas, pivot tables, data modeling, and large workbook management/performance optimization
• FP&A Domain Knowledge: Solid understanding of budgeting, forecasting, and financial modeling processes within an FP&A function
• Analytical Mindset: Ability to build accurate, audit-ready financial models and troubleshoot data or logic discrepancies
• Communication: Ability to work with finance leadership and non-technical stakeholders to gather requirements and deliver clear, executive-ready outputs
• Attention to Detail: High accuracy standards given the executive visibility of the reports produced

Preferred Skills:

• Experience with Oracle Hyperion Planning, Essbase, or HFM (Hyperion Financial Management)
• Familiarity with other automation/scripting tools (Power Query, Power BI, SQL) to complement VBA-based workflows
• Prior experience supporting a corporate FP&A team in a mid-to-large enterprise environment
• Experience building executive dashboards or board-level reporting packages
• Knowledge of financial modeling best practices (three-statement models, variance analysis, driver-based forecasting)