The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia headed by the Chief Information Officer. The GIS Services Group (GSG) coordinates enterprise level data publishing, spatial analysis, training, contracts and vendors for spatial data or technology, and the development and support of enterprise applications that provide location intelligence services.
This OIT position will initially support the reconciliation of multiple property based datasets to support the city’s migration to Next Generation 911 and prepare a model to resolve address issues (compounding over a century) specific to Philadelphia . The GIS Analyst is responsible for the analyzing property datatasets and identifying issues that need to be corrected within source datasets. This position will also be responsible for the creation and maintenance of a city-wide master address point layer as well as a cultural assets layer using the ArcGIS suite of desktop products. The GIS Analyst will publish web maps, model workflows and analyze statistics relating to their work. A key component of this job will be the ability to interact with departmental and internal databases, executing database queries and constructing views and joins to support analytical tasks and reports.
The successful candidate must reside in the City of Philadelphia or establish primary residence in the City of Philadelphia within 6 months of employment.
This is an opportunity to join one of the most innovative and productive geodata teams working in civic government. We are tackling problems fearlessly and looking for applicants with skills, energy and determination to join us in improving government services for the residents of Philadelphia.
Develop, edit and maintain geospatial datasets and databases.
Create and maintain process automation related to data maintenance.
Create and maintain master address and cultural asset point feature layers in ArcSDE.
Analyze addressing, parcel, and centerline data for reports and presentations to senior staff.
Complete technical documentation of datasets and processes.
Create and maintain of web map applications published via ArcGIS Online.
Support the extraction, transformation and loading (ETL) of departmental 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 Deputy GIO and Lead GIS Analyst.
Write MS SQL database queries and construct views to support analysis and reporting tasks.
Prepare web maps applying sound cartographic techniques for chloropleths, cartograms, and rasters.
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 managers and GIS staff to address/resolve data issues.
Participate in meetings and events within the department and citywide GIS community.
Competencies, Knowledge, Skills and Abilities
Direct or related experience with Public safety operations and 911 call centers.
Proficiency using ESRI ArcGIS 10.x software suite for editing, data creation, analysis and map production.
Proficiency writing complex queries and joining and appending tables in MS SQL Server or Oracle.
Thorough understanding of basic data update workflows and the ability to model them.
Familiarity with ArcGIS Online map publishing and tools.
Proficiency using Microsoft Office Professional Suite (Access, Excel, Word, Powerpoint).
Excellent written and oral communication skills.
Ability to create and maintain good working relationships and collaborations while being able to work independently and take initiative.
Preferred, but not required skills include:
Experience in maintenance of versioned and non-versioned spatial data in ESRI ArcSDE 10.x.
Experience with municipal land records: tax assessment records and parcel mapping.
Experience with street centerline file usage and attribution
Experience analyzing and correcting property/addressing information for utilization by 911.
Experience with data maintenance that’s reliant on multiple data sources.
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.
A minimum of 2 years of professional GIS experience.
Remember to say you found this opportunity at EnvironmentalCareer.com