Role: Hyperion Essbase Consultant
Experience Required: 5+ years
Duration: 6+ Months
Location: Remote
Time Zone: Easter Time Zone
Required Skills: Essbase Administration SQL SSIS Visual Studio VB Script/VBA SmartView Essbase Cubes
Background
Clients are changing their fiscal year to the calendar year and are needing to modify/update data connections, data integration, and reports to ensure reports/reporting tools are able to accommodate this change.
Environment
-
Hyperion Essbase on prem with integrated with Lawson
-
Roughly 8 cubes in their cube farm, in the process of upgrading Essbase and taking advantage of more Automation
-
SQL Server databases
-
SQL- Stored procedures and SSIS
-
VB and Excel
Requirements
-
Visual Studio – SSIS integrations
-
Visual Basic coding
-
SQL queries
-
Hyperion/Essbase
-
Data loading
-
ASO Cube Calculations
-
BSO Cube Calculations
-
Drill down concepts
-
Debugging incorrect data
