Hyperion Administrator
Dallas, TX

Job Description

Become Part of Our Team

As an industry leader Balfour Beatty offers employees a comprehensive benefits package that includes competitive salaries, comprehensive medical, dental and vision benefits, paid time off and volunteer hours, education assistance and much more including:

* Medical, Dental, Vision and Life Insurance
* Health Savings Account
* 401(k) with company match
* Flexible Spending Accounts (Dependent & Medical Reimbursement)
* Vacation Time
* Sick Time
* Holidays
* Paid Personal Days
* Paid Volunteer time
* Tuition Assistance
* Employee Referral Bonus

Summary

At Balfour Beatty Construction in Dallas, Texas we are seeking a Hyperion Administrator. The role of the Hyperion Administrator is to act as a liaison between IT and the business regarding, but not limited to, the Hyperion environment and applications. This position will be responsible for the daily management, administration, and technical end user support of all Hyperion tools and related data/systems. Solution oriented consulting for new development work will also be a key function for this position.

Essential Functions

* Handle routine requests, such as adding and removing metadata in the Hyperion environment.
* Write calc scripts, business rules, and member formulas in Calculator and MDX language.
* Create and maintain data forms and financial reports.
* Write SQL statements to query data from Ledger system.
* Update and debug SQL Server stored procedures and views.
* Design & administer the security in the Hyperion environment.
* Perform data loads/exports, including data validation and consolidation of data; this includes performing month-end close responsibilities.
* Research and investigate data discrepancies and provide data validation reports.
* Maintain data mappings.
* Respond incidents/issues.
* Monitor and report system performance, availability, and utilization.
* Maintain open communication to team members and end users regarding system and data availability.
* Develop complex rule files to adjust feeds for data loading, dimension building and modified existing rule files.
* Develop and deliver progress reports, proposals, requirements documentation, and presentations.
* Build, develop, and grow any business relationships vital to the success of projects.

Minimum Requirements

* High School Diploma or GED Equivalent.
* 5 years or more of experience in Hyperion Planning, Essbase, Financial Reporting and Shared Services administration/development.
* Understanding of ETL processes.
* Experience with PBCS plan type data maps and data replication.
* Essbase BSO and ASO member formulas.
* PBCS backup and recovery, both full and incremental.
* PBCS migrations / LCM (part or whole).
* High level Smart View expertise.

Preferred Experience

* Bachelor's degree in Accounting, Finance or Computer Science preferred.
* Oracle Data Integrator and Hyperion Data Relationship Management experience preferred.
* Solid experience using MS Office 2007, Windows XP and Windows Server 2003; Windows 7 experience preferred.
* Finance and Accounting experience is preferred.
* Reacts to project adjustments and alterations promptly and efficiently.
* Flexible during times of change.
* Prior project management & business analysis experience is nice-to-have.
* Experience at working both independently and in a team-oriented, collaborative environment.
* Conform to shifting priorities, demands and timelines through analytical and problem-solving capabilities.
* Reacts to project adjustments and alterations promptly and efficiently.
* Ability to work directly with end users and create requirements, design docs, test plans, etc.
* Demonstrated ability to anticipate potential problems/act in a proactive manner.
* Strong written, oral and interpersonal skills.

About Us

Balfour Beatty US is an industry-leading provider of general contracting, at-risk construction management and design-build services for public and private sector clients across the nation. Performing heavy civil and vertical construction, our teams build the unique structures and infrastructure that play an important role in how people live, work, learn and play in our communities. Our teammates have an instinctive passion for innovating that is fueled by a relentless curiosity, a drive to employ lean practices and processes and the determination to find a better way. Through Zero Harm®, we are challenging the construction industry's assumptions about safety. We believe that no level of harm should come to anyone as a result of our business.

Consistently ranked among the nation's largest building contractors, by Engineering News-Record, our US business is a subsidiary of London-based Balfour Beatty plc (LSE: BBY).

Balfour Beatty is an equal opportunity employer that recognizes the value of a diverse workforce. All qualified individuals will receive consideration for employment without regard to race, color, age, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, genetic information, or any other criteria protected by federal, state or local law.

Accessibility: If you need an accommodation as part of the employment process please contact Human Resources at

Phone: 214-451-1177

Email: hrcontact@balfourbeattyus.com

Equal Opportunity Employer, including disabled and veterans.

If you want to view the EEO is the Law poster, please choose your language: