Share this Job

Compliance Data Analyst, Senior

San Francisco, CA, US, 94105

Requisition ID # 38768 

Job Category : Information Technology 

Job Level : Individual Contributor

Business Unit: Electric Operations

Job Location : San Francisco

Department Overview 
The men and women of Electric Operations ensure the delivery of clean, safe, reliable and affordable energy to nearly 16 million people in Northern and Central California. Electric Operations is responsible for every aspect of PG&E's electric distribution and transmission operations, including planning, engineering, maintenance and construction, asset management, business planning, restoration and emergency response. 
Position Summary 
The Operations Data Analyst reports to the manager of Reporting and Insight within the Electric Compliance group. The key functions of this role involve Data Engineering, Data Modeling/ETL, and Data Visualization. He or she extracts data for analysis, leadership support, and responds to ad hoc data requests. The individual maintains operation tools and databases to ensure that they are kept up-to-date using data from various PG&E systems. He or she develops, maintains, and enhances operational metric database tools for the broader analytics team. The analyst identifies and solves current gaps in data requirements and creates ease of access to ensure fast and consistent responses to leadership inquiries. 
Job Responsibilities 

  • Develop and maintain standard reporting and responds to data inquiries and ad hoc requests.


  • Perform quality assurance checks on SQL Server processes and tables


  • Maintain steady state SQL extracts and update weekly operational dashboards in Excel and Tableau.


  • Serve as first point of contact to clients with ad hoc analysis and questions on weekly reports.


  • Design data analysis to achieve business objectives, process data, analyze data, write clear and concise data findings and tailor communications to specific audiences.


  • Analyzes data using various statistical tools to develop ad hoc reports, statistics, trends and profiles


  • Demonstrate and communicate clear, concise, and actionable data analyses for clients


  • Provides recommendations to enhance database(s) with new data sources and improved data processes


  • Providing historical performance, trending and benchmarking analysis


  • Participate on special initiatives project teams. May assist with some IT related enhancement discussions. Collaborates with team members on most effective field rollout of process, tool and/or reporting changes.

BA/BS Degree in Marketing, Business, Computer Science, Engineering or other related field or equivalent work experience 
5 years of Job-related experience 

Demonstrated excellent written and verbal communication skills. 
Proficient with Microsoft Excel/Access/PowerPoint 
Strong data analysis skills, knowledgeable in collecting data, organizing, synthesizing, reporting, recognizing trending and anomalies, drawing conclusions from data. 
Familiarity with utility operations 
Advanced skill in writing SQL queries using Microsoft SQL Server 
Experience in creating packages and scripts in SQL Server Integration Services (SSIS) 
Well-versed in data visualization best practices with proven experience using Tableau Desktop Professional. 
Extensive technical knowledge of SAP R3, BW, AO and BusinessObjects 



Our Mission

To safely and reliably deliver affordable and clean energy to our customers and communities every single day, while building the energy network of tomorrow.

Our Vision

With a sustainable energy future as our North Star, we will meet the challenge of climage change while providing affordable energy for all customers.

Our Culture

We put safety first.
We are accountable. We act with integrity, transparency and humility.
We are here to serve our customers.
We embrace change, innovation and continuous improvement.
We value diversity and inclusion. We speak up, listen up and follow up.
We succeed through collaboration and partnership. We are one team.

Pacific Gas and Electric Company (PG&E), a subsidiary of PG&E Corporation (NYSE:PCG), is one of the largest combined natural gas and electric companies in the United States. Based in San Francisco, our 24,000 employees deliver safe, reliable, affordable and clean energy to nearly 16 million people throughout our Northern and Central California service area, stretching from Eureka to Bakersfield and from the Pacific Ocean to the Sierra Nevada.

More About Our Company

Pacific Gas and Electric Company is an Affirmative Action and Equal Employment Opportunity employer that actively pursues and hires a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, sex, age, religion, physical or mental disability status, medical condition, protected veteran status, marital status, pregnancy, sexual orientation, gender, gender identity, gender expression, genetic information or any other factor that is not related to the job.

Employee Privacy Notice                                                                                                                                                                                                                                      The California Consumer Privacy Act (CCPA) goes into effect on January 1, 2020. CCPA grants new and far-reaching privacy rights to all California residents. The law also entitles  job applicants, employees and non-employee workers to be notified of what personal information PG&E collects and for what purpose. The Employee Privacy Notice can be accessed through the following link: Employee Privacy Notice

PG&E will consider qualified applicants with arrest and conviction records for employment in a manner consistent with all state and local laws.

Nearest Major Market: San Francisco
Nearest Secondary Market: Oakland