Essbase/Hyperion to EDW Data Warehouse Consultant

Sonoma Consulting Inc.; Oak Brook (IL); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading IT consultancy seeks an Essbase Hyperion Consultant to migrate data from a Hyperion Planning environment to an Enterprise Data Warehouse. The successful candidate will translate multi-dimensional structures into relational formats and document data relationships. Knowledge of Essbase, relational databases, along with financial processes is essential. Candidates with insurance experience will be highly regarded. This opportunity is based in Oak Brook, Illinois.

Qualifications

• Knowledge of Essbase, relational databases, and financial processes required.
• Experience with data migration and transformation processes.
• Familiarity with star schema format is necessary.

Responsibilities

• Migrate data from Essbase to the Enterprise Data Warehouse.
• Translate hierarchical structures into relational formats.
• Document and map data relationships.

Skills

Essbase

Multidimensional

Hyperion

Data warehouse

ETL

Job description

Essbase Hyperion Consultant (Locals to IL)

• Contract

Company Description


Halo Group is a premier provider of IT talent. We place technology experts within
the teams of the world’s leading companies to help them build innovative
businesses that keep them one step closer to their customers and one step
ahead of the competition. We offer a meaningful work environment for
employees, attractive and interesting engagements for consultants, and cutting-edge
digital innovation for our customers.

We delight in helping our customers execute their digital vision. Big projects or
small, Halo Group knows that by combining the highest quality talent with our
unwavering support, we will become an invaluable extension of the team. Halo
Group's experienced consultants in Detroit, Atlanta and Dallas specialize in all
areas of product/project governance, UX/UI, multi-platform applications, quality
assurance/testing, cloud computing, and data analytics.

Since its inception, Halo Group has been recognized for numerous awards, including:

- INC 5000
- Future 50
- 101 Best and Brightest
- Michigan 50 Companies to Watch
- Goldline Research - “Most Dependable Companies”
- Ernst & Young - “Entrepreneur of the Year” Finalist


Job Description:

Looking to migrate data from our Hyperion Planning environment where the data is stored in an Essbase multi-dimensional database, into our Enterprise Data Warehouse.

• This involves taking the fragmented multi-dimensional hierarchical structures and translating them into meaningful relational structures.
• The hierarchical data needs to be aligned across each dimension into meaningful business grouping and terms that can be stored in a relational / star schema format.
• Data relationships need to be identified, documented and mapped.
• Work with Kemper data architect to determine the best EDW target structures (star schema).
• Document data transformations for the ETL developer.
• Test data loaded from Essbase into the EDW for completeness and accuracy.

Knowledge of Essbase, relational DB and financial processes are needed. Insurance experience would be extremely helpful.


H1b, US Citizens, GC, EAD and TN Permit.

Skills: Essbase, Multidimensional, Hyperion, Data warehouse, ETL
Title: Essbase Conusltant, Hyperion Developer, Hyperion Consultant, Data Analyst,

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply