GIS Analyst (Water Utility)

This is responsible program coordination, technical and professional work in the Water Utility. The position assists Mapping Section program coordinator in mapping system activities, providing technical support to Utility Engineering and field staff. This position has responsibility for implementation of the Utility’s field record system (field viewing computer records) and use of the automated mapping system by staff at all levels. In addition the position performs technical and professional functions in preparing reports and maps. Under the general direction of Mapping/GIS Coordinator, the position is responsible for providing support to planning and implementation efforts.

Examples of Duties and Responsibilities:

Prioritize and maintain Water Utility computer mapping system. Coordinate recording of Water Utility (WU) Construction Records; including maintenance WU Engineering Construction Database (non-mapping). Coordinates review and GIS updates of project (preconstruction) surveys. Provide technical assistance to Water Utility staff in use of computer mapping/GIS. Provide feedback and assistance in compiling Standard Operating Procedures related to mapping. Coordinate and record daily system updates such as new services, system repairs, main and service failures, and hydrant flow tests.

GIS data analysis duties will include creating custom maps, and compiling data (for mapping and reporting) from multiple sources (CIS, AMI, external GIS databases, spreadsheets, etc.). Create and generate tabular reports to support Water Utility functions.

Create custom Access databases and Excel Spreadsheets that can be consumed by the GIS for custom maps. Design GIS databases and applications to support WU functions. Other duties as assigned.

Minimum Qualifications:

Knowledge, Skills and Abilities:

Working knowledge of standard engineering, computer mapping and/or drafting systems and other specialized computer programs. Working knowledge of drafting, surveying and engineering design practices and techniques. Working knowledge of computer terminology, engineering applications, GIS, relational databases, and database reporting applications. Working knowledge of Water Utility policies, practices, procedures governing laws, ordinances and regulations. Ability to plan, coordinate and carry out ongoing programs or areas of responsibility. Ability to interpret and explain engineering plans, specifications and other technical documents and projects to other staff, agencies and the public. Ability to perform and coordinate the performance of technical work, including drafting, and the assembly, recording, compilation, and tabulation of data. Ability to maintain good working relationships with staff, members of other agencies and the general public. Ability to communicate effectively orally and in writing. Ability to follow oral and written instructions. Ability to communicate technical information accurately and in a timely, tactful and courteous manner by phone, in writing and in person to staff and members of the general public. Ability to maintain adequate attendance.

Training and Experience:

Two years of GIS support experience including digital cartography, surveying, database analysis and other related responsibilities. Such experience would normally be gained after completion of at least an Associate’s degree in the area of civil engineering technology, or a closely related field. Possession of a Bachelor’s degree in engineering, geography, surveying or closely related field which included an internship that encompassed the technical components listed above or the technical skills listed below may be substituted for the experience requirement. Other combinations of training and/or experience which can be demonstrated to result in the possession of the knowledge, skills and abilities necessary to perform the duties of positions in this class will also be considered.

Preferred Technical Skills:

Knowledge and experience with RDBMS systems such as SQL Server or Oracle, ESRI GIS products (ArcGIS 9.x and/or 10.x, ArcInfo, ArcView, ArcSDE, ArcGIS Server), graphical user interfaces, maps/map projections, spatial geometry, and vector and raster data types, SQL Syntax, and business reporting applications such as Crystal Reports or SSRS, Windows 2000/XP/7 desktop OS and database servers. Strong familiarity of the Microsoft Office Suite of products including MS Access. Experience with Bentley Microstation, AutoCad, Accela, CityWorks, Asset Management, SCADA, Python, Javascript, or T-SQL a plus.

Special Requirements:
Possession of a valid Wisconsin driver’s license.

Physical Requirements:

Employees in this position must be able to lift/carry objects weighing up to 20 pounds on a regular basis and objects weighing up to 75 pounds on occasion. In addition, employees must be able to frequently walk over uneven surfaces and in active construction sites, bend and squat, stand for long periods of time, and tolerate loud noises, dust and pollen. This position requires work outdoors in all types of weather. Ability to operate a CAD/GIS workstation with hand and eye coordination using a mouse and keyboard for inputting data. Ability to work at computer work station and desk for long hours.