GIS Analyst

Safety/Security Status:
Security Sensitive Job Summary

This role involves designing, developing, implementing, and maintaining SQL Server databases, ArcGIS Enterprise GIS solutions, and web-based mapping applications to meet the City’s spatial data needs. Responsibilities include managing enterprise geodatabases and ArcGIS Server sites, application development, publishing map and geodata web services, conducting geographic analysis, project management, and maintaining comprehensive documentation.

• Designs, develops, implements, maintains, and supports SQL Server databases, ArcGIS Enterprise GIS solutions, and web-based mapping applications.
• Manages versioned enterprise geodatabases, ArcGIS Server sites, and shared services.
• Develops applications and publish map and geodata web services in production and development environments.
• Performs geographic analysis and project management tasks.
• Develops and maintain comprehensive documentation for processes, protocols, and the structure of enterprise geodatabases, applications, data services, and workflows.
• Administers and maintains the SQL Server database for the City of Bentonville’s spatial data, including managing user logins, backups, archives, SDE loading and tuning, patches, troubleshooting, and data sharing.
• Proficiently uses ArcGIS Online software, manage user accounts, and develop ArcGIS Online web applications.
• Designs, maintains, and documents the coordinated flow of data between departmental peripheral applications, ArcGIS Desktop, ArcGIS Online, and 911 dispatch systems.
• Coordinates with other departments and agencies in implementing spatially enabled applications integrated with the above systems.
• Uses ArcGIS Model Builder and Python scripting tools to develop automated workflows and tools for updating and maintaining various systems.
• Drafts technical reports, standards, specifications, and process guides, and document details of map updates.
• Installs, updates, and maintains Enterprise GIS software and related GIS databases, servers, and portals.
• Manages GIS users, roles, software, and security models (ArcGIS Online, and Portal).
• Functions as database administrator for all GIS-related processes and projects.
• Utilizes Task Scheduler to manage the execution of scripts and SQL queries for data management.
• Develops code and software tools to automate complex GIS procedures for efficiency.
• Assists the GIS Coordinator with long-range planning for a sustainable GIS environment.
• Provides technical assistance and support for GIS users, including troubleshooting and diagnostics.
• Attends relevant meetings and conferences to stay updated with new technologies and best practices.

• Proficient using ArcGIS Online software, as well as managing user accounts for utilization of ArcGIS Online Applications and the development of ArcGIS Online web applications.
• Develop code and software tools to automate complex GIS procedures to increase efficiencies and the overall effectiveness of the GIS program.
• Assist GIS Coordinator with long-range planning requirements for a sustainable GIS environment.
• Utilize Task Scheduler to manage the timely execution of scripts and SQL queries to manage the import, export, and conversion of data into the City’s various systems.
• Installs, updates, and Maintains Enterprise GIS software and related GIS databases, Servers, and Portals for broad use in the GIS and Web Mapping.

Bachelor’s degree required with major course work in GIS, information systems, business/public administration, statistical analysis, social science, or related field.

• Five years of professional experience in GIS-related activities is desired.
• Two years of experience in developing GIS applications using ArcGIS for Server, ArcGIS Online or related technology.
• Two years of experience in Relational Database Management Systems (RDBMS), including MS-SQL Server.

• This is a full-time position based at our facilities.
• Must be available to respond to system emergencies during off-hours and weekends as required.
• Occasional travel may be required to support remote sites and oversee network…