Geographic Information Systems Analyst

Senior GIS Analyst

PGW is seeking a Senior GIS Analyst. This role is suited for a well-rounded GIS professional who performs a wide range of GIS tasks within a cloud-hosted ESRI ArcGIS Enterprise environment. The individual is expected to work independently and will be responsible for designing data models, ensuring data quality, analyzing data patterns, automating data processing, and presenting data visualization results.

The ideal candidate will have 5+ years of full-time professional GIS experience, including at least one year serving as an administrator of an ArcGIS Enterprise environment, encompassing ArcGIS Portal and the ArcGIS Enterprise Geodatabase. The candidate should have strong experience with ESRI products such as ArcGIS Pro, Experience Builder, Dashboards, Survey123, and Field Maps. Proficiency in SQL and Python (including arcpy and the ArcGIS API for Python) is required.

This is a full-time, hybrid position, with the office located in Philadelphia, PA.

The expected annual salary range for this position is $85,000–$100,000.

Responsibilities

1. 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.

2. 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.

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

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

5. 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.

6. Works with PGW cloud maintenance vendor for software installations and updates.

7. 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.

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

9. Processes real-time data from different sources using ArcGIS GeoEvent.

10. Performs routing analysis using ArcGIS Network Analysis.

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

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

13. Keeps up with new GIS technology and products.

Qualifications

1. 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.

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

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

4. 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.

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

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

7. Must have experience with writing complex SQL.

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

9. Must have experience with modern APIs like REST API.

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

11. Experience with ESRI Utility Network or Geometric Network is a plus.

12. Experience with Amazon Web Services (AWS) is a plus.

13. Familiarity with AutoCAD and basic interpretation of drawings is a plus.

14. 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.

15. Must have strong self-learning initiatives and capability.

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

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

18. 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.

19. 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.

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

21. 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.

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

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