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

Nomi Health Business Intelligence Interview Guide

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


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

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

Overview

Nomi Health 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.

Nomi Health 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

Nomi Health Business Intelligence Interview Questions

We are looking for a Senior Software Engineer (Backend) to join our team in Austin, Texas. You will help revolutionize the healthcare industry and work with cutting-edge technologies like Golang, GraphQL, AWS Lambda, and Serverless to design, develop, and maintain robust, scalable software solutions.<br><br><b>This position is a hybrid role, requiring in-office presence on Tuesdays, Wednesdays, and Thursdays.</b><br><br><strong>How you will make an impact</strong><br><ul><ul><li><b>Innovate & Collaborate:</b> Partner with Agile teams to create and refine high-quality software that drives our healthcare and payment systems.</li><li><b>Stay Ahead of the Curve:</b> Lead the adoption of new technologies, engage with tech communities, and mentor other engineers to foster a culture of continuous improvement.</li><li><b>Ensure Reliability:</b> Utilize your deep expertise in languages like Go, C++, or Java, and your knowledge of SQL/NoSQL databases, to ensure our systems are reliable and scalable.</li><li><b>Leverage Cloud Tech:</b> Work with AWS, Docker, Kubernetes, and other cloud-based tools to deliver efficient, high-performing solutions.</li></ul></ul><br><br><strong>What we are looking for</strong><br><ul><ul><li><b>Education:</b> Bachelor's degree in Computer Science or a related technical field preferred. Equivalent practical experience in software development will also be considered.</li><li><b>Experience:</b> 6+ years in software development, with proficiency in Go, Java, or C++. Hands-on experience with cloud platforms like AWS is essential.</li><li><b>Skills:</b> Strong in high-level and low-level software design, with a keen eye for detail and a commitment to excellence.</li><li><b>Mindset:</b> Enthusiastic about learning and applying new technologies, with a collaborative approach to problem-solving.</li></ul></ul>

Nomi Health Business Intelligence Interview Guide

Overview

Nomi Health Business Intelligence Salary

Nomi Health Business Intelligence Interview Process

Nomi Health Business Intelligence Interview Questions

Nomi Health Business Intelligence Jobs