Operations Data Analyst, Principal

Requisition ID # 174657 

Job Category: Business Operations / Strategy 

Job Level: Manager/Principal

Business Unit: Energy Delivery

Work Type: Hybrid

Job Location: Dublin; Pleasanton

Department Overview

Electric Transmission & Distribution ensures the delivery of clean, safe, reliable and affordable energy to nearly 16 million people in Northern and Central California. The Electric Transmission & Distribution Team, comprised of roughly 10,100 coworkers, is responsible for ensuring the electric grid's reliability and resiliency through the ongoing maintenance and operations of PG&E's 100,000 miles of distribution lines and over 18,000 miles of transmission lines.

Coworkers in Electric Transmission & Distribution actively engage in the Lean Methodology through the use of visual management in operating reviews to cross-functionally identify and solve problems, and create standard work. By working together as One Electric. One Team. We are delivering for our hometowns. 

Position Summary

Extracts, transforms, and manages operations data for analysis, leadership support, reporting, and responses to ad hoc data requests. Maintains operations data tools, databases, and data pipelines to ensure that data is accurate, reliable, and up-to-date. Develops, maintains, and enhances operational data solutions for the broader analytics teams, including solutions built on Snowflake and SQL-based data platforms. Identifies and solves current gaps in data requirements, data quality, integration, and ease of access to ensure fast and consistent responses to business and leadership needs.

This position is hybrid, working from your remote office and your assigned work location based on business need. The assigned work location will be Dublin or Pleasanton of the PG&E Service Territory. In office reporting expectation is 1-2 days per week.

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.

Bay Minimum: $140,000
Bay Maximum: $238,000

This job is also eligible to participate in PG&E’s discretionary incentive compensation programs. 

Job Responsibilities

• Manages very complex data engineering and data analysis projects with very limited supervision from initial request through implementation and delivery, ensuring that projects are completed within budget and on-time.
• Acts as a thought leader applying extensive data engineering, data processing, and data analysis expertise in the development of strategy or resolution to complex data issues.
• Creates very complex automated data routines and processes for reporting and data delivery, ensuring accurate data manipulation, transformation, and data cleansing.
• Designs, develops, and maintains scalable data pipelines and data structures using Snowflake, SQL, and related data integration technologies.
• Manages major and complex cross-functional data projects that have broad company implications.
• Manages extracting, transforming, and transferring data from databases and other source systems to support operational analysis and reporting efforts.
• Develops complex SQL queries, stored procedures, data transformations, and data models to support enterprise reporting and analytics.
• Supports modernization and migration of existing data processes and legacy ETL workflows to Snowflake and modern data engineering solutions.
• Develops comprehensive reports and analysis for long-term, company-wide issues. Presents/communicates clear, concise and actionable data analyses for clients.
• Acts as team lead and provides direction to less experienced employees.
• May work with Senior Management to develop business-related strategy, leveraging data in decision making.

Qualifications

Minimum:

• Bachelors Degree in Marketing, Business, Computer Science, Engineering or other related field or equivalent work experience
• Job-related experience, 8 years

Desired:

• 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 Python 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 multi-tasking skills. Advanced communication and presentation skills to deliver highly complex data and findings to Sr. Management.
• Expertise in project management to lead large, cross-functional projects and develop concise data findings for Sr. Management.