EngineerJobs.io
← Back to all jobs

Job Description

The Senior Data Engineer for Substation Data & AI Solutions will build and maintain scalable data capabilities that support operational analytics, artificial intelligence, asset management, and business applications at PG&E. This hybrid role focuses on integrating structured and unstructured Substation data across enterprise systems using AWS, Snowflake, Python, SQL, and related technologies.

Role Summary

The Senior Data Engineer will design, develop, and maintain reliable and secure data pipelines for Substation Systems & Tools. The work includes connecting structured and unstructured Substation data across enterprise environments and enabling reusable data services for analytics, AI/ML, dashboards, and operational applications. This position is hybrid, with work performed from a remote office and the assigned location based on business need.

Responsibilities

  • Design, develop, and maintain scalable ETL/ELT data pipelines using Python, SQL, AWS, and Snowflake.
  • Integrate data from APM, SAP, Diagnostic/Operational systems, and other Substation data sources.
  • Build solutions for structured and unstructured data, including engineering documents, PDFs, images, and equipment test results.
  • Create data models and reusable data services that support analytics, AI/ML, dashboards, and operational applications.
  • Develop APIs and integration solutions connecting enterprise and cloud platforms.
  • Enhance data quality, reliability, availability, performance, and governance.
  • Support automation and modernization of manual data-processing activities.
  • Collaborate with data scientists, application developers, business analysts, engineers, and Substation subject matter experts.

Required Qualifications

  • BA/BS in Computer Science, Management Information Systems, or a related field of study, or equivalent experience.
  • 5 years of experience in data engineering/ETL ecosystems such as Palantir Foundry, Spark, Informatica, SAP BODS, or OBIEE.

Desired Qualifications

  • Strong proficiency in Python and SQL.
  • Experience developing enterprise-scale ETL/ELT pipelines and data integrations.
  • Experience with AWS and Snowflake, or comparable cloud and data platforms.
  • Experience with data modeling, APIs, relational databases, and structured and unstructured data.
  • Understanding of CI/CD, Git, security, access controls, and data governance.
  • Experience with AWS S3, Glue, Lambda, and Airflow.
  • Experience with Snowflake/Snowpark PostgreSQL or similar databases.
  • Experience developing React and/or Streamlit applications.
  • Experience with SAP, APM/EAM, utility, or industrial asset data.
  • Data pipeline experience supporting AI/ML and document-processing solutions.

Technology Stack

  • Python, SQL, AWS, Snowflake
  • Palantir Foundry, Spark, Informatica
  • SAP BODS, OBIEE
  • AWS S3, AWS Glue, AWS Lambda, Airflow
  • Snowpark, PostgreSQL
  • React, Streamlit
  • CI/CD, Git, APIs

Compensation

Salary range: USD 116,000 to 194,000 per year.

  • Bay Area Minimum: $122,000.00
  • Bay Area Maximum: $194,000.00
  • California Minimum: $116,000.00
  • California Maximum: $184,000.00

Benefits

This job is also eligible to participate in PG&E’s discretionary incentive compensation programs.

Company and Team Overview

Over 6,500 coworkers in Electric T&D work to deliver clean, safe, reliable and affordable energy to nearly 16 million people in Northern and Central California. The Electric T&D team supports grid reliability and resiliency through ongoing maintenance and operations of PG&E’s 100,000 miles of distribution lines and over 18,000 miles of transmission lines.

Electric T&D coworkers use Lean Methodology through Visual Management in Operating Reviews to cross-functionally identify and solve problems, and create standard work. The organization emphasizes “One Electric. One Team” to deliver for local communities.

Job Details

  • Location: Oakland, CA (Hybrid)
  • Job Category: Information Technology
  • Job Level: Individual Contributor
  • Business Unit: Energy Delivery
  • Work Type: Hybrid
  • JOB LOCATION: Oakland

Similar Jobs