Advanced Hyperion Planning Specialist

Position overview

Responsibilities

• Provide functional and technical expertise for corporate and consolidation processes.
• Support monthly financial close; upload and maintain actual, budget, and forecast data through Data Management; maintain mapping tables and import formats.
• Interpret code, calculation, and aggregation script logic.
• Troubleshoot financial statement calculation or source-system disconnects, identify root causes, and determine countermeasures.
• Work with stakeholders and end users to resolve system issues.
• Improve information collection, analysis, and presentation processes; standardize and document financial systems and reporting controls.
• Communicate business requirements to IT and the Finance Manager, EPM Systems.
• Train end users and develop the capabilities of Business Planning members.
• Assist with Oracle EPM enhancements across SDLC design, development, testing, implementation, and maintenance.
• Explain technical information to functional and technical teams and operational management.

Qualifications

• Bachelor’s degree with a major in Accounting or Business Administration.
• At least three years of work experience in Accounting or Financial Planning and Analysis.
• Experience with Oracle EPM Planning, including Hyperion Planning, PBCS, or EPBCS.
• Knowledge of Financial Close and Consolidation (FCC) or Hyperion Financial Management (HFM), and FDMEE or Data Management.
• Basic GAAP knowledge and ability to understand account linkages for balance sheet, income statement, and cash flow statements.
• Experience in budgeting, forecasting, and variance analysis; ability to draw conclusions from financial and quantitative information.
• Proficiency in Excel, Essbase, and SmartView.
• Knowledge of Oracle ERP and Oracle Fusion Data Intelligence (FDI) or FAW.
• Able to learn technical knowledge quickly and work hands-on in a fast-paced department.
• Experience working cross-functionally with Accounting, IT, and Plant Finance.
• Independent, capable, and proactive in a flexible or remote environment; strong analytical, problem-solving, and debugging skills.

Preferred qualifications

• Previous Hyperion Administrator experience.
• Experience with SDLC deliverables in the automotive industry.
• Experience with BI tools such as EPM Dashboards and Domo.

Compensation

• Annual salary is $93,000 to $116,000.

Benefits

• Benefits include medical, dental, vision, and prescription coverage; 401(k) company match; paid time off and holidays; bonus program; and FSA/HSA options.
• Additional offerings include insurance, tuition reimbursement, training, wellness programs, employee assistance, recognition, and volunteer opportunities.
• Fitness center, cafeteria, food markets, health clinic, and pharmacy availability varies by location.