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

<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>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

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

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

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Find the total salary of slacking employees.

Slacking Employees Salaries

<p>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

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

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

<p><strong><code>players</code></strong> table</p>

<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>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

<p>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

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

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

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

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

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

Puget Sound Energy Business Intelligence Interview Questions

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.
PSE's Planning team is looking for qualified candidates to fill an open Data Scientist I position!  Specific details regarding the work arrangements for this position will be discussed in further detail during the interview process.
Job Description  The Data Scientist in this position will focus on performing moderately complex statistical and machine learning analytics of large (Big Data) datasets to provide statistical, predictive, and prescriptive insights to the organization. Collaboration will include team members such as system planners, engineers, data scientists, and supervisors.
This role supports evolving planning methodologies for distribution needs, including equipment performance, load flow results, electrification, new customer loads, distributed energy resources (DERs), advanced metering infrastructure (AMI), load forecasting, and load-flow modeling.
It involves working directly with data users and customers to facilitate the implementation of models and conclusions drawn from data analysis and machine learning. These models may also be used by other departments or customers for forecasting and planning purposes.
The role requires cleansing datasets using appropriate techniques alongside leads, peers, or supervisors. Data scientists at this level are recognized as experts within their organizational domains.
Responsibilities include developing production-quality models where analysis requires reviewing various factors, upholding safety standards, and promoting a culture of safety. The role also emphasizes conducting business ethically and in compliance with regulations.
Responsibilities   Collaborate across departments to understand issues and provide solutions to complex problems.
Clarify business requests and document requirements, considering broad perspectives.
Improve data collection procedures, including processing, cleansing, and verifying data integrity.
Develop analytics and machine learning models to support corporate goals.
Participate in data management governance and community proceedings, creating and socializing data science standards.
Communicate insights clearly and perform ad-hoc analyses.
Implement new statistical methodologies as needed and optimize project efforts.
Perform other duties as assigned.
Minimum Qualifications   Bachelor's degree in a relevant field or equivalent experience.
At least one year of applying quantitative methods and building machine learning models, or classroom/lab experience.
Proficiency in Python or R, strong SQL skills, and experience with visualization tools like Tableau or Power BI.
Ability to synthesize large data sets into actionable insights and collaborate on data projects.
Preferred Qualifications   Graduate degree in a quantitative field.
Experience with AWS, Azure, or other cloud platforms.
Experience with SAP data.
Curiosity, passion for problem-solving, and ability to handle ambiguity.
Additional Information  The pay range is $99,600 - $175,200, with potential bonuses. Benefits include health insurance, retirement plans, PTO, and more. We are committed to diversity and equal opportunity employment.
For accommodations during the application process, contact Human Resources.

#J-18808-Ljbffr

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.PSE's Energy Supply Merchant team is looking for qualified candidates to fill an open Quantitative Risk Analyst position!Specific details regarding the work arrangements for this position will be discussed in further detail during the interview process.Job DescriptionResponsible for analyzing energy market structures, rules, and mechanisms while managing the implementation of market design initiatives and related projects. This role combines expertise in energy markets, economics, analytical skills, and project management to support the development, implementation, and optimization of market design solutions. results. Collaborates with internal and external stakeholders to evaluate and continuously improve asset optimization, risk measurement, and resource planning capabilities. Provides theoretical and quantitative guidance for evaluation of structured transactions, new asset acquisitions, and integration of renewable resources. Utilizes knowledge of PSE's resource portfolio, regional energy supply and demand fundamentals, commodity market dynamics, and modeling best practices to mentor analysts and inform the company's energy supply and risk management
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.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
Responsibilities Maintain and improve quantitative models for forecasting and optimization of natural gas and electric resources, portfolio management, and energy trading activities. Monitor and analyze market trends, pricing patterns, and participant behavior Analyze wholesale electricity market designs, pricing mechanisms, and trading rules Assess the impact of new technologies and policies on market operations Prepare detailed analysis and recommendations for market design modifications Collaborate with stakeholders to develop market rules and procedures Lead cross-functional teams in implementing market design changes Manage stakeholder engagement throughout implementation process Maintain up-to-date knowledge of the region's energy supply resources and operations and understand the impact of external factors on energy availability and commodity prices. Support WUTC rate case filings by preparing testimony and responding to (and initiating) data requests from external stakeholders. Support regulatory filings and market design proposals Communicate the impact of new and potential transactions and asset acquisitions on the risk profile of the energy portfolio. Develop and maintain model documentation consistent with policies governing control over model inputs and outputs, data integrity, quality, and security. Perform ad hoc analysis and other duties as assigned.Minimum Qualifications Bachelor's degree in a relevant field (Finance, Economics, Statistics, Engineering, or similar) Minimum 2 years work experience, preferably in the energy industry Proficiency with statistical methods and concepts including regression analysis and Monte Carlo simulations Familiarity with financial analysis and accounting principles Advanced skills in MS Office, especially Excel, including proficiency in writing macros or queries Excellent communication, writing, and presentation skills Self-starter with the ability to work effectively without direct supervision in a fast paced, stressful, and multitasking environmentDesired Qualifications Master's Degree in a quantitative field (not including MBA) Hands on experience building or using mathematical models and / or production cost models Programming experience in Python, R, SQL, MATLAB or similar Knowledge of portfolio risk management principles Understanding of western gas and power market dynamics and market fundamentals Project Management experience Technical Writing experienceAdditional InformationAt PSE we value and respect our employees and provide them opportunities to excel. We offer a competitive compensation and rewards package.The pay range for this position is $79,200.00 - $131,700.00, and this position is eligible for annual goals based incentive bonuses. 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). 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. 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.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 or .
Create a job alert for this search
#J-18808-Ljbffr

3 days ago Be among the first 25 applicants
Direct message the job poster from Puget Sound Energy
Data Executive at Puget Sound Energy | ex-DocuSign, T-Mobile, MIT Lincoln Lab, Sandia Labs
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.
PSE's Data and AI team is looking for qualified candidates to fill an open Senior Data Architect position!
Specific details regarding the work arrangements for this position will be discussed in further detail during the interview process.
Job Description
Puget Sound Energy is on a mission to power the Pacific Northwest with reliable, sustainable, and innovative energy solutions. Our Data & AI organization is at the heart of this transformation—shaping the future of grid operations, clean energy initiatives, and AI-driven customer experiences. Now we're seeking a Senior Data Architect to unify our diverse data landscape (on-prem, multi-cloud, and beyond) and ensure our data systems truly deliver for our customers, our region, and our planet.
Why This Role Matters
Enormous Impact : The data architectures you create will influence everything from cutting-edge AI pilots to everyday operational efficiencies—powering better reliability, proactive outage prevention, and a greener, smarter grid.
Transformative Environment : We face legacy integration challenges and skyrocketing AI demands—perfect for someone eager to build future-ready systems that help reduce carbon footprints and serve our community more effectively.
Innovative Culture : Join us in modernizing how we store, move, and secure data, championing new frameworks and practices that can redefine utility operations for decades to come.
About You
Strategic Visionary : You see data as the linchpin for optimizing energy distribution, driving AI use cases, and ultimately transforming how utilities operate.
Technical Trailblazer : Hands-on mastery of data platforms (on-prem, AWS, Azure) coupled with a proven track record of large-scale architectural wins.
Positive Influencer : People follow your lead because you know how to build real partnerships and excitement, bridging technical teams, business stakeholders, and external vendors.
Product Mindset : You thrive on delivering tangible outcomes—iterating on architecture roadmaps that produce measurable improvements and ROI.
Key Responsibilities
Architect & Evangelize : Research, analyze, and propose enterprise data strategies. Act as the go-to expert for multi-year visioning and architectural roadmaps.
Establish Standards & Governance : Define guiding principles, policies, and reference architectures; ensure consistent data security, lineage, and quality across solutions.
Collaborate with Delivery Teams : Mentor engineers, advise on platform roadmaps, and champion reuse and rationalization—making the most of IT investments.
Integration & Feasibility : Evaluate and select products, ensuring interoperability across on-prem, cloud, and hybrid systems. Conduct feasibility studies and design reviews.
Drive Outcomes : Own the results of major data initiatives—accelerating AI pilots, cutting downtime, or streamlining data flows—and showcase clear business impact.
Ethics & Compliance : Promote a culture of total safety, uphold ethical standards, and embed regulatory compliance into every data strategy.
Join Us
If you're looking to make a massive difference, driving genuine change in how a major utility harnesses data and AI to serve its community, we want you. Your technical leadership and passion can propel us into a smarter, cleaner, and more resilient future—one where your architectural choices genuinely matter to the well-being of millions.
Minimum Qualifications
Bachelor's degree in Computer Science, or related field.
15 years of IT architecture experience.
10 years' experience working in a large-scale, complex IT environment.
Ability to translate short and long-range strategic plans for architecture into design and implementation of current and future applications.
Has deep technical expertise in three or more technology domains, and broad understanding of how that technology is used across multiple business functions, in multiple industries, to deliver business value.
Is able to influence with credibility across multiple business functions or technologies with limited analysis.
Excellent interpersonal, oral / presentation and written communication skills in both technical and non-technical language.
Strong leadership, project and team building skills – ability to lead teams and drive projects and initiatives by working effectively with others with a demonstrated ability to work cross-departmentally.
Strong collaborator – willingness to share ideas, documentation and best practices.
Conceptual and analytical thinker – ability to extract, analyze and document complex business and technical requirements / strategies from customers and IT team members.
Desired Qualifications
MS or MBA degree in Computer Science, or related field.
Prior utility industry work experience.
Prior consulting experience with a top-tier IT consultancy.
ITIL / ITSM v3 Training and Certification.
PMI PMP Certification.
Additional Information
At PSE we value and respect our employees and provide them opportunities to excel. We offer a competitive compensation and rewards package.
The pay range for this position is $174,000.00-$306,600.00, and this position is eligible for annual goals based incentive bonuses.
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)
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.
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.
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.

#J-18808-Ljbffr

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.<br><br>PSE's Energy Supply Merchant team is looking for qualified candidates to fill an open <b>Senior Quantitative Risk Analyst</b> position!<br><br>Specific details regarding the work arrangements for this position will be discussed in further detail during the interview process.<br><br><strong><b>Job Description</b></strong><br><br>Responsible for analyzing energy market structures, rules, and mechanisms while managing the implementation of market design initiatives and related projects. This role combines expertise in energy markets, economics, analytical skills, and project management to support the development, implementation, and optimization of market design solutions. results. Collaborates with internal and external stakeholders to evaluate and continuously improve asset optimization, risk measurement, and resource planning capabilities. Provides theoretical and quantitative guidance for evaluation of structured transactions, new asset acquisitions, and integration of renewable resources. Utilizes knowledge of PSE's resource portfolio, regional energy supply and demand fundamentals, commodity market dynamics, and modeling best practices to mentor analysts and inform the company's energy supply and risk management strategies.<br><br>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.<br><br>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.<br><br><strong><b>Job Responsibilities</b></strong><br><br><ul> <li>Maintain and improve quantitative models for forecasting and optimization of natural gas and electric resources, portfolio management, and energy trading activities. </li> <li>Monitor and analyze market trends, pricing patterns, and participant behavior</li> <li>Analyze wholesale electricity market designs, pricing mechanisms, and trading rules</li> <li>Assess the impact of new technologies and policies on market operations</li> <li>Prepare detailed analysis and recommendations for market design modifications</li> <li>Collaborate with stakeholders to develop market rules and procedures</li> <li>Lead cross-functional teams in implementing market design changes</li> <li>Manage stakeholder engagement throughout implementation process</li> <li>Maintain up-to-date knowledge of the region's energy supply resources and operations and understand the impact of external factors on energy availability and commodity prices. </li> <li>Support WUTC rate case filings by preparing testimony and responding to (and initiating) data requests from external stakeholders. </li> <li>Support regulatory filings and market design proposals</li> <li>Communicate the impact of new and potential transactions and asset acquisitions on the risk profile of the energy portfolio. </li> <li>Develop and maintain model documentation consistent with policies governing control over model inputs and outputs, data integrity, quality, and security. </li> <li>Perform ad hoc analysis and other duties as assigned.</li></ul><br><br><strong><b>Minimum Qualifications</b></strong><br><br><ul> <li>Bachelor's degree in a relevant field. (Finance, Economics, Statistics, Engineering, or similar)</li> <li>Minimum 4 years work experience, preferably as a quantitative analyst in the energy industry</li> <li>Proficiency with quantitative methods and concepts including regression analysis, Monte Carlo simulations, scenario analysis, and stress testing</li> <li>Experience with financial analysis and familiarity with accounting principles</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>Self-starter with the ability to work effectively without direct supervision in a fast paced, stressful, and multitasking environment</li></ul><br><br><strong><b>Desired Qualifications</b></strong><br><br><ul> <li>Master's Degree in a quantitative field</li> <li>8+ years of energy industry experience, preferably in an analyst role</li> <li>Hands on experience building and operating quantitative models</li> <li>Programming experience in Python, R, SQL, MATLAB, or similar</li> <li>Experience with production cost modeling software such as Plexos, Aurora, GenTrader, PROMOD</li> <li>Knowledge of portfolio risk management principles</li> <li>Experience in western gas and power markets</li> <li>Familiarity with regulated utility rate cases and state regulatory agencies/public utility commissions</li> <li>Project Management experience</li> <li>Technical Writing experience</li></ul><br><br><strong><b>Additional Information</b></strong><br><br>At PSE we value and respect our employees and provide them opportunities to excel. We offer a competitive compensation and rewards package.<br><br>The pay range for this position is $104,500.00 - $174,100.00, and this position is eligible for annual goals based incentive bonuses. <br><br>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). <br><br>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. <br><br>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.<br><br>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.

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

Puget Sound Energy Business Intelligence Interview Guide

Overview

Puget Sound Energy Business Intelligence Interview Process

Puget Sound Energy Business Intelligence Interview Questions

Puget Sound Energy Business Intelligence Jobs