Prepare for and practice interview questions from Corvus insurance.

Corvus insurance Interview Questions

Corvus insurance 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>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

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?

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

Corvus insurance Salaries by Position

<p>We’re united by a mission: to make the world a safer place. Corvus Insurance uses novel data and artificial intelligence/machine learning to achieve better insights into commercial insurance risk. Our software empowers brokers and policyholders to better predict and prevent complex claims through data-driven tools and Smart Commercial Insurance policies. This allows us to reduce or eliminate the impact of adverse events, creating a safer world for everyone. Drawing inspiration from the intelligent, tool-building corvid family of birds, we are a team of high-flying collaborative builders. We’re excited to meet you. Spread your wings and soar with us.

Corvus is seeking a Product Manager who will assume ownership of our data-driven product initiatives for Corvus by partnering with our internal functional teams - Underwriting, Actuary, Sales, Claims, Finance & Engineering to serve data as a product.

You will lead our efforts to:
Deliver the necessary capabilities that will enable teams to easily access data insights.
Drive the consumption of data to deliver the best insurance product and experience for our external stakeholders (e.g., brokers and policyholders).
Measure usage and impact of data efforts in helping business stakeholders deliver on their OKRs.
Craft the roadmap for the cloud-based data platform based on strategic priorities, critical use cases, usage patterns and stakeholder feedback.

Responsibilities: Dive deep into our data needs across the organization owning the product outcomes while partnering directly with our design and engineering teams.
Decompose complex use cases and technical requirements into smaller manageable problems by creating and prioritizing with your team and key stakeholders.
Build relationships with your users; understand user's processes and objectives; introduce new ways of doing things better, and solicit productive feedback.
Be a voice for your internal customers by deeply understanding their needs, assessing what is most meaningful and ruthlessly prioritizing the work required to deliver business impact.
Measure success of products and services of the Data Initiatives by continuously monitoring adoption metrics and driving towards the most effective and desired solutions.
Evangelize data across the organization in order to build awareness of data across business and technical teams.

What you’ll bring to the flock: 5+ years experience in product management preferably in a B2B data heavy environment.
3+ years of experience delivering insights through data and/or data focused solutions to your stakeholders.
Experience with identifying stakeholder needs, encapsulating needs into a product vision, translating requirements to product specifications, driving alignment with stakeholders, building and bringing products to market, and driving adoption post-launch.
Experience with data analytics and modern cloud based warehouse and ETL platforms/tools such as Postgres, Amazon Redshift, Snowflake, Databricks, Fivetran, Looker, PowerBI.
A successful track record of working cross-functionally to bring products to fruition and driving adoption of products.
Solid understanding in Agile methodologies within a Product Development Lifecycle.
Background in Insurance or a regulated industry a plus.

Compensation Range: $124K - $155K

#J-18808-Ljbffr</p>

Corvus insurance Interview Questions

Corvus insurance Interview Guides

Corvus insurance Interview Questions

Corvus insurance Salaries by Position

Corvus insurance Opening Jobs