GIS System Administrator

Under direct supervision of the Water Distribution Superintendent, represent the department on tasks including but not limited to the following:

Oversee and maintain the daily GIS operations including the ESRI suite of applications (ArcGIS Enterprise, ArcGIS Portal, ArcGIS online, Survey 123, ArcGIS Field Maps, ArcGIS Pro, Experience Builder, and ArcGIS Dashboards)

Provide GIS system administration utilizing ESRI’s Utility Network, database editing, geocoding, geoprocessing, georeferencing, data conversion, workflow management, spatial analysis, and quality control processes in desktop and web-based environments for the Public Utilities Department and other city departments.

Manage workflows, data management, and daily assignments with the Public Works GIS position.

Tasks Routinely Performed

• Manage a proactively developing GIS system that uses ESRI’s Enterprise Platform which includes: ArcServer, ArcGIS Online, ArcPro, Field Maps, and extensions. Also to include the relationship between GIS and related records and tables.
• Manage, maintain and edit layers, related tables, maps, surveys, and other data.
• Design, develop, implement, and maintain geospatial web applications and data collection workflows. Manage and oversee data and the workflows including map making, web applications, processes, spreadsheets, data files, and documentation for a variety of uses both internally and externally.
• Assist department staff and oversee the deployment and integration of various software (Cityworks, IT Pipes, Springbrook, MS applications, others) to support operations, work and inventory management, integrating with GIS as applicable.
• Conduct data and spatial analysis and create GIS data for custom mapping requests, quality control, presentations, and reports using GIS tools and methods.
• Create, maintain, and update maps, drawings, spreadsheets, data files, and documentation to use internally and externally.
• Build applications, visualize data, and automate workflows using GIS and other platforms.
• Utilize aerial imagery to create new data and perform quality control on existing data.
• Oversee and maintain the Enterprise database through Amazon Web Services.
• Maintain utility infrastructure using GIS and relational databases and platforms.
• Prepare asbuilts of construction installation with the use of Autodesk and ArcGIS software products.
• Use survey equipment to perform duties related to inspecting, GIS, and data collection as needed.
• Assist the Department in daily activities.
• Shall be subject to recall any time before or after regularly scheduled shift.
• Shall perform general building and grounds maintenance.
• Shall use GIS for locating infrastructure and ongoing maintenance functions
• Various other related duties, as assigned.

Qualifications

Bachelor’s degree in Geographic Information Systems, Geography, or related field from an accredited college, plus five years of related experience; or equivalent combination of education and experience.

Work Conditions and Physical Demands:
Must be able to sit, stand, and/or walk for at least 6 to 8 hours per day.
Must be able to lift moderately heavy items, 40 to 50 pounds required.
Must have no impairments that limit work capabilities in year-round weather conditions.
Must be free of limitations for seat belt use or restrictions that impair entering or existing vehicles or
equipment.
Must have no restrictions that impair starting and stopping procedures in vehicles.
Must have no climbing or height restrictions.
Must have no limitations for bending, crouching, stooping or kneeling.
Must have no restrictions to repetitive movement of arms and neck while speaking on the telephone, typing working on the computer keyboard or using other equipment and frequent sitting while using these devices.

Essential Knowledge & Skills

•  Advanced proficiency with the ESRI suite of applications (ArcGIS Enterprise, ArcGIS online, Survey 123, ArcGIS Field Maps, ArcGIS Pro, Experience Builder, and ArcGIS Dashboards)
• Ability to communicate GIS-related technical issues and concepts to staff with varying levels of technical knowledge.
• Understand emerging GIS technologies and their application to improve City services
• Fluent with one or more programming languages including HTML, Python, Arcade, and/or SQL.
•  Must have regular, predictable attendance.
• Must maintain proper relations with the public, coworkers, management and other City staff.
• Shall attend seminars or training to maintain proficiency in software, technology, and the utility industry.
• Advanced knowledge of Microsoft products including but not limited to; Excel, Word, Powerpoint, Power Automate, and Teams.
• Ability to relate well with co-workers and the general public.
• Ability to communicate effectively, both orally and written.
• Ability to maintain accurate and complete reports and prepare clear and detailed reports.
• Considerable knowledge of survey methods used in inspection, and utility mapping.
• Knowledge of drafting methods and software including Autodesk.
• Ability to operate equipment for locating buried utilities.
• Ability to operate GPS and other equipment for data collections and point staking.
• Ability to add, subtract, multiply and divide in all units of measure using whole numbers, common fractions and decimals.
• Ability to apply common sense understanding to carry out instructions furnished in written, oral, diagram or digital form.
• Possession of a valid motor vehicle operator’s license issued by the State of Wisconsin with a clean driving record.
• Ability to pass post-offer physical examination.
• Must be available for overtime work assignments.