Operations Data Analyst, Principal

Pacific Gas And Electric Company•Dublin, CA

2d•$140,000 - $238,000•Hybrid

About The Position

The Operations Data Analyst, Principal extracts, transforms, and manages operations data for analysis, leadership support, reporting, and ad hoc requests. The role maintains operations data tools, databases, and data pipelines to keep information accurate, reliable, and current. It develops, maintains, and enhances operational data solutions for analytics teams, including solutions built on Snowflake and SQL-based platforms, and addresses gaps in data requirements, quality, integration, and accessibility. This position is hybrid, working from a remote office and an assigned work location in Dublin or Pleasanton according to business needs. The in-office reporting expectation is 1–2 days per week. The role is part of PG&E’s Electric Transmission & Distribution business unit, which supports the reliability and resiliency of the electric grid serving Northern and Central California.

Requirements

Bachelor’s degree in Marketing, Business, Computer Science, Engineering, or a related field, or equivalent work experience.
Eight years of job-related experience.

Nice To Haves

Master’s degree or equivalent experience.
Familiarity with utility operations.
Hands-on experience developing production data solutions using Snowflake.
Advanced experience writing SQL queries and working with relational databases.
Experience designing and developing ETL/ELT data pipelines and data integration solutions.
Experience with Snowflake data architecture, data modeling, performance optimization, and data transformation.
Experience migrating data, SQL workloads, or ETL processes from legacy or on-premises platforms to Snowflake.
Experience with SQL Server and database development, including stored procedures and complex SQL transformations.
Experience with Python and libraries such as Pandas.
Experience with Microsoft Fabric and Microsoft Power Platform tools such as Power BI, Power Apps, and Power Automate.
Advanced skill in Microsoft Excel.
Experience with data quality, reconciliation, validation, and troubleshooting across multiple data sources.
Strong organizational, prioritization, and multitasking skills.
Advanced communication and presentation skills for delivering highly complex data and findings to Senior Management.
Project management expertise to lead large, cross-functional projects and develop concise data findings for Senior Management.

Responsibilities

Manage complex data engineering and analysis projects from initial request through implementation and delivery, ensuring they are completed within budget and on time.
Apply extensive data engineering, data processing, and data analysis expertise to develop strategies and resolve complex data issues.
Create automated data routines and processes for reporting and data delivery, ensuring accurate data manipulation, transformation, and cleansing.
Design, develop, and maintain scalable data pipelines and data structures using Snowflake, SQL, and related data integration technologies.
Manage major, complex cross-functional data projects with broad company implications.
Extract, transform, and transfer data from databases and other source systems to support operational analysis and reporting.
Develop complex SQL queries, stored procedures, data transformations, and data models for enterprise reporting and analytics.
Support modernization and migration of existing data processes and legacy ETL workflows to Snowflake and modern data engineering solutions.
Develop comprehensive reports and analyses for long-term, company-wide issues, and communicate clear, concise, actionable findings to clients.
Act as team lead and provide direction to less experienced employees.
May work with Senior Management to develop business-related strategy using data to inform decisions.