Requisition ID # 175852
Job Category: Information Technology
Job Level: Individual Contributor
Business Unit: Energy Delivery
Work Type: Hybrid
Job Location: Oakland
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