The Role
Develop, maintain and optimize Essbase/Hyperion cubes (primarily ASO, some BSO), build backend data marts with Oracle PL/SQL, create Smart View reports and custom toolbars, manage Hyperion Planning apps, automate builds with AutoSys and Unix scripting, and act as SME for future development.
Summary Generated by Built In
Job Description
Hello,
Hope you are doing well.
Job Title:Essbase (Hyperion) Developer
Position Type: Contract to Hire
Location:PLANO, TX
Job Description:
- Analyzing Requirements and translating requirements into Technical specs for Design and Development of Essbase Cubes in ASO Model ( 75%) and BSO Model (25%)
- Hands on Development of backend data marts Oracle PL-SQL Programming for building Essbase Hierarchy Views/ Fact Views
- Hand on Development of Smart View Reports / Custom Took Bar Maintenance ( using VB Scripting)
- Maintaining Hyperion Planning Applications - Changes to Web forms, User Security, Business Rules Modification and Hierarchy updates and Data Loads.
- Hand On Development and Maintenance of Autosys Scheduler Jobs for Essbase Cube builds
- Learn existing Essbase Footprint to develop into SME for future Development activities.
- Comprehensive experience in creation of Essbase applications, Essbase cubes including Analytic outlines, dimension build rules, data load rules, Workflows, user security, Calculation Scripts and Reports
- Expertise in developing Essbase applications involving BSO/ASO, Essbase Studio, Smart View, Administrative Services, LCM.
- Skilled in administering, automation, optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environments.
- Strong with Hyperion versions 11.x
- Strong with Oracle Database ( All Metadata and Data sourced from Oracle Database )
- Auto Sys Scheduling tool & Unix / Shell Scripting
Required Skills
- Must have 5 to 7 years of Experience in Essbase Cubes development,
- Experience with the following technologies ASO Model Cube Design/ Development. Performance Tuning ASO Model Cube
- Experience with at least 2 end to end Hyperion planning Implementations
- Experience with Web forms, Task Lists, Business Rules , Shared Services Security Provisioning
- Building Essbase Cubes using Essbase Studio and Data Mart framework Experience in MAXL, MDX, Smart View, Essbase Toolbar Customization using VB Scripting
- Understanding the customization process for SmartView and having the ability to create custom reports and workflows
- High Proficiency with Oracle PLSQL programing
- Must have Unix shell scripting experience
All your information will be kept confidential according to EEO guidelines.
Skills Required
- 5 to 7 years of experience in Essbase cube development
- Experience designing and developing ASO and BSO model cubes and performance tuning ASO
- At least 2 end-to-end Hyperion Planning implementations
- Experience with Essbase Studio and Data Mart framework for building cubes
- High proficiency in Oracle PL/SQL programming
- AutoSys scheduling tool experience
- Unix / Shell scripting experience
- Experience with MAXL, MDX, and Smart View
- Essbase toolbar customization and Smart View report customization using VB scripting
- Experience with Web Forms, Task Lists, Business Rules, Shared Services security provisioning
- Experience administering, automating, optimizing, and performance tuning Essbase applications and migrations
- Familiarity with Hyperion versions 11.x
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Randstad is a global leader in the HR services industry and a Dutch multinational human resource consulting firm. Founded in 1960 and headquartered in Diemen, Netherlands, it provides outsourcing, staffing, consulting, and workforce solutions. The company connects job seekers with employers across various sectors, including finance, technology, healthcare, and manufacturing, helping people secure rewarding jobs and stay relevant in the ever-changing world of work.
