GIS Application Engineer (ESC)

Requisition ID # 162069 

Job Category: Maintenance / Construction / Operations 

Job Level: Individual Contributor

Business Unit: Electric Engineering

Work Type: Hybrid

Job Location: Oakland

Department Overview

The Electric Engineering team ensures the delivery of safe and reliable electric service to our customers. Electric Engineering is responsible for PG&E's electric distribution and transmission operations, including planning, engineering, maintenance and construction, asset management, business planning, restoration, and emergency response.

Position Summary

This job is represented by Engineers and Scientists of California (ESC) subject to collective bargaining.

The GIS Application Engineer performs GIS analysis, custom programming and related tasks under direction of higher classification employees.

This position is hybrid, working from your remote office and your assigned work location based on business need. The assigned work location will be within the PG&E Service Territory

PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation range is specific to the locality of the job.  The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, collective bargaining agreements, and internal equity.

The annual salary range is:

CA Minimum, $159,444

CA Maximum, $175,476

Job Responsibilities

• Interact with clients to design and implement GIS solutions for client needs. Manage projects involving client accounts, with a high level of client satisfaction. Market GIS services to client organizations.
• Develop custom GIS applications on various platforms including desktop, web-based, and mobile. This may include application design, database design, programming, testing, troubleshooting, and client support including training as appropriate.
• Design and develop intermediate real-time database queries, analyses and reports using spatial RDBMS, including the use of sophisticated views, automated updates, and stored procedures.
• Design and develop spatial analysis techniques utilizing industry-standard spatial modeling tools and extensive custom programming in GIS software or spatial databases.
• Data management: Perform administrative tasks on GIS RDBMS databases, including Oracle (Spatial) and SQL Server, or equivalent. Ensure reliability and data integrity of databases.
• Analyze system performance, improve processes, evaluate outside data sources and software.
• Acquire, evaluate and modify scripts for the benefit of the GIS group and its clients.
• Ability to perform all tasks of all lower classification GIS positions as needed.
• Ability to manage projects with high client satisfaction and excellent communication.
• Collaboratively direct the work of others.

General Skills Needed:

• Intermediate to advanced working knowledge in Visual Basic for ArcGIS, VBscript, Javascript for Active Server Pages, PL-SQL programming, or equivalent.
• Intermediate to advanced working knowledge of Oracle Spatial and SDE geodatabase applications and tools, or equivalent.
• Intermediate to advanced working knowledge of client business.
• Advanced problem-solving and research skills. Ability to implement sophisticated geometric algorithms.
• Intermediate to advanced working knowledge of relational databases and SQL language, or equivalent.
• Intermediate to advanced working knowledge of GIS modeling concepts and practices including linear referencing / dynamic segmentation. Theissen polygons, regions and network analysis.

Qualifications

Minimum:

• BA/BS in Geomatics, Geography, GIS, or related field, or the equivalent in education and/or experience.
• Successful completion of two college level courses (semester or quarter) or 16 days of advanced coursework in programming that directly applies to the general skills described above.  Coursework may be taken via University Extension, through a vendor (e.g. ESRI, Oracle), or online, or equivalent
• 4 years of experience in GIS at the Senior GIS Analyst level or equivalent

Desired:

• Experience in the electric or gas utility industry