IT Manager (GIS & Business Intelligence)

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 IT Manager(GIS-BI) will lead a team of GIS & Business Intelligence Developer Analyst(s) responsible for the creation and maintenance of ETL processes around various spatial and tabular datasets, which are an essential part of a city-wide GIS and data enterprise environment.  This is performed using a combination of the ArcGIS suite of desktop products, authoring custom code in Python, and creating custom views in Oracle SQL. The IT Manager (GIS-BI) will also lead Business Intelligence Developer Analyst(s) in publishing web maps, model workflows, and generating statistics from the department’s relational database of permit, licensing and code enforcement records. The candidate will lead a team in efforts to develop mapping, dashboard, and other business intelligence related applications to support various business processes within 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 maintain project status reports to Deputy IT Director and IT Director.
•    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.
•    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/or ArcGIS Pro for editing, data creation, analysis and map production.
•    Proficiency authoring Arcpy, Pandas, and related Python scripts 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