Loading...
Share this Job

Expert Gas Portfolio Assessment Analyst - San Francisco, CA

San Francisco, CA, US, 94105

Requisition ID # 50962 

Job Category : Accounting / Finance 

Job Level : Individual Contributor

Business Unit: Strategy & Policy

Job Location : San Francisco

Department Overview

The Core Gas Supply Department (CGS) procures and manages natural gas supplies, transportation and storage for Pacific Gas and Electric Company's Core (residential and small commercial) customers. CGS strives to ensure reliable gas supplies while minimizing costs where performance is measured through its annual Core Procurement Incentive Mechanism (CPIM) which benchmarks actual portfolio costs against a set of industry indicies.  CGS comprises an exciting and fast paced team which offers many learning opportunities through exposure to Regulatory approval process, Asset Acquisition, Trading, Portfolio Planning and Analytics, Risk and Compliance, and Reporting.

 

The Gas Portfolio Management and Analysis team is responsible for using various analysis techniques and models to support (1) asset acquisition and commodity trading optimization, (2) measuring actual performance relative to CPIM benchmark; (3) preparing metric and compliance reports, and (4) forecasting loads and costs.

 

Position Summary

The Expert Analyst position will lead efforts providing technical and commercial guidance based on analytical outcomes for the $0.8B natural gas commodity, storage and transportation portfolio.  The successful candidate will focus on developing a strong understanding the portfolio’s cost models, and leverage output to prepare portfolio plans to guide strategies to optimize performance.  S/he will submit cyclical reports on gas load forecast and actual usage, trade data, and asset costs for ratemaking, compliance, and business finance reporting, as well as improve data access as part of ongoing continuous improvement for robust analytics and recommendations.

 

Job Responsibilities 

  • Lead and support efforts for gas transport and storage acquisition and optimization for CGS’s $400M/year asset portfolio.  Use scenario, utilization, least cost and regression analysis while accounting for reliability and regulatory constraints to recommend transport and storage products for changing market conditions, expiring contracts, regulatory rate cycles and mandates.
  • Independently prepare input scenarios for optimization model (transitioning to Python) to analyze current gas storage and transportation assets for meeting forecasted residential customer load. Compare forecasted scenario costs, eliminate unreliable scenarios and present hedging and optimization plans for traders to execute.  Update model code for current asset mix and requirements.
  • Perform complex ad hoc analysis and present effective graphics supporting recommendations for trading needs and management requests.
  • Prepare accurate and timely monthly, quarterly and annual customer load and portfolio cost actuals and forecast reports for Accounting, Banking, Rates, EPP metric reporting and cash flow forecasting. 
  • Maintain automated data-scraping processes in MATLAB to aggregate gas pipeline maintenance schedules, Core gas loads and various rates and tariff information impacting trading, optimization and asset performance.  Future effort may involve converting to Python.
  • Create dashboards for traders and management using Excel and Tableau for displaying portfolio performance relative to CPIM Benchmark, storage and transport hedge positions, and progress on plan objectives. 
  • Organize data using Microsoft Access, Power BI or other to improve data access and accuracy for analysis, position monitoring, and dashboards.  Work with other Portfolio Management analysts to prioritize data needs and gather requirements to build tables.  
     
    Qualifications
    Minimum: 
  • Bachelor’s degree in Business, Economics, Statistics, or Finance; or four years equivalent experience required.
  • Requires a minimum of five years of relevant experience in data analytics and statistics
  • Gas or electric portfolio experience
  • Demonstrated use of scenario, least cost or regression analysis
  • Demonstrated technical skills such as automation, pivot tables, macros, charting, and advanced formulas.
     
    Desired:
  • Ability to manage multiple priorities simultaneously to meet deadlines in a time-sensitive environment
  • Experience with data models and design, including Monte Carlo simulation
  • Experience with Python, OpenLink Endur, Access, MATLAB, Teradata, Tableau, Visio, SQL
  • Demonstrated Continuous Improvement experience and mindset

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.

Company
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

EEO
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