Data Analyst - City Geo

Who We Are

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.

Opportunities in Tech - Don’t wait for the future, shape it.

Benefits - We care about your wellbeing.

The Office of Innovation & Technology (OIT) is the central IT department for the City of Philadelphia led by the Chief Information Officer. In addition, OIT provides leadership and expertise on the design, integration, and management of data across city government. Data is key to municipal operations and business intelligence. The City of Philadelphia shares hundreds of datasets with the public and between departments: Open Data - opendataphilly.org, Metadata – metadata.phila.gov.

As a result, residents can find information about assets, services and conditions in their neighborhood. Civic associations can lookup landlords and see if they have violations before supporting their zoning variance. Voters can trust that OPA property data and crime incidents are posted online for anyone to see.

The City’s applications that support bill paying, filling permits, and all day to day transactions are reliant on OIT’s ability to effectively integrate and ingest data among various systems in multiple formats. This work is done not just for the benefit of government operations, but for the public. Examples of OIT’s commitment to serving the public through the effective and innovative integration of City open data include:

https://Atlas.phila.gov

https://Openmaps.phila.gov

https://streetsmartphl.phila.gov/

www.phila.gov/solarmap

www.phila.gov/stressmap

OIT’s teams apply agile development techniques and are staffed by engaged, diverse, talented and committed analysts, application developers, and engineers eager to do their best professional work to improve City processes and policies to better serve Philadelphia residents.

The Data Analyst position is in CityGeo, the organization that coordinates data resources and GIS across Philadelphia Departments. The Data Analyst is responsible for organizing data from multiple sources and executing projects for open data releases, analysis, data development and integration, predictive analytics, scripting, and data modeling. This position will support the Open Data Program and other programs managed by CityGeo.

The work is conducted with both spatial and non-spatial databases using a suite of desktop products including; ArcGIS, ArcGIS Online/Portal, PowerBI, and associated programs. Primary responsibilities will focus on preparing analyses, data creation, application development, coding, and data extraction/transformation/integrations to support business intelligence needs and measure organizational performance. This work will include statistical analysis, predictive analysis, developing metrics using python, -R, Excel, and other related GIS tools. The Data Analyst is also responsible for administering enterprise platforms, such as ArcGIS Online.

The Data Analyst will work cooperatively with Department staff to understand program goals and database structures in order to design projects, develop data requirements, and integrate data for publication as Open Data and in the City’s Enterprise Data Warehouse (DataBridge).

The Data Analyst will manage complex projects; and may supervise the day to day work of multiple lead or associate analysts at CityGeo. Supervisory tasks may include mentoring, managing, and developing methodologies and tasks for associate staff to execute.

The candidate will support the OIT’s efforts to develop and promote data standards and policies for the creation, management, and sharing of spatial and non-spatial data for business intelligence, project/program performance tracking, and public open data publishing.

Essential Functions

• Prepare data for publication as Open Data
• Develop and maintain geospatial datasets.
• Develop Extraction Transform and Load (ETL) scripts using Python.
• Develop data visualizations to support public access to data sets.
• Perform predictive analytics, reporting and visualization of City data.
• Query, analyze and prepare statistics on spatial and non-spatial data using GIS, Excel, -R and other tools.
• Complete metadata documentation of datasets and processes.
• Create and maintain of web map applications published via ArcGIS Online/Portal.
• Prepare and execute workflows and automated routines using Python and ModelBuilder.
• Prepare and execute queries in spatial and non-spatial databases using SQL.
• Serve as Subject Matter Expert to assist City agencies data management and integration needs through consultation and training.
• Interact with city departments, GIS managers and analytical staff on data sharing, ETL and other joint projects.
• Participate in meetings and events within department, city and wider data user community.
• Prepare and conduct presentations at departmental meetings, trainings and select conferences.
• Provide supervision of subordinate, intern or employees.
• Administrate enterprise platforms and tools (ArcGIS Online, Confluence, etc.)
• Organize and lead team projects and initiatives.

Competencies, Skills & Abilities

Required:

• Proficiency in database management: create, edit, update, join, append and query data from spatial and non-spatial relational databases.
• Experience with data visualization and graphics tools for the creation of professional presentations reports, web content, or education materials.
• Experience authoring complex Python scripts and creating models in ArcGIS Model Builder for automation of routines and geo processes.
• Proficiency using ESRI ArcGIS 10.x software suite.
• Proficiency using ArcGIS Online/Portal to publish data and produce GIS applications.
• Proficiency in spatial data creation, editing and maintenance using ArcGIS desktop and/or ArcGISPro.
• Excellent written and oral communication skills.
• Proficiency in project planning and time management (setting and meeting goals, setting timelines, updating mangers and team members on status, etc.).
• Ability to create and maintain good working relationships and collaborations while being able to work independently and take initiative.
• Genuinely excited and enthusiastic about learning and pushing technical limits when finding new solutions.

Preferred:

• Experience with cloud services and data management.
• Experience with parcel mapping, editing, and parcel management.
• Proficiency in statistical methods and analysis including correlation and regression using -R or related statistical software tools.
• Experience with non-Esri GIS and mapping software to generate on-line maps and data including CARTO.
• Multi-user versioned and distributed editing, replication in ArcGIS Server/ArcGIS SDE 10.x environment.
• Previous experience building ETL processes.

Five or more years of relevant professional experience required. 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.

Did you know?

• We are a Public Service Loan Forgiveness Program qualified employer
• 25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities
• We offer Comprehensive health coverage for employees and their eligible dependents
• Our wellness program offers eligibility into the discounted medical plan
• Employees receive paid vacation, sick leave, and holidays
• Generous retirement savings options are available.

The 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 or send an email to faqpchr @phila.gov. For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx