Business Analyst, Expert

Requisition ID # 164503 

Job Category: Business Operations / Strategy 

Job Level: Individual Contributor

Business Unit: Customer & Enterprise Solutions

Work Type: Hybrid

Job Location: Oakland

Department Overview

At PG&E, we are committed to delivering for our hometowns, serving our planet and leading with love. Customers are at the center of everything we do, and our philosophy “Customer at the Heart” reinforces this stance in our work across all functional areas.  We build customers’ trust by delivering a ten out of ten experience in every interaction.  The Revenue Controls and Policy team is responsible for the integrity of customers’ bills and payments through rigorous testing, monitoring, and controls.  This includes guidance on complex policies impacting revenues and representing the Company in high-impact forums to maintain trust and transparency for our communities.  Additionally, we collaborate with municipal, county, and state agencies to ensure adherence to relevant laws, regulations, and standards.

Position Summary

PG&E is seeking an individual experienced in complex rate/program implementation to manage end-to-end business user testing. The definition of “end-to-end” business user testing includes five main categories: (1) reviewing and documenting program requirements, (2) ensuring billing system changes align with program requirements outlined in the advice filing, (3) developing test strategies to minimize customer impact, (4) creating program requirements via an Excel template, and (5) performing actual testing scenarios. Additional responsibilities include data analysis, research, reporting, monthly cash and customer refund reconciliation. The position also involves recurring monthly/quarterly/annual remittance of taxes and fees, support for billed revenue financial data reporting, and evaluating and recommending improvements for business processes, practices, and procedures. The ideal candidate is a self-starter who can adapt to a fast-changing environment and work with colleagues focused on customer advocacy.

This position is hybrid, working from your remote office and the Oakland General Office (OGO) 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: $114,000     

Bay Area Maximum: $182,000      

 Job Responsibilities

• Develop or modify gas and electric rate calculation templates for user acceptance testing due to regulatory decisions affecting gas/electric rates.
• Address various requests and inquiries from internal and external customers, ensuring all data provided aligns with utility standards.
• Present findings regarding rate calculation issues and offer recommendations to management or others within the organization.
• Proactively assess the impact of billing system implementation on downstream user experiences.
• Develop and monitor metrics that provide data for process measurement, business operations, or risk assessment.
• Promote continuous improvement by analyzing complex problems, anticipating issues, and presenting findings and recommendations to stakeholders at all levels of the organization.
• Collaborate and coordinate with IT for rate value changes or the implementation of new programs.
• Acquire expertise in billing systems and regulatory matters.
• Conduct validation of various bill credits, including electric/gas climate credits and associated taxes/fees.
• Assist with monthly, quarterly, and annual tax remittances.
• Support the Customer Revenue Insight (CRI-billed revenue data) system by providing accurate and timely recurring/ad-hoc reports.
• Assist the leadership team with special projects, such as new business initiatives and audits.
• Offer feedback and coaching to peers and leaders across the organization to enhance programs, processes, and controls.
• Challenge the status quo and business decisions when necessary, presenting suitable alternatives.
• Develop and update procedures to ensure process documentation is available for business continuity.
• Reconciliation between reporting systems.
• Facilitate problem resolution and oversee solution deployment.

Minimum:

• A Bachelor of Science in Business, Finance, Economics, Engineering, or a job-related discipline, or equivalent work experience is required.
• Six years of relevant work experience.

Desired:

• MBA or graduate degree.
• Extensive expertise in both qualitative and quantitative analytical methods.
• Experience in the utility industry, with knowledge of CA Public Utilities Code, tariffs, rules, regulations, standards, and local ordinances.
• Advanced understanding of PG&E’s billing systems.
• Proficiency with SAP, Oracle Utility Analytics, SQL, Teradata, and Microsoft Power BI suite.
• Ability to be creative, versatile, efficient, and productive in the face of ambiguity.
• Advanced skills in Visual Basics for applications (VBA), Excel, including slicers, pivot tables, and conditional formulas.
• Expertise in Power BI.
• A keen focus on detail.
• Strong and persuasive verbal/written communication skills.
• Continuous improvement mindset to analyze complex problems, anticipate issues, and present findings and recommendations to stakeholders at all levels of the organization.

#featuredjob