Prepare for and practice interview questions from The Realreal.

The Realreal Interview Questions

The Realreal 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 you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

The Realreal Salaries by Position

About The Role The RealReal is seeking a Staff Product Manager to lead our Growth team in driving new customer acquisition and activation through on site and data driven marketing initiatives. In this role you will drive innovation, enable marketing spend optimization, and partner with our marketing teams to shape the future of our marketing data and technology strategy. You will drive the conceptual and technical development of product ideas from end to end, including creating business cases, prioritizing scope ruthlessly, and working directly with a full stack development team on a daily basis. Manage multiple engineering teams and data science collaborators. You will also be responsible for stakeholder management, providing thought leadership, and partnering across functional areas and other product teams to launch initiatives that deliver value to the customer and our business. *States Not Eligible: AK, AR, DE, KS, MS, ND, SD, WY What You Get To Do Every Day <ul><li>Lead a Product Management function focused on conceiving, building, and launching user-focused, high-quality products that grow our seller base</li><li>Work closely with engineering, design, and business leadership to define our product vision and strategy across your product areas, and deliver tangible business outcomes</li><li>Execute efficiently in a fast-paced, fluid environment where change is constant and creativity is a must</li><li>Write technical requirements, manage technical backlogs, and effectively prioritize new features vs. tech debt. Work with a full-stack engineering team to build world-class products that eliminate workflow friction, maximize output, and improve employee experience</li></ul> What You Bring To The Role Minimum Requirements: <ul><li>7+ years of Product Management experience with relevant experience in a growth and or marketing technology role</li><li>Deep understanding of a wide range of marketing technologies and platforms including CRM, marketing automation, measurement and attribution analytics, personalization, bid optimization, media ad platforms, content management and AI driven solutions</li><li>Solid technical background with understanding and/or hands-on experience in software development and web technologies.</li><li>Self-motivated and thrive in a fast-paced environment, working independently and execute on several major initiatives at a time</li><li>Proven ability to lead and influence cross-functional teams without formal authority</li><li>Strong analytical and quantitative skills; ability to use hard data and metrics to back up assumptions, recommendations, and drive actions.</li><li>Exceptional written and verbal communication skills even in areas of high technical complexity.</li><li>Demonstrated ability to develop product and marketing strategies and effectively communicate recommendations to executive management.</li><li>Proven track record of leading multiple squads and cross-functional teams.</li><li>Actively mentors and develops product management talent.</li><li>Bonus if experience leading teams of product managers</li><li>Must have a great understanding and empathy for The RealReal customers and be their advocate</li></ul> Preferred Requirements: <ul><li>Familiarity with and experience optimizing conversion passback data and scores for ad platforms (Google, meta, TikTok) etc.</li><li>Experience and examples of work with AI/ ML</li><li>Experience with implementation of multi-touch attribution and media mix modeling</li><li>Experience working with Salesforce marketing cloud, Google Suite of Tools</li><li>Expertise in data privacy regulations and compliance with ability to navigate complex data governance requirements</li></ul> Compensation, Benefits, + Perks <ul><li>Employee Stock Purchase Plan</li><li>401K with Company Match</li><li>Medical, Dental & Vision Insurance</li><li>Paid Parental Leave</li><li>Unlimited Discretionary Time Off (DTO)* and 10 Paid Company Holidays</li><li>* Unlimited DTO with Manager approval</li></ul> The expected salary range for this role is $164,204.00-$190,000.00. To determine starting pay we carefully consider a variety of factors, including primary work location and an evaluation of a candidate's skills, experience, market demands, and internal parity. Additionally, salary is just one component of TRR's total rewards package. Depending on role, employees may also be eligible for a bonus program, incentive pay and benefits. The RealReal is the world's largest online marketplace for authenticated, resale luxury goods, with more than 30 million members. With a rigorous authentication process overseen by experts, The RealReal provides a safe and reliable platform for consumers to buy and sell their luxury items. We have hundreds of in-house gemologists, horologists and brand authenticators who inspect thousands of items each day. As a sustainable company, we give new life to pieces by thousands of brands across numerous categories-including women's and men's fashion, fine jewelry and watches, art and home-in support of the circular economy. We make selling effortless with free virtual appointments, in-home pickup, drop-off and direct shipping. We do all of the work for consignors, including authenticating, using AI and machine learning to determine optimal pricing, photographing and listing their items, as well as handling shipping and customer service. At our 13 retail locations, including our twelve shoppable stores, customers can sell, meet with our experts and receive free valuations. The RealReal is committed to providing an equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or expression, or Veteran status. We will consider qualified applicants for a position regardless of arrest or conviction records. At TRR, People Come First. That's why diversity and inclusion are vital to our priorities as an equal opportunity employer. You can read about our Diversity Equity and Inclusion program here. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The employee is regularly required to sit; use hands to finger, handle, or feel and talk or hear. The employee is occasionally required to stand; walk; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl; and taste or smell. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

About The Role The RealReal is seeking a Staff Product Manager to lead our Growth team in driving new customer acquisition and activation through on site and data driven marketing initiatives. In this role you will drive innovation, enable marketing spend optimization, and partner with our marketing teams to shape the future of our marketing data and technology strategy. You will drive the conceptual and technical development of product ideas from end to end, including creating business cases, prioritizing scope ruthlessly, and working directly with a full stack development team on a daily basis. Manage multiple engineering teams and data science collaborators. You will also be responsible for stakeholder management, providing thought leadership, and partnering across functional areas and other product teams to launch initiatives that deliver value to the customer and our business. *States Not Eligible: AK, AR, DE, KS, MS, ND, SD, WY What You Get To Do Every Day <ul> <li>Lead a Product Management function focused on conceiving, building, and launching user-focused, high-quality products that grow our seller base </li><li>Work closely with engineering, design, and business leadership to define our product vision and strategy across your product areas, and deliver tangible business outcomes </li><li>Execute efficiently in a fast-paced, fluid environment where change is constant and creativity is a must </li><li>Write technical requirements, manage technical backlogs, and effectively prioritize new features vs. tech debt. Work with a full-stack engineering team to build world-class products that eliminate workflow friction, maximize output, and improve employee experience </li></ul>What You Bring To The Role Minimum Requirements: <ul> <li>7+ years of Product Management experience with relevant experience in a growth and or marketing technology role </li><li>Deep understanding of a wide range of marketing technologies and platforms including CRM, marketing automation, measurement and attribution analytics, personalization, bid optimization, media ad platforms, content management and AI driven solutions </li><li>Solid technical background with understanding and/or hands-on experience in software development and web technologies. </li><li>Self-motivated and thrive in a fast-paced environment, working independently and execute on several major initiatives at a time </li><li>Proven ability to lead and influence cross-functional teams without formal authority </li><li>Strong analytical and quantitative skills; ability to use hard data and metrics to back up assumptions, recommendations, and drive actions. </li><li>Exceptional written and verbal communication skills even in areas of high technical complexity. </li><li>Demonstrated ability to develop product and marketing strategies and effectively communicate recommendations to executive management. </li><li>Proven track record of leading multiple squads and cross-functional teams. </li><li>Actively mentors and develops product management talent. </li><li>Bonus if experience leading teams of product managers </li><li>Must have a great understanding and empathy for The RealReal customers and be their advocate </li></ul>Preferred Requirements: <ul> <li>Familiarity with and experience optimizing conversion passback data and scores for ad platforms (Google, meta, TikTok) etc. </li><li>Experience and examples of work with AI/ ML </li><li>Experience with implementation of multi-touch attribution and media mix modeling </li><li>Experience working with Salesforce marketing cloud, Google Suite of Tools </li><li>Expertise in data privacy regulations and compliance with ability to navigate complex data governance requirements </li></ul>Compensation, Benefits, + Perks <ul> <li>Employee Stock Purchase Plan </li><li>401K with Company Match </li><li>Medical, Dental & Vision Insurance </li><li>Paid Parental Leave </li><li>Unlimited Discretionary Time Off (DTO)* and 10 Paid Company Holidays </li><li>* Unlimited DTO with Manager approval </li></ul> The expected salary range for this role is $164,204.00-$190,000.00. To determine starting pay we carefully consider a variety of factors, including primary work location and an evaluation of a candidate's skills, experience, market demands, and internal parity. Additionally, salary is just one component of TRR's total rewards package. Depending on role, employees may also be eligible for a bonus program, incentive pay and benefits. The RealReal is the world's largest online marketplace for authenticated, resale luxury goods, with more than 30 million members. With a rigorous authentication process overseen by experts, The RealReal provides a safe and reliable platform for consumers to buy and sell their luxury items. We have hundreds of in-house gemologists, horologists and brand authenticators who inspect thousands of items each day. As a sustainable company, we give new life to pieces by thousands of brands across numerous categories-including women's and men's fashion, fine jewelry and watches, art and home-in support of the circular economy. We make selling effortless with free virtual appointments, in-home pickup, drop-off and direct shipping. We do all of the work for consignors, including authenticating, using AI and machine learning to determine optimal pricing, photographing and listing their items, as well as handling shipping and customer service. At our 13 retail locations, including our twelve shoppable stores, customers can sell, meet with our experts and receive free valuations. The RealReal is committed to providing an equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or expression, or Veteran status. We will consider qualified applicants for a position regardless of arrest or conviction records. At TRR, People Come First. That's why diversity and inclusion are vital to our priorities as an equal opportunity employer. You can read about our Diversity Equity and Inclusion program here. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The employee is regularly required to sit; use hands to finger, handle, or feel and talk or hear. The employee is occasionally required to stand; walk; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl; and taste or smell. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

The Realreal Interview Questions

The Realreal Interview Guides

The Realreal Interview Questions

The Realreal Salaries by Position

The Realreal Opening Jobs