Apply on Employer Site

Philadelphia Gas Works · 2 days ago

Geographic Information Systems Analyst

Philadelphia, PA

Full-time

Hybrid

Mid, Senior Level

$85K/yr - $100K/yr

5+ years exp

Philadelphia Gas Works is seeking a Senior GIS Analyst to perform a wide range of GIS tasks within a cloud-hosted ESRI ArcGIS Enterprise environment. The role involves designing data models, ensuring data quality, analyzing data patterns, automating data processing, and presenting data visualization results.

EnergyOil and Gas

Comp. & Benefits

Hiring Manager

William Foronda

Responsibilities

Works with PGW business users to provide GIS solutions to business processes and regulatory information requests. Analyzes spatial and non-spatial data, creates maps, apps, documentation, and reports for PGW business in ArcGIS Enterprise environment or any business-required formats

Designs and develops automated workflows using Python to integrate the cloud-based ArcGIS Enterprise environment with PGW on-premise systems, including the in-house work management system (AIMS) and CIS system, through modern APIs. Automates additional GIS workflows using Python, JavaScript or other scripting languages as needed

Writes and optimizes SQL statements against both GIS and non-GIS relational databases

Administrates ArcGIS Enterprise Portal, including managing services, maps, apps, users, groups, and licenses. Monitors ArcGIS Enterprise’s performance and ArcGIS Online credit consumption

Administrates ArcGIS Enterprise Geodatabase, including managing data and users, assigning privileges, managing versions, performing maintenance, ensuring functionality and performance, and responding to database related issues

Works with PGW cloud maintenance vendor for software installations and updates

Works with PGW data maintenance vendor for punctual and accurate GIS data updates. Monitors vendor’s data deliveries in enterprise geodatabase. Conducts Quality Assurance / Quality Control (QA / QC) using ESRI Data Reviewer and Python

Edits and maintains PGW asset data in a versioned enterprise geodatabase using ArcGIS Pro

Processes real-time data from different sources using ArcGIS GeoEvent

Performs routing analysis using ArcGIS Network Analysis

Geocodes addresses automatically using ESRI Geocoder and/or Google Maps API

Follows GIS department’s database, mapping, and scripting standards to perform tasks

Keeps up with new GIS technology and products

Qualification

ArcGIS ProArcGIS EnterprisePythonSQLESRI productsJavaScriptETL processAWSAutoCADAnalytical skillsOrganizational skillsCommunication skillsInterpersonal skillsLeadership abilityDecision making skills

Required

Bachelor's Degree in Geography, Geographic Information Systems (GIS), Information Systems and Technology, or other related field of study; Master's Degree or GIS Certificate is a plus

Minimum of 5+ years of full-time experience using the ESRI platform

Must have experience with ArcGIS Pro. Must have experience editing data in ArcGIS Pro

Must have experience administrating ArcGIS Enterprise and ArcGIS Online. Must have experience publishing services, configuring web maps/apps, and using other ESRI products like Dashboards, Experience Builder, Survey123, and Field Maps

Must have experience administrating ArcGIS enterprise geodatabase (Oracle, PostgreSQL, etc.)

Must have experience with Python, ArcPy, and ArcGIS API for Python

Must have experience with writing complex SQL

Must have experience with HTML, CSS, JavaScript, ArcGIS Arcade, and ArcGIS API for JavaScript

Must have experience with modern APIs like REST API

Must have experience with Extraction, Translation, and Load (ETL) process

Must have strong self-learning initiatives and capability

Must have analytical skills with the ability to apply, develop, present, and execute creative solutions

Must have organizational, planning and follow-through skills with the ability to manage multiple projects under high pressure situations

Must have verbal and written communications skills with the ability to present and discuss technical information in a way that establishes rapport, persuades others, and gains understanding

Must be computer literate with proficiency in the use of Microsoft Word, Excel, PowerPoint, and SharePoint with the ability to display ideas through presentations, flowcharts, and graphs

Must have interpersonal skills with the ability to build long-term constructive and cooperative working relationships with co-workers, vendors, management, and outside agencies

Must have leadership ability with a willingness to lead, take charge, and offer opinions in to provide guidance to lower-level peer group and assist the Manager of GIS Systems & Architecture in identifying the best people for special assignments and advancement

Must have decision making skills with the ability to recommend strategic direction for the organization and manage continuous improvement projects

Equivalent combination of education and experience may be acceptable in lieu of a degree

Preferred

Experience with ESRI Utility Network or Geometric Network is a plus

Experience with Amazon Web Services (AWS) is a plus

Familiarity with AutoCAD and basic interpretation of drawings is a plus

A general understanding of the functional operations of a natural gas utility's Distribution and Field Service Departments and their interaction with Gas Processing, Transportation, Materials Management, Building Services, Customer Service, Marketing, and Operating Systems Support is a plus