Data Engineer, Senior - Substation Data & AI Solutions

PG&E Corporation
Oakland, CA, United States
1 day ago
Apply on jobs.pge.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$122,000 - $194,000
Working hours
Regular working hours
Job source

Tech stack

Application Programming Interfaces (APIs) Artificial Intelligence Airflow Amazon Web Services Amazon S3 Databases Continuous Integration Data Governance Extract Transform Load (ETL) Relational Databases Python (Programming Language) PostgreSQL
+11 more
SAP (Applications) Software Engineering SQL Databases Unstructured Data ReactJS Snowflake Git Operational Systems Data Management Streamlit Framework Data Pipelines

Job description

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., * 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.

Requirements

  • 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

Benefits & conditions

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, and internal equity. Although we estimate the successful candidate hired into this role will be placed towards the middle or entry point of the range, the decision will be made on a case-by-case basis related to these 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.

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.pge.com
Prepare application

Good distractions

Loading talks and stories from around this role…