Prepare for and practice interview questions from Project44.

Project44 Interview Questions

Project44 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

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?

Project44 Salaries by Position

Why project44?At project44, we’re on a mission—to make supply chains work. We revolutionize supply chains with our High-Velocity Supply Chain Platform. As the connective tissue of the supply chain, project44 optimizes global product movement, delivering unparalleled resiliency, sustainability, and value for our customers. We operate the world's most trusted end-to-end visibility platform, tracking over 1 billion shipments annually for 1,300 leading brands across industries including manufacturing, automotive, retail, life sciences, food & beverage, and oil, chemical & gas. Our High-Velocity platform eliminates supply chain friction, enabling sophisticated inventory control, exceptional customer experience, and predictive analytics through machine learning and automation. If you’re eager to be part of a winning team that works together to solve some of the most challenging supply chain challenges every day, let’s talk. About the team Are you interested in driving business outcomes through analytics? What about using data to answer difficult questions and come up with interesting insights and collaborate with others? If so, then this is the job for you. As a Senior Data Analyst in the Internal Analytics team, you get to use your quantitative skill set, obsession around customer value, drive for operational efficiency, and collaborative spirit to work cross-functionally, to provide data-driven insights and productize workflows to enable our operational teams to reach the next level. Responsibilities <ul><li>Build dashboards and reports to operationalize workflows and provide data-driven insights. </li><li>Analyse raw data, assess quality, profiling, cleansing, and structuring for downstream processing </li><li>Identify opportunities that present the most potential for customer value, and operational efficiency. </li><li>Define and analyse operational performance metrics </li><li>Partner with operational teams to understand requirements and areas of opportunity. </li><li>Partner with product teams to investigate product-level analytics. </li><li>Collaboration in the creation of single-source-of-truth normalized data and standardized denormalized data sets to power companywide analytics. </li></ul>Qualifications <ul><li>Bachelor or master’s degree in business Analytics, Economics, Marketing, Statistics or a related field and 3 years of work experience in the job offered or in an analytics-related occupation </li><li>Experience must include 3 years of experience in the following: </li><li>3+ years of experience in quantitative analysis and data mining </li><li>3+ years of experience in SQL or another programming language for data querying </li><li>3-5 years of relevant experience </li><li>Define and analyze metrics that inform the success of products </li><li>Dashboarding experience with Tableau and Looker</li></ul> In-office Commitment: This position requires a commitment to contribute to our collaborative culture by working in-office three days weekly. Diversity & Inclusion At project44, we're designing the future of how the world moves and is connected through trade and global supply chains. As we work to deliver a truly world-class product and experience, we are also intentionally building teams that reflect the unique communities we serve. We’re focused on creating a company where all team members can bring their authentic selves to work every day. We’re building a company that every one of us at project44 is proud to work for, and our journey of becoming a more diverse, equitable and inclusive organization, where all have a sense of belonging, is shaped through the actions of our leadership, global teams and individual team members. We are resolute in our belief that each team member has an equal responsibility to mold and uphold our culture. project44 is an equal opportunity employer seeking to enrich our work environment by creating opportunities for individuals of all backgrounds and experiences to thrive. If you share our values and our passion for helping the way the world moves, we’d love to review your application! For any needed accommodations during the hiring process, please email recruiting@project44.com. Even if you don’t meet 100% of the above job description you should still seriously consider applying. Studies show that you can still be considered for a role if you meet just 50% of the role’s requirements. #LI-Hybrid

Project44 Interview Questions

Project44 Interview Guides

Project44 Interview Questions

Project44 Salaries by Position

Project44 Opening Jobs