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

Indigo Fair Business Intelligence Interview Guide

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


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

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

Overview

Indigo Fair 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.

Indigo Fair 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>There was a robbery from the ATM at the bank where you work. Some unauthorized withdrawals were made, and you need to help your bank find out more about those withdrawals.</p>

<p>However, the only information you have is that there was more than 1 withdrawal, they were all performed in 10-second gaps, and no legitimate transactions were performed in between two fraudulent withdrawals.</p>

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value <code>transaction_value</code>, and <code>created_at</code> time for each transaction.</p>

<p>Write a query to retrieve all user IDs in ascending order whose transactions have exactly a 10-second gap from one another.</p>

<p><em>Note: Assume that there are only withdrawals from the ATM, which are denoted with a positive <code>transaction_value</code></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>For given table <code>bank_transactions</code>:</p>

<table>
<thead>
<tr>
<th><code>user_id</code></th>
<th><code>created_at</code></th>
<th><code>transaction_value</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>2017-01-01 10:10:15</td>
<td>10</td>
</tr>

<tr>
<td>2</td>
<td>2017-01-01 11:11:11</td>
<td>20</td>
</tr>

<tr>
<td>3</td>
<td>2017-01-01 12:12:12</td>
<td>10</td>
</tr>

<tr>
<td>4</td>
<td>2017-01-01 10:10:20</td>
<td>30</td>
</tr>

<tr>
<td>5</td>
<td>2017-01-01 10:10:34</td>
<td>40</td>
</tr>

<tr>
<td>6</td>
<td>2017-01-01 11:11:21</td>
<td>50</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th><code>user_id</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>2</td>
</tr>

<tr>
<td>6</td>
</tr>
</tbody>
</table>


There was a robbery from the ATM at the bank where you work. Some unauthorized withdrawals were made, and you need to help your bank find out more about those withdrawals.

ATM Robbery

<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

Indigo Fair Business Intelligence Interview Questions

<strong>About Faire</strong><br><br>Faire is an online wholesale marketplace built on the belief that the future is local - independent retailers around the globe are doing more revenue than Walmart and Amazon combined, but individually, they are small compared to these massive entities. At Faire, we're using the power of tech, data, and machine learning to connect this thriving community of entrepreneurs across the globe. Picture your favorite boutique in town - we help them discover the best products from around the world to sell in their stores. With the right tools and insights, we believe that we can level the playing field so that small businesses everywhere can compete with these big box and e-commerce giants.<br><br>By supporting the growth of independent businesses, Faire is driving positive economic impact in local communities, globally. We're looking for smart, resourceful and passionate people to join us as we power the shop local movement. If you believe in community, come join ours. <br><br><strong>About the Role:</strong><br><br>Faire is using machine learning to change wholesale and help local retailers compete with Amazon and big box stores. Our experienced data scientists and machine learning engineers are developing solutions related to discovery, ranking, search, recommendations, ads, logistics, underwriting, and more - all with the goal of helping local retail thrive. <br><br>As a member of the Discovery Data team you'll be responsible for one of the following areas: <br><ul><li><strong>Search</strong>: Optimizing search through query understanding, retrieval, ranking, post-ranking and whole-page optimization with state-of-art technologies including embeddings, graph learning, deep learning and large language models (LLMs).</li><li><strong>Personalization</strong>: Personalizing recommendation surfaces through embeddings, near-real-time / streaming signals, explore-exploit, and diversification.</li><li><strong>Ads / Sponsored Products</strong>: Joining a newly established team building Ads Delivery and Advertiser Optimization from the ground up and tackling challenges in ads targeting, retrieval, prediction/ranking, bidding, pacing, and auction design. </li></ul><br>Our team already includes experienced Data Scientists and Machine Learning Engineers from Uber, Airbnb, Square, Facebook, LinkedIn and Pinterest. We're a lean, talented team with high opportunity for direct product impact and ownership. <br><br><strong>You're excited about this role because... </strong><br><ul><li>You'll be able to work on cutting-edge search / personalization / ads problems combining a wide variety of data about our retailers, brands and products</li><li>You want to use machine learning to help local retailers and independent brands succeed </li><li>You want to be a foundational team member of a fast growing company</li><li>You like to solve challenging problems related to a two-sided marketplace </li></ul><br><strong>Qualifications:</strong><br><ul><li>4 years of industry experience using machine learning to solve real-world problems</li><li>Experience and strong understanding of search / personalization / ads for product development </li><li>Strong programming skills </li><li>An excitement and willingness to learn new tools and techniques </li><li>Experience with deep learning </li><li>The ability to contribute to team strategy and to lead model development without supervision </li><li>Strong communication skills and the ability to work with others in a closely collaborative team environment </li></ul><br><strong>Great to Haves:</strong><br><ul><li>Highly recommended: Master's or PhD in Computer Science, Statistics, or related STEM fields </li><li>Ability to quickly implement state of the art algorithms from an academic paper</li></ul><br><strong>Salary Range:</strong><br><br>California: the pay range for this role is $177,500 - $244,000 per year.<br><br>This role will also be eligible for equity and benefits. Actual base pay will be determined based on permissible factors such as transferable skills, work experience, market demands, and primary work location. The base pay range provided is subject to change and may be modified in the future.<br><br>This role will be in-office on a hybrid schedule - Faire employees will be expected to go into the office 2 days per week on Tuesdays and Thursdays, effective the week of January 13, 2025. Additionally, in-office roles will have the flexibility to work remotely up to 4 weeks per year. <br><br>Applications for this position will be accepted for a minimum of 30 days from the posting date.<br><br><strong>Why you'll love working at Faire</strong><br><ul><li><strong>We are entrepreneurs: </strong>Faire is being built for entrepreneurs, by entrepreneurs. We believe entrepreneurship is a calling and our mission is to empower entrepreneurs to chase their dreams. Every member of our team is taking part in the founding process.</li><li><strong>We are using technology and data to level the playing field:</strong> We are leveraging the power of product innovation and machine learning to connect brands and boutiques from all over the world, building a growing community of more than 350,000 small business owners.</li><li><strong>We build products our customers love:</strong> Everything we do is ultimately in the service of helping our customers grow their business because our goal is to grow the pie - not steal a piece from it. Running a small business is hard work, but using Faire makes it easy.</li><li><strong>We are curious and resourceful:</strong> Inquisitive by default, we explore every possibility, test every assumption, and develop creative solutions to the challenges at hand. We lead with curiosity and data in our decision making, and reason from a first principles mentality.</li></ul><br>Faire was founded in 2017 by a team of early product and engineering leads from Square. We're backed by some of the top investors in retail and tech including: Y Combinator, Lightspeed Venture Partners, Forerunner Ventures, Khosla Ventures, Sequoia Capital, Founders Fund, and DST Global. We have headquarters in San Francisco and Kitchener-Waterloo, and a global employee presence across offices in Toronto, London, and New York. To learn more about Faire and our customers, you can read more on our blog.<br><br>Faire provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, genetics, sexual orientation, gender identity or gender expression.<br><br>Faire is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. To request reasonable accommodation, please fill out our Accommodation Request Form (https://bit.ly/faire-form)

Indigo Fair Business Intelligence Interview Guide

Overview

Indigo Fair Business Intelligence Salary

Indigo Fair Business Intelligence Interview Process

Indigo Fair Business Intelligence Interview Questions

Indigo Fair Business Intelligence Jobs