Prepare for and practice interview questions from Stubhub.

Stubhub Interview Questions

Stubhub Interview Guides

<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

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

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

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


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

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?

Stubhub Salaries by Position

<h3>Job Description</h3><div>Job Description<div><div><p>StubHub is on a mission to redefine the live event experience on a global scale. Whether someone is looking to attend their first event or their hundredth, we're here to delight them all the way from the moment they start looking for a ticket until they step through the gate. The same goes for our sellers. From fans selling a single ticket to the promoters of a worldwide stadium tour, we want StubHub to be the safest, most convenient way to offer a ticket to the millions of fans who browse our platform around the world.</p></div><p></p><div>StubHub is hiring for a Senior Data Analyst to join our Catalog Team. The Catalog Team forms the backbone of the StubHub consumer experience allowing customers to discover, browse and purchase the best seats for any event globally. Catalogs are incredibly rich and complex, and it is this team's mission to ensure that we have complete, accurate, up-to-date, and optimized catalogs. In this role, you will work closely with cross functional team members and report to the Senior Product Manager of Catalog.</div><div></div><div><strong>This is a hybrid work opportunity located in New York, NY. 3-day in-office and 2-day remote schedule.</strong></div><p><strong>What You've Done </strong></p><ul><li>3+ years working in quantitative or analytical role; sales operations, operations, project management, management consulting or finance a plus</li><li>Expert in SQL and Microsoft Excel, and experience with A/B testing or experimental design</li><li>Self-motivation and autonomy, the ability to independently identify and implement high-value analyses and projects</li><li>High attention to detail including precise and effective communications</li><li>Organized, strong interpersonal management, time management and communication skills</li></ul><p><strong>What You'll Do </strong></p><ul><li>Lead initiatives to craft, pilot, scale, and optimize programs to increase global supplier acquisition</li><li>Design, build, and optimize dashboards, SQL queries and interfaces to provide internal customers with usable, reliable, and accessible data</li><li>Conduct research on competitors, potential product offerings, vendors, and clients</li></ul><p><strong>What We Offer</strong></p><ul><li><strong>Accelerated Growth Environment:</strong> Immerse yourself in an environment designed for swift skill and knowledge enhancement, where you have the autonomy to lead experiments and tests on a massive scale.</li><li><strong>Top Tier Compensation Package:</strong> Enjoy a rewarding compensation package that includes enticing stock incentives, aligning with our commitment to recognizing and valuing your contributions.</li><li><strong>Flexible Time Off:</strong> Embrace a healthy work-life balance with unlimited Flex Time Off, providing you the flexibility to manage your schedule and recharge as needed.</li><li><strong>Comprehensive Benefits Package:</strong> Prioritize your well-being with a comprehensive benefits package, featuring 401k, and premium Health, Vision, and Dental Insurance options.</li><li><strong>Team-Building Events:</strong> Engage in vibrant team events that foster camaraderie and collaboration, creating an atmosphere where your professional and personal growth are celebrated.</li></ul><p></p><div><div><p>The anticipated gross base pay range is below for this role. Actual compensation will vary depending on factors such as a candidate's qualifications, skills, experience, and competencies. Base annual salary is one component of StubHub's total compensation and competitive benefits package, which includes equity, 401(k), paid time off, paid parental leave, and comprehensive health benefits. </p></div><div>Salary Range</div><div>$135,000—$155,000 USD</div></div><div><div><strong>About Us</strong></div><div>StubHub is the world's leading marketplace to buy and sell tickets to any live event, anywhere. Through StubHub in North America and viagogo, our international platform, we service customers in 195 countries in 33 languages and 49 available currencies. With more than 300 million tickets available annually on our platform to events around the world -- from sports to music, comedy to dance, festivals to theater -- StubHub offers the safest, most convenient way to buy or sell tickets to the most memorable live experiences. Come join our team for a front-row seat to the action. </div><div></div><div>For California Residents: California Job Applicant Privacy Notice found here</div><div></div><div><strong>We are an equal opportunity employer and value diversity on our team. We do not discriminate on the basis of race, color, religion, sex, national origin, gender, sexual orientation, age, disability, veteran status, or any other legally protected status.</strong></div></div></div></div>

<p>We're on the lookout for an accomplished Staff Data Scientist to join the Data Engineering and Analytics team at StubHub. In this role, you'll play a pivotal part in crafting and deploying cutting-edge machine learning models that drive business and operational choices within StubHub's dynamic ecosystem. Our Data Science team serves as the backbone for enabling data-driven decisions across the organization, harnessing the potential of StubHub's consumer data through statistical and machine learning techniques. This involves creating both business-facing and customer-facing products, along with delivering user-friendly tools and clear explanations for non-technical users to enhance self-service capabilities.</p>

<h3>Job Description</h3><div>Job Description<div><div><p>StubHub is on a mission to redefine the live event experience on a global scale. Whether someone is looking to attend their first event or their hundredth, we're here to delight them all the way from the moment they start looking for a ticket until they step through the gate. The same goes for our sellers. From fans selling a single ticket to the promoters of a worldwide stadium tour, we want StubHub to be the safest, most convenient way to offer a ticket to the millions of fans who browse our platform around the world.</p></div><div><div><div>StubHub is on a mission to redefine the live event experience on a global scale. Whether someone is looking to attend their first event or their hundredth, we're here to delight them all the way from the moment they start looking for a ticket until they step through the gate. The same goes for our sellers. From fans selling a single ticket to the promoters of a worldwide stadium tour, we want StubHub to be the safest, most convenient way to offer a ticket to the millions of fans who browse our platform around the world.</div><div></div><div>StubHub is seeking Senior Software Engineers in Android to design and develop next-generation technologies and complex features. As a Senior Software Engineer, you will be at the forefront of tackling significant, ambiguous, and non-trivial challenges as a core contributor and innovator, bringing creative technical solutions to life. In order to ensure our company's success, our Senior Software Engineers must demonstrate initiative and enthusiasm for the problems they tackle. StubHub is committed to being a phenomenal and inclusive place to work. As a Senior Software Engineer, you will also be an advocate and mentor for your team members, displaying leadership qualities and being an example for those around you. </div><div></div><div>This is a hybrid work opportunity located in either New York, NY or Los Angeles, CA.</div><div></div><div><strong>About the team</strong></div><div>The Consumer Experience (CX) team is responsible for the end-to-end product experience for fans looking to discover, buy, and sell tickets to their favorite live events through our web and mobile platforms. It sits at the forefront of fulfilling StubHub's mission to become the global destination for accessing live event experiences by crafting the product experience that millions of fans interact with every day. We are obsessed with understanding our users' needs and delivering feature innovations, both short-term and long-term, that are as effective as they are enjoyable. We serve a global fan base and aim to deliver a localized experience that feels personalized to every individual in over 60 regions and 30 languages. We believe that diversity of thought and transparency of impact breed the best innovations, which is why we are a cross-functional team of specialists in product, design, engineering, and data working closely together with equal voice in ideation and equal access to insights. We work across the entire stack leveraging any tool or technology necessary to support web and mobile feature innovation at scale.</div></div><div><div>What You've Done:<ul><ul><li>5-6+ years of professional experience in software development </li><li>Extensive experience developing robust, mission-critical systems using multiple general-purpose programming languages (Kotlin or Java)</li><li>Demonstrated expertise in building software with one or more of the following: Infrastructure, Databases, Data Processing, Machine Learning, Distributed Systems, Security, and Privacy</li><li>Previous experience designing and developing solutions to complex problems with significant business impact</li><li>A strong understanding of how their systems interact with the broader production environment, including dependencies and platform primitives</li><li>Exposure to React Native</li><li>Proven ability to learn other coding languages, platforms, frameworks, and tools</li><li>Experience owning projects from the initial idea all the way to production</li><li>Experience mentoring junior engineers</li></ul></ul></div></div><div><div>What You'll Do:<ul><ul><li>Design, develop, test, deploy, and maintain impactful improvements across all StubHub's platforms and products, resulting in high-quality outcomes</li><li>Collaborate with team members to ensure best practices across our code</li><li>Manage individual initiative priorities, deadlines, and deliverables with your technical expertise</li><li>Mentor other team members and help many increase their technical capabilities, fostering a culture of inclusion, results-oriented execution, open innovation, and limitless creativity </li></ul></ul></div></div><div><div>What We Offer:<ul><ul><li><strong>Accelerated Growth Environment:</strong> Immerse yourself in an environment designed for swift skill and knowledge enhancement, where you have the autonomy to lead experiments and tests on a massive scale.</li><li><strong>Top Tier Compensation Package:</strong> Enjoy a rewarding compensation package that includes enticing stock incentives, aligning with our commitment to recognizing and valuing your contributions.</li><li><strong>Flexible Time Off:</strong> Embrace a healthy work-life balance with unlimited Flex Time Off, providing you the flexibility to manage your schedule and recharge as needed.</li><li><strong>Comprehensive Benefits Package:</strong> Prioritize your well-being with a comprehensive benefits package, featuring 401k, and premium Health, Vision, and Dental Insurance options.</li><li><strong>Team-Building Events:</strong> Engage in vibrant team events that foster camaraderie and collaboration, creating an atmosphere where your professional and personal growth are celebrated.</li></ul></ul></div></div></div><div><div><p>The anticipated gross base pay range is below for this role. Actual compensation will vary depending on factors such as a candidate's qualifications, skills, experience, and competencies. Base annual salary is one component of StubHub's total compensation and competitive benefits package, which includes equity, 401(k), paid time off, paid parental leave, and comprehensive health benefits. </p></div><div>Salary Range</div><div>$200,000—$275,000 USD</div></div><div><div><strong>About Us</strong></div><div>StubHub is the world's leading marketplace to buy and sell tickets to any live event, anywhere. Through StubHub in North America and viagogo, our international platform, we service customers in 195 countries in 33 languages and 49 available currencies. With more than 300 million tickets available annually on our platform to events around the world -- from sports to music, comedy to dance, festivals to theater -- StubHub offers the safest, most convenient way to buy or sell tickets to the most memorable live experiences. Come join our team for a front-row seat to the action. </div><div></div><div>For California Residents: California Job Applicant Privacy Notice found here</div><div></div><div><strong>We are an equal opportunity employer and value diversity on our team. We do not discriminate on the basis of race, color, religion, sex, national origin, gender, sexual orientation, age, disability, veteran status, or any other legally protected status.</strong></div></div></div></div>

Stubhub Interview Questions

Stubhub Interview Guides

Stubhub Interview Questions

Stubhub Salaries by Position

Stubhub Opening Jobs