Prepare for and practice interview questions from Dandy.

Dandy Interview Questions

Dandy Interview Guides

<p>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.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

<p>Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.</p>

<p>What factors could have biased this result, and what would you look into?</p>


<p>What could potentially bias the average boarding time in favor of an airline that only flies domestically?</p>

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<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

Dandy Salaries by Position

<p>Dandy is transforming the massive ($200B) but antiquated dental industry. Backed by some of the world's leading venture capital investors, we are on an ambitious mission to integrate and simplify every function of the dental practice through technology. By building the operating system for every dental office in America, Dandy is empowering dentists with technology, innovation, and world-class support to achieve more for their practice, their people, and their patients.

About The Role

We're on the hunt for experienced senior data analysts who can tackle some of our most significant challenges in the realm of analytics for our digital design center (DDC) workforce. Our DDC team plays a pivotal role in Dandy's dental operations, overseeing critical areas like designer workforce management, product feature enhancement for better quality, and capacity/utilization optimization. In this dynamic, cross-functional role, you'll have the freedom to independently harness data analysis to drive recommendations that propel Dandy to become the top dental lab in the industry.

What You'll Do

Develop and share insights that drive the DDC team and partner functions, such as operations and product.
Define the data language (i.e. KPIs, dashboards, measurement, etc) to ensure your team grasps the underlying truth that drives progress and success
Facilitate rapid decision making through ad hoc work or by democratizing data/self service (effective BI or user-friendly explores in Looker in partnership with our analytics engineers)
Utilize your data super powers to reduce ambiguity and solve problems
Mentor other analysts and help them grow

What We're Looking For

4+ years of experience working in operations, people, or manufacturing analytics or data science, ideally in a B2B setting
BA/BS in a quantitative field such as mathematics, statistics, engineering or a BA/BS in behavioral science (economics, psychology, etc) with statistics skills
Excellent SQL skills
Strong scripting Python skills
Strong communication skills and experience communicating results in a way that drives change. You have the ability to use data to inform, align, and lead
Strong senses of autonomy and ownership
Strong critical thinking, problem solving, and statistical skills

Bonus Points For

Have hands-on experience in workforce analytics, especially with companies managing large international teams
Interest in working and learning in an earlier stage company where we’re still working out some of the basics
Experience in capacity planning and modeling
Strong customer empathy, particularly for dentists
Experience in Looker, Hex, and DBT

The reasonably estimated salary for this role at Dandy is $150,000 - $175,000 plus equity. Actual compensation is based on a number of factors including, but not limited to the primary work location, candidate's skills, qualifications, and experience.

In addition, Dandy offers a wide range of best in class, comprehensive and inclusive employee benefits including healthcare, dental, parental planning, mental health benefits, a 401(k) plan, and paid time off.

Dandy is proud to be an equal-opportunity employer. We are committed to building a diverse and inclusive culture that celebrates authenticity to win as one. We do not discriminate on the basis of race, religion, color, national origin, gender, gender identity, sexual orientation, age, marital status, disability, protected veteran status, citizenship or immigration status, or any other legally protected characteristics.

At Dandy, we fully comply with the Americans with Disabilities Act (ADA). We are dedicated to embracing challenges and creating an accessible, inclusive workplace for all individuals. If you require any accommodations for your interview or have any questions beforehand, rest assured that we will move at Dandy speed and do everything in our power to meet your needs.
#J-18808-Ljbffr</p>

Dandy Interview Questions

Dandy Interview Guides

Dandy Interview Questions

Dandy Salaries by Position

Dandy Opening Jobs