Develop, edit, and maintain geospatial datasets and databases.
Complete technical documentation of such datasets and processes.
Analyze permit, licensing and code enforcement data for reports, dashboards, and presentations.
Write SQL queries and construct views which support analysis and reporting.
Prepare and execute workflows, ETL, and geoprocessing tools using Python.
Support the extraction, transformation and loading (ETL) of data for ArcGIS Online dashboard(s), open-source Metabase Dashboards (or similar applications) to be used for reporting and statistics.
Create and prepare miscellaneous maps and reports on an ad hoc basis for executive staff, sometimes with quick turnaround times.
Prepare and maintain project status reports to Deputy IT Director and IT Director.
Prepare and deliver presentations and/or training sessions on GIS and related technology, tools or procedures for departmental and City staff on as needed basis.
Participate in meetings and events within the department and citywide GIS community.
