Essbase Hyperion Consultant (Locals to IL)
- Location
- Oak Brook, IL · On-site
- Job type
- Contract
- Level
- Mid-level
- Listed
- Today
Skills & highlights for this role
- Essbase
- relational databases
- ETL
Also useful
- star schema data warehouse design
- financial processes
How well does your resume fit this job?
Upload your resume to see your score for this Sonoma Consulting Inc. role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
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.
Qualifications & Requirements
Knowledge of Essbase, relational DB and financial processes are needed. Insurance experience would be extremely helpful.
Skills: Essbase, Multidimensional, Hyperion, Data warehouse, ETL
Title: Essbase Conusltant, Hyperion Developer, Hyperion Consultant, Data Analyst,
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
Additional Information: H1b, US Citizens, GC, EAD and TN Permit.
From Sonoma Consulting Inc.'s careers page, first listed on Rolev.ai on November 19, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Essbase Hyperion Consultant (Locals to IL) role at Sonoma Consulting Inc., it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
- .Net DeveloperRaks Group LLC · Minneapolis, MN
- Senior Snowflake Data EngineerExperient · Charlotte, NC
- Oracle ETL Developer - Rensselaer, NY - 24 Months - # 17231/110645Maganti IT Resources LLC · Rensselaer, NY
- SQL DeveloperReveille Technologies Inc. · Houston, TX
- Oracle APPS Developer with EBSVui Inc. · Charlottesville, VA
- SQL DB DeveloperEsolvit Inc. · Austin, TX
More at Sonoma Consulting Inc.
All Sonoma Consulting Inc. jobsCommon questions
Where is the Essbase Hyperion Consultant (Locals to IL) job at Sonoma Consulting Inc. located?
This Essbase Hyperion Consultant (Locals to IL) position at Sonoma Consulting Inc. is located in Oak Brook, IL (On-site). Always check Sonoma Consulting Inc.'s application page for specific state eligibility or relocation policies.
What qualifications are required for Essbase Hyperion Consultant (Locals to IL) at Sonoma Consulting Inc.?
For the Essbase Hyperion Consultant (Locals to IL) role, Sonoma Consulting Inc. highlights experience with Essbase, relational databases, ETL. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the Essbase Hyperion Consultant (Locals to IL) position at Sonoma Consulting Inc.?
This listing links directly to Sonoma Consulting Inc.'s SmartRecruiters application page. You can apply directly on Sonoma Consulting Inc.'s site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.