GIS/Business Intelligence Developer Analyst

Company Description

A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact. 
As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else. We offer a vibrant work environment, comprehensive health care and benefits, and the experience you need to grow and excel. If you’re interested in working with a passionate team of people who care about the future of Philadelphia, start here.

What We Offer:
•    Impact - The work you do here matters to millions. 
•    Growth - Philadelphia is growing, why not grow with it? 
•    Diversity & Inclusion - Find a career in a place where everyone belongs.
•    Benefits - We care about your well-being.
 

The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia headed by the Chief Information Officer (CIO). OIT oversees all major information and communications technology initiatives for the City of Philadelphia - increasing the effectiveness of the information technology infrastructure, where the services provided are advanced, optimized, and responsive to the needs of the City of Philadelphia’s businesses, residents, and visitors. OIT responsibilities include: identifying the most effective approach for implementing new information technology directions throughout city government; improving the value of the city’s technology assets and the return on the city’s technology investments; ensuring data security continuity; planning for continuing operations in the event of disruption of information technology or communications services; and supporting accountable, efficient and effective government across every city department, board, commission and agency.

Job Description

The GIS/Business Intelligence Developer Analyst is responsible for the creation, analysis, and maintenance of various spatial datasets, tabular datasets, and applications using the ArcGIS suite of desktop products, Python scripting, and Oracle SQL Developer. 
The GIS/Business Intelligence 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 Business Intelligence/GIS Developer Analyst will also execute Oracle SQL database queries and construct views and joins to support analytical tasks and reports. 
The successful candidate can look forward to assisting the Licenses & Inspections GIS/Business Intelligence Developer Analyst Manager and Supervisor in developing mapping, dashboards, and other business intelligence related applications for field work by the department.   The candidate will also train staff in the use of these applications.

Essential Functions
•    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 deliver presentations and/or training sessions on GIS and related technology, tools or procedures for departmental and City staff.
•    Participate in meetings and events within the department and citywide GIS community.

Competencies, Knowledge, Skills and Abilities
•    Proficiency using Esri ArcGIS 10 software suite and ArcGIS Pro for editing, data creation, analysis and map production.
•    Proficiency authoring Arcpy, Pandas, and related Python modules for geoprocessing and automation of routines.
•    Proficiency writing complex queries and joining and appending tables in Oracle SQL.
•    Familiarity with ArcGIS Online map publishing and tools including, but not limited to, Web App Builder, Survey 123, and Esri Dashboards.
•    Familiarity with mobile mapping tools including Esri’s Field Maps.
•    Experience with data visualization and graphics tools for the creation of dashboards.
•    Ability to communicate techni