This role supports operations leadership by extracting, transforming, and managing operational data used for analysis, enterprise reporting, and responses to ad hoc data requests. You will also lead complex cross-functional initiatives, develop scalable data pipelines, and modernize legacy data workflows.
Position Overview
Extract, transform, and manage operations data to support analysis, leadership decision-making, reporting, and ad hoc information requests. Maintain operational data tools, databases, and data pipelines to keep information accurate, reliable, and current. Develop, maintain, and enhance operational data solutions for broader analytics teams, including solutions built on Snowflake and SQL-based data platforms.
Identify gaps in data requirements, data quality, integration, and ease of access, then resolve them to enable fast and consistent responses to business and leadership needs.
Location and Work Setup
- Location: Dublin, CA (hybrid)
- Assigned work location: Dublin or Pleasanton within the PG&E Service Territory
- In-office expectation: 1-2 days per week
- Job location listing: Dublin; Pleasanton
Salary Range
- Minimum: USD 140,000 per year
- Maximum: USD 238,000 per year
- BAY minimum: $140,000
- BAY maximum: $238,000
Key Responsibilities
- Manage very complex data engineering and data analysis projects end to end, from initial request through implementation and delivery, with very limited supervision, ensuring projects are completed on-time and within budget.
- Apply extensive data engineering, data processing, and data analysis expertise to develop strategy or resolution for complex data issues.
- Create automated reporting and data delivery routines that ensure accurate data manipulation, transformation, and cleansing.
- Design, develop, and maintain scalable data pipelines and data structures using Snowflake, SQL, and related data integration technologies.
- Lead major, complex cross-functional data projects with broad company implications.
- Oversee extraction, transformation, and transfer of data from databases and other source systems to support operational analysis and reporting.
- Develop complex SQL queries, stored procedures, data transformations, and data models to support enterprise reporting and analytics.
- Support modernization and migration of existing data processes and legacy ETL workflows to Snowflake and modern data engineering solutions.
- Create comprehensive reports and analysis for long-term, company-wide issues; present clear, concise, and actionable analyses for clients.
- Serve as team lead by providing direction to less experienced employees.
- May partner with Senior Management to develop business-related strategy that leverages data for decision-making.
Required Qualifications
- Bachelor’s Degree: Marketing, Business, Computer Science, Engineering, or other related field, or equivalent work experience
- Experience: 8 years of job-related experience
- Education: 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 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 including Power BI, Power Apps, and Power Automate
- Advanced skills in Microsoft Excel
- Experience with data quality, reconciliation, validation, and troubleshooting across multiple data sources
- Strong organizational, prioritization, and multi-tasking skills, with advanced communication and presentation skills for delivering highly complex findings to Sr. Management
- Expertise in project management to lead large, cross-functional projects and develop concise data findings for Sr. Management
Technologies
- Snowflake
- SQL
- Python
- Pandas
- Microsoft Fabric
- Power BI
- Power Apps
- Power Automate
- Microsoft Excel
- ETL
- ELT
- SQL Server
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 team is comprised of roughly 10,100 coworkers and supports the reliability and resiliency of the electric grid through ongoing maintenance and operations of PG&E’s 100,000 miles of distribution lines and over 18,000 miles of transmission lines.
Team members engage in Lean Methodology using visual management in operating reviews to cross-functionally identify and solve problems and create standard work. The department operates as One Electric. One Team to deliver for local communities.
Benefits
- Discretionary incentive compensation programs
Requisition Details
- Requisition ID: #174657
- Job Category: Business Operations / Strategy
- Job Level: Manager/Principal
- Business Unit: Energy Delivery
