Senior Gas Portfolio Assessment Analyst

Requisition ID# 161174Job Category: Accounting / FinanceJob Level: Individual ContributorBusiness Unit: Engineering, Planning & StrategyWork Type: HybridJob Location: OaklandDepartment OverviewThe Core Gas Supply Department (CGS) procures and manages natural gas supplies (including Renewable Natural Gas), transportation and storage for Pacific Gas and Electric Company's Core (residential and small commercial) customers. CGS strives to deliver reliable gas supplies while minimizing costs to our customers. Our performance is measured through the Core Procurement Incentive Mechanism (CPIM) incentive ratemaking program which compares actual portfolio costs against a set of independent industry benchmarks. CGS is an exciting and fast-paced organization that offers many learning opportunities through exposure to the regulatory approval process, asset acquisition, trading, portfolio planning and analytics, risk and compliance, and reporting. Renewable natural gas is a new addition to our portfolio.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 SummaryThe Senior Analyst position will work as part of a team to provide technical and commercial guidance based on analytical outcomes for the $1.5 billion natural gas commodity, storage and transportation portfolio. The successful candidate will focus on developing a strong understanding of the portfolio's cost models and participate in the team's portfolio planning to guide strategies to optimize performance. Additionally, this role will prepare cyclical reports on gas usage, trade data, and asset costs for ratemaking, compliance, and business finance reporting and improve data access as part of ongoing continuous improvement for robust analytics and recommendations.This position is hybrid, working from your remote office and your assigned work location based on business need. The preferred work location is Oakland, CA.PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of thejob posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will bebased on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience,market value, geographic location, and internal equity.Although we estimatethe successful candidate hiredinto this rolewill beplaced between the entry point and the middle of the range, the decisionwill be made on a case-by-casebasis related tothese factors.This job is also eligible to participate inPG&E's discretionary incentive compensation programs.A reasonable salary range is:Bay Area Minimum: $102,000Bay Area Maximum: $162,000Job ResponsibilitiesSupport gas transport and storage acquisition team overseeing 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 due to expiring contracts, changing market conditions, or regulatory rate cycles and mandates.Prepare inputs and run optimization model (transitioning to Python) to analyze gas storage and transportation scenarios for meeting forecasted residential customer load. Analyze output comparing forecasted costs and eliminating unreliable scenarios to recommend assets to gain support from management and regulators.Perform ad hoc analysis and present effective graphics supporting recommendations in response to trading needs or 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 tables 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.QualificationsMinimum:Bachelor's degree in Business, Economics, Statistics, or Finance; or four years equivalent experience3 years of relevant experienceDesired:Demonstrated use of scenario, least cost or regression analysisDemonstrated technical skills such as automation, pivot tables, macros, charting, and advanced formulas.Ability to manage multiple priorities simultaneously to meet deadlines in a time-sensitive environmentNatural gas or electric portfolio experienceExperience with data models and design, including Monte Carlo simulationExperience with Python, OpenLink Endur, Access, MATLAB, Teradata, Tableau, Visio, SQLDemonstrated Continuous Improvement experience and mindset#featuredjob