Data Engineer, Expert

PG&E is seeking an Expert Data Engineer to lead the development of a modern, cloud-native data platform that supports vegetation management operations, regulatory compliance, and advanced analytics. This role is central to transforming fragmented legacy systems into a unified, audit-ready Snowflake Data Lakehouse, enabling scalable, secure, and transparent data access across the organization.

The engineer will design and implement robust ELT pipelines using Snowflake, Airflow, Informatica, and a suite of AWS services including Step Functions, Fargate, Lambda, DynamoDB, and S3. The role spans structured, semi-structured, and unstructured data domains, integrating sources such as Salesforce (OneVM), SAP, SharePoint, ArcGIS, and remote sensing imagery (LiDAR, orthoimagery, surface reflectance, etc.).

This position is hybrid, working from your remote office and your assigned work location based on business need. The assigned work location will be within the PG&E Service Territory. 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, collective bargaining agreements, 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 ($140,000 - $190,000), the decision will be made on a case-by-case basis related to these factors.

This job is also eligible to participate in PG&E’s discretionary incentive compensation programs. A reasonable salary range is:

Bay Area Minimum: $140,00

Bay Area Mid-Point: $189,000

Bay Area Maximum: $238,000

• Design, build, and maintain scalable data pipelines using tools such as Airflow, Informatica, AWS services, and Snowflake to support ingestion, transformation, and curation of structured, semi-structured, and unstructured data.
• Collaborate with cross-functional teams – including data scientists, analysts, and business stakeholders – to understand data requirements and deliver high-quality, analytics-ready datasets.
• Implement and optimize data lakehouse architectures, ensuring efficient data flow across Bronze, Silver, and Gold layers in Snowflake.
• Support the deployment of machine learning models by enabling feature pipelines, model input/output data flows, and integration with platforms like Sage Maker or Foundry.
• Apply software engineering best practices such as version control, CI/CD, unit testing, and infrastructure-as-code to ensure reliable and maintainable data workflows.
• Monitor and troubleshoot data pipelines, ensuring data quality, lineage, and governance standards are met across all environments.
• Mentor junior engineers and contribute to architectural decisions, code reviews, and knowledge sharing within the team.
• Communicate technical concepts and project updates clearly to both technical and non-technical audiences.

• BA/BS in computer science, Management Information Systems or related field of study, or equivalent experience
• 7 years of experience with data engineering/ETL ecosystems such as Palantir Foundry, Spark, Informatica, SAP BODS, OBIEE.
• Experience with multiple data engineering/ETL ecosystems.
• Experience with machine learning algorithm deployment.

• Master's degree in Computer Science, Management Information Systems, or related field of study, or equivalent experience
• Hands-on experience in data engineering, including:
  • Designing and building…