Prepare for and practice interview questions from Juniper Square.

Juniper Square Interview Questions

Juniper Square 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

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?

Juniper Square Salaries by Position

About Juniper Square Our mission is to unlock the full potential of private markets. Privately owned assets like commercial real estate, private equity, and venture capital make up half of our financial ecosystem yet remain inaccessible to most people. We are digitizing these markets, and as a result, bringing efficiency, transparency, and access to one of the most productive corners of our financial ecosystem. If you care about making the world a better place by making markets work better through technology - all while contributing as a member of a values-driven organization - we want to hear from you. Juniper Square offers employees a variety of ways to work, ranging from a fully remote experience to working full-time in our physical office in San Francisco or one of our co-working spaces. We invest heavily in digital-first operations, allowing our teams to collaborate effectively across most US states, two Canadian Provinces, and India. About your role We're looking for an experienced product manager to join our growing team developing the future platform for Private Equity investment managers. Juniper Square's platform is used by customers throughout the lifecycle of an investment and investors: from marketing offerings and soliciting leads, digital signing of contracts and terms, reporting on investment financials performance and recording transactions. In this role, you will develop a deep understanding of our customers, their business problems, and their workflows as well as the dynamics at play within private markets. You will leverage these insights to drive the full product lifecycle from high level roadmap definition and stakeholder alignment all the way through execution, GTM, and delivery of value to customers. We are a highly collaborative team, and you will be working very closely with leadership, product managers, customers, customer success, sales, engineers and designers throughout the phases of software development. What you'll do <ul><li>Develop the roadmap for your domain, balance competing needs between features, stability and performance.</li><li>Develop deep empathy for our customers' needs and pain points, by close collaboration with colleagues from our product, sales, customer success, operations teams as well as customers themselves.</li><li>Ship features and improvements frequently and iteratively, planning projects, documenting requirements, and motivating those building solutions with an understanding of the 'why' and the 'what', inspiring their ownership of the 'how'.</li><li>Work cross-functionally with product marketing, customer success, operations teams and more to roll out new capabilities and drive adoption.</li></ul> Qualifications <ul><li>5+ years of experience in technical product management role</li><li>Bachelor's degree in technical or quantitative field, or equivalent schooling or training</li><li>Demonstrated ability to define and ship complex, technical products in an iterative, agile manner</li><li>Comfort working with a range of levels, from envisioning entirely new products to mastering details and edge cases</li></ul><ul><li>Proven ability to motivate, lead and convey complex technical concepts to both technical and non-technical audiences through writing, presentations and collaboration with a diverse set of business teams from engineering to operations, and marketing to customer success</li></ul> At Juniper Square, we believe building a diverse workforce and an inclusive culture makes us a better company. If you think this job sounds like a fit, we encourage you to apply even if you don't meet all the qualifications. Compensation Compensation for this position includes a base salary, equity, and a variety of benefits. The U.S. base salary range for this role is $140,000-180,000 USD. Actual base salaries will be based on candidate-specific factors, including experience, skillset, and location, and local minimum pay requirements as applicable. Benefits include: <ul><li>Health, dental, and vision care for you and your family</li><li>Life insurance and disability coverage</li><li>Mental wellness coverage</li><li>Fertility and growing family support</li><li>Unlimited vacation in addition to company paid holidays</li><li>Paid family leave, medical leave, and bereavement leave policies</li><li>401k retirement savings plan</li><li>Healthcare FSA and commuter benefits programs</li><li>Allowance to customize your work and technology setup at home</li><li>Annual professional development stipend</li></ul> #LI-FM1 #LI-Remote

Juniper Square Interview Questions

Juniper Square Interview Guides

Juniper Square Interview Questions

Juniper Square Salaries by Position

Juniper Square Opening Jobs