The Hyperion Financial Management (HFM) system administrator functions as a team member of the project team and/or as a major contributor/subject matter expert responsible for the development, implementation and maintenance of HFM and FDM (Financial Data Management) applications. This position will work with the project team to ensure HFM/FDM system is available and accessible to financial users domestically and internationally.

The HFM system administrator occupies a key role in the Finance team. The HFM system administrator functions as integrator between business needs and technology solutions, providing the interface between the finance and IT divisions to ensure successful implementation and support efforts.

General Summary: The HFM system administrator updates and maintains business/financial systems including exporting/importing of files into the HFM application. Develops requirements and specifications and carries out project tasks to develop, design, automate, compile, prepare and test reports. May be responsible for planning, organizing and managing workflow, and/or act as project manager. This position needs to resolve complex issues.

As a participant of our overall HFM / FDM development team:

• Develop and maintain all technical aspects of the HFM / FDM Application which includes constructing metadata and logic changes, data import routines, web form and business rule development, report development and general system maintenance
• Build and modify reporting systems and create complex reports for global users
• Proactively review application design and make recommendations for design enhancements
• Participate in overall effort to ensure HFM and FDM applications are developed in a way that complies with architectural standards and established methodologies and practices
• Troubleshoot and resolve HFM and FDM user questions and issues where possible and work with the IT department to address issues that might require joint attention
• Develop and update training documentation
• Monitor and report to project management on the status of project efforts, anticipating/identifying issues that inhibit the attainment of project goals and implementing corrective action
• Ensure overall system stability of HFM and FDM applications

General duties and responsibilities:

• Meet internal and external CPM information needs of the organization according to established standards, including problem research/resolution and customer education
• Support the close and reporting processes and monthly system maintenance cycles
• Help management develop strategic goals and objectives for the system
• Advise business partners on the best way for the reporting systems to accommodate changes/new requirements
• Analyze requests for changes, new requirements to production system, determine impact on existing systems processes and develop appropriate specifications, enhancements and/or procedures to comply
• Influence others to operate in a more cost-effective manner. Provides technical guidance on more complex issues.
• The position will also be responsible for continued development & maintenance of the FDM application
• Designing & prototyping, testing, training, defining support procedures and implementation
• Develop logic and methodologies for mapping tables, loading data, designing logic groups, creating import scripts, etc.
• Provide technical guidance to users and management

• Bachelor's degree in Finance, Accounting or Information Technology
• 3 to 7 years experience in Hyperion HFM, HFSS, FDM
• Has completed at least 2-3 HFM implementations involving consolidation of multiple legal entities, setting up different hierarchies and reporting of non financial information through HFM
• Has written rules in HFM for financial consolidation under different methods, understand the eliminations and other aspects of consolidation
• Has implemented FDQM and has the experience in writing scripts to pull data directly from source systems such as SAP, Oracle etc.
• Has implemented Hyperion financial shares services and has indepth knowledge of HFM security groups, rights etc.
• Has installed and configured HFM and has indepth knowledge on how to trouble shoot incase HFM is not working
• Has designed and implemented dashboards in Hyperion Web studio
• Has designed and implemented reports in FR
• Understand HFM metadata, has designed and implemented metadata as part of HFM implementation
• Has implemented Essbase and Hyperion planning
• Has Hyperion/Oracle certification on HFM, FR, Webstudio, FDM, Essbase etc.
• Highly developed analytical and problem solving skills
• Strong functional background of accounting processes
• Business knowledge of financial accounting processes
• Excellent computer skills with a working knowledge of MS Excel, Word, Access, PowerPoint, Project, Visio and/or SQL

• Excellent communication skills (written/verbal), organization and interpersonal skills
• Ability to work in a team environment as well as independently
• Maintains a positive, achievement-oriented attitude
• Demonstrates initiative and innovation in achieving results
• Dedicated to delivering exceptional customer service
• Proven ability to perform well and with a high degree of accuracy under tight deadlines
• Excellent analytical skills
• Ability to prioritize and manage projects and changing deadlines
• Desire to learn finance and accounting
• Able to work with little supervision and meet tight timelines