Data Engineer (Principal Consultant #1086, 1858)

Illinois State Board of Education - Illinois, United States

Hiring: Data Engineer (Principal Consultant #1086, 1858) Company: Illinois State Board of Education Location: Illinois, United States Job Posted Time: 2026-09-16 13:35:22 Target Skills & Keywords : AWS, Azure, Data Warehouse, ELT, ETL, GCP, Git, Python, SQL, SQL Server, Shell, Snowflake About the job Experience: •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) •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) •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) Required Skills: •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. Qualifications: •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. •In-depth knowledge 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. •Knowledge of cloud-based data migration and implementation. Compensation: •$64,322 - $109,467 / year Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!