About this role
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