Data Platform Engineer

Pacific Gas And Electric Company; Town of Oakland (WI); Hybrid; USD 140,519,000 - 223,488,000; Full time

Job summary

Pacific Gas And Electric Company seeks a Data Platform Engineer to build and support modern data infrastructure across AWS and Azure, including relational data, data lakes, and data warehouses. You will design reliable data pipelines, integrate AI capabilities, and manage cloud storage with Terraform and Azure DevOps pipelines.

The role focuses on automation, data quality, and scalable architectures, enabling analytics, AI workloads, and predictive maintenance.

Qualifications

• Bachelor's degree in computer science or related field, or equivalent experience.
• 2 years of infrastructure/systems administration or cloud operations.
• 1 year of cloud tech, automation, or cloud-based environments.
• AWS or Azure certification or equivalent.

Responsibilities

• Build, test, and deploy data solutions and data pipelines for relational databases, data lakes, and data warehouses.
• Implement data integrity, data cleansing, and data retention processes.
• Create data objects within cloud storage services.
• Troubleshoot, maintain, and install database-related software components.
• Collect, review, and analyze data to support reliability and performance.
• Partner with application teams to resolve data inconsistencies.
• Develop IaC modules and reusable deployment patterns for databases, storage, networking, monitoring, and backups.
• Plan and execute migrations from on-prem to cloud-native architectures with validation and rollback.

Skills

Data platform design

AWS/Azure cloud

Terraform

Azure DevOps

SQL data modeling

Python scripting

Data pipelines & ETL

Education

Bachelor's degree or equivalent experience

2 years in infrastructure/cloud operations

1 year in cloud technologies & automation

AWS/Azure certification or equivalent

Tools

Terraform

Azure DevOps

SQL Managed Instance

Data Lake Storage

Cosmos DB

Synapse

Job description

Requisition ID # 174343

Job Category: Engineering / Science

Job Level: Individual Contributor

Business Unit: Technology & Security

Work Type: Hybrid

Job Location: Oakland

Department Overview

Technology & Security delivers secure, resilient, and scalable enterprise platforms that support critical business applications, infrastructure services, cloud operations, automation, and emerging technology enablement.

Position Summary

The Data Platform Engineer (DPE) builds and supports modern data infrastructure that enables advanced business capabilities across AWS (RDS, Aurora, DynamoDB, Redshift), Azure (Azure SQL, Cosmos DB, Synapse), and AzureLocal (SQL Managed Instance). The DPE manages cloud storage services, including AWS (S3, EBS, EFS, FSx), Azure (Blob Storage, Azure Files, Managed Disks, Data Lake Storage), and AzureLocal (Storage Spaces Direct, Azure Managed Disks). The role focuses on designing reliable data pipelines and data structures that support analytics, AI, and machine learning workloads. The DPE also integrates AI capabilities into database platforms to improve automation, optimization, and predictive maintenance.

The role includes developing AI-driven workflows that support database maintenance, performance tuning, and data cleansing. Infrastructure provisioning for database and storage resources is managed through Terraform, including multi-cloud resource provisioning, lifecycle policies, encryption, replication, and access control as code. Deployment automation is implemented through Azure DevOps pipelines, including database schema migrations, storage provisioning, backup validation, and environment promotion from DEV to PROD.

PG&E is providing the hourly rate 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 hourly rate 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. This job is also eligible to participate in PG&E's discretionary incentive compensation programs.

The hourly rate for this position ranges from $49.04 to $77.88.

This position is hybrid, working from your remote office and 1-2 days per week at our Oakland Headquarters based on business need. The assigned work location will be within the PG&E Service Territory.

Job Responsibilities

• Build, test, and deploy data solutions and data pipelines for relational databases, data lakes, and data warehouses.
• Build and implement data integrity, data cleansing, and data retention processes.
• Create data objects within cloud storage services.
• Troubleshoot, maintain, and install software components related to databases.
• Collect, review, and analyze data to support operational reliability and performance optimization.
• Partner with application teams to identify, analyze, and resolve data inconsistencies.
• Assist in data quality controls, validation rules, reconciliation checks, schema drift handling, and automated exception reporting to improve trust in downstream analytics, AI, and reporting workloads.
• Develop infrastructure-as-code modules and reusable deployment patterns for databases, storage accounts, networking dependencies, monitoring policies, backup configuration, replication, and environment promotion.
• Plan and execute database and storage migrations from legacy or on-premises platforms to cloud-native architectures, including assessment, dependency mapping, cutover planning, validation, rollback planning, and post-migration optimization.

Qualifications

Minimum:

• Bachelor's degree in computer science, job-related discipline, or equivalent experience
• 2 years experience in infrastructure, systems administration, cloud operations, or related Information Technology functions
• 1 year of experience supporting cloud technologies, cloud services, infrastructure automation, or cloud-based operating environments
• AWS Certified Data Engineer or Azure Data Engineer or equivalent cloud platform certification

Desired:

• 3 years of experience with databases.
• Experience working in an Agile/Scrum environment
• Knowledge of cloud technologies and services, including EC2, Lambda, Terraform, S3, OCI, and CI/CD, and containers
• Experience with SQL, Oracle, NoSQL, Aurora Postgres, RDS, and Redshift
• Experience with data management
• Understanding of Agile/Scrum principles and team-based delivery practices
• Knowledge of continuous integration and continuous deployment practices and tools
• Understanding of the AI development life cycle
• Understanding of machine learning concepts, platforms, and operational workflows
• Ability to deliver work in sprints and collaborate effectively with cross-functional teams
• Experience with scripting