BI ETL Consultant

Posted 2 Months 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

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

Temporary Cashier

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

Hex Logo Hex

Revenue Operations Director

Artificial Intelligence • Big Data • Software • Analytics • Business Intelligence • Big Data Analytics
Remote or Hybrid
United States
160 Employees
190K-250K Annually

Morningstar Logo Morningstar

Quantitative Analyst

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Hybrid
Chicago, IL, USA
11500 Employees
100K-500K Annually

PwC Logo PwC

Data Scientist

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
2 Locations
370000 Employees
77K-202K Annually

Similar Companies Hiring

Ford Energy Thumbnail
Automotive • Software • Energy • Utilities • Manufacturing • Renewable Energy
Glendale, Kentucky
55 Employees
Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
70 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
30 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account