Prepare for and practice interview questions from Resilience Lab.

Resilience Lab Interview Questions

Resilience Lab Interview Guides

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

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.

What factors could have biased this result, and what would you look into?

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

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?

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

Resilience Lab Salaries by Position

Role: Senior Data Engineer Department: Technology Location: US based (fully remote) Compensation: $145k - $175k About Us: Launched in 2019, Resilience Lab is the largest community of clinicians working collaboratively to produce better outcomes and improve quality mental health access. Our diverse team of best-in-class therapists is committed to delivering the best care experience: Clients who match with Resilience Lab therapists benefit from holistic, evidenced-based, high-quality, and affordable care that meets them where they're at, wherever they are. Clinicians are trained in the Resilience Institute, an online platform for the modern mental health clinician, offering continued learning to guarantee clients the highest quality of service and contemporary care. Technology powers Resilience Lab care delivery, automating all non-clinical work to foster therapeutic alliance and team-based care. Read our Mission, Vision & Values at https://www.resiliencelab.us/our-mission-and-values Opportunity: Resilience Lab is seeking an experienced Senior Data Engineer to help grow and mature our data platform. The Data team at Resilience Lab has two overarching technical goals - to establish and manage the data model for our new application platform and to build and maintain our data warehouse. As a Senior Data Engineer on the Data team, you will have the opportunity to help drive these efforts. Your day may be spent: Ingesting a new data source into our cloud data warehouse Evolving our data marts to power organizational business intelligence Building a new feature set into the data model of our new application platform Collaborating with colleagues across Technology, Product and Business Intelligence to design technical solutions to meaningful problems with impact Enhancing the data SDLC with new features and tools Consulting with business stakeholders to understand their pain points and propose effective solutions Monitoring job performance, finding and fixing the root cause of job failures Our stack: dbt Fivetran Prefect Redshift Postgres AWS duckdb These skills will help you be successful in this role: Expert at writing scalable SQL, especially in ELT data pipelines with 5+ years experience across 2 or more platforms Strong understanding of Kimball dimensional modeling and other data warehousing concepts Skilled at applying software engineering principles (e.g. testing, version control, code reviews, CI/CD) 3+ years of experience using Python to build data pipelines and in scripting Comfortable modeling and normalizing transactional data with 2+ years experience 1+ years of experience using dbt in an enterprise setting Familiarity with the AWS ecosystem and experience using it to build data pipelines (e.g. Lambdas, Step Functions, Glue) These experienceswill set you apart: Proven track record of working with data teams in a fast-paced, startup environmentProven success driving projects through implementation to completion, including stakeholder education and onboarding Demonstrated curiosity and drive to learn and smartly apply new technologies 2+ years of experience in healthtech and/or US healthcare in a data capacity 1+ years of experience administering a database system such as RDS Postgres Compensation - Up to $145k - $175k Resilience Lab are a fully-remote working company and offer a lucrative benefits package including medical, dental, optical cover, 401k, and much more. This role will be joining an already established and thriving engineering team with a great company-wide mental health and diversity focused culture. If this is aligned with your experience and interest, we would love to have you apply!

Resilience Lab Interview Questions

Resilience Lab Interview Guides

Resilience Lab Interview Questions

Resilience Lab Salaries by Position

Resilience Lab Opening Jobs