Hybrid Highway Data Manager: GIS & SQL Lead

State of Illinois; Springfield (IL); Hybrid; USD 61,000 - 108,000; Full time

Benefits offered by this job

Flexible work schedules

Hybrid scheduling

Health, Life, Vision, and Dental

Job summary

State of Illinois invites qualified applicants for the Highway Data Manager role within the Department of Transportation. The position oversees the Illinois Roadway Information System (IRIS), manages highway inventory data, and ensures timely federal data submissions.

You will train staff, develop data procedures, and coordinate GIS work with districts while supporting public reporting needs and data quality controls in a hybrid office setting.

Qualifications

• Bachelor’s degree in business, mathematics, or computer science; plus two years of data management/analysis experience, OR eight years of data management/analysis experience.
• Knowledge of MS Access, Excel and ESRI ArcGIS required for data tasks.
• Ability to develop and run SQL queries, reports, pivot tables, and charts for federal/state roadway data.

Responsibilities

• Manage highway inventory data activities and implement highway data policies.
• Develop procedures for collection, processing, and analysis of highway inventory data; train staff.
• Coordinate GIS activities related to highway inventory data and IRIS system ownership.
• Generate roadway data files and publications for federal data submittals.

Skills

Microsoft Access

Microsoft Excel

ESRI ArcGIS

SQL

Data analysis

Supervisory experience

Communication skills

Education

Bachelor’s degree in business, mathematics, or computer science

Tools

SQL queries

Job description

State of Illinois invites qualified applicants for the Highway Data Manager role within the Department of Transportation. The position oversees the Illinois Roadway Information System (IRIS), manages highway inventory data, and ensures timely federal data submissions.

You will train staff, develop data procedures, and coordinate GIS work with districts while supporting public reporting needs and data quality controls in a hybrid office setting.