Progressive Insurance Interview Questions

Progressive Insurance Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(24)
Statistics
(11)
SQL
(9)
Product Sense & Metrics
(8)
Data Structures & Algorithms
(8)

Progressive Insurance Interview Questions

Practice for the Progressive 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
A/B Testing
Medium
Loading pricing options

View all Progressive Insurance questions

Challenge

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

Progressive Insurance Salaries by Position

$100K
$112K
Data Scientist
Median: $105K
Mean (Average): $106K
Data points: 21
$83K
$110K
Business Intelligence
Median: $98K
Mean (Average): $98K
Data points: 30
$70K
$119K
Software Engineer
Median: $84K
Mean (Average): $91K
Data points: 7
Data Engineer*
$91K
Data Engineer
Median: $91K
Mean (Average): $91K
Data points: 1
$73K
$103K
Data Analyst
Median: $85K
Mean (Average): $86K
Data points: 33
Product Analyst*
$75K
Product Analyst
Median: $75K
Mean (Average): $75K
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 $105,623 base salary while the Product Analyst role on average pays the least with a $75,400 base salary.

Discussion & Interview Experiences

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