The Compass Digital Labs Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Compass Digital Labs Business Intelligence Interview Guide

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


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

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

Overview

Compass Digital Labs 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.

Compass Digital Labs 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

Compass Digital Labs Business Intelligence Interview Questions

<p>We are looking for a passionate Data Scientist/AI Engineer to join our team at Compass Digital. You will design, develop, and maintain cutting-edge data products and AI solutions, focusing on making difficult-to-access data sources available through web scraping and document scanning. Collaborating with Data Scientists, Analytics Engineers, Front-End Engineers, ML Engineers, and AI Engineers, you will build cloud-native backend systems and infrastructure for new AI-powered applications. Your work will lay the foundations for a new product delivering Data Analytics and AI capabilities.</p><p><br></p><p><strong>Now, if you were to come on board as our Data Scientist/AI Engineer, we’d ask you to do the following for us:</strong></p><ul><li>Develop and maintain scalable AI applications from concept to deployment;</li><li>Collaborate with cross-functional teams to define, design, and ship new features;</li><li>Architect and implement efficient and reusable AI systems;</li><li>Write clean, well-documented, and maintainable code following best practices;</li><li>Conduct code reviews, provide constructive feedback and mentor junior team members;</li><li>Staying up-to-date with emerging AI technologies and industry trends to drive continuous improvement</li><li>Work in a dynamic, collaborative, progressive, and high-performing team</li><li>Interactions with multiple cross-functional teams, exposure to many components of modern data technology</li></ul><p><br></p><p><strong>Think you have what it takes to be our AI Engineer? We’re committed to hiring the best talent for the role. Here’s how we’ll know you’ll be successful in the role:</strong></p><ul><li>Bachelor's degree in a STEM field or equivalent experience</li><li>Strong experience with Large Language Models (LLMs)</li><li>2+ years of hands-on experience in developing AI and data products</li><li>Proficiency with the modern data science stack, including Python, NumPy, and pandas</li><li>Strong cloud engineering skills with experience taking AI ideas to production</li><li>Experience with both SQL and NoSQL database systems and data warehouses</li><li>Familiarity with RESTful APIs</li><li>Knowledge of version control systems such as Git and agile development methodologies</li><li>Excellent problem-solving skills, attention to detail, and ability to work independently or within a team</li><li>Excellent written and verbal communication skills, with the ability to convey complex concepts to non-technical users</li></ul><p></p>

Compass Digital Labs Business Intelligence Interview Guide

Overview

Compass Digital Labs Business Intelligence Salary

Compass Digital Labs Business Intelligence Interview Process

Compass Digital Labs Business Intelligence Interview Questions

Compass Digital Labs Business Intelligence Jobs