Citywide GIS & SQL Administrator

Kids for the Future; Venice (FL); On-site; USD 77,000 - 112,000; Full time

Job summary

The City of Venice is seeking a GIS Analyst to coordinate all aspects of the city’s GIS and SQL database use, integrations, and projects. The role reports to the Information Technology Director.

Responsibilities include developing standards for GIS/SQL deployment, supporting external agencies, and staying current with GIS technologies. Candidates should have an Esri certification or plan to obtain one within six months, and hold a Florida driver’s license.

Qualifications

• Associate's Degree with six (6) years GIS experience and project planning.
• Bachelor's Degree in GIS, Information Technology, Geography or comparative field with four (4) years GIS experience and project planning.
• Esri Technical certification or ability to obtain within six (6) months.
• Must possess a valid Florida driver's license or ability to obtain an instate license within thirty (30) days from hire.

Responsibilities

• Provides professional support services to city departments and outside agencies on the City's GIS, including application software, network, and associated systems, including administration and support of Microsoft SQL Server databases that underpin enterprise GIS.
• Coordinates with city departments in developing standard operating procedures and prioritization of information technology GIS projects.
• Establishes long and short-term strategic plans, goals, and objectives for the GIS/SQL database systems, including data architecture to improve techniques and data quality.
• Meets regularly with city departments' GIS staff to assess and plan for new technology and developments to modify, enhance, and resolve issues with existing systems.
• Collaborates with GIS staff and partners to develop SQL queries, stored procedures, and Python scripting to automate data workflows, QA/QC checks, and ETL processes.

Skills

GIS

ArcGIS

SQL databases

Python scripting

Data analysis

Cartography

Spatial analysis

Project management

Driver's license

Education

Associate's Degree in GIS/related field

Bachelor's Degree in GIS/IT/Geography or related field

Esri Technical Certification

Tools

ArcGIS

Microsoft SQL Server

Python

Job description

The City of Venice is seeking a GIS Analyst to coordinate all aspects of the city’s GIS and SQL database use, integrations, and projects. The role reports to the Information Technology Director.

Responsibilities include developing standards for GIS/SQL deployment, supporting external agencies, and staying current with GIS technologies. Candidates should have an Esri certification or plan to obtain one within six months, and hold a Florida driver’s license.