Principal Data Engineer & Data Warehouse Architect – ETL

Illinois State Board of Education; Illinois; On-site; USD 64,322 - 109,467; Full time

Job summary

Illinois State Board of Education is seeking a Data Engineer (Principal Consultant) to support the ISBE data warehouse. The role focuses on data architecture, data modeling, and ETL/ELT processes to enable informed decision making across agency initiatives.

The incumbent will work under supervision, collaborating with data engineers, analysts, and business stakeholders to deliver scalable data solutions and insights. Salary ranges are provided for Springfield or Chicago locations.

Qualifications

• Requires 5–8 years of experience in development and analysis.
• Experience with data warehousing concepts (star/snowflake schemas).
• Strong SQL skills and knowledge of data governance is a plus.

Responsibilities

• Develops, optimizes, and troubleshoots ETL/ELT processes from multiple sources.
• Supports data warehouse operations including data migration, reporting, and performance tuning.
• Collaborates with stakeholders to deliver scalable data solutions and dashboards.

Skills

ETL/ELT pipelines

SQL

Data warehousing

Data modeling

Git/version control

Education

Bachelor's degree in Computer Science

Associate's degree + 5-8 years experience

Tools

SQL Server

ETL tools

Data modeling tools

BI tools (Power BI/Tableau/Looker)

Job description

Illinois State Board of Education is seeking a Data Engineer (Principal Consultant) to support the ISBE data warehouse. The role focuses on data architecture, data modeling, and ETL/ELT processes to enable informed decision making across agency initiatives.

The incumbent will work under supervision, collaborating with data engineers, analysts, and business stakeholders to deliver scalable data solutions and insights. Salary ranges are provided for Springfield or Chicago locations.