Quantitative Analyst

Requisition ID # 169615 

Job Category: Business Operations / Strategy 

Job Level: Individual Contributor

Business Unit: Corporate Affairs

Work Type: Hybrid

Job Location: Oakland

Department Overview

The Rates department within PG&E’s Customer & Corporate Affairs organization develops and provides expertise on gas and electric customer rates in regulatory proceedings at the California Public Utilities Commission (CPUC) and the Federal Energy Regulatory Commission (FERC). 

With a primary focus on ensuring fair, equitable, and stable rates for our customers, the Rates department designs rate plans, conducts cost of service analyses, forecasts revenues, and analyzes trends and drivers impacting customer rates and bills.  We support other organizations in understanding energy usage various programs and policies that support our customers.

Position Summary

PG&E is seeking a Quantitative Analyst to support cost analyses used in PG&E’s electric and gas rate design proposals in regulatory proceedings.  These analyses are foundational for ensuring that our customers’ rates are designed fairly and equitably.  In this role, the Quantitative Analyst works cross-functionally to extract and process data from various internal sources, build models and perform analytics on cost-of-service related topics.  The Quantitative Analyst also supports evidentiary hearings including assisting expert witnesses on developing or revising proposals, summarizing and evaluating others’ proposals, and responding to external requests.  Utility business knowledge, an understanding of economic and financial concepts, and quantitative modeling such as programming, statistics and mathematics are key skills to be successful in this role. 

The successful candidate will embody a balance of analytic capability, intellectual curiosity, structured thinking, written and verbal communication skills, and team-orientation.

This position is hybrid, working from your remote office and Oakland General Office once per week and based on business needs.  

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.  

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

A reasonable salary range is: 

Bay Area Minimum:    $87,000
Bay Area Maximum:    $131,000

Responsibilities

• Acts as a witness assistant including writing sections of testimony; developing work papers and exhibits; preparing technical content of less complex data responses; reviewing, analyzing and summarizing third party testimony, regulatory proposals, pleadings, agreements and decisions; and assisting in developing or revising proposals and analyses for submittal in regulatory proceedings.
• Completes quantitative modeling, analysis and visualization of moderate scope and complexity with limited support.
• Extracts, transforms, and loads data from dissimilar sources including PG&E’s cloud systems.
• Builds analytical tools, quantitative, economic and financial models, data analysis and evaluations, interprets outcomes and develops recommendations for cost-of-service related regulatory filings.
• Maintains and updates models and assumptions.
• Adopts efficient tools and processes and ensures robust quality control of results.
• Prepares and maintains documentation of models and procedures.
• Presents key insights to influence decision making.
• Collaborates with teams across PG&E.
• Responds to time-sensitive requests related to the subject matter including modeling, analytics and visualization.

Qualifications

Required

• Bachelor’s degree in Data Science, Computer Science, Physics, Econometrics or Economics, Engineering, Mathematics, Applied Sciences, Statistics, Business or equivalent field.
• Job-related experience 2 years, OR Master’s Degree and 1 year job-related experience.

Desired

• 3 years of job-related experience.
• Utility industry experience.

• Skilled in Python, including object-oriented programming.
• Basic prioritization skills to effectively manage multiple assignments or a project with demanding time constraints

• Proficiency in Microsoft Excel, Word, and PowerPoint, and Power BI.
• Statistical and mathematical modeling experience.
• Some academic background in finance and/or economics.
• Strong oral and written communications skills and ability to concisely convey information based on unique audience needs
• Experience in making presentations and writing reports.
• Knowledge of project management, process improvement methods and techniques, or change management.