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 SQL skills.
- 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
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.
How to Apply
To view full posting and apply electronically, please visit https://www.isbe.net/Lists/ISBECareers/CareerDisplayForm.aspx?ID=1170. Interested parties must submit the required application, cover letter, resume, and transcripts (unofficial until recommended for hire). The subject line should include the position number(s) you are applying for.