Data Engineer, Senior - Substation Data & AI Solutions

PG&E Corporation

Oakland (CA)

Hybrid

USD 116,000 - 194,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Pacific Gas and Electric Company in Oakland is seeking a Senior Data Engineer to design, develop, and maintain scalable data solutions for operational analytics, AI, asset management, and business applications.

You will integrate Substation data across enterprise systems using AWS, Snowflake, Python, and SQL, building reliable pipelines while collaborating with data scientists, engineers and analysts.

Qualifications

  • BA/BS in Computer Science, MIS or related field, or equivalent experience.
  • 5 years of experience with data engineering/ETL ecosystem (Palantir Foundry, Spark, Informatica, SAP BODS, OBIEE).
  • Strong proficiency in Python and SQL.
  • Experience with AWS and Snowflake, or comparable cloud/data platforms.

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.
  • Develop solutions for structured and unstructured data, including engineering docs, PDFs, images, and test results.
  • Design data models and reusable data services supporting analytics, AI/ML, dashboards, and operational apps.
  • 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, app developers, business analysts, engineers, and Substation SMEs.

Skills

Python
SQL
ETL pipelines
AWS
Snowflake
Data modeling
APIs

Education

BA/BS in Computer Science or MIS

Tools

Palantir Foundry
Spark
Informatica
SAP BODS
OBIEE
Git
CI/CD
Airflow

Job description

Requisition ID# 175852

Job Category: Information Technology

Job Level: Individual Contributor

Business Unit: Energy Delivery

Work Type: Hybrid

Job Location: Oakland

Department Overview:

Over 6,500 coworkers in Electric T&D ensure the delivery of clean, safe, reliable and affordable energy to nearly 16 million people in Northern and Central California.The Electric T&D Team is responsible for ensuring the electric grid's reliability and resiliency through the ongoing maintenance and operations of PG&E's 100,000 miles of distribution lines and over 18,000 miles of Transmission lines. Coworkers in Electric T&D's actively engage in the Lean Methodology through the use of Visual Management in Operating Reviews to cross-functionally identify and solve problems, and create standard work. By working together as One Electric. One Team. We are delivering for our hometowns.

Position Summary:

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 will integrate structured and unstructured Substation data across enterprise systems and establish reliable, secure, and reusable data pipelines using AWS, Snowflake, Python, SQL, and related technologies.

This position is hybrid, working from your remote office and your assigned location based on business need.

PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of thejob posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will bebased on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience,market value, geographic location, and internal equity.Although we estimatethe successful candidate hiredinto this rolewill be placed towards the middle or entry point of the range, the decisionwill be made on a case-by-casebasis related tothese factors.

A reasonable salary range is:

Bay Area Minimum: $122,000.00

Bay Area Maximum: $194,000.00

California Minimum: $116,000.00

California Maximum: $184,000.00

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

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.
  • 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.
Qualifications:
Minimum Qualifications:
  • BA/BS in Computer Science, Management Information Systems or related field of study, or equivalent experience
  • 5 years of experience with data engineering/ETL ecosystem, such as Palantir Foundry, Spark, Informatica, SAP BODS, 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/data platforms
  • Experience with data modeling, APIs, relational databases, and structured/unstructured data
  • Understanding of CI/CD, Git, security, access controls, and data governance
  • AWS S3, Glue, Lambda, Airflow
  • Snowflake/Snowpark
  • PostgreSQL or similar databases
  • React and/or Streamlit application development
  • SAP, APM/EAM, utility, or industrial asset data
  • Data pipelines supporting AI/ML and document-processing solutions
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer, Senior - Substation Data & AI Solutions
Data Engineer, Senior - Substation Data & AI Solutions

PG&E • Oakland (CA)

Hybrid
USD 122,000 - 194,000
Hybrid work model
Discretionary incentive programs
Data Scientist, Senior - Substation AI & Asset Intelligence
Data Scientist, Senior - Substation AI & Asset Intelligence

PG&E Corporation • Oakland (CA)

Hybrid
USD 126,000 - 200,000
Operations Data Analyst, Principal
Operations Data Analyst, Principal

Pacific Gas and Electric Company • Dublin (CA)

Hybrid
USD 140,000 - 238,000
Senior Data Scientist in San Ramon
Senior Data Scientist in San Ramon

Energy Jobline ZR • San Ramon (CA)

Hybrid
USD 126,000 - 200,000
Senior, Operations Data Analyst - Reliability Strategy
Senior, Operations Data Analyst - Reliability Strategy

Pacific Gas and Electric Company • Oakland (CA)

Hybrid
USD 105,000 - 169,000
Data Platform Engineer
Data Platform Engineer

PG&E • Oakland (CA)

Hybrid
USD 68,000 - 107,000
Senior Data Engineer - Substation Analytics & AI
Senior Data Engineer - Substation Analytics & AI

PG&E • Oakland (CA)

Hybrid
USD 122,000 - 194,000
Hybrid work model
Discretionary incentive programs
Data Engineer III
Data Engineer III

TheCorporate LLC • Oakland (CA)

On-site
USD 120,000 - 180,000
Senior Data Engineer, Substation AI & Data Pipelines
Senior Data Engineer, Substation AI & Data Pipelines

PG&E Corporation • Oakland (CA)

Hybrid
USD 116,000 - 194,000
Expert Business Performance Analyst
Expert Business Performance Analyst

Pacific Gas and Electric Company • Oakland (CA)

Hybrid
USD 126,000 - 200,000