Operations Data Analyst, Principal

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.