Datawarehouse Lead (Software Solutions Lead #1934)

Illinois State Board of Education; Springfield (MA); On-site; USD 87,000 - 131,000; Full time

Job summary

Illinois State Board of Education seeks a Data Warehouse Lead to oversee the design, development, and maintenance of the ISBE data warehouse. You will lead a team of data professionals, manage ETL processes, and collaborate with business stakeholders to deliver data solutions.

Based in Springfield, IL, this exempt, full-time role requires strong leadership, data modeling expertise, and a track record of delivering data projects on time and with quality.

Qualifications

• Bachelor's degree in Computer Science or related IT field with at least five years of experience, or an Associate's degree with at least five years of related work.
• Minimum five years in data warehousing, data architecture, and ETL processes.
• Proven experience leading a team of data professionals.
• Proficiency in SQL Server, data modeling tools, ETL tools, and data warehousing technologies.
• Strong analytical and problem-solving skills; ability to translate business requirements to technical solutions.
• Excellent verbal and written communication; ability to explain complex concepts to non-technical stakeholders.

Responsibilities

• Oversees end-to-end development and implementation of data warehouse projects to meet business requirements and deadlines.
• Designs data architecture and models supporting storage, retrieval, and analysis.
• Assesses current architecture and recommends cloud migration strategies for efficient data management.
• Develops, optimizes, and maintains ETL processes for accurate data loading.
• Establishes data quality standards and governance for data accuracy, consistency, and security.
• Leads and mentors a team of data analysts to help achieve goals.
• Collaborates with stakeholders, IT, and departments to deliver data solutions.
• Maintains documentation of data warehouse architecture and procedures.
• Performs other duties as assigned.

Skills

Leadership

Project management

Verbal & written communication

Education

Bachelor's degree in Computer Science or related field

Associate's degree in IT field

Tools

Microsoft SQL Server

Data modeling tools

ETL tools

Data warehousing technologies

Job description

Datawarehouse Lead (Software Solutions Lead #1934)

Inventory #

1934

Location

Springfield

Union

Exempt

Department

Software Solutions

Full Salary Range

$87,132.1 - $130,698.14

Office Hours

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

Posted Date

August 5, 2026

Closing Date

Software Solutions Department is seeking a highly skilled and experienced Data Warehouse Lead to oversee the design, development, and maintenance of Illinois State Board of Education (ISBE) data warehouse. The ideal candidate will have a strong background in data architecture, data modeling, and ETL processes, along with excellent leadership and project management skills. This position functions under general supervision and reports to a Supervisor.

Duties and Responsibilities

• Oversees the end-to-end development and implementation of data warehouse projects, ensuring they meet business requirements and are delivered on time.
• Designs and implements data architecture and data models that support efficient data storage, retrieval, and analysis.
• Analyzes current data warehouse architecture and makes recommendations on cloud migration that ensures efficient data management.
• Develops, optimizes, and maintains ETL (Extract, Transform, Load) processes to ensure data is accurately and efficiently loaded into the data warehouse.
• Establishes and enforces data quality standards and governance policies to ensure the accuracy, consistency, and security of data.
• Leads and mentors a team of data analysts, providing guidance and support to help them achieve their goals.
• Works closely with business stakeholders, IT teams, and other departments to understand data requirements and deliver solutions that meet their needs.
• Maintains comprehensive documentation of data warehouse architecture, processes, and procedures.
• Performs other duties as assigned.

Required Qualifications

• Bachelor's degree in Computer Science or other IT related field with at least five years of experience, or, an Associate's degree in one of these fields with at least five 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, data architecture, and ETL processes.
• Proven experience in leading a team of data professionals.
• 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, Dataverse).

Preferred Qualifications

• Knowledge of cloud-based data migration and implementation.