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

The Energy Authority Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at The Energy Authority? The The Energy Authority 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 The Energy Authority Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at The Energy Authority.</li>
<li>Practice real The Energy Authority 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 The Energy Authority Business Intelligence interview.</p>


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

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

Overview

The Energy Authority 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.

The Energy Authority 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>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

<p>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

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

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

<p><code>employees</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</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>

<tr>
<td><code>team</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>manager</code></td>
<td>VARCHAR</td>
</tr>

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


Manager Team Sizes

The Energy Authority Business Intelligence Interview Questions

<p>About The Energy Authority The Energy Authority is a public power-owned, nonprofit corporation with offices in Jacksonville, Florida, and Bellevue (Seattle), Washington. TEA provides public power utilities with access to advanced resources and technology systems so they can respond competitively in the changing energy markets. Through partnership with TEA, utilities benefit from an experienced organization that is singularly focused on deriving the maximum value of their assets from the market. TEA Values TEA employees share a common sense of purpose. When TEA accomplishes its mission, the result is improved quality of life for the citizens and businesses of the communities our clients serve. TEA employees exceed the expectations of those they serve, deliver services with the highest standards of fair, honest, and ethical behavior, set the standard for service and expertise in our industry, embody a spirit of collaboration, and embrace TEA's founding entrepreneurial spirit by seizing opportunities to deliver value. If you are self-motivated, driven to deliver excellence, and passionate about your career, TEA is the perfect place for you. It's YOUR Future. It's OUR Future. Be a Data Science Intern at The Energy Authority Why You'll Love This Role: Join a dynamic team at the heart of innovation in energy markets. As a Data Science Intern with our Corporate Analytics team, you'll work alongside passionate professionals with diverse expertise. Your contributions will be highly visible and impactful, helping public power utilities thrive. You'll solve challenging problems using machine learning, statistics, and advanced analytics. This role is designed to offer you continuous learning opportunities and the chance to see the direct impact of your work. What You'll Do: Design, develop, and refine advanced statistical and machine learning models to meet client objectives. Build intuitive tools and dashboards for internal and external stakeholders. Manage projects from initial research to production, ensuring a seamless lifecycle. Explore new methods for solving complex machine learning challenges. Follow best practices like code reviews and utilizing R packages and Git repositories. Apply your knowledge of statistics, data modeling, and advanced mathematics to extract valuable insights for our clients. Seek opportunities to generalize solutions that can benefit multiple clients. Present your results clearly, using both written and visual storytelling, to clients and internal teams. Who You Are: You hold (or are pursuing) a Bachelor's degree in Engineering, Mathematics, Data Science, or a related quantitative field. A Master's degree or higher in Statistics, Applied Mathematics, Physics, Data Science, or similar fields is a plus. You have strong problem-solving and communication skills. You're proficient in data analytics using R/Python and have hands-on experience with statistical techniques and machine learning models such as Regression, Neural Networks, and more. You're comfortable working with SQL/noSQL databases and have a basic understanding of web design (HTML, CSS, JavaScript) with a preference for R-Shiny. You have a knack for writing clean, scalable, and reusable code. Familiarity with the Electric Utility Industry is preferred but not required. Internship Details: Duration: 3-6 months, with a minimum of 10 weeks full-time (40 hours/week). Part-time hours available after the initial 10 weeks. Location: Preference for candidates based in Jacksonville, FL, or Seattle, WA, or willing to relocate for at least 10 weeks. Remote candidates will also be considered. If you're ready to contribute to high-impact projects and expand your skills in data science, TEA offers the perfect environment for your growth. 4o</p>

The Energy Authority Business Intelligence Interview Guide

Overview

The Energy Authority Business Intelligence Salary

The Energy Authority Business Intelligence Interview Process

The Energy Authority Business Intelligence Interview Questions

The Energy Authority Business Intelligence Jobs