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.

Python

Machine Learning

Product Metrics

A/B Testing

Analytics

Statistics

Probability

Algorithms

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

Requisition ID # 155957 Job Category: Information Technology Job Level: Individual ContributorBusiness Unit: Information TechnologyWork Type: HybridJob Location: Oakland Department OverviewThe IT Meter to Cash Application Development team is responsible for software development and implementation of new functionality within the Customer Care and Billing system and its Direct Interfaces. This team works closely with the IT business analyst team to assure delivery of products and services that are top quality. Position SummaryWe are looking for an Expert Level IT applications design analyst in Customer Information team who can be a quick learner, thorough, organized, flexible to adapt in fast paced and dynamic environments. The analyst is mainly responsible for analyzing business requirements and developing function requirement and functional 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. A reasonable salary range is:Bay Area Minimum: $122,000Bay Area Maximum: $194,000 Job ResponsibilitiesIdeation:<ul><li style="text-align:justify">Work with business organizations to guide/provide input regarding enhancement feasibility</li><li style="text-align:justify">Using business process knowledge, proactively look for opportunities for system enhancements</li><li style="text-align:justify">Evaluate and provide input to business needs and requirements</li><li style="text-align:justify">Prepare estimates for customer requests</li><li style="text-align:justify">Prepare preliminary mockups and designs </li></ul> Project:<ul><li style="text-align:justify">Analyze/assemble Functional/non-Functional requirements</li><li style="text-align:justify">Provide technical expertise and assistance in designing, testing and developing applications</li><li style="text-align:justify">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</li><li style="text-align:justify">Prepare final functional requirement and functional design document</li><li style="text-align:justify">Conduct walkthrough of deliverables with business and IT Stakeholders and obtain approval/signoff</li><li style="text-align:justify">Provide Subject Matter Expert support to developers and testers</li><li style="text-align:justify">Work with business to document and analyze project change controls</li><li style="text-align:justify">Support stabilization of deployed code</li></ul> Maintenance:<ul><li style="text-align:justify">Troubleshoot potential system issues to determine if there is a defect</li><li style="text-align:justify">Analyze production defects, identify business and system impacts and quantify problems</li><li style="text-align:justify">Contribute to defect troubleshooting and solution design</li><li style="text-align:justify">Assist business and technical teams with ad hoc requests</li><li style="text-align:justify">Provide functional expertise to clients for resolving business issues</li></ul> QualificationsMinimum:<ul><li>Bachelors Degree in Computer Science or job-related discipline or equivalent experience</li><li>7 years experience in analyzing, designing and developing functional requirements, functional design, UX/UI design</li><li>Experience as Project Manager, high complexity</li></ul> Desired:<ul><li>Utility industry experience, job-related</li><li style="text-align:justify">Experience with CC&B Application</li><li style="text-align:justify">Oracle Utility C2M certified</li><li style="text-align:justify">Minimum 5 years of experience with Oracle CC&B applications, and data modeling</li><li style="text-align:justify">Working knowledge of relational databases (SQL experience) </li><li style="text-align:justify">Working knowledge of UML</li><li style="text-align:justify">Be able to work independently but within the framework of the team and product</li><li style="text-align:justify">Be able to work well within a team setting</li><li style="text-align:justify">Collaborate with cross functional teams to maintain efficiency, consistency and achieve successful implementation of system enhancement</li><li style="text-align:justify">Working knowledge of MS Office suite of applications, including Word, Excel, PowerPoint, Visio</li><li style="text-align:justify">Excellent verbal and written communication skills</li><li style="text-align:justify">Working knowledge of Salesforce CRM application and data model</li><li style="text-align:justify">Experience dealing with Call Center and/or Back Office centric business</li><li>Understanding of database/schema architecture</li></ul>

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