Hyperion Administrator Job Description
Hyperion administrator
provides database development and administration support for Microsoft Access, Microsoft SQL, and other database software as required including applications interfacing with these databases.
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:
Maintain budgeting/planning allocations
Set up and maintain user access within Shared Services for Hyperion Planning and Essbase
Planning and Essbase administration
FDQM administration
HFM administration
Reporting Studio writer
Smart View and Essbase Excel add-in support
Deployment and ongoing financial data maintenance of Hyperion EPM suite
Metadata updates/hierarchies
Coordinating FDMEE data loads from EBS
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:
Balance sheet and cash flow
Database administration
Database software and operating systems
Income statement
SOX and importance of internal controls
Software Development Life Cycle
Systems analysis procedures
Access
Budgeting
Classes
Desired experience for hyperion administrator includes:
Creating/maintaining standard reports
Support and perform systemic month-end closing processes
Develop, update and maintain system administration documentation
Ability to utilize and learn accounting/financial software packages
Proficient in Microsoft Excel and various Microsoft Office applications
Ability to analyze reports, reconciliations and other related documents
Hyperion Administrator Examples
1
Hyperion Administrator Job Description
Job Description Example
Our innovative and growing company is looking for a hyperion administrator. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for hyperion administrator
- 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
Qualifications for hyperion administrator
- 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
2
Hyperion Administrator Job Description
Job Description Example
Our company is growing rapidly and is hiring for a hyperion administrator. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for hyperion administrator
- 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
Qualifications for hyperion administrator
- 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
3
Hyperion Administrator Job Description
Job Description Example
Our innovative and growing company is hiring for a hyperion administrator. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for hyperion administrator
- 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
Qualifications for hyperion administrator
- 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
4
Hyperion Administrator Job Description
Job Description Example
Our company is hiring for a hyperion administrator. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for hyperion administrator
- 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
Qualifications for hyperion administrator
- 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
5
Hyperion Administrator Job Description
Job Description Example
Our company is looking to fill the role of hyperion administrator. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for hyperion administrator
- 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)
Qualifications for hyperion administrator
- 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