Data Engineer

Pacific Gas and Electric Company; Oakland (CA); On-site; USD 102,000 - 162,000; Full time

Job summary

Pacific Gas and Electric Company is seeking a data engineering professional to design, develop, and optimize data extraction, transformation, and loading pipelines. The role emphasizes data lineage, metadata collection, and collaboration with data owners and leadership throughout the lifecycle.

The position operates in a hybrid model with Oakland, CA presence, typically 1–2 days on-site weekly, subject to business needs and company policy.

Qualifications

• Bachelor’s degree in Computer Science or a related field, or equivalent experience.
• 3 years of data engineering/ETL experience with tools such as Informatica, SAP BODS, OBIEE.

Responsibilities

• Analyzes existing applications and systems and formulates logic for new systems, devises logic procedures, logical database design, performs coding and tests/debugs programs.
• Designs and deploys new systems and enhancements to existing systems ensuring compatibility and inter-operability.
• Works on moderately complex problems that require in depth analysis and judgment to obtain results or solutions.
• Resolves application problems within procedural guidelines.
• Provides technology that supports solutions which meet business capabilities and are consistent with enterprise standards, architectures and strategies.

Skills

Python

PySpark

SQL

Snowflake SQL

Education

Bachelor's Degree in Computer Science or related field

Tools

AWS

GitHub Actions

Jenkins

Terraform

Snowflake Data Cloud

Job description

Job Category: Information Technology

Job Level: Individual Contributor

Business Unit: Technology & Security

Work Type: Hybrid

Job Location: Oakland

Department Overview

Information Systems Technology Services is a unified organization comprised of various departments which collaborate effectively in order to deliver high quality technology solutions.

Position Summary

Designs, develops, modifies, configures, debugs and evaluates jobs for extracting data from various sources, implements transformation logic, and stores data in various formats fit for use by stakeholders. Collects metadata about jobs including data lineage and transformation logic. Works with teams, clients, data owners and leadership throughout the development cycle practicing continuous improvement.

This position is hybrid, working from your remote office and Oakland, CA, approximately 1 - 2 days per week, or more based on business needs or company requirements.

Compensation

PG&E is providing the full salary/pay range for this position. The actual amount paid to an individual will be based on multiple factors, including, but not limited to, internal equity,specific skills, education, licenses or certifications, experience, market value, and geographic location. The range to reasonably expect will be between the minimum and midpoint listed below. Thefinal decision will be made on a case-by-case basis related to the factors above.This job is also eligible to participate in PG&E’s discretionary incentive compensation programs.

Bay Area Min: $102,000.00

Bay Area Mid: $132,000.00

Bay Area Max: $162,000.00

Job Responsibilities

• Analyzes existing applications and systems and formulates logic for new systems, devises logic procedures, logical database design, performs coding and tests/debugs programs.
• Designs and deploys new systems and enhancements to existing systems ensuring compatibility and inter-operability.
• Works on moderately complex problems that require in depth analysis and judgment to obtain results or solutions.
• Resolves application problems within procedural guidelines.
• Provides technology that supports solutions which meet business capabilities and are consistent with enterprise standards, architectures and strategies.

Qualifications

Minimum:

• Bachelors Degree in Computer Science or job-related discipline or equivalent experience
• Experience with data engineering/ETL ecosystems (e.g., Informatica, SAP BODS, OBIEE), 3 yrs

Desired:

Programming & Big Data

• Languages: Python, PySpark, SQL, Snowflake SQL

Cloud & DevOps (Infrastructure)

• Cloud Platforms: Amazon Web Services (AWS)
• CI/CD & DevOps Tools: GitHub Actions, Jenkins, Terraform (Infrastructure as Code), Git (Version Control)

Database Technologies

• Platforms: Snowflake Data Cloud
• Core Competencies: Designing and managing cloud data warehouses, writing optimized Snowflake SQL, and managing storage/compute resources.

ETL / ELT & Data Integration