Safety/Security Status: Security Sensitive

SUMMARY - This position is responsible for the design, development, implementation, maintenance, and support of SQL Server databases, ArcGIS Enterprise GIS solutions, and web-based mapping applications to address the City’s spatial data needs. Duties include the management of versioned enterprise geodatabases, ArcGIS Server sites and shared services, application development, and publication of map and geodata web services in production and development environments. Duties also include geographic analysis, project management, developing and maintaining comprehensive documentation for the processes, protocols, and structure of enterprise geodatabases, applications, data services and workflows. Works with considerable latitude for the use of initiative and independent judgment within the scope of responsibility.

ESSENTIAL DUTIES AND RESPONSIBILITIES - include the following:

Reporting relationships, work assignments, and work schedules may be subject to change in order to meet City needs or operational requirements. Attendance at work and the ability to get along with the public, supervisors, and co-workers are essential elements of this position. Other duties may be assigned by Supervisor. GIS Analyst will include the skills and duties of a Level II GIS Technician plus the following:

1. Administer and maintain the SQL Server database that serves as the central repository for the City of Bentonville’s spatial data.

1. Manage user logins, backups, archives, SDE loading and tuning, patches, troubleshooting, and data sharing for the database.

1. 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.

1. Responsible for designing, maintaining and documenting the coordinated flow of data between departmental peripheral applications, ArcGIS Desktop, ArcGIS Online, and 911 dispatch systems.

1. Coordinating with other departments and agencies as they implement spatially enabled applications and programs integrated with the above systems and others as required.

1. Use ArcGIS Model builder and other Python scripting tools to develop automated workflows and tools for updating and maintaining the various systems as well as for use by other GIS users in performing their job duties.

1. Have basic scripting and/or programming experience (e.g. Python and SQL)

1. Draft technical reports, standards, specifications, and process guides. Record and document details of map updates, additions, or deletions.

1. Installs, updates, and Maintains Enterprise GIS software and related GIS databases, Servers, and Portals for broad use in the GIS and Web Mapping.

1. Manages GIS users, roles, software, and security models (ArcGIS Online, and Portal)

1. Functions as database administrator for all GIS related processes and projects.

1. 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.

1. Develop code and software tools to automate complex GIS procedures to increase efficiencies and the overall effectiveness of the GIS program.

1. Assist GIS Coordinator with long-range planning requirements for a sustainable GIS environment.

1. Provide technical assistance and support for GIS users, including troubleshooting, diagnostics, problem resolution and general question response.

1. Attend relevant meetings and conferences to stay up to date with new technologies, techniques, and best practices.

SUPERVISORY RESPONSIBILITIES - May direct and lead the work of others on a project-by-project basis. Provides training to end users and general public as needed for GIS applications and software. Reports to the GIS Coordinator.

QUALIFICATIONS - To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

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

Preferred qualifications below:

• 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;

LANGUAGE SKILLS - Ability to read, analyze, and interpret common scientific and technical journals, financial reports, and legal documents. Ability to respond to common inquiries or complaints from customers, regulatory agencies, or members of the business community. Ability to effectively present information to top management, public groups, and/or boards of directors.

MATHEMATICAL SKILLS - Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.

REASONING ABILITY - Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

CERTIFICATES, LICENSES, REGISTRATIONS - Valid Driver License

PHYSICAL DEMANDS - The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Employee is required to sit for long periods, reach with hands and arms, use hands to handle or feel objects/controls, and talk or hear. Also required to stand and walk. Semi-regularly stoop, kneel, crouch, and/or crawl. Employee must lift and/or move up to 25 lbs. regularly. Occasionally lifting up to 50 lbs. required. Visual abilities required include color differentiation, close/distant vision, and the ability to adjust focus.

HEALTH BENEFITS
The City of Bentonville is proud to offer a comprehensive benefits package to eligible, full-time employees who work 30 hours per week. This year's benefits package can be viewed here:

https://www.bentonvillear.com/DocumentCenter/View/15032/City-of-Bentonville-2024-Benefits-Guide

WORK ENVIRONMENT - The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level is typical of a normal office work environment.

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.