The PG&E Data Analyst interview guide, interview questions, salary data, and interview experiences.

PG&E Data Analyst Interview Guide

Getting ready for an Data Analyst interview at PG&amp;E? The PG&amp;E Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for PG&amp;E Data Analyst roles.</li>
<li>Gain insights into the Data Analyst interview process at PG&amp;E.</li>
<li>Practice real PG&amp;E Data Analyst interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the PG&amp;E Data Analyst interview.


Getting ready for an Data Analyst interview at PG&E? The PG&E Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for PG&E Data Analyst roles.
- Gain insights into the Data Analyst interview process at PG&E.
- Practice real PG&E Data Analyst interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the PG&E Data Analyst interview.
        

Overview

PG&E Data Analyst Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

PG&E Data Analyst Interview Process

As part of the financial management in a large corporation, the CFO wants to review the expenses in all departments for the previous financial year (2022).

Write a SQL query to calculate the total expenditure for each department in 2022. Additionally, for comparison purposes, return the average expense across all departments in 2022.

Note: The output should include the department name, the total expense, and the average expense (rounded to 2 decimal places). The data should be sorted in descending order by total expenditure.

<h3>Example:</h3>

Input:

<code>departments</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<code>expenses</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>department_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>amount</td>
<td>FLOAT</td>
</tr>

<tr>
<td>date</td>
<td>DATE</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>department_name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>total_expense</td>
<td>FLOAT</td>
</tr>

<tr>
<td>average_expense</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Calculate total and average expenses for each department.

Department Expenses

The probability that it will rain tomorrow is dependent on whether or not it is raining today and whether or not it rained yesterday.

If it rained yesterday and today, there is a 20% chance it will rain tomorrow. If it rained one of the days, there is a 60% chance it will rain tomorrow. If it rained neither today nor yesterday, there is a 20% chance it will rain tomorrow.

Given that it is raining today and that it rained yesterday, write a function <code>rain_days</code> to calculate the probability that it will rain on the nth day after today.

Example:

Input:

<pre tabindex="0" class="chroma"><code>n=5
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def rain_days(n) -&gt; 0.39968
</code></pre>

Given that it is raining today and that it rained yesterday, write a function to calculate the probability that it will rain on the nth day after today.

Rain in N Days

Let’s say that you’re a data scientist at Robinhood. 

How do we measure the launch of Robinhood’s fractional shares program?

Let’s say you are a data scientist at Robinhood.

Robinhood is introducing a program to allow users to buy fractional shares of publically listed companies.

Focusing in on the activity of new users, which of the following metrics would be the LEAST important to keep track of in determining if the program added value to Robinhood’s platform for new users?

Let's say you are a data scientist at Robinhood. 



Robinhood is introducing a program to allow users to buy fractional shares of publically listed companies.



Focusing in on the activity of new users, which of the following metrics would be the LEAST important to keep track of in determining if the program added value to Robinhood's platform for new users?

Fractional Shares Metrics

Fractional Shares

PG&E Data Analyst Interview Questions

<div id="sajCpTopImage"></div><div id="sajCpCustomDescription">Requisition ID# 162012Job Category: Business Operations / StrategyJob Level: Individual ContributorBusiness Unit: Electric OperationsWork Type: HybridJob Location: Dublin; Alameda; Alta; American Canyon; Angels Camp; Antioch; Auberry; Auburn; Avenal; Avila Beach; Bakersfield; Balch Camp; Bear Valley; Belden; Bellota; Belmont; Benicia; Berkeley; Brentwood; Brisbane; Buellton; Burney; Buttonwillow; Calistoga; Campbell; Canyon Dam; Canyondam; Capitola; Caruthers; Chico; Clearlake; Clovis; Coalinga; Colusa; Concord; Concord; Corcoran; Cottonwood; Cupertino; Daly City; Danville; Davis; Dinuba; Downieville; Emeryville; Eureka; Fairfield; Folsom; Fort Bragg; Fortuna; Fremont; French Camp; Fresno; Fresno; Fulton; Garberville; Geyserville; Gilroy; Grass Valley; Guerneville; Half Moon Bay; Hayward; Hinkley; Hollister; Holt; Huron; Jackson; Kerman; King City; Lakeport; Lemoore; Lincoln; Linden; Livermore; Lodi; Loomis; Los Banos; Lower Lake; Madera; Magalia; Manteca; Manton; Mariposa; Martell; Marysville; Maxwell; Menlo Park; Merced; Meridian; Millbrae; Milpitas; Modesto; Monterey; Montgomery Creek; Morgan Hill; Morro Bay; Moss Landing; Mountain View; Napa; Needles; Newark; Newman; Novato; Oakdale; Oakhurst; Oakland; Oakley; Olema; Orinda; Orland; Oroville; Palo Alto; Palo Cedro; Paradise; Parkwood; Paso Robles; Petaluma; Pioneer; Pismo Beach; Pittsburg; Placerville; Pleasant Hill; Point Arena; Potter Valley; Quincy; Rancho Cordova; Red Bluff; Redding; Richmond; Ridgecrest; Rio Vista; Rocklin; Roseville; Round Mountain; Sacramento; Salida; Salinas; San Bruno; San Carlos; San Francisco; San Francisco; San Jose; San Luis Obispo; San Mateo; San Rafael; San Ramon; San Ramon; Sanger; Santa Cruz; Santa Maria; Santa Nella; Santa Rosa; Selma; Shaver Lake; Sonoma; Sonora; South San Francisco; Springville; Stockton; Storrie; Taft; Tracy; Turlock; Twain; Ukiah; Vacaville; Vallejo; Walnut Creek; Wasco; Washington; Watsonville; West Sacramento; Wheatland; Whitmore; Willits; Willow Creek; Willows; Windsor; Winters; Woodland; Yuba CityDepartment OverviewThe team of Electric Operations ensure the delivery of safe and reliable electric service to our customers. Electric Operations is responsible for every aspect of PG&Es electric distribution and transmission operations, including planning, engineering, maintenance and construction, asset management, business planning, restoration and emergency response.Position SummaryConducts research, data analysis, budgeting, forecasting and reporting in support of business decision making, strategy and operations. Participates in business process improvement, quality control and other initiatives. Develops, manages and coordinates performance and quality assessment, business process re-engineering, change management, communication and training.Position duties may include (but are not limited to)- Executes configuration and administrative functions within the WFM scheduling tool, including Intraday performance configuration, security profile management, and configuration of reporting structures. Develops and uses metrics to develop recommendations related to business strategy and operations. Presents findings and recommendations to leaders. Performs analysis on complex data models requiring customized reports and data. Manages small to mid-size projects.Location is flexible within the PG&E Service Territory, please note hiring leader will make final decision of what are appropriate headquarters for the role based on business need. This position is hybrid, working from your remote office and your assigned work location based on business need. The assigned work location will be within the PG&E Service Territory.Position will require approximately 25% travel time in work schedule.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 towards the middle or entry point of the range, the decision will be made on a case-by-case basis related to these factors.A reasonable salary range is:Bay Area Minimum:$114,000Bay Area Maximum:$182,000ORCalifornia Minimum:$108,000California Maximum: $173,000This job is also eligible to participate in PG&Es discretionary incentive compensation programs.Job Responsibilities Performs analysis on highly complex data models that have cross- functional impact. Applies advanced knowledge to wide- ranging issues. Develops innovative data solutions to address complex business issues. Presents findings and proposed recommendations to leaders. Develop business cases in support of strategy or change initiatives. Works with and leverages relationships with Directors and Managers across functions / PG&E. Manages cross-functional projects or initiatives. Supervisory Responsibility- May provide direction and coaching to other Business Analysts.Qualifications-Minimum:<ul><li>BS in Business, Finance, Economics, Engineering or related discipline orequivalent work experience required.</li><li>6 years of related work experience</li></ul>Desired:<ul><li>Graduate Degree or equivalent experience</li></ul>#featuredjob</div><div id="sajCpQualifications"><div id="sajCpQualificationsRequired"><h3 class="jobOverviewSubtitle">Required</h3><ul></ul></div><div id="sajCpQualificationsPreferred"><h3 class="jobOverviewSubtitle">Preferred</h3><ul></ul></div></div><div id="sajCpIndustries"><h3 class="jobOverviewSubtitle">Job Industries</h3><ul><li><a id="sajCpSingleIndustryLink" href="https://www.snagajob.com//job-search/q-Other">Other</a></li></ul></div>

Requisition ID # 160963 Job Category: Business Operations / Strategy Job Level: Individual Contributor Business Unit: Information Technology Work Type: Hybrid Job Location: Oakland Department Overview It is an exciting time to be at PG&E at we are embarking on our 10-year True North Strategy, an enterprise strategy that sets a clear vision of what it means to achieve our Purpose: Delivering for Our Hometowns, Serving Our Planet, and Leading with Love. Information Systems Technology Services is a unified organization comprised of various departments which collaborate effectively in order to deliver high quality technology solutions. Powering PG&E with innovative solutions & services that drive reliability, security, and customer satisfaction. We are the trusted, climate-resilient, smart, digital utility platform that redefines the customer energy experience The Office of the CIO (OCIO) represents the cross-functional IT Management capabilities that enable running the business of IT. The OCIO focuses on supporting IT's operation model by ensuring a consistent, transparent and efficient approach to the way the IT organization delivers value to its partners. The core of the OCIO consists of four areas essential to the long-term success of IT: Contract Management, Culture, Program Management Office and Investment Management. Position Summary Conducts research, data analysis, budgeting, forecasting and reporting in support of business decision making, strategy and operations. Participates in business process improvement, quality control and other initiatives. Develops, manages and coordinates performance and quality assessment, business process re-engineering, change management, communication and training. This position is hybrid, working from your remote office and the Oakland General Office(OGO) up to 2 days a week and or as business needs change. 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. We would not anticipate that the individual hired into this role would land at or near the top half of the range described below, but the decision will be dependent on the facts and circumstances of each case.? A reasonable salary range is:? Bay Area Minimum: $114,000.00 Bay Area Maximum $182,000.00 Job Responsibilities <ul> <li>Applies advanced knowledge to wide- ranging issues. </li><li>Develop business cases in support of strategy or change initiatives. </li><li>Develops innovative data solutions to address complex business issues. Presents findings and proposed recommendations to leaders. </li><li>Executes OT/UT while managing call delivery requirements across sites. </li><li>May provide direction and coaching to other Business Analysts. </li><li>Performs analysis on highly complex data models that have cross- functional impact. </li><li>Works with and leverages relationships with Directors and Managers across functions / PG&E. </li><li>Build predictive models that will better detect anomalies, estimate accruals, and resolve financial imbalances. </li><li>Assist in the initiation, conducting and coordinating studies and analysis on IT operations, resource allocation, financial reviews; and analyzing programs to ensure that program goals and work plans are on target. </li><li>Participates and assists in the preparation of the annual business plans for the assigned IT functional area, and coordinates contract or resource management efforts including making recommendations based on analysis work. </li><li>Maintain annual capital and expense budgets utilizing proper accounting/budgeting controls, enter financial data into tracking system, and compile regular and ad-hoc financial status reports. </li><li>Implement cost allocation program and respond to questions and concerns from the business areas. Review contract invoices, identify disparities, and resolve issues with the vendors. </li></ul> Qualifications Minimum: <ul> <li>Bachelors Degree in Business Administration or job-related discipline or equivalent experience </li><li>6 years job-related experience </li><li>Strong knowledge of business and financial planning, professional concepts as they apply to the IT organization </li><li>Experience with budgeting process </li><li>Strong organizational business understanding </li><li>Advanced Microsoft Suite knowledge in Excel, Project, Access Word; able to create pivot tables </li><li>Advanced business analysis research and problem-solving skills. </li></ul> Desired: <ul> <li>Graduate Degree or equivalent experience </li><li>Experience with Amazon Web Marketplace </li><li>Tools: JIRA, SMC Remedy, Wiki </li></ul> #featuredjob

Requisition ID# 161819
Job Category: Business Operations / Strategy
Job Level: Individual Contributor
Business Unit: Electric Operations
Work Type: Hybrid
Job Location: Sacramento
Department Overview
PG&E's Underground Program organization is working to reduce wildfire risk each day as we underground 10,000 miles of distribution lines. We are responsible for working across all internal teams and engaging external stakeholders to support successfully meeting our goals and reducing wildfire risk in our hometowns. We work in an exciting and fast-paced environment.
Position Summary
Conducts research, data analysis, budgeting, forecasting and reporting in support of business decision making, strategy and operations. Participates in business process improvement, quality control and other initiatives. Develops, manages and coordinates performance and quality assessment, business process re-engineering, change management, communication and training.
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 towards the middle or entry point of the range, the decision will be made on a case-by-case basis related to these factors.
A reasonable salary range is:
Minimum Base Salary (Bay Area) $ 114,000.00
Maximum Base Salary (Bay Area) $ 182,000.00
OR
Minimum Base Salary (California) $ 108,000.00
Maximum Base Salary (California) $ 173,000.00
Job Responsibilities
Performs analysis on highly complex data models that have cross- functional impact.
Applies advanced knowledge to wide- ranging issues.
Performs analysis, visual management on a wider range of program performance metrics
Compile granular project level cost analytics as well as overall unit cost calculations.
Research, develop, & maintain data models used for steady state or ad hoc reporting.
Facilitation of program/project change control processes
Assist with review, compilation, response to data request from internal and external stakeholders.
Develops innovative data solutions to address complex business issues. Presents findings and proposed recommendations to leaders.
Develop business cases in support of strategy or change initiatives.
Works with and leverages relationships with Directors and Managers across functions / PG&E.
Manages cross-functional projects or initiatives.
May provide direction and coaching to other Business Analysts.
Qualifications
Minimum:
BS in Business, Finance, Economics, Engineering or related discipline or equivalent work experience required.
6 years related work experience
Proficiency in Microsoft Office, Power BI, Power Query, Power Automate, Python, Power Apps, and Advanced Excel.
Desired:
MBA or graduate degree
Extensive knowledge of different analytical methods, approaches and tactics.
Broad expertise in what-if modeling analysis, concepts, methods and techniques and analysis of how different factors affect business outcomes.
Creative problem-solving skills to develop solutions.
Strong analytical and writing skills to create compelling business cases based on complex business environments and inputs.
Influence skills to effectively gain buy in from leaders inside and outside of the department Knowledge and understanding of key drivers affecting business results.
Project management skills to lead large and complex projects working with cross-functional teams.
Organizational, prioritization and multi-tasking skills.
Adaptable to changing business conditions and ambiguity.
Proficiency in SQL, VBA, P6, Visio or similar software.
#featuredjob

Job Category: Business Operations / Strategy
Job Level: Individual Contributor
Business Unit: Electric Operations
Work Type: Hybrid
Department Overview
PG&E's Underground Program organization is working to reduce wildfire risk each day as we underground 10,000 miles of distribution lines. We are responsible for working across all internal teams and engaging external stakeholders to support successfully meeting our goals and reducing wildfire risk in our hometowns. We work in an exciting and fast-paced environment.
Position Summary
Conducts research, data analysis, budgeting, forecasting and reporting in support of business decision making, strategy and operations. Participates in business process improvement, quality control and other initiatives. Develops, manages and coordinates performance and quality assessment, business process re-engineering, change management, communication and training.
This position is hybrid, working from your remote office and assigned location based on business needs.
Salary Range
A reasonable salary range is:
Minimum Base Salary (Bay Area): $98,000.00
Maximum Base Salary (Bay Area): $146,000.00
Job Responsibilities
Performs analysis on complex data models requiring customized reports and data.
Performs analysis, visual management on a wider range of program/project performance metrics.
Develops new or revises existing data analysis to predict business outcomes selecting from various complex variables.
Research, develop, & maintain data models used for steady state or ad hoc reporting.
Manages cross-functional projects or initiatives.
Develops and uses metrics to develop recommendations related to business strategy and operations. Presents findings and recommendations to leaders.
Manages small to mid-size projects.
Qualifications
Minimum:
Bachelor of Science in Business, Finance, Economics, Engineering or related discipline or equivalent work experience required.
4 years of related work experience.
Broad knowledge of different analytical methods, approaches and tactics.
Advanced understanding of fundamental analysis and what-if modeling concepts, methods and techniques and analysis of how different factors affect business outcomes.
Creative problem-solving skills to develop solutions.
Qualitative and quantitative analytical skills to justify any business changes.
Strong presentation and communication skills to deliver findings and recommendations to various levels of management.
Knowledge and understanding of key drivers affecting business results.
Strong project management knowledge and skills to lead project teams.
Excellent organizational, prioritization and multi-tasking skills.
Adaptable to changing business conditions and ambiguity.
Proficiency in Microsoft Office, SQL, Power BI, Power Automate, Python, VBA P6, Advanced Excel, Visio or similar software.

#J-18808-Ljbffr

Requisition ID # 160358
Job Category: Information Technology
Job Level: Individual Contributor
Business Unit: Information Technology
Work Type: Hybrid
Job Location: Oakland
Department Overview
Meter to Cash (MTC) Delivery is responsible for analyzing and designing work that impacts the Meter to Cash systems and their direct interfaces. This team works with business and technical stakeholders to obtain the best possible solutions for its clients.
Its deliverables include providing estimates for MTC related work; developing an internal work plan with identified resources and target completion dates; and preparing requirements and functional designs. To ensure the MTC Delivery team provides the utmost service to its clients, it is organized into three functional areas that align with PG&E’s business operations: Customer Information, Billing/Finance, and Measure & Field Services.
Position Summary
We are looking for an Expert level IT business analyst in MTC Delivery Billing/Finance team who can be a quick learner, thorough, organized, flexible to adapt in fast paced and dynamic environments. The analyst serves as a subject matter expert for assigned area of coverage with in-depth knowledge of the business practices and MTC functionality that supports it. The analyst is mainly responsible for analyzing business requirements, proposing system solution and developing function requirement and function design documents. In addition, the analyst is responsible for analyzing O&M and project defects to determine business/technical impact and providing recommendation on fixing the defects.

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.  We would not anticipate that the individual hired into this role would land at or near the top half of the range described below, but the decision will be dependent on the facts and circumstances of each case.
A reasonable salary range is:
Bay Area Minimum: $122,000.00
Bay Area Maximum: $194,000.00
&/OR
California Minimum: $116,000.00
California Maximum: $184,000.00
Qualifications
Minimum:
Bachelor’s degree in Computer Science, Information Systems or job-related discipline or equivalent work experience
Minimum 7 years of experience in analyzing, designing and developing functional requirements and application functional design in rate billing and financial domain
Minimum 5 years of working experience of Oracle CC&B/BCS/C2M application and data model
Participation in projects of high complexity.
Desired:
Experience in CC&B billing financial and Energy Service Provide direct access, Community Choice Aggregation rate billing
Working knowledge of relational databases (SQL experience)
Excellent verbal and written communication
Collaborate with cross functional teams to maintain efficiency, consistency and achieve successful implementation of system enhancement
Working experience with the corresponding Line of Business
Leadership role in projects of high complexity
Working knowledge of MS Office suite of applications, including Word, Excel, PowerPoint, Visio
CCBA-certification of Competency in Business Analysis certification

Responsibilities
Ideation:
Work with business organizations to provide input regarding enhancement feasibility
Using business process knowledge, proactively look for opportunities for system enhancements
Evaluate and provide input to “business concept requirements”
Prepare high level design approach and develop concept estimation
Anticipate client concerns and questions, and provide proactive, timely and professional client-focused communications.
Project:
Analyze/assemble Functional/non-Functional requirements
Analyze and design solutions independently with minimal guidance as needed on the most complex projects.
Provide technical expertise and assistance in designing, testing and developing applications
Perform feasibility analysis, design and provide recommendations on the alternative solutions, project strategy and deliverable prioritization, as well as system alternatives or enhancements to current systems
Prepare functional requirement and functional design documentation
Conduct walkthrough of deliverables with business and obtain approval/signoff
Provide SME support to developers and testers
Work with business to document and analyze project change controls
Work with business to document and analyze project change controls
Work effectively with other groups to persuade, exchange ideas and foster cooperation
Analyze end-to-end business processes of moderate to high complexity and information needs of the clients in one or more business functional areas.
Support stabilization of deployed code
Comply with SOX and other standard process requirements.
Provide expert consulting in information technology to the client to identify and satisfy the business needs.
Provide timely responses to client inquiries or delegate as appropriate.
Provides mentorship and guidance to less experienced employees.
Review design and technical specification documents for alignment with business solution.
Serves as key technical resource within the area of specialization.
Mentors the Associate and Career-level team members.
Understand in detail the current and future business environment of the business clients; effectively anticipate, identify, and fully meet the business needs.
Maintenance:
Troubleshoot potential MTC system issues to determine if there is a defect
Analyze production defects, identify business and system impacts and quantify problems
Contribute to defect troubleshooting and solution design
Assist business and technical teams with adhoc requests
Provide functional expertise to clients for resolving business issues
#featuredjob

Requisition ID # 160358
Job Category: Information Technology
Job Level: Individual Contributor
Business Unit: Information Technology
Work Type: Hybrid
Job Location: Oakland
Department Overview
Meter to Cash (MTC) Delivery is responsible for analyzing and designing work that impacts the Meter to Cash systems and their direct interfaces. This team works with business and technical stakeholders to obtain the best possible solutions for its clients.

Its deliverables include providing estimates for MTC related work; developing an internal work plan with identified resources and target completion dates; and preparing requirements and functional designs. To ensure the MTC Delivery team provides the utmost service to its clients, it is organized into three functional areas that align with PG&E’s business operations: Customer Information, Billing/Finance, and Measure & Field Services.

Position Summary
We are looking for an Expert level IT business analyst in MTC Delivery Billing/Finance team who can be a quick learner, thorough, organized, flexible to adapt in fast paced and dynamic environments. The analyst serves as a subject matter expert for assigned area of coverage with in-depth knowledge of the business practices and MTC functionality that supports it. The analyst is mainly responsible for analyzing business requirements, proposing system solution and developing function requirement and function design documents. In addition, the analyst is responsible for analyzing O&M and project defects to determine business/technical impact and providing recommendation on fixing the defects.

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.  We would not anticipate that the individual hired into this role would land at or near the top half of the range described below, but the decision will be dependent on the facts and circumstances of each case.

A reasonable salary range is:
Bay Area Minimum: $122,000.00
Bay Area Maximum: $194,000.00
&/OR
California Minimum: $116,000.00
California Maximum: $184,000.00

Qualifications
Minimum:
Bachelor’s degree in Computer Science, Information Systems or job-related discipline or equivalent work experience
Minimum 7 years of experience in analyzing, designing and developing functional requirements and application functional design in rate billing and financial domain
Minimum 5 years of working experience of Oracle CC&B/BCS/C2M application and data model
Participation in projects of high complexity.

Desired:
Experience in CC&B billing financial and Energy Service Provide direct access, Community Choice Aggregation rate billing
Working knowledge of relational databases (SQL experience)
Excellent verbal and written communication
Collaborate with cross functional teams to maintain efficiency, consistency and achieve successful implementation of system enhancement
Working experience with the corresponding Line of Business
Leadership role in projects of high complexity
Working knowledge of MS Office suite of applications, including Word, Excel, PowerPoint, Visio
CCBA-certification of Competency in Business Analysis certification

Responsibilities
Ideation:
Work with business organizations to provide input regarding enhancement feasibility
Using business process knowledge, proactively look for opportunities for system enhancements
Evaluate and provide input to “business concept requirements”
Prepare high level design approach and develop concept estimation
Anticipate client concerns and questions, and provide proactive, timely and professional client-focused communications.
Project:
Analyze/assemble Functional/non-Functional requirements
Analyze and design solutions independently with minimal guidance as needed on the most complex projects.
Provide technical expertise and assistance in designing, testing and developing applications
Perform feasibility analysis, design and provide recommendations on the alternative solutions, project strategy and deliverable prioritization, as well as system alternatives or enhancements to current systems
Prepare functional requirement and functional design documentation
Conduct walkthrough of deliverables with business and obtain approval/signoff
Provide SME support to developers and testers
Work with business to document and analyze project change controls
Work with business to document and analyze project change controls
Work effectively with other groups to persuade, exchange ideas and foster cooperation
Analyze end-to-end business processes of moderate to high complexity and information needs of the clients in one or more business functional areas.
Support stabilization of deployed code
Comply with SOX and other standard process requirements.
Provide expert consulting in information technology to the client to identify and satisfy the business needs.
Provide timely responses to client inquiries or delegate as appropriate.
Provides mentorship and guidance to less experienced employees.
Review design and technical specification documents for alignment with business solution.
Serves as key technical resource within the area of specialization.
Mentors the Associate and Career-level team members.
Understand in detail the current and future business environment of the business clients; effectively anticipate, identify, and fully meet the business needs.
Maintenance:
Troubleshoot potential MTC system issues to determine if there is a defect
Analyze production defects, identify business and system impacts and quantify problems
Contribute to defect troubleshooting and solution design
Assist business and technical teams with adhoc requests
Provide functional expertise to clients for resolving business issues
#featuredjob

Requisition ID # 161822
Job Category: Business Operations / Strategy
Job Level: Individual Contributor
Business Unit: Electric Operations
Work Type: Hybrid
Job Location: Sacramento
Department Overview

PG&E’s Underground Program organization is working to reduce wildfire risk each day as we underground 10,000 miles of distribution lines.  We are responsible for working across all internal teams and engaging external stakeholders to support successfully meeting our goals and reducing wildfire risk in our hometowns.  We work in an exciting and fast-paced environment.

Position Summary

Conducts research, data analysis, budgeting, forecasting and reporting in support of business decision making, strategy and operations. Participates in business process improvement, quality control and other initiatives. Develops, manages and coordinates performance and quality assessment, business process re-engineering, change management, communication and training.

This position is hybrid, working from your remote office and assigned location 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 towards the middle or entry point of the range, the decision will be made on a case-by-case basis related to these factors.

A reasonable salary range is:

Minimum Base Salary (Bay Area)           $ 98,000.00
Maximum Base Salary (Bay Area)          $ 146,000.00

Job Responsibilities

Performs analysis on complex data models requiring customized reports and data.
Performs analysis, visual management on a wider range of program/project performance metrics
Develops new or revises existing data analysis to predict business outcomes selecting from various complex variables.
Research, develop, & maintain data models used for steady state or ad hoc reporting.
Manages cross-functional projects or initiatives.
Develops and uses metrics to develop recommendations related to business strategy and operations. Presents findings and recommendations to leaders.
Manages small to mid-size projects.

Qualifications

Minimum:

Bachelor of Science in Business, Finance, Economics, Engineering or related discipline or equivalent work experience required.
4 years of related work experience

Desired:

MBA or graduate degree
Broad knowledge of different analytical methods, approaches and tactics.
Advanced understanding of fundamental analysis and what-if modeling concepts, methods and techniques and analysis of how different factors affect business outcomes.
Creative problem skills to develop solutions.
Qualitative and quantitative analytical skills to justify any business changes.
Strong presentation and communication skills to deliver findings and recommendations to various levels of management.
Knowledge and understanding of key drivers affecting business results.
Strong project management knowledge and skills to lead project teams.
Excellent organizational, prioritization and multi-tasking skills.
Adaptable to changing business conditions and ambiguity.
Proficiency in Microsoft Office, SQL, Power BI, Power Automate, Python, VBA P6, Advance Excel, Visio or similar software.

#featuredjob

Requisition ID # 161819
Job Category: Business Operations / Strategy
Job Level: Individual Contributor
Business Unit: Electric Operations
Work Type: Hybrid
Job Location: Sacramento
Department Overview
PG&E’s Underground Program organization is working to reduce wildfire risk each day as we underground 10,000 miles of distribution lines.  We are responsible for working across all internal teams and engaging external stakeholders to support successfully meeting our goals and reducing wildfire risk in our hometowns.  We work in an exciting and fast-paced environment.

Position Summary
Conducts research, data analysis, budgeting, forecasting and reporting in support of business decision making, strategy and operations. Participates in business process improvement, quality control and other initiatives. Develops, manages and coordinates performance and quality assessment, business process re-engineering, change management, communication and training.
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 towards the middle or entry point of the range, the decision will be made on a case-by-case basis related to these factors.
A reasonable salary range is:
Minimum Base Salary (Bay Area)           $ 114,000.00
Maximum Base Salary (Bay Area)          $ 182,000.00
OR
Minimum Base Salary (California)           $ 108,000.00
Maximum Base Salary (California)          $ 173,000.00

Job Responsibilities
Performs analysis on highly complex data models that have cross- functional impact.
Applies advanced knowledge to wide- ranging issues.
Performs analysis, visual management on a wider range of program performance metrics
Compile granular project level cost analytics as well as overall unit cost calculations.
Research, develop, & maintain data models used for steady state or ad hoc reporting.
Facilitation of program/project change control processes
Assist with review, compilation, response to data request from internal and external stakeholders.
Develops innovative data solutions to address complex business issues. Presents findings and proposed recommendations to leaders.
Develop business cases in support of strategy or change initiatives.
Works with and leverages relationships with Directors and Managers across functions / PG&E.
Manages cross-functional projects or initiatives.
May provide direction and coaching to other Business Analysts.

Qualifications

Minimum:
BS in Business, Finance, Economics, Engineering or related discipline or equivalent work experience required.
6 years related work experience
Proficiency in Microsoft Office, Power BI, Power Query, Power Automate, Python, Power Apps, and Advanced Excel.

Desired:
MBA or graduate degree
Extensive knowledge of different analytical methods, approaches and tactics.
Broad expertise in what-if modeling analysis, concepts, methods and techniques and analysis of how different factors affect business outcomes.
Creative problem-solving skills to develop solutions.
Strong analytical and writing skills to create compelling business cases based on complex business environments and inputs.
Influence skills to effectively gain buy in from leaders inside and outside of the department Knowledge and understanding of key drivers affecting business results.
Project management skills to lead large and complex projects working with cross-functional teams.
Organizational, prioritization and multi-tasking skills.
Adaptable to changing business conditions and ambiguity.
Proficiency in SQL, VBA, P6, Visio or similar software.
#featuredjob

Requisition ID # 161820 Job Category:Business Operations / Strategy Job Level:Individual ContributorBusiness Unit:Electric OperationsWork Type:HybridJob Location:Oakland; Sacramento  Department Overview PG&amp;E's Underground Program organization is working to reduce wildfire risk each day as we underground 10,000 miles of distribution lines. We are responsible for working across all internal teams and engaging external stakeholders to support successfully meeting our goals and reducing wildfire risk in our hometowns. We work in an exciting and fast-paced environment.  Position Summary Conducts research, data analysis, budgeting, forecasting and reporting in support of business decision making, strategy and operations. Participates in business process improvement, quality control and other initiatives. Develops, manages and coordinates performance and quality assessment, business process re-engineering, change management, communication and training. This position is hybrid, working from your remote office and assigned location based on business needs. The assigned work location will be within Oakland or Sacramento and will be agreed upon by the successful candidate and hiring leader. PG&amp;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 towards the middle or entry point of the range, the decision will be made on a case-by-case basis related to these factors. A reasonable salary range is: Minimum Base Salary (Bay Area) $ 114,000.00Maximum Base Salary (Bay Area) $ 182,000.00  Job Responsibilities Performs analysis on highly complex data models that have cross- functional impact.Applies advanced knowledge to wide- ranging issues.Performs analysis, visual management on a wider range of program performance metricsCompile granular project level cost analytics as well as overall unit cost calculations.Research, develop, &amp; maintain data models used for steady state or ad hoc reporting.Facilitation of program/project change control processesAssist with review, compilation, response to data request from internal and external stakeholders.Develops innovative data solutions to address complex business issues. Presents findings and proposed recommendations to leaders.Develop business cases in support of strategy or change initiatives.Works with and leverages relationships with Directors and Managers across functions / PG&amp;E.Manages cross-functional projects or initiatives.May provide direction and coaching to other Business Analysts.  Qualifications Minimum: BS in Business, Finance, Economics, Engineering or related discipline or equivalent work experience required.6 years related work experience  Desired: MBA or graduate degreeExtensive knowledge of different analytical methods, approaches and tactics.Broad expertise in what-if modeling analysis, concepts, methods and techniques and analysis of how different factors affect business outcomes.Creative problem-solving skills to develop solutions.Strong analytical and writing skills to create compelling business cases based on complex business environments and inputs.Influence skills to effectively gain buy in from leaders inside and outside of the department Knowledge and understanding of key drivers affecting business results.Project management skills to lead large and complex projects working with cross-functional teams.Organizational, prioritization and multi-tasking skills.Adaptable to changing business conditions and ambiguity.Proficiency in Microsoft Office, SQL, Power BI, Power Automate, Python, VBA P6, Advance Excel, Visio or similar software.  #featuredjob

PG&E Data Analyst Interview Guide

Overview

PG&E Data Analyst Salary

PG&E Data Analyst Interview Process

PG&E Data Analyst Interview Questions

PG&E Data Analyst Jobs