Data Engineer, Senior - Substation Data & AI Solutions

Pacific Gas And Electric Company•Oakland, CA
•$116,000 - $194,000•Hybrid

About The Position

The Senior Data Engineer will support Substation Systems & Tools by designing, developing, and maintaining scalable data solutions that enable operational analytics, artificial intelligence, asset management, and business applications. The role integrates structured and unstructured Substation data across enterprise systems and establishes reliable, secure, and reusable data pipelines using AWS, Snowflake, Python, SQL, and related technologies. This is a hybrid position, working from a remote office and an assigned location based on business need. The role is within Electric T&D, which maintains and operates PG&E’s electric transmission and distribution lines and focuses on grid reliability and resiliency.

Requirements

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

Nice To Haves

  • Strong proficiency in Python and SQL.
  • Experience developing enterprise-scale ETL/ELT pipelines and data integrations.
  • Experience with AWS and Snowflake, or comparable cloud/data platforms.
  • Experience with data modeling, APIs, relational databases, and structured/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.
  • Experience with PostgreSQL or similar databases.
  • React and/or Streamlit application development experience.
  • Experience with SAP, APM/EAM, utility, or industrial asset data.
  • Experience with data pipelines supporting AI/ML and document-processing solutions.

Responsibilities

  • Design, develop, and maintain scalable ETL/ELT data pipelines using Python, SQL, AWS, and Snowflake.
  • Integrate data from APM, SAP, diagnostic and operational systems, and other Substation data sources.
  • Develop solutions for structured and unstructured data, including engineering documents, PDFs, images, and equipment test results.
  • Design data models and reusable data services supporting analytics, AI/ML, dashboards, and operational applications.
  • Develop APIs and integration solutions connecting enterprise and cloud platforms.
  • Improve data quality, reliability, availability, performance, and governance.
  • Support automation and modernization of manual data-processing activities.
  • Partner with data scientists, application developers, business analysts, engineers, and Substation SMEs.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service