GIS/Business Intelligence Developer Analyst

$60,000 - $70,000/Yr

City of Philadelphia - Philadelphia, PA

Part-time,Full-time - Entry Level

Philadelphia, PA

10,001+ employees

Executive, Legislative, and Other General Government Support

About the position

The GIS/Business Intelligence Developer Analyst plays a crucial role in the Office of Innovation & Technology (OIT) for the City of Philadelphia, focusing on the creation, analysis, and maintenance of spatial and tabular datasets. This position involves utilizing the ArcGIS suite, Python scripting, and Oracle SQL to support various analytical tasks and reporting needs, ultimately contributing to the effectiveness of city services and operations.

Responsibilities

• Develop, edit, and maintain geospatial datasets and databases.
• Complete technical documentation of datasets and processes.
• Analyze permit, licensing, and code enforcement data for reports, dashboards, and presentations.
• Write SQL queries and construct views to 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 dashboards and similar applications.
• Create and prepare miscellaneous maps and reports on an ad hoc basis for executive staff.
• Prepare and deliver presentations and/or training sessions on GIS and related technology for departmental and City staff.
• Participate in meetings and events within the department and citywide GIS community.

Requirements

• Baccalaureate degree in Geographic Information Systems (GIS), Geography, Urban Planning, Public Health, Natural Resources, Statistics, Information Science, Computer Science, or Civil Engineering.
• 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.
• Proficiency writing complex queries and joining tables in Oracle SQL.
• Familiarity with ArcGIS Online map publishing and tools.
• Experience with data visualization and graphics tools for dashboard creation.
• Excellent written and oral communication skills.
• Proficient in project planning and time management.

Nice-to-haves

• Experience with data visualization and graphics tools for professional presentation materials.
• Experience working in Git and Github.
• Experience with non-Esri software for generating map and data products.
• Experience with Jupyter Notebooks.
• Experience with municipal land records such as tax assessment and permit records.
• Experience with front-end application development and computer science fundamentals.
• Experience providing training, presentations, or seminars.

Benefits

• Comprehensive health coverage for employees and their eligible dependents.
• Wellness program offering eligibility into a discounted medical plan.
• Paid vacation, sick leave, and holidays.
• Generous retirement savings options.
• Eligibility for the Public Service Loan Forgiveness program.
• Free Commute on SEPTA with the Key Advantage Program.
• Tuition discounts and scholarships with local colleges and universities.