Principal Strategic Analyst at Pacific Gas and Electric – Oakland, CA,

Principal Strategic Analyst at Pacific Gas and Electric Company – Oakland, CA, US, 94612

Requisition # 164183

Job Category:
Business Operations / Strategy

Job Level: Manager/Principal

Business Unit:
Finance

Work Type:
Hybrid

Job Location:

Oakland

Department Overview
The Business Finance teams provide financial planning and reporting services to PG&E and is responsible for providing strategic direction and coordination in respect to strategic functional area planning processes, financial planning, forecasting, analytics and reporting.

The Value Delivery program, part of the Business Finance team, is a transformative effort to optimize PG&E’s strategy to realize value to support the company’s long‑term growth while maintaining affordability for our customers. With the goal of improving our Cap/Expense ratio over a six‑year period – representing $1‑$2B in savings, the program will lead the enterprise plan to deliver operational efficiency and financial performance.

We are seeking a highly skilled and accomplished Principal Strategic Analyst to define and execute on structured analysis. The ideal candidate would have worked for MBB, Big 4, Private Equity or PE focused consulting companies or worked on transformation, cost reduction, Bizops focused roles at large enterprises. They will have a structured hypotheses based problem‑solving mindset with detailed understanding of the underlying data and data structures of multiple systems to allow in‑depth analysis of existing and potential data insights.

The role is hybrid working from your remote office and in‑person at the Oakland General Office 2‑3x weekly or 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.

Although we estimate the successful candidate hired into this role will be placed between the entry point and the middle of the range, the decision will be made on a case‑by‑case basis related to these factors. This job is also eligible to participate in PG&E’s discretionary incentive compensation programs.

A reasonable salary range is:

Bay Area Minimum: $

Bay Area Maximum: $

• Evaluate enterprise performance and provide data‑driven insights that lead to actionable recommendations
• Frame analytic approaches and lead quantitative analyses that will yield critical answers to key questions
• Collect data from a wide variety of enterprise databases, including SAP, Oracle CC&B, ECC, Alteryx, Foundry, Redshift, MSSQL, Synapse, Excel, plain or formatted text files, etc.
• Implement automated data ingestion and transformation processes
• Enrich company data through external and public sources
• Design database models, efficient table structures, and advanced schemas that carry out data quality and consistency standards
• Apply modern modeling approaches, business intelligence patterns, and data management techniques
• Rock‑solid SQL skills to work with extensive volumes –millions of rows- of data at various aggregation levels
• Develop code/scripts to apply data processing logic and business rules
• Apply statistical learning toolsets to build predictive models that enrich, expand, and allow a deeper understanding of data analyses and solutions
• Well versed with Python/SAS to build descriptive predictive models that enrich, expand, and allow a deeper understanding of data analyses and solutions
• Use of interactive data visualization tools, such as Tableau and Power BI, to present results in a compelling manner, for the benefit of internal or client teams
• Ability to tell a convincing story to C‑level executives using visual charts and dashboards
• Present complicated technical findings to a non‑technical audience
• Prepare polished documents and compelling presentation materials
• Work with all levels of leadership (up to and including SVP/EVP) across functions to drive…