Prepare for and practice interview questions from Next insurance.

Next insurance Interview Questions

Next insurance 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?

Next insurance Salaries by Position

Location: Waltham, MA (Hybrid or Eastern Time Zone Remote)Founded in 2016 and headquartered in Palo Alto, NEXT is an insurtech company offering digital insurance solutions tailored to small businesses across the U.S. By leveraging AI and machine learning, we provide customized policies for sectors such as general liability, professional liability, and commercial auto insurance. Business owners can easily receive quotes and purchase coverage through our online platform. Our mission is to help entrepreneurs thrive.To date, we have raised over $1.1 billion in funding, including a $265 million strategic round in November 2023, led by Allstate and Allianz X. This funding is intended to accelerate our path to profitability and expansion. A strategic partnership with Allstate enables us to develop new commercial auto products and extend our offerings to Allstate's customer base. Serving more than 500,000 small businesses nationwide, we employ around 700 people, with offices in Palo Alto, Waltham, Rochester, Israel, and some remote roles.Since 2016, we've empowered hundreds of thousands of small businesses across the United States with fast, customized, and affordable insurance coverage. Backed by the biggest names in insurance and tech, we're experiencing exponential growth and are seeking an enterprising and enthusiastic Insurance Product Manager to join our dynamic team.We're inviting an accomplished and forward-thinking Insurance Product Manager to join our Workers Compensation team. This is a highly visible and cross-functional position with the primary goal of delivering best-in-class products to small businesses in multiple verticals. We believe that the insurance products available on the market today do not fit the needs of small businesses and we are committed to leading the charge in rethinking small business insurance as we know it. If you get excited about analytics & love finding meaning in data to recommend improvements, and want to work on initiatives that will have a real impact on the industry and the customer - we'd love to talk to you!What You'll Do:* Become a go-to expert for the data analysis of our workers compensation product, overseeing the product's analytics in all verticals and using that data to identify ways to improve growth and profitability* Conduct industry research and competitive benchmarking to provide insights on our WC positioning and success* Share responsibility for the growth and profitability of our insurance product line by providing analytics that aid in determining and rolling out to new geographies and customer segments* Partner closely with multiple teams at Next including primarily our Sales Distribution Teams and also Technical Product, Engineering, Data Science, Claims, Compliance, Customer Operations, and Legal* Be the ambassador of the line of business to our distribution internal stakeholders as well as external partners (e.g. Reinsurers, Agents, Partners, etc.)What We Need:* 5+ years of Workers Compensation insurance experience in product management, underwriting, or actuarial.* Experience in the SMB space* Experience in working with Insurance Analytics teams to identify opportunities for improvement and recommend strategies to optimize growth and profitability* Proven experience in using data driven methods in decision making and strong analysis skills* Customer obsessed, passionate about making great products that serve and empower small business owners* Highly organized, able to handle multiple projects at once, and make progress on all fronts* Able to work independently and comfortable with ambiguity* BA/BS degree from a top university preferred but not required

Next insurance Interview Questions

Next insurance Interview Guides

Next insurance Interview Questions

Next insurance Salaries by Position

Next insurance Opening Jobs