BI ETL Consultant

Posted 25 Days Ago
Be an Early Applicant
Skokie, IL, USA
In-Office
Junior
Big Data • Cloud • eCommerce • Software
The Role
Design, develop, test and document ETL processes and ensure data accuracy and integrity. Build data marts/star schemas using Kimball best practices. Perform hands‑on ETL development and advanced SQL work. Collaborate on analysis, coding, and testing; apply big data and NoSQL knowledge as needed.
Summary Generated by Built In
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

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.

Skills Required

  • 1-3 years of experience
  • Hands-on ETL development experience (one or more ETL tools)
  • Design data marts / star schemas following Kimball best practices
  • Deep technical knowledge and hands-on experience with SQL
  • Computer Science degree
  • Experience with SAP Data Services
  • Experience with Informatica
  • Experience with SSIS (SQL Server Integration Services)
  • Experience with Talend
  • Experience with Pentaho
  • Experience with big data technologies (Hadoop, Hortonworks)
  • Experience with NoSQL databases
  • Experience with IoT (Internet of Things)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Skokie, IL
75 Employees
Year Founded: 1988

What We Do

Dunn Solutions Group is a digital commerce & business transformation consultancy focused on delivering velocity to our clients. DSG helps our clients achieve speed by automating business processes (application development), and direction using advanced analytics.

Similar Jobs

PwC Logo PwC

Tax - Japanese Business Network - Intern - Winter 2028 - Destination CPA

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
7 Locations
370000 Employees
29K-48K Hourly

Tapestry - Coach and Kate Spade Logo Tapestry - Coach and Kate Spade

Sales Associate III

eCommerce • Fashion • Retail • Sales • Wearables • Design
Hybrid
Aurora, IL, USA
16000 Employees
15-20 Hourly

Tapestry - Coach and Kate Spade Logo Tapestry - Coach and Kate Spade

Temporary Sales Associate

eCommerce • Fashion • Retail • Sales • Wearables • Design
Hybrid
Schaumburg, IL, USA
16000 Employees
15-20 Hourly

Capital One Logo Capital One

Sr. Associate, Travel Call Center Quality Operations

Fintech • Machine Learning • Payments • Software • Financial Services
Hybrid
4 Locations
55000 Employees
81K-111K Annually

Similar Companies Hiring

Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees
Revel.io Thumbnail
Aerospace • Hardware • Robotics • Software
US
50 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account