Data Engineer, Senior - Substation Data & AI Solutions
Backend Developer
Python
Artificial Intelligence
Big Data
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Database
Databases
ETL
Informatica
Information Technology (IT)
Programming
Programming Language
Programming Languages
Reporting and Analytics
Software Development
SQL
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