GIS Coordinator – PW

Essential Functions

Display honest, trustworthy, and ethical behavior when dealing with internal and external customers.

Establish and maintain cooperative working relationships with those contacted in the course of work.

Regular attendance that is punctual and dependable is required.

Administers the Public Works versioned enterprise geodatabase, designs and creates new spatial datasets, tables, and route systems manages user access to geospatial data and creates/maintains coded value domains, attribute rules, and database sequences.

Performs complex queries and data analysis of GIS datasets and tabular data.

Responsible for the creation, maintenance, and quality control of all Public Work GIS data.

Assists in the preparation and evaluation of Requests for Proposals for Engineering and GIS consultant services.

Administration, configuration, and training/user support of OpenGov/Cartegraph OMS and Cartegraph Asset Management including interface customization, GIS integration, user administration, role administration, import/export administration, automation manager, record filter administration, scenario builder, structure manager, etc.

Integrate GraniteNet pipe inspection data with GIS.

Designs and develops custom software code for GIS applications.

Integrates the Public Works GIS database into vendor supplied solutions.

Conducts user needs assessments and recommends implementation of GIS needs and development of future GIS related products.

Designs, develops and maintains Public Works GIS database schemas and documentation.

Assists in designing, developing, and implementing GIS workflows.

Responsible for the development of plans and procedures for effective integration or transfer of GIS data from various sources into usable databases.

Assigns, tests and manages security policy groups and user permissions to digital information.

Demonstrate and explain computer system software capabilities to potential users provide specialized training, software and data support, and mentoring for City staff.

Serve as technical advisor to and is a member of the joint Grand Island – Hall County GIS Committee.

Interact with Federal, State, County, City and other agencies on the exchange and utilization of GIS and GPS information.

Coordinate the Public Works Department’s geographic information system including spatial and non-spatial database design, maintenance, customizing, programming and mapping. Use ESRI software products manages the development, implementation, dissemination, analysis, and maintenance of the GIS databases, map layers and related engineering data. Coordinate planning of related interdepartmental GIS projects.

Acquire or develop software and reports to support network analyses needed by the Public Works engineers.

Respond to inquiries regarding GIS data, records and mapping information identify, compile, and generate specific maps given situational requests utilizing CADD files and topography attributes for assigned projects analyze results, so that applications can be specifically designed for individual users or departments.

Oversee and monitor the department’s computerized infrastructure model and system network validate data entry, analyze scenarios, and calibrate results for accuracy.

Create and maintain the dynamic, interactivity of the City’s internet ‘home’ page updating the departmental web pages with relative GPS and GIS information and working with other city departments in developing their individual web pages, on-line forms, and training their personnel in how to maintain this data.

Provide budgetary recommendations regarding equipment purchases and software applications. Review and make recommendations concerning outside services and materials.

Automate tasks such as Public Works sewer connections, locations and associated fees.

Develop data collection contracts to collect data for such things as pavement management, traffic signs, drainage, and other public works related infrastructure.

Perform related duties as assigned.

Qualifications

Knowledge of:

Principles of engineering as applied to surveying, design, and construction work.

Geographic Information Systems (GIS) technology and Computer Aided Drafting (CAD) methods including database design and management, programming and customization, cartography and map design.

Software used to perform GIS activities including ESRI’s software products.

Data collection methods and technologies including methods of surveying and understanding of high accuracy GPS systems.

Project, coordinate systems and conversion techniques as they pertain to GIS and GPS.

Relational Database Management Systems as it pertains to spatial data, implementation, and administration.

GIS data models used for analysis of utility infrastructure and geographic networks and skill to perform topological corrections of data.

Microsoft Windows software, specific application software asset management and database management systems.

Programming for customizing GIS and related resources including Python, Arcade, Java, Visual Basic, and SQL.

Ability to:

Provide advance data query for SQL, flat file and other data formats.

Learn and apply techniques associated with the development and administration of GIS systems.

Analyze, manipulate and interpret data to reach logical conclusions.

Troubleshoot complex technical issues and solve problems.

Communicate effectively both orally and in writing.

Represent the City in a professional manner to outside agencies.

Perform a leadership role within a committee.

Respond to and resolve citizen concerns and requests for service.

Create detailed maps from CADD files, spatial and non-spatial databases, and geographic attribute records.

Analyze, program, implement, maintain and support GIS and web-based applications.

Supplemental Information