Back to jobs

BI ETL Consultant

Skokie, IL, United States

Pay
Pay not listedSimilar roles state $127K–$190K
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting
Apply at Dunn Solutions Group

What you’ll work on

Full posting
  • Ensure accuracy and integrity of ETL through analysis, design, coding, testing and documentation

  • Design data marts and star schemas following Kimball best practices

  • Develop hands-on ETL solutions in one or more tools

From the employer’s posting
Ensure accuracy and integrity of ETL; analysis, design, coding, testing and documentation
Hands-on experience with designing data marts / star schemas following Kimball best practices
Hands-on ETL developer (in one or more tools)

What you’ll bring

All qualifications

Core experience

  • 1-3 years of experience
  • Deep technical knowledge and hands-on SQL experience
  • Hands-on ETL development in one or more tools
  • Hands-on experience designing data marts or star schemas
  • Computer Science degree

Preferred experience

  • Experience with SAP Data Services, Informatica, or SSIS
  • Experience with Talend or Pentaho
  • Experience with big data technologies such as Hadoop or Hortonworks
Qualification wording
1- 3 years of experience
Deep technical knowledge and hands-on experience with SQL
Hands-on ETL developer (in one or more tools)
Hands-on experience with designing data marts / star schemas following Kimball best practices
Computer Science degree
Experience with SAP Data Services or Informatica or SSIS (or any combination)
Experience with Talend or Pentaho
Experience with big data technologies and implementations (i.e. Hadoop, Hortonworks)

Tools in this posting

  • SQL
  • Hadoop
  • NoSQL
  • SAP
Source — Tool mentions in context
Technical Skills Ensure accuracy and integrity of ETL; analysis, design, coding, testing and documentation Hands-on ETL developer (in one or more tools) Hands-on experience with designing data marts / star schemas following Kimball best practices Deep technical knowledge and hands-on experience with SQL Computer Science degree Pluses
Pluses Experience with SAP Data Services or Informatica or SSIS (or any combination) Experience with Talend or Pentaho Experience with big data technologies and implementations (i.e. Hadoop, Hortonworks) Experience with NoSQL databases IOT (Internet of Things) Qualifications
Qualifications Experience with SAP Data Services or Informatica or SSIS (or any combination) Experience with Talend or Pentaho Experience with big data technologies and implementations (i.e. Hadoop, Hortonworks) Experience with NoSQL databases IOT (Internet of Things) Additional Information

Posting record

Report an error

Open 3 monthsWe first saw this posting 118 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jul 3, 2026 · 118 days ago
Recorded sightings
36
Last seen by us
Oct 30, 2026
Employer says posted
Jan 18, 2016

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

Your next step

  • Have your resume and examples of relevant work ready.
  • Check the listed location, eligibility and core experience before starting.
  • Ask the employer about the pay range before committing time to the process.

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

Job Description

Experience

    1- 3 years of experience

Technical Skills

    Ensure accuracy and integrity of ETL; analysis, design, coding, testing and documentation
    Hands-on ETL developer (in one or more tools)
    Hands-on experience with designing data marts / star schemas following Kimball best practices
    Deep technical knowledge and hands-on experience with SQL
    Computer Science degree

Pluses

    Experience with SAP Data Services or Informatica or SSIS (or any combination)
    Experience with Talend or Pentaho
    Experience with big data technologies and implementations (i.e. Hadoop, Hortonworks)
    Experience with NoSQL databases
    IOT (Internet of Things)

Qualifications

 Experience with SAP Data Services or Informatica or SSIS (or any combination)
    Experience with Talend or Pentaho
    Experience with big data technologies and implementations (i.e. Hadoop, Hortonworks)
    Experience with NoSQL databases
    IOT (Internet of Things)

Additional Information

All your information will be kept confidential according to EEO guidelines.

Company Description

Dunn Solutions Group is a full-service information technology consulting firm. We bring exceptional strategic experience, design skills and technology expertise to every project, plus complementary capabilities in client education.

 Focused on the business intelligence, application development and web/portal spaces, Dunn Solutions Group delivers services worldwide through offices in Chicago, Minneapolis, Raleigh, St. Louis, and Bangalore, India.

 We work closely with our software vendor partners including SAP, Liferay, Microsoft, Informatica and others to deliver solutions to our clients.

 Our IT professionals and business experts bridge the gap between business needs and technical solutions. Over the years, we have cultivated our experience and knowledge in a large number of industries and technologies in order to provide our customers with the most valuable solutions possible.



Specialties

Business Intelligence, Custom Application Development, Mobile Applications, Data Warehousing, Portals, E-Commerce

Website

http://www.dunnsolutions.com


Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Skokie, IL, United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

See how this role fits your experience

Add your resume to compare the role’s scope, tools and requirements with your experience.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.