Prepare for and practice interview questions from Equipmentshare.

Equipmentshare Interview Questions

Equipmentshare 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

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

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

Equipmentshare Salaries by Position

EquipmentShare is Hiring a Data Scientist (Operations Research). EquipmentShare is searching for a Sr Data Scientist specializing in Operations Research (OR) to join our team. This position is fully remote. Primary Responsibilities Despite having been fundamentally altered by earlier industrial revolutions, the construction industry has hardly budged with the computer revolution. In fact, since 1970, labor productivity in the US construction industry has actually declined, despite it more than doubling in the rest of the economy. This has contributed to housing shortages and the parlous state of infrastructure in some places, and is sanding the gears of carbon reduction efforts. We think the industry is ripe for change, and we're pushing the leading edge of that change with our next generation T3 Platform, the OS for Construction. Through T3, we help contractors to coordinate humans and (increasingly smarter) machines to build more effectively. As a Sr Data Scientist specialized in OR in our small and quickly growing team, you will play a major role in this effort. In particular, you will <ul><li>Create and enhance fleet management practices across the company through analytical techniques</li><li>Develop, from scratch, simulation experiments that lead to implemented optimization algorithms to solve our complex supply chain problems</li><li>Assist in identifying key KPIs and metrics to measure our company's supply chain effectiveness</li><li>Help to identify the highest value next opportunities for OR within a big greenfield space, work cross-functionally to plan and build, and measure your significant business impact via experimentation</li></ul>Why We're a Better Place to Work <ul><li>Competitive compensation packages </li><li>401 (k) and company match</li><li>Health insurance and medical coverage benefits</li><li>Unlimited paid time off</li><li>Generous paid parental leave</li><li>Volunteering and local charity initiatives that help you nurture and grow the communities you call home</li><li>Stocked breakroom and full kitchen (corporate HQ)</li><li>State of the art onsite gym (corporate HQ)/Gym stipend for remote employees</li><li>Opportunities for career and professional development with conferences, events, seminars, continued education</li></ul>About You Our mission to change an entire industry is not easily achieved, so we only hire people who are inspired by the goal and up for the challenge. In turn, our employees have every opportunity to grow with us, achieve personal and professional success and enjoy making a tangible difference in an industry that's long been resistant to change. Skills & Qualifications Minimum Qualifications: <ul><li>Graduate degree or equivalent practical experience in statistics, computer science, applied math, operations research or related field</li><li>4+ years working on technology-powered products and projects within the OR, supply chain optimization, or data science roles</li><li>Demonstrated understanding of the techniques and methods of modern algorithm development</li><li>Strong cross-functional communication skills</li><li>Must be qualified to work in the United States - we are not sponsoring any candidates at this time</li></ul> EquipmentShare is committed to a diverse and inclusive workplace. EquipmentShare is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. #LI-Remote

EquipmentShare is Hiring a Product ManagerEquipmentShare is searching for a Product Manager to support our team. This position is fully remote.What You'll Do as a Product Manager* Develop the vision and strategy for your product space* Build alignment on the roadmap and prioritization while responding to new business and customer needs* Drive product execution in partnership with the cross-functional team* Lead research and discovery efforts to shape the user experience and requirements.* Partner with design, engineering and other product managers to discover and deliver the best solution to the market.* Be the primary source of deep knowledge of users and customers, and the data about how customers want to interact with this solution.* Track industry trends and the competitive landscape as they pertain to your domain.* Define and commit to measurable results and achieve them through direct ownership or influence working with others.Why We're a Better Place to Work* Competitive compensation packages* 401 (k) and company match* Health insurance and medical coverage benefits* Unlimited paid time off* Generous paid parental leave* Volunteering and local charity initiatives that help you nurture and grow the communities you call home* Stocked breakroom and full kitchen (corporate HQ)* State of the art onsite gym (corporate HQ)/Gym stipend for remote employees* Opportunities for career and professional development with conferences, events, seminars, continued educationAbout YouOur mission to change an entire industry is not easily achieved, so we only hire people who are inspired by the goal and up for the challenge. In turn, our employees have every opportunity to grow with us, achieve personal and professional success and enjoy making a tangible difference in an industry that's long been resistant to change.Skills & QualificationsMinimum Qualifications:* Bachelor's degree or equivalent practical experience* 4+ years working on technology-powered products as either a product manager or software engineer* Demonstrated understanding of the techniques and methods of modern product discovery and delivery* Demonstrated ability to learn multiple functional areas of business* Must be qualified to work in the United StatesPreferred Qualifications:* Product Management experience preferred* Experience managing day-to-day technical and design direction* Knowledge of multiple functional areas (e.g., Product Management, Engineering, UX/UI, Sales, Customer Support, Finance or Marketing)* Ability to influence multiple stakeholders without direct authorityEquipmentShare is committed to a diverse and inclusive workplace. EquipmentShare is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status.#LI-Remote

Equipmentshare Interview Questions

Equipmentshare Interview Guides

Equipmentshare Interview Questions

Equipmentshare Salaries by Position

Equipmentshare Opening Jobs