Prepare for and practice interview questions from Numero Data.

Numero Data Interview Questions

Numero Data Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</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>

Write a query to randomly sample a row from a big table.

Random SQL Sample

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Numero Data Salaries by Position

###Strictly on W2 Required Skills:<ul><li>Ideal candidate should have a degree in a quantitative field (e.g., mathematics, computer science, physics, economics, engineering, statistics, operations research, quantitative social science, etc.).</li><li>Basic Knowledge on software development principles and architecture.</li><li>Good analytical and problem-solving abilities.</li><li>Ability to break down and understand complex business problems, define a solution and implement it using advanced quantitative methods.</li><li>Familiarity with programming for data analysis; ideally Python, SQL, or R.</li><li>Solid oral and written communication skills, especially around analytical concepts and methods.</li><li>Great work ethic and intellectual curiosity.</li><li>Knowledge of Cloud technologies such as AWS or Google Cloud.</li><li>Knowledge of any relational database such as My SQL.</li><li>Must be a team player with excellent communication and problem-solving skills and have experience working with customers across teams.</li></ul>

Required Skills:<ul><li>Ideal candidate should have a degree in a quantitative field (e.g., mathematics, computer science, physics, economics, engineering, statistics, operations research, quantitative social science, etc.).</li><li>Basic Knowledge on software development principles and architecture.</li><li>Good analytical and problem-solving abilities.</li><li>Ability to break down and understand complex business problems, define a solution and implement it using advanced quantitative methods.</li><li>Familiarity with programming for data analysis; ideally Python, SQL, or R.</li><li>Solid oral and written communication skills, especially around analytical concepts and methods.</li><li>Great work ethic and intellectual curiosity.</li><li>Knowledge of Cloud technologies such as AWS or Google Cloud.</li><li>Knowledge of any relational database such as My SQL.</li><li>Must be a team player with excellent communication and problem-solving skills and have experience working with customers across teams.</li></ul>

Numero Data Interview Questions

Numero Data Interview Guides

Numero Data Interview Questions

Numero Data Salaries by Position

Numero Data Opening Jobs