1 Click Easy Apply


Hyperion Essbase Administrator


Dallas, Texas


Job Type: FT


Rate: DOE


Hyperion Essbase Administrator Job Opening in Dallas, Texas - Hyperion Essbase Administrator for consideration, email resume to . technology's client in uptown, dallas is seeking a oracle hyperion essbase systems administrator for a full-time position. apply today! position summary: this senior analyst position will maintain the current business intelligence environment and develop new solutions to support the business community. the position primarily supports oracle hyperion essbase 11.1.2.4, hyperion financial reporting, planning budgeting cloud services (pbcs), and hyperion smart view excel add-in. this role requires comprehensive understanding of business requirements in order to develop efficient, optimized applications as well as ability to support ad hoc user requests. a thorough understanding of finance and accounting are also required in order to properly support the business applications. essential functions: ? design, develop and deploy enterprise scale essbase applications to meet ad hoc analysis and reporting needs based on business requirements. ? provide technical support for essbase administration services (eas), hyperion shared services, financial reporting studio, and hyperion workspace. ? develop and maintain essbase outlines, calculation scripts, dimension builds, data loads, report scripts, and batch automation scripts (maxl and msh). ? perform essbase data loads from disparate data sources including data validation and discrepancy correction. ? develop and maintain sql scripts to facilitate data staging and loading. ? responsible for managing and monitoring hyperion load process (ad hoc requests and nightly scheduled loads) and addressing load issues. ? perform exports of essbase data to downstream applications databases. ? thorough understanding of dense/sparse settings, dynamic calculations, and development best practices for essbase outlines. ? technical knowledge of outline development functionality such as attribute dimensions, user defined attributes (udas), substitution variables, aggregate storage (aso), and block storage (bso). ? optimize and tune essbase applications to enhance performance for data loads, aggregations calculations, and data retrievals. ? manage security provisioning by maintaining users, user groups, and access security privileges. ? provide support for the smart view excel add-in including vba programming. ? develop planning forecasting applications and maintain business rule logic and web forms. ? design, develop, and maintain hyperion financial reports. ? fulfill complex ad-hoc queries, analysis, and reporting requests submitted by business users. ? provide ongoing support to business users for daily operational requests and issue resolution for a user base of 200+ global users. ? participate in annual audit of applications and semi-annual user access review. ? ensure application compliance with policies, procedures, and change control process. ? play a key role in project rollouts including new development, enhancements, and upgrades. ? develop and execute unit, system integration, and user acceptance test plans to support application testing. ? create application specific training materials and conduct end user training sessions to support the business community. required knowledge, skills and abilities: ? must have worked as a hyperion administrator for essbase, planning, and financial reports and have experience supporting a global business community. ? must demonstrate technical knowledge of essbase best practices in application design and deployment. ? proven ability to transform a complex set of business requirements into intuitive, scalable essbase and planning applications to solve business problems. ? proficient use of smart view excel add-in including vba programming in conjunction with data from hyperion. ? proficient use of sql scripts and batch automation scripts (maxl and msh). ? comprehension of financial analysis and/or accounting concepts. ? strong analytical/problem solving skills and detail oriented. ? excellent interpersonal skills, including ability to effectively communicate with business users, executives, and subject matter experts. ? ability to multi-task and work efficiently in a fast paced, rapidly changing environment. ? ability to work well under time constraints. ? team player with a positive attitude, professional demeanor, and strong work ethic. ? hard-working, ability to prioritize, and commitment to producing successful end results. ? self-starter, ability to work well with minimal direction in a team environment. ? oracle financials experience preferred. ? knowledge of microsoft power bi a plus. ? knowledge of oracle business intelligence 12.2.1.2 (obi) a plus. education: ? bachelor?s degree in finance, accounting, or computer science required. ? master?s degree in business administration (mba) a plus. experience: ? must have extensive (5-7 years) essbase, planning and financial reports development experience, including building enterprise scale applications. ? 5-7 years of experience in the creation, modification, and support of essbase outlines, calculations, report scripts, load rules, sql scripts, and maxl/msh scripts. ? 5-7 years of experience in essbase etl (extract, transfer, and load) processes from disparate data sources to essbase. ? 5-7 years of experience with planning business rules and web input forms. ? advanced smart view excel add in experience (5-7 years) required, including vba programming. computer skills: ? extensive technical knowledge of hyperion applications (oracle hyperion essbase 11.1.2.4, hyperion financial reporting, planning budgeting cloud services (pbcs), essbase administration services (eas), hyperion shared services, financial reporting studio, hyperion workspace, and hyperion smart view excel add in). ? experience with sql developer. ? proficiency with microsoft office suite 2013 / 2016 (word, excel, outlook, and project). work environment: ? this job operates in a professional office environment. ? this role?s hours vary depending on business activity but are generally 40 or more hours per week. travel requirements: this position does not require frequent travel.

1 Click Easy Apply

TalentEinstein.com - Superhuman AI Recruiting Assistant | Terms & Conditions

All rights reserved
Swanco LLC