Hyperion Administrator Job Description
Hyperion Administrator Duties & Responsibilities
To write an effective hyperion administrator job description, begin by listing detailed duties, responsibilities and expectations. We have included hyperion administrator job description templates that you can modify and use.
Sample responsibilities for this position include:
Hyperion Administrator Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Hyperion Administrator
List any licenses or certifications required by the position: HFM, AWS, PMP
Education for Hyperion Administrator
Typically a job would require a certain level of education.
Employers hiring for the hyperion administrator job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and University Degree in Accounting, Finance, Computer Science, Business, Information Systems, Engineering, Education, Business/Administration, Technical, Information Technology
Skills for Hyperion Administrator
Desired skills for hyperion administrator include:
Desired experience for hyperion administrator includes:
Hyperion Administrator Examples
Hyperion Administrator Job Description
- Creating/maintaining standard reports (SmartView and Financial Reporting)
- Maintain business rules and calculation scripts
- Maintain data integrity in accordance with SOX compliance
- Oversees position requirements and performs internal controls, including providing evidence of internal control performance to management internal and external auditors
- Develops test plans and scripts
- Provide Management Reporting support to the financial planning teams across the Divisions and cross divisional functions
- Analyze processes to monitor and control data integrity, quality, and associated Sarbanes-Oxley compliant controls
- Identify and implement improvements to existing processes (efficiency, cost reductions, reduction in calculations' execution times, improved integrations)
- Develop and maintain archiving policies and processes
- Engage and support server cleanup as necessary and directed by the archiving policies and procedures
- Working knowledge of Hyperion Planning, Essbase and HFM
- Project management experience (leading design sessions, resolution discussions, go-live and support) a plus
- Ability to learn and utilize financial software packages
- Demonstrable proficiency in Microsoft Excel
- Possesses a customer support mindset to partner with various Shared Service and Brand personnel
- Demonstrable ability to interpret and write SQL (or SQL-syntax) scripts a plus
Hyperion Administrator Job Description
- Maintain and provide Quality Assurance on metadata in production applications
- Continuously improve month end financial reporting and processes
- Work with the customer support team as needed to resolve application issues
- Performs routine scheduled and ad-hoc data loads and meta-data updates, validating accuracy and performing corrective actions, as warranted
- Monitors supported applications daily for performance and integrity
- Maintains application security for forms, tasks, reports and end users / groups using Shared Services
- Proactively researches technology tends of the product
- Resolve questions for end-users
- Identify and document scope and effort for change requests
- Work closely with the HFM, Essbase, Planning, BW and IT teams to ensure that all of the structures and related feeds are accurate and efficient
- BA degree is required preferably in the Finance, Accounting, Computer Science area, or equivalent experience
- Hyperion Planning (11.1.2.4 preferred)
- Data Forms
- Calculation Manager
- LCM
- Experience with JavaScript or any other scripting language
Hyperion Administrator Job Description
- Work with other Financial Systems groups to ensure that each systems needs are handled appropriately
- Responsible for developing and maintaining processes to ensure that the structures are validated and in sync with other corporate reporting systems
- Handle month end financial close processes in SAP-BW
- Work with cross-functional teams to understand business needs and develop new reporting structures as and when required
- Validate monthly overhead allocations
- Coordinates financial report preparation and business analysis
- Research and coordinate resolution of system-related issues with the IT Infrastructure and Server Operations Groups Oracle support
- Design, configure, and setup Hyperion installations by gathering and analyzing information
- Administration of Hyperion version 11 servers, databases & applications including, upgrades, backup and recovery, capacity management, deployment of production code changes, and fail-over testing
- Maintain the production, test and development instances of supported systems as part of the technology infrastructure team
- Experience with Maestro a plus
- Experience of scripting/programming a plus
- Must be a self-starter and be able to work independently or as part of a team
- Minimum 5 year of experience as Hyperion admin - install, maintain, configure, patch, cluster setup of EPM environments
- Ensuring data accuracy and integrity in the Planning systems
- Bachelor's degree in Management Information Systems, Finance, Accounting or a related field
Hyperion Administrator Job Description
- Coach and Develop a team of 2-3 financial analysts/senior financial analysts
- Ensures Production environment stability and performance are up to par and meet SLA agreements
- Participates in requirements sessions and prepare detailed functional specifications, design models, and system workflows from which software applications will be developed and implemented
- Develops test scenarios, test scripts and leads teams in unit, integration and acceptance testing
- Facilitates Business end-user training and Help desk training as needed
- Leads, mentors and assists software developers/engineers with technical Hyperion issues
- Leads application development projects as assigned
- Maintain Outline and Calc Scripts for Administrative duties
- Ensure the integrity of data migrations between Hyperion HFM & Planning Applications
- Provide timely and effective technical support to internal customers to troubleshoot issues and minimize down time for the end user during the month-end close & forecasting processes
- Certification in supported Hyperion products a plus
- Hands-on Hyperion applications (Planning, PBCS, Essbase, Smartview, FRS, FDMEE, EAS, Shared Services) administration skills required, including developing and maintaining forms, tasks, reports, business rules, outlines, calculation and reporting scripts, load rules, batch scripts, security, managing meta-data / core data loads and validations
- Strong understanding of financial planning and reporting concepts and associated business processes
- Advanced Excel skills including formula development, pivot tables, macro / VB development, familiarity with text, look-up and reference, data and financial functions
- Prior customer support and training program delivery experience for financial planning systems
- Ability to multi-task and adhere to deadlines, including flexibility to work alternate schedules and overtime (nights and weekends) to support planning cycles
Hyperion Administrator Job Description
- Create and maintain training documentation on company intranet
- Maintain data backups and understanding of disaster recovery practices
- Act as a department liaison to various business functions
- Assist the Financial Analysts and management with other FP&A projects or tasks as requested
- Support production environment and close process utilizing ticketing and escalation methodologies for overall change requests
- Initiate change controls for all Hyperion Planning and Essbase application changes along with associated documentation and testing
- Perform routine Essbase and Planning procedures including those related to the monthly close and Budget process such as loading of Fx rates, form modification and updating of substitution variables
- Migrate Hyperion Planning and Essbase applications between production and development environments
- Maintain data linkages between Hyperion Planning/ Essbase and other applications such as Hyperion HFM and the Global Data Warehouse
- Maintain enterprise level cloud based Planning and Consolidation applications (PBCS/FCCS) and be responsible for the broader environments integrity as it relates to reliability and availability of the applications (security, uptime, maintenance processes)
- 5 plus years Hyperion Essbase/Planning preferred
- Oracle/Hyperion reporting products experience (Financial Reporting, SmartView)
- Ability to support users community located across the globe
- Project management skills to be able to lead system upgrades
- The candidate must have a bachelor's degree, preferably in a business related field and more than five years of related experience
- A minimum of three (3) years of hands on Hyperion Financial Management (HFM) experience