Data Engineer, Senior - Substation Data & AI Solutions
Pacific Gas And Electric Company Oakland, California, United States · $116K–$194K/yr
Utilities · 10,001+ employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
About the role
The Senior Data Engineer will design, develop, and maintain scalable data pipelines to support operational analytics, AI, and asset management. They will integrate structured and unstructured data from various substation systems while ensuring data quality, reliability, and governance.
What they look for
Requirements
Candidates must hold a bachelor's degree in Computer Science, Management Information Systems, or a related field. A minimum of 5 years of experience with data engineering and ETL ecosystems is required.
Benefits
Full 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 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.
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
Similar roles
-
Senior Data Engineer II
Oscar Health New York, New York, United States · $181K–$237K/yr
-
Data Engineer
AcuityMD $113K–$159K/yr
-
Staff Data Engineer, Analytics
Afresh San Francisco, California, United States · $168K–$250K/yr
-
Data Engineer - Agentic AI
Defense Unicorns Springfield, Virginia, United States · $149K–$201K/yr
-
Senior Data Engineer
Southend Pharmacy Houston, Texas, United States · €45K–€65K/yr
-
Senior Data Engineer (Talent Pool)
ioet San José de Alluriquín, Santo Domingo de los Tsáchilas, Ecuador