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.

Requirements

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.

Benefits

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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills

Pythonobject-oriented programmingquantitative modelingdata analysisstatistical modelingfinancial modelingdata visualizationdata extractiondata transformationdata loading

Soft skills

prioritizationoral communicationwritten communicationpresentation skillscollaborationanalytical thinkingproblem-solvingattention to detailtime managementinfluencing decision making