Hyperion Database Administrator

Our client is a hugely popular Pacific Northwest company seeking a DBA to act as the contact for all users on their Hyperion system around issues or problems. If you have the qualifications, contact us right away to take advantage of this excellent contract opportunity!

SUMMARY OF KEY RESPONSIBILITIES

- Troubleshoots, identifies and tracks Hyperion software and data issues to ensure resolution and keep systems operational.
- Develops recommendations and coordinates issue resolution with Information Technology (IT).
- Documents and communicates problem resolution.
- Analyzes current processes, tools, system or database and makes recommendations for development, improvement or simplification.
- Acts as a Subject Matter Expert in cross functional teams to provide recommendations on new initiatives or projects around Hyperion.
- Assesses benefits to be derived from systems improvements and quantifies impact to business unit.
- Collaborates with business group management to develop appropriate Hyperion training materials to support the needs of the functional area.
- Provides ongoing end user systems training to ensure continued and correct use of application and to roll out new tools and procedures.
- Gathers and documents business requirements.
- Helps design and develop new and improved processes, tools and system enhancements to support business unit requirements.
- Participates with IT Developers in testing for Hyperion fixes, new releases and enhancements, changes and implementations, in order to ensure functionality and user acceptance.
- Maintains the integrity and the functionality of business unit systems by performing system and database maintenance.
- Monitors system performance; analyzes problems and recommends solutions.
- Monitors usage, practices, trends to identify potential problems.
- Maintains Hyperion configurations, documentation and procedures, such as user setups and interface administration for departmental computing or non-enterprise systems.
- Researches, design and schedules standardized reports or create ad hoc reports or data queries to support the business unit.
- Maintains standardized reports currently in production.
- Maintains a log of completed and ongoing system changes.
- Works with IT partners, functional analysts and vendors on medium projects to coordinate system enhancements.
- Tracks project progress and provides updates to impacted parties.
- Communicates new system functionality to department and assists users in understanding implications.

HYPERION ADMINISTRATOR SUMMARIZED REQUIREMENTS

- Security (adding users, modifying rights to accounts)
- Understanding Calculation scripts and creating new scripts as needed (large part of role)
- Understanding upstream cube changes or enhancements/Working with IT
- Adjusting Hierarchy changes
- Functional Training on all things Hyperion
- May acts as Systems Analyst (can explain data flow and how things work)
- Manages Hyperion communications across teams
- Works on technical aspects of new cubes and enhancements (requirements gathering)
- Uses both Cert and Prod environments
- Some Monthend Activities
- Documentation

SUMMARY OF EXPERIENCE

- Functional experience Hyperion Administration: 5 years
- Hyperion end user support and training: 5 years
- Script development and application testing: 5 years
- Systems design, testing and implementation: 3 years
- Project management: 2 years
- Proficiency in Microsoft Office Suite
- Analytical, problem solving and troubleshooting skills
- Systems and process flow documentation skills
- Understanding of functional area business objectives, strategies and work flow processes
- Working knowledge of business specific application system (Oracle Hyperion Essbase, Shared Services and Workspace)
- Administrative and organizational skills
- Knowledge of business requirements management
- Ability to communicate clearly and concisely, both orally and in writing
- Ability to convey technical information in an accessible and understandable manner
- Effective customer service skills

This contract position is expected to be 4-5 months in duration.