Find & Apply For Database Architect Jobs in Chicago, Illinois

This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13815907 This position is a union position; therefore, provisions of the relevant collective bargaining agreement/labor contract apply to the filling of this position. All applicants who want to be considered for this positionMUST apply electronically through the illinois.jobs2web.com {target="_blank" rel="noopener"} website. State of Illinois employees should click the link near the top left to apply through the SuccessFactors {target="_blank" rel="noopener"} employee career portal. Applications submitted via email or any paper manner (mail, fax, hand delivery) will not be considered. Why Work for Illinois? Working with the State of Illinois is a testament to the values of compassion, equity, and dedication that define our state. Whether youre helping to improve schools, protect our natural resources, or support families in need, youre part of something biggersomething that touches the lives of every person who calls Illinois home. No matter what state career youre looking for, we offer jobs that fit your life and your scheduleflexible jobs that provide the gold standard of benefits. Our employees can take advantage of various avenues to advance their careers and realize their dreams. Our top-tier benefits and great retirement packages can help you build a rewarding career and lasting future with the State of Illinois. Position Overview This position is accountable for managing the highway inventory data activities. This position implementshighway data policies, develops procedures for the collection, processing, analysis of highway inventory data,trains central and district office staff in these procedures, and coordinates the geographic information system(GIS) activities related to highway inventory data. This position has accountability as the system owner of theIllinois Roadway Information System (IRIS), responsibility for generating the roadway data files for required federal data submittals, and for roadway statistical publications. This data provides the department with the capability to meet the information needs for state reporting, Federal Highway Administration (FHWA)requirements, and other management systems. ## Essential Functions

• Develops review procedures to ensure the accuracy and validity of the Illinois Roadway InformationSystem (IRIS) system file.
• Advises and directs staff to provide consistent and complete support for the districts regarding proceduresfor the collection, processing, and analysis of highway inventory data.
• Directs the timely submittals of all Federal Highway Administration (FHWA) required roadway relateddata submittals.
• Utilizes geographic information system (GIS) applications, other geographical based software to assistin the review of data, GIS based plots, and reports produced from the data.
• Develops and generates Microsoft Access and structured query language (SQL) queries to create annualreports, publications, special reports, summaries on both an annual basis, and as requested by users.
• Maintains the GIS base layers to ensure the accurate geographical and data representation of theroadway network.
• Directs and advises the districts of needed revisions of data errors detected through edit checks.
• Works with other unit staff in coordinating changes with roadways, Highway Performance MonitoringSystem (HPMS), structures, railroads, traffic, and GIS that will influence the other parts of the IRISsystem.
• Performs duties in compliance with departmental safety rules. Performs all duties in a manner conduciveto the fair and equitable treatment of all employees.
• Performs other duties as assigned. ## Minimum Qualifications
• Completion of a bachelors degree majoring in business, mathematics, or computer science, PLUStwo years of experience in managing and analyzing data, OR Eight years of experience in managingand analyzing data.

## Preferred Qualifications Strong working knowledge of Microsoft Access, Microsoft Excel, and Environmental Systems Research Institute (ESRI) ArcGIS. Ability to develop custom queries and reports against both current and historical tables, includinggenerating summary information, pivot tables, and charts for reporting current and historical roadwaydata. Working knowledge of the departmental transportation data systems. Supervisory experience. Ability to analyze federal and state data regulations to comply with reporting requirements.<