Data Engineer (Principal Consultant #1086, 1858)

Illinois Education Job Bank; Chicago (IL); Hybrid; USD 64,000 - 109,000; Full time

Job summary

Illinois State Board of Education is seeking a Data Engineer (Principal Consultant) to support the ISBE data warehouse initiatives. The role focuses on data architecture, modeling, ETL/ELT processes, and collaboration with stakeholders to deliver scalable data solutions.

The position requires 5–8 years in data warehousing, SQL Server expertise, and strong analytical, communication, and documentation skills, with preference for BI tool experience (Power BI, Tableau, Looker) and cloud familiarity.

Qualifications

• Bachelor's degree in Computer Science or other IT related field with 5-8 years of experience, or, an Associate's degree in one of these fields with 5-8 years of experience performing development and application analysis work. (COPY OF TRANSCRIPTS REQUIRED AT TIME OF APPLICATION)
• Minimum of five years of experience in data warehousing and relational databases.
• Hands-on experience with data warehousing concepts (Star Schema, Snowflake, fact/dimension tables).
• Proficiency with ETL/ELT tools and data integration technologies.
• Proficiency in Microsoft SQL server, data modeling tools, ETL tools and data warehousing technologies.
• Strong understanding of database concepts and data modeling.
• Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
• Excellent verbal and written communication skills, with the ability to effectively communicate complex technical concepts to non-technical understanding of ISBE application framework to troubleshoot and support user interfaces (e.g., Data Quality Dashboard, Illinois Report Card, My Data Dashboard, data verse.)
• GIT version control ability to translate business needs into technical requirements.
• Excellent communication and documentation skills.

Responsibilities

• Develops, optimizes, and troubleshoots ETL/ELT processes to extract, transform, and load data from multiple sources.
• Supports ongoing data warehouse operations such as data migration, reporting, analysis, troubleshooting, and performance tuning.
• Collaborates with data engineers, analysts, and business stakeholders to deliver scalable data solutions.
• Interprets data and analyzes results using statistical techniques and provides ongoing reports.
• Creates and maintains documentation on large scale data warehouse models and processes.
• Identifies, analyzes, and interprets trends or patterns in complex data sets.
• Supports reporting and BI tools by preparing datasets, building queries, and optimizing data access.
• Participates in data governance, quality initiatives, and best practice development.
• Performs other duties as assigned.

Skills

Strong analytical and problem-solving

Excellent verbal and written comms

GIT version control

Microsoft SQL Server

Education

Bachelor's degree in Computer Science or related IT field

Associate's degree in IT field

Tools

Power BI

Tableau

Looker

Azure

AWS

Google Cloud

Job description

Data Engineer (Principal Consultant #1086, 1858)

Duties

Software solutions department is seeking a skilled and experienced Data Engineer to provide support for Agency initiatives revolving around the ISBE data warehouse. The ideal candidate will have a strong background in data architecture, data modeling, and Extract, Transform, Load (ETL) processes. This position functions under general supervision and reports to a supervisor.

Duties and Responsibilities:

• Develops, optimizes, and troubleshoots ETL/ELT processes to extract, transform, and load data from multiple sources.
• Supports ongoing data warehouse operations such as data migration, reporting, analysis, troubleshooting, and performance tuning.
• Collaborates with data engineers, analysts, and business stakeholders to deliver scalable data solutions.
• Interprets data and analyzes results using statistical techniques and provides ongoing reports.
• Creates and maintains documentation on large scale data warehouse models and processes.
• Identifies, analyzes, and interprets trends or patterns in complex data sets.
• Supports reporting and bi tools by preparing datasets, building queries, and optimizing data access.
• Participates in data governance, quality initiatives, and best practice development.
• Performs other duties as assigned.

Qualifications

Required Qualifications:

• Bachelor's degree in Computer Science or other IT related field with 5-8 years of experience, or, an Associate's degree in one of these fields with 5-8 years of experience performing development and application analysis work. (COPY OF TRANSCRIPTS REQUIRED AT TIME OF APPLICATION)
• Minimum of five years of experience in data warehousing and relational databases.
• Hands-on experience with data warehousing concepts (Star Schema, Snowflake, fact/dimension tables).
• Proficiency with ETL/ELT tools and data integration technologies.
• Proficiency in Microsoft SQL server, data modeling tools, ETL tools and data warehousing technologies.
• Strong understanding of database concepts and data modeling.
• Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
• Excellent verbal and written communication skills, with the ability to effectively communicate complex technical concepts to non-technical understanding of ISBE application framework to troubleshoot and support user interfaces (e.g., Data Quality Dashboard, Illinois Report Card, My Data Dashboard, data verse.)
• GIT version control ability to translate business needs into technical requirements.
• Excellent communication and documentation skills.

Preferred Qualifications:

• Experience with BI tools (Power BI, Tableau, Looker).
• Knowledge of cloud-based data migration and implementation.
• Knowledge of scripting languages (Python, Shell).
• Background in education data and reporting background in data governance, data quality, or master data management.
• Familiarity with cloud data platforms (e.g., Azure, AWS, Google Cloud).
• Familiarity with AI technology and tools.

Salary/Benefits

Union: IFSOE

Department: Software Solutions

Anticipated Starting Salary Range: $64,322 - $81,284

Full Salary Range: $64,322 - $109,467

Office Hours: Monday – Friday 8:00 a.m. – 5:00 p.m.

District Name IL State Board of Education Building Name Address 555 West Monroe Street Suite 900
Chicago, IL 60661 Phone [phone] Fax [phone] IASA Region Abe Lincoln County Sangamon Employment Type Full-time permanent Job Category Agency/Association Grade Level Other