DataJobs.io
← Back to all jobs

Job Description

PG&E is hiring a Senior Data Engineer to build scalable data foundations for Substation Systems & Tools and data products spanning operational analytics, AI, and asset management.

Responsibilities

  • Design, develop, and maintain scalable ETL/ELT data pipelines using Python, SQL, AWS, and Snowflake
  • Integrate Substation data from APM, SAP, Diagnostic/Operational systems, and other Substation sources
  • Create solutions for structured and unstructured content, including engineering documents, PDFs, images, and equipment test results
  • Design data models and reusable data services for 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 SMEs

Requirements

  • BA/BS in Computer Science, Management Information Systems, or related field, or equivalent experience
  • 5 years of experience with data engineering/ETL ecosystem such as Palantir Foundry, Spark, Informatica, SAP BODS, or OBIEE
  • Strong proficiency in Python and SQL
  • Experience building 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, AWS Glue, AWS Lambda, and Airflow
  • Experience with Snowflake/Snowpark, PostgreSQL, or similar databases
  • React and/or Streamlit application development experience
  • Experience with SAP, APM/EAM, utility, or industrial asset data
  • Data pipelines supporting AI/ML and document-processing solutions

Technologies

  • 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
  • SAP, APM/EAM

Benefits

  • Eligible to participate in PG&E’s discretionary incentive compensation programs

Job Details

  • Location: Oakland, CA (hybrid)
  • Job Category: Information Technology
  • Job Level: Individual Contributor
  • Business Unit: Energy Delivery
  • Salary: USD 116,000 - 194,000 per year
  • Reasonable Bay Area salary range: $122,000.00 - $194,000.00
  • Reasonable California salary range: $116,000.00 - $184,000.00

Department Overview

  • Over 6,500 coworkers in Electric T&D support delivery of clean, safe, reliable and affordable energy to nearly 16 million people in Northern and Central California
  • Electric T&D maintains and operates 100,000 miles of distribution lines and over 18,000 miles of transmission lines to support grid reliability and resiliency
  • Uses Lean Methodology and Visual Management in Operating Reviews to identify and solve problems and create standard work
  • Engages as “One Electric. One Team” to deliver for local communities

Position Summary

  • Support Substation Systems & Tools by designing, developing, and maintaining scalable data solutions for operational analytics, artificial intelligence, asset management, and business applications
  • Integrate structured and unstructured Substation data across enterprise systems using reliable, secure, reusable pipelines
  • Establish pipelines using AWS, Snowflake, Python, SQL, and related technologies
  • Work type: Hybrid, working from a remote office and an assigned location based on business need

Similar Jobs