Advanced Hyperion Planning Specialist

Job Summary:

As an Advanced Hyperion Planning Specialist for Corporate Planning, you will be responsible for working as part of a team that provides direct support to the North America CEO. As a systems analyst, you will perform system admin responsibilities for Oracle EPM, provide systems support to North America Power Users, and provide North America EPM Financial Reports for Corporate, US, Canada, and Mexico Plants.

Responsibilities:

• Providing functional/technical expertise to support corporate and consolidation process 
• Support monthly financial close, upload and maintain actual, budget and forecast data through Data Management, and maintain mapping tables, and import formats 
• Interpret code, calculation and aggregation script logic 
• Troubleshoot financial statement disconnects of calculations or source systems. Identify root cause and short and long term countermeasures 
• Interact with business stakeholders, end user, peers, and management personnel to resolve system issues 
• Strengthen the processes and systems for collecting, analyzing and presenting management and business information, standardizing and documenting the control framework for financial systems and reporting tools 
• Understand and interpret business requirements and effectively communicate them to IT and Finance Manager - EPM Systems
• Provide system training to end users and upskill current Business Planning members 
• Partner with IT and Finance Manager – EPM Systems to assist in the development and deployment of Oracle EPM Enhancements through all phases of Software Development Life Cycle (SDLC) including the design, development, test, implementation, and maintenance of financial applications 
• Communicate highly technical information to functional and technical team members and ability to simplify for operational management

Qualifications:

• Bachelor's degree with a major in Accounting, or Business Administration 
• 3 or more years work experience in Accounting or Financial Planning and Analysis 
• Experience with Oracle's EPM Planning (Hyperion Planning, PBCS, or EPBCS, also acceptable) 
• Knowledge of Financial Close and Consolidation (FCC) or Hyperion Financial Management (HFM) and Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) or Data Management
• Basic knowledge of GAAP with ability to understand linkages between accounts to develop a Balance Sheet, Income Statement, and Cash Flow Statement 
• Experience in budgeting, forecasting and variance analysis. Able to draw accurate conclusions from financial and quantitative information. 
• Proficient in Excel, Essbase and SmartView. 
• Knowledge of Oracle ERP. 
• Knowledge of Oracle Fusion Data Intelligence (FDI) or FAW (Fusion Data Warehouse)
• Ability to pick up new technical knowledge quickly. 
• Able to work comfortably in a hands-on fast pace department 
• Experienced in working with cross-functional teams like Accounting, IT and Plant Finance 
• High level of independent capability and initiative to operate in a flexible work/remote environment 
• Demonstrate strong analytical skills, problem solving/debugging skills. 
• Preferred: Previous Hyperion Admin Role 
• Preferred: Experience in SDLC deliverables with the automotive industry 
• Preferred: Experience in BI Tools such as EPM Dashboards and Domo 

Benefits Summary: 

• Medical, Dental, Vision, Prescription Drug plans  
• 401K with 4% Company Match 
• Vacation/PTO and 13 paid Holidays 
• Bonus Program 
• FSA/HSA and Dependent Care Programs 
• Company provided Life, Disability, ADD and Business Travel Insurance 
• Various No Cost Wellness & Chronic Condition Management Programs 
• Various Optional Insurance programs such as legal, identity theft, critical illness, etc. 
• Tuition Reimbursement  
• Career Development and Ongoing Training  
• Employee Assistance Program  
• Employee Spotlight and Recognition Program 
• Volunteer Opportunities  
• Onsite Fitness Center (vary by location) 
• Cafeteria and food markets (vary by location)  
• Onsite Health Clinic and Pharmacy (vary by location) 

Annual Salary: $93,000 – $116,000