Homesite Insurance Interview Questions

Homesite Insurance Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(19)
SQL
(6)
Statistics
(6)
Probability
(5)
Product Sense & Metrics
(5)

Homesite Insurance Interview Questions

Practice for the Homesite Insurance interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Easy

Write a SQL query to select the 2nd highest salary in the engineering department.

Note: If more than one person shares the highest salary, the query should select the next highest salary.

Example:

Input:

employees table

Column Type
id INTEGER
first_name VARCHAR
last_name VARCHAR
salary INTEGER
department_id INTEGER

departments table

Column Type
id INTEGER
name VARCHAR

Output:

Column Type
salary INTEGER
SQL
Medium
Product Sense & Metrics
Medium
Loading pricing options

View all Homesite Insurance questions

Challenge

Check your skills...
How prepared are you for working at Homesite Insurance?

Homesite Insurance Salaries by Position

$102K
$115K
Data Scientist
Median: $102K
Mean (Average): $106K
Data points: 12
$60K
$170K
Software Engineer
Median: $90K
Mean (Average): $99K
Data points: 298
$77K
$129K
Data Engineer
Median: $94K
Mean (Average): $97K
Data points: 18
$72K
$96K
Data Analyst
Median: $83K
Mean (Average): $85K
Data points: 5
$59K
$91K
Business Analyst
Median: $75K
Mean (Average): $76K
Data points: 12
Product Analyst*
$74K
Product Analyst
Median: $74K
Mean (Average): $74K
Data points: 1

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Data Scientist role pays the most with a $106,138 base salary while the Product Analyst role on average pays the least with a $74,160 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.