Database GIS Specialist

Job Summary:

This position is accountable for development, operation and continuing appraisal of all Geographic Information System (GIS) applications in the Bureau of Programming, Program Development and Program Management Sections. Most of these applications will use data from a comprehensive project information system, Windows Program Planning System (WPPS), and other bureau applications including the Performance Based Project Prioritization (PBP) System that uses GIS files and Excel spreadsheets. Users of these applications are Office of Highways Project Implementation staff. This position provides secondary support for analysis and maintenance of WPPS and the preparation of detailed and summary project reports for inclusion in briefings to the departmental executive staff and to legislators. WPPS contains: 1) the departmental Multi-Year Highway Improvement Program (MYP) with the annual highway element identified; 2) other unfunded highway projects considered to be viable candidates by the Office of Planning and Programming and Regional Engineers; and 3) additional unfunded prioritized projects identified as long-range highway needs for new roads, capacity improvements, reconstruction and rehabilitation that require updating and monitoring on a routine basis.

Duties:

• Develops and evaluates the adequacy of the GIS applications reporting data from WPPS for all state highway
  systems as input to the state highway element of the MYP, the annual program, For the Record, and STIP
  publications.
• Develops and coordinates the use of the PBP to provide project analysis systematically and on request.
• Assists in the production of four annual publications: the MYP, the annual highway improvement program,
  For the Record, and the STIP.
• Maintains proficiency and competence in the use of Arc GIS software and the Microsoft Office Suite including,
  but not limited to, Word, Excel, and PowerPoint. Maintains proficiency and competence using Adobe Acrobat
  and Crystal Reporting software.
• Secondarily prepares numerous, diversified reports utilizing the project information contained in WPPS on
  an as needed basis for the OHPI and OPP.
• Evaluates proposals and revises procedures used for WPPS to ensure accurate and uniform reporting in
  GIS applications to all users. Reviews and revises all reporting formats to reflect the changing data
  requirements of all users.
• Prepares statistical summaries, reports and manuals that ensure maximum utility of WPPS information.
• Facilitates cooperation between central and district offices in the collection, processing and interpretation of
  highway project data.
• Advises district staff on operation of WPPS and assists in training activities with district staff.
• Provides and coordinates all aspects of Information Technology support to the Bureau of Programming.
• Performs duties in compliance with departmental safety rules. Performs all duties in a manner conducive to the fair and equitable treatment of all employees.
• Performs other duties as assigned.

Qualifications:

Required:

• Valid driver’s license
• Occasional travel

Desired:

• Completion of four years of college preferably with major courses in computer science, information technology or database management
• Five years of experience in information technology or database management, three years of which should be in developing applications using Arc GIS software and two years in database support
• Proficient in the use of Crystal Reports, Adobe Acrobat, and Excel software

Apply online at link included