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.

Duties and Responsibilities

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

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.

Additional Information:

• 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 operations and incidents.

Language Skills: Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals. Ability to write routine reports and correspondence. Ability to speak effectively before groups of customers or employees of organization.

Mathematical Skills: Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent.

Reasoning Ability: Able to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.

Certificates, Licenses, Registrations

• Valid driver’s license
• Basic computer hardware/software training course(s)

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.

While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee frequently is required to stand, walk, climb or balance; stoop, kneel, crouch, or crawl; and taste or smell. The employee must regularly lift and/or move up to 25 pounds, frequently lift and/or move up to 50 pounds, and occasionally lift and/or move up to 100 pounds. The employee occasionally uses hand trucks or dollies when moving large, bulky items. This position is regularly engaged in loading and unloading large, bulky boxes containing Personal Computers (pcs), Monitors, Printers, and other PC-related equipment. This position is regularly required to position and move pcs and their related components into tight spaces. Also, this position is engaged in the movement of office furniture (desks, filing cabinets, bookcases, etc.… during the PC installation process at various locations throughout the city. Job duties also entail loading/unloading City vehicles, driving City vehicles, climbing stairs, and working with wiring overhead. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

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.

While performing the duties of this job, the employee is occasionally exposed to moving mechanical parts and risk of electrical shock. The noise level in the work environment is usually quiet.

Benefits:

• Competitive salary based on experience and qualifications.
• Car & Cell Phone Allowance
• Health, dental, and vision insurance.
• Retirement savings plan.
• Paid time off and holidays.
• Opportunities for professional development and training.
• Dynamic and collaborative 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.