With a workforce of over 30,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 our residents have the opportunity to reach their potential. 

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 the GIS operations, business intelligence, and analytics of the Department of Licenses and Inspections and reports to the L+I Business Intelligence Project Manager. 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 that include ArcGIS suite of desktop products, ArcGIS Online, SQL querying, and Python scripts. This position focuses on developing and presenting business intelligence tools for L+I operations and business.  The GIS Analyst will publish web maps, model workflows, manage applications, and generate and analyze statistics from the department’s relational database of permit, licensing and code enforcement records. This position will be actively involved in the development, maintenance, and presentation of web-based dashboard reporting tools.  The candidate will also take part in special projects which may be related but not limited to: mobile data collection, floodplain analysis, and utilizing areal lidar and imagery of the city.  The candidate will be encouraged to persue creative and/or unique projects on an as needed basis.

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 of web and mobile map applications published via ArcGIS Online.
    Analyze permit, licensing and code enforcement data for reports, dashboards, and in presentations to Commissioner and Deputy Mayor staff.
    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 Deputy GIO and Lead GIS Analyst.
    Write Oracle and similar 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 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.
    Advanced -level proficiency using Microsoft Office 2007 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 on-line 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.

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 is preferred. 

Successful candidate must be a city of Philadelphia 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

 For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx