Share this Job

Customer Data Analyst, Expert

San Francisco, CA, US, 94105

Requisition ID # 43120 

Job Category : Information Technology 

Job Level : Individual Contributor

Business Unit: Customer Care

Job Location : San Francisco

Department Overview 

In Customer Care, we are focused on delivering the desired customer experience for each of our customers. Everything we do starts with the customer and our information about the customer. Within Customer Care, PG&E’s Customer Energy Solutions department (CES) is responsible for designing, implementing and administering customer demand side management programs, including energy efficiency, distributed generation, demand response, and rate programs that help PG&E customers in Northern and Central California manage the energy use of their homes and businesses. PG&E has been a national leader in energy efficiency since 1976 and continues to recruit and develop individuals to carry the CES Department’s legacy of effective energy efficiency programs on into the future.


Within Income Qualified Program and Disadvantaged Communities department, the Energy Savings Assistance (ESA) Program helps income-qualified residential customers throughout PG&E’s service territory reduce energy consumption and costs while increasing their health, comfort, and safety. Qualified customers receive no-cost home weatherization, energy efficient appliances, and energy education services. Through this state-mandated program, PG&E has helped customers save over $54 million on their energy bills since 1983.


Position Summary

The Expert Customer Data Analyst will have an opportunity to work alongside with colleagues who possess diverse perspectives who are committed and passionate about customer advocacy. This individual will evaluate the effectiveness of our data, and recommend improvements in data system, regulatory reporting, business processes and procedures.  This position may also be involved in special projects.  This requires a resilient self-starter who can adapt in a rapidly changing environment.  Additionally, this individual should possess strong analytical & problem-solving skills, system understanding and regulatory reporting.  The successful candidate will be responsible for research, data quality & analysis and reporting in support of business decision making, business strategy, business operations and data request while demonstrating the ability to work comfortably with stakeholders at all levels of the organization.



  • Manage and cultivate strong vendor relationships by facilitating recurring business reviews, compiling and evaluating monthly vendor performance metrics, benchmarking, and proactively exploring technologies that can be leveraged to enhance processes
  • Analyze trends/exceptions and provide recommendations 
  • Liaise with other organizations and explore process improvement opportunities
  • Complete monthly and annually regulatory reporting
  • Assist with data requests
  • Data Analysis: Compiles and analyzes data. May develop and/or maintain data models for what-if analysis and for other business purposes.
  • Metrics and Reporting: Develops and tracks program metrics. Develops and maintains standard, custom and ad-hoc reports.
  • Forecasting: Develops forecasts.
  • Data Integrity: Researches data issues; collaborates across organizations and data systems to resolve data issues.
  • BA/BS Degree in Computer Science, Business, Accounting, or Marketing
  • Six years of related work experience
  • Ability to write in SQL scripting
  • Knowledge of Teradata and CDW
  • Microsoft Access, Tableau, SAS, VBA or related
  • Understanding of root cause analysis and process improvement concepts, methods and techniques
  • Advanced Proficiency in Microsoft Office, Project, Visio
  • Effective oral and written communication skills
  • Advanced skills in Microsoft Excel and a love of excel modeling
  • Knowledge of different analytical methods, approaches and tactics
  • Energy Insights (EI) knowledge, including developing reports
  • CDW
  • NEBs (Non-Energy Benefits Tool)
  • CET (Cost Effective Tool)
  • Familiar with Utilities, Operations, and Energy Efficiency Programs


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 climate 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