Essbase Hyperion Consultant (Locals to IL)

Posted 2 days ago

sonoma consultingOak Brook (IL)

Data Warehousing Specialists Computer Systems Design Services

SENIORITY

Senior

Apply

About the role

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 50101 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 Consultant, Hyperion Developer, Hyperion Consultant, Data Analyst

Before you apply

Applying takes about a minute. These four things decide how fast it moves after that.

Your profile is current

It's what we read first. Occupations, seniority and locations matter more than a long history.

Two examples you can talk through

Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.

A number in mind

What you're on now and what would make you move. We negotiate better when we know both.

Your notice period

Employers plan around it, and it's the question that stalls offers most often.

Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.