Hyperion Administrator
Description:
About our client
Our Toronto-based client is looking for a Hyperion Administrator for a 1-year contract position. This is a hybrid role, that will require the successful Hyperion Administrator to work onsite at the client location, as well as remotely from home.
Responsibilities
The Hyperion Administrator will assist in the annual budget development, quarterly forecast, and monthly period-end
reporting procedures including data preparation, process management, and update of system task flows.
The Hyperion Administrator will also provide end-user support during the budget and forecast cycles, troubleshooting support, and maintain the Hyperion Planning and Essbase applications, metadata, business rules, web forms, data integration from source systems, mappings, financial reporting, user access, and security, as well as enhancing functionality when needed to meet budget, forecast and reporting requirements, including the following tasks:
o Develop and maintain web forms, business rules/calculation scripts, task lists
and other Hyperion Planning and Essbase artifacts
o Develop and maintain reports using Hyperion Financial Reporting and Smart
View
o Maintenance of the Development, SIT, UAT, and Production environments
o Perform artifact migration between environments, including metadata and
data synchronization
o Execute security changes in Planning and Essbase ensuring that proper
approvals are obtained
o Maintenance of the Essbase ASO database for reporting, and reporting
mapping
o Document, test, and maintain all Planning and Essbase dimensions, metadata
and rules changes related to the chart of accounts (CoA), entities, scenarios,
versions and custom members
o Maintenance of the FDMEE/ODI application which provides automated upload
connectivity between Oracle Finance and Hyperion Planning/Essbase to
ensure the completeness and accuracy of the financial information transferred
between systems. FDMEE is also used to load data from HCM (HR data) and
Workbrain (capitalization data) into Hyperion
o Execute the manual upload of spreadsheet data where systems are not
connected and provided administrative/technical support to the automation of
the manual processes
o Perform code fixes, following change management and ITIL
o Perform and validate data loads from source systems
o Perform unit testing, SIT and UAT testing, and document testing plan, testing
script and results
Qualifications
o Degree in computer science/engineering or equivalent work experience
o Knowledge and hands-on use of FDMEE, Hyperion Planning, Essbase, SmartView and
Financial Reporting. Strong experience in the development of Business Rules, Essbase,
python scripts, calc Scripts, and Maxl
o Hyperion Essbase and/or Planning certification is an asset
o Proven experience in independently dealing with business users
o Hands-on experience with troubleshooting application and data issues
o Analyze release notes and provide direction to the business about changes due to
patches