BI ETL Consultant

Dunn Solutions Group; Skokie (IL); On-site; USD 70,000 - 90,000; Full time

Job summary

Dunn Solutions Group is seeking an experienced ETL Developer in Skokie, Illinois, to ensure accuracy and integrity of ETL processes. Ideal candidates will possess 1–3 years of relevant experience and a Computer Science degree.

The role involves hands-on development using various ETL tools and strong SQL skills while adhering to Kimball best practices in data design.

Qualifications

• 1–3 years of experience in ETL development or data analysis.
• Hands-on experience with designing data marts following best practices.
• Deep technical knowledge of SQL.

Responsibilities

• Ensure accuracy and integrity of ETL processes.
• Engage in analysis, design, coding, testing, and documentation.
• Develop and maintain data structures efficiently.

Skills

ETL development

SQL

Data Mart design

Kimball best practices

NoSQL databases

Big Data technologies

Education

Computer Science degree

Tools

SAP Data Services

Informatica

SSIS

Talend

Pentaho

Hadoop

Hortonworks

Job description

Job Description

1–3 years of experience.

• 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 (e.g., Hadoop, Hortonworks).
• Experience with NoSQL databases.
• Experience with 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 (e.g., Hadoop, Hortonworks).
• Experience with NoSQL databases.
• Experience with IoT (Internet of Things).

Additional Information

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