The Puget Sound Energy Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Puget Sound Energy Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Puget Sound Energy? The Puget Sound Energy Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Puget Sound Energy Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Puget Sound Energy.</li>
<li>Practice real Puget Sound Energy Business Intelligence interview questions.</li>
</ul>
<p>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 Puget Sound Energy Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Puget Sound Energy? The Puget Sound Energy Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Puget Sound Energy Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Puget Sound Energy.
- Practice real Puget Sound Energy Business Intelligence 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 Puget Sound Energy Business Intelligence interview.
        

Overview

Puget Sound Energy Business Intelligence Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

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

Puget Sound Energy Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</p>

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

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

<p>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>transactions</code> table</p>

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

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

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

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

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

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p> 
<strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Puget Sound Energy Business Intelligence Interview Questions

<p>Remote and Hybrid Work Opportunities: Hybrid (WA Based)</p><p>Puget Sound Energy is looking to grow our community with top talented individuals like you! With our rapidly growing, award-winning energy efficiency programs, our pathway to an exciting and innovative future is now.</p><p>PSE's Energy Supply Merchant team is looking for qualified candidates to fill an open <b>Consulting Quantitative Risk Analyst</b> position!</p><p>Specific details regarding the work arrangements for this position will be discussed in further detail during the interview process.</p><p>Work directly with the PSE Merchant traders to lead the technical administration, maintenance, and operation of the unified PCI ETRM platform. Work with traders and business analysts to design technical solutions to improve the performance of trading, compliance, auditing, and all related operations for the Merchant organization. Coordinate with PSE’s primary ETRM vendor to coordinate design, development, and deployment of system upgrades and improvements. Works with PSE’s data group to design and deploy a unified data architecture for trading and related data.</p><p>Upholds the safety compliance standards inherent in PSE’s operating and/or field procedures related to work responsibilities. Promotes and supports a culture of total safety.</p><p>Demonstrates commitment to conduct business honestly, ethically and consistent with our core values and Code of Conduct. Ensures duties are performed in accordance with all regulatory compliance obligations.</p><h3><b>Job Responsibilities</b></h3><ul><li>Provide technical leadership on administration of the power and gas PCI ETRM platform.</li><li>Work closely with power and gas traders to design optimization and trading solutions inside of the PCI ETRM platform.</li><li>Create and improve quantitative models for forecasting and optimization of natural gas and electric resources, portfolio management, and energy trading activities.</li><li>Own and be accountable for accuracy of model results inside the PCI platform and justification of methodologies.</li><li>Coordinate resolution of technical issues inside the PCI ETRM with the vendor.</li><li>Design and coordinate implementation of data management solutions supporting trading operations inside or outside of the PCI ETRM platform.</li><li>Perform ad hoc analysis and other duties as assigned.</li></ul><h3><b>Minimum Qualifications</b></h3><ul><li>Bachelor’s degree in a relevant field (Finance, Economics, Statistics, Engineering, or similar).</li><li>Minimum 8 years work experience, with at least 4 as a quantitative analyst in the energy industry.</li><li>Proficiency with quantitative methods and concepts including regression analysis, Monte Carlo simulations, stress testing, and scenario analysis.</li><li>Familiarity with production cost modeling and software such as Plexos, Aurora, GenTrader, PROMOD, etc.</li><li>Programming experience in Python, R, SQL, MATLAB, or similar.</li><li>Experience with financial analysis and risk measurement techniques.</li><li>Advanced skills in MS Office, especially Excel, including proficiency in writing macros and queries.</li><li>Excellent communication, writing, and presentation skills.</li><li>Ability to work effectively without direct supervision in a fast-paced, stressful, and multitasking environment.</li></ul><h3><b>Desired Qualifications</b></h3><ul><li>3+ years of direct experience using or supporting PCI ETRM software.</li><li>10+ years of energy industry experience, preferably in a technical role.</li><li>Familiarity with electricity and natural gas trading and risk management operations software.</li><li>Knowledge of western natural gas and power markets.</li></ul><h3><b>Additional Information</b></h3><p>At PSE we value and respect our employees and provide them opportunities to excel. We offer a competitive compensation and rewards package.</p><p>The pay range for this position is $116,300.00 - $193,600.00, and this position is eligible for annual goals-based incentive bonuses.</p><p>PSE offers a suite of benefits to our employees. Employees are eligible for medical, dental, vision, basic life, and short- and long-term disability insurance. There are additional voluntary options of supplemental life insurance, accidental death and dismemberment insurance, flexible spending accounts for health care and dependent daycare, and an Employee Assistance Program (EAP). For long-term savings, PSE offers a 401(k) investment option and a cash balance retirement plan. Employees will also receive Paid Time Off (PTO) and Paid Holidays throughout the calendar year. Detailed benefit overviews can be found on our Career page - Why Work For Us (pse.com).</p><p>Families and businesses depend on PSE to provide the energy they need to pursue their dreams. Our steadfast commitment to serving Washington communities with safe, dependable, and efficient energy started in 1873. Today we're building the Northwest's energy future through efforts like our award-winning energy efficiency programs and our leadership in renewable energy.</p><p>Puget Sound Energy is committed to providing equal employment opportunity to all qualified applicants. We do not discriminate on the basis of race, color, religion, sex, national origin, age, sexual orientation, gender identity, marital status, veteran status, or presence of a disability that with or without reasonable accommodation does not prevent performance of the essential functions of the job, or any other category prohibited by local, state, or federal law.</p><p>Should you have a disability that requires assistance and/or reasonable accommodation with the job application process, please contact the Human Resources Staffing department at jobs@pse.com or 425-462-3017.</p>
#J-18808-Ljbffr

Puget Sound Energy Business Intelligence Interview Guide

Overview

Puget Sound Energy Business Intelligence Salary

Puget Sound Energy Business Intelligence Interview Process

Puget Sound Energy Business Intelligence Interview Questions

Puget Sound Energy Business Intelligence Jobs