Note: The job is a remote job and is open to candidates in USA. InfiCare Staffing is hiring a Hyperion Analyst to support financial planning and analysis activities. The role focuses on building and maintaining Hyperion- and Excel-based financial models, automating reporting with VBA, retrieving multidimensional financial data, and supporting budgeting, forecasting, and executive decision-making.
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 macros integrated with Hyperion functions to automate recurring report packages and enable one-click refresh capability
- Write and optimize ad-hoc multidimensional grid queries using 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 and 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
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
- Experience with Oracle Hyperion Planning, Essbase, or HFM (Hyperion Financial Management)
- Familiarity with other automation/scripting tools such as Power Query, Power BI, and 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, including three-statement models, variance analysis, and driver-based forecasting
Company Overview