Job Description

The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia headed by the Chief Information Officer. This OIT position supports GIS operations and analytics of the Department of Licenses and Inspections and reports to the L&I GIS Manager, working under the Planning Director. L+I promotes Code compliance through education, consultation, responsiveness to public complaints, building plan reviews, licensing and permitting processes, on-site inspections, and enforcement actions. At all times, L+I’s focus is public safety.

The GIS Analyst is responsible for the creation, analysis, and maintenance of various spatial datasets and applications using ArcGIS suite of desktop products including Modelbuilder and Python scripting. The GIS Analyst will publish web maps, model workflows, generate and analyze statistics from the department’s relational database of permit, licensing and code enforcement records. The GIS Analyst will also execute MS SQL database queries and construct views and joins to support analytical tasks and reports. The candidate will assist the L&I GIS Manager and Lead GIS Analyst in efforts to develop mobile mapping and dashboard applications for field work by the department and train staff in the use of these applications.

Essential Functions
● Develop, edit and maintain geospatial datasets and databases.
● Create and maintain process automation related to data maintenance.
● Complete technical documentation of datasets and processes.
● Create and maintain web and mobile map applications published via ArcGIS Online.
● Analyze permit, licensing and code enforcement data for reports, dashboards, and presentations.
● Support the extraction, transformation and loading (ETL) of departmental data into ArcGIS Online dashboard(s) or similar technology for the analysis and presentation of data.
● Prepare and execute workflows, ETL and geoprocessing models using Python.
● Prepare and execute workflows and geoprocessing models using ArcGIS ModelBuilder
● Prepare and maintain project status reports to L&I GIS Manager and Planning Director.
● Write MS SQL database queries and construct views to support analysis and reporting tasks.
● 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.
● Interact with departmental management and inspection staff.
● Participate in meetings and events within the department and citywide GIS community.

Competencies, Knowledge, Skills and Abilities
● Proficiency using ESRI ArcGIS 10.x software suite for editing, data creation, analysis and map production including ModelBuilder and Spatial Analyst
● Proficiency authoring Python scripts for geoprocessing and automation of routines.
● Proficiency writing complex queries and joining and appending tables in MS SQL Server or Oracle
● Familiarity with ArcGIS Online map publishing and tools
● Familiarity with mobile mapping tools including ESRI’s Collector app.
● Familiarity with ArcGIS Network Analyst.
● Experience with data visualization and graphics tools for the creation of professional presentation and education materials.
● Advanced-level proficiency using Microsoft Office 2007-current Professional Suite (Access, Excel, Word, Powerpoint)
● Excellent written and oral communication skills.
● Proficient in project planning and time management
● Ability to create and maintain good working relationships and collaborations while being able to work independently and take initiative.

The following skills are beneficial, but not required:
● Experience in maintenance of versioned and non-versioned spatial data in ESRI ArcSDE 10.x
● Experience with data visualization and graphics tools for the creation of professional presentation and education materials.
● Experience with non-ESRI software to generate online and hardcopy map and data products.
● Experience with municipal land records: tax assessment records; permit and licensing records; land use; etc.
● Experience providing training, presentations or seminars