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

Everquote Business Intelligence Interview Guide

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


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

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

Overview

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

Everquote 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 show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

<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

Everquote Business Intelligence Interview Questions

<p>EverQuote are hiring a Senior Software Engineer for one of their most vital and exciting teams in the business – you will work with an experienced team of Backend Engineers and Data Analysts on a brand new product.</p><p><br></p><p>There is a clear path to promotion with this role - watch your career sky-rocket – ambition and talent is rewarded in EverQuote! This is a fun and friendly place to work, where teamwork rules!</p><p><br></p><p><strong>Who Are They?</strong></p><p><br></p><p>EverQuote is a fast-growing, data-driven tech company with 50 of Belfast’s best and brightest technologists in their ‘penthouse’ city centre office. Their world is data – specifically data that connects Insurance carriers with consumers. They do it better than anyone else.</p><p><br></p><p><strong>What Do They Do?</strong></p><p><br></p><p>They gather, analyse and wrangle data. They empower consumers and help to build their customers’ businesses. Everyone in EverQuote is a technologist at heart – but they’re all about people and collaboration, and they’re damn good at that bit too!</p><p><br></p><p><strong>What’s happening at EverQuote?</strong></p><p><br></p><p>It’s happening! With the market soaring, this has allowed them to enter an exciting new growth phase, with the Site Leadership hugely motivated to attract the best Engineering, Product & Leadership talent in Northern Ireland. Their engineering strategy is evolving too, with huge replatforming and modernisation efforts kicking off across their tech offering. There has never been a better time to become a GOAT and join EverQuote NI as a Senior Software Engineer.</p><p><br></p><p><strong>What are they offering?</strong></p><p><br></p><p>EverQuote’s Leadership Team in Belfast is second-to-none. They truly care about their people. They provide one of the most comprehensive benefits packages on the market.</p><p><br></p><ul><li>Hybrid working</li><li>Market leading salary plus bonus (15%)</li><li>Private Medical for you and your family</li><li>Dental Cover for you and your family</li><li>Matched pension</li><li>Work-From-Home</li><li>Learning + Development allowance</li><li>Free lunch Tuesdays</li></ul><p><br></p><p><strong>What do you need?</strong></p><p><br></p><ul><li>5 + years experience in Backend engineering</li><li>5 + years Python</li><li>Experience with MySQL</li><li>Bonus - Experience with AWS</li></ul><p><br></p><p>Get in touch today for a confidential conversation - you won't be disappointed!</p>

Everquote Business Intelligence Interview Guide

Overview

Everquote Business Intelligence Salary

Everquote Business Intelligence Interview Process

Everquote Business Intelligence Interview Questions

Everquote Business Intelligence Jobs