GIS Developer Analyst

  • Philadelphia, PA
  • Full-time

Company Description

With a workforce of over 25,000 people, and opportunities in more than 1,000 different job categories, the City of Philadelphia is the fifth largest city in the United States and one of the largest employers in Southeastern Pennsylvania. As an employer, the City of Philadelphia operates through the guiding principles of service, integrity, respect, accountability, collaboration, diversity and inclusion. Through these principles, we strive to effectively deliver services, to resolve the challenges facing our city, and to make Philadelphia a place where all of our residents have the opportunity to reach their potential.

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.

Position Summary
The GIS Developer 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 Developer 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 Developer 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

Qualifications

Baccalaureate degree from an accredited college or university which has included major course work in Geographic Information Systems (GIS), Geography, Urban Planning, Public Health, Natural Resources (analytical focus), Statistics, Information Science, or Civil Engineering. Master’s degree in preferred.

Additional Information

Please submit a resume and cover letter with your application.

Successful candidate must be a City resident within six months of hire. 

The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race, ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age,disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at 215-686-4670 or send an email to For more information, go to: Human Relations Website at: http://www.phila.gov/humanrelations