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

Spreetail Business Intelligence Interview Guide

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


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

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

Overview

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

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

<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

Spreetail Business Intelligence Interview Questions

<p>Spreetailpropels brands to increase their ecommerce market share across the globe while improving their operational costs. Learn how we are building one of the fastest-growing ecommerce companies in history: www.spreetail.com. <br> <br>Our Software & Technology teams build scalable, reliable, and cutting-edge software to propel Spreetail to being a top ecommerce company. We are seeking motivated individuals who are passionate about learning new technologies and building software to build a monster ecommerce company. If you are looking for an environment that provides creative freedom, work-life balance, and meaningful relationships, keep scrolling down. <br><br><strong>How you will achieve success:</strong> <br></p><ul> <ul><li>Collaborates with software partners, users, and stakeholders to write and produce stories for Engineering teams and brainstorm with internal and external partners on potential solution paths. </li> <li>Examines data on key input and output metrics, customer feedback, and product usage information to create insights that drive product decisions </li><li>Builds and owns a backlog tied to a specific feature set or area of a product and owns and drives discovery on stories for one to two squads of engineers </li><li>Relentlessly pursues new learning opportunities from shadowing users to work-flow deep dives. Builds, refines, and manages the long-term vision for a Product Identity or large set of tools (1-3-5 year plans) </li><li>Ability to drive discovery sessions with little oversight and elicit detailed discussions on named features with both a short and long-term time horizon. </li> </ul></ul><strong>What experience will help you in this role:</strong> <ul> <ul><li>5+ years of experience working in product management. </li><li>Experience working with Agile development practices. </li><li>Domain Expertise - mobile work, supply chain, or external customer base. </li> <li>Advanced understanding of the financial aspects of the business, including the input and output metrics. </li> <li>Able to execute accurately and can lead numerous projects across teams and functions. </li></ul> </ul><br> <br>$126,000 - $170,000 a year <br><br>Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $126,000/year to $170,000 + bonus. Pay is based on a number of factors including geographic market location and may vary depending on job-related knowledge, skills, and experience. Spreetail is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://proco-client.com/spreetail/2024/homepage/. This position will remain posted until filled. Applicants should apply via our external career site. <br><br>In an effort to Make Spreetail Better, we hire people that are aligned with our values and are passionate about pursuing ecommerce excellence. We believe the right person can learn what is needed to succeed in their role, so we encourage job applicants to apply even if you don't meet all the qualifications listed. We are looking for diverse backgrounds and perspectives, so we don't require college degrees and welcome non-linear career paths. If this role highlights your experience and gets you excited - please apply! <br><br>Not the role for you? Check out additional opportunities to join our team on our job board and sign up for our Talent Community Newsletter for exclusive insights into future openings. <br><br>What you can expect from us: <br> <br>•<b> The flexibility to take care of yourself.</b> Spreetailers operate in a relationship and experience-driven work culture that promotes results and encourages taking time off when needed. Salaried team members enjoy untracked PTO and hourly team members earn 20 PTO days per year. <br> <br>•<b>We believe in celebrating your accomplishments. </b>Each year is a new milestone with the opportunity to receive special gifts, Spreetail Swag Store credit, or donate to a nonprofit of your choice. <br><br>•<b>We'll take care of you and your family. </b>Spreetail will cover 100% of health insurance premiums for you and 50% for your partner and dependents included on the plan, as well as support your growing family with paid time off. <br> <br>•<b>The opportunity to revolutionize your community. </b>With two Volunteer Weeks and 24 hours of paid Community Time Off every year, we encourage team members to give back and make a social impact. <br><br>Learn more about our full benefits package including parental leave, domestic partner coverage, unit appreciation rights, and more. <br><br><b>Equal Opportunity Employer </b> <br><br>At Spreetail, we are relentless in our pursuit of equity and equality, we embrace cultural differences that raise our bar, we pursue the challenges within ourselves to make Spreetail better, and we humbly acknowledge our duty to build and foster an inclusive workplace where all may succeed. <br> <br>Spreetail is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information.

Spreetail Business Intelligence Interview Guide

Overview

Spreetail Business Intelligence Salary

Spreetail Business Intelligence Interview Process

Spreetail Business Intelligence Interview Questions

Spreetail Business Intelligence Jobs