Guardian Life Interview Questions

Guardian Life Interview Guides

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

Guardian Life Interview Questions

Practice for the Guardian Life 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
Machine Learning
Easy
Loading pricing options

View all Guardian Life questions

Challenge

Check your skills...
How prepared are you for working at Guardian Life?

Guardian Life Salaries by Position

$81K
$160K
Software Engineer
Median: $131K
Mean (Average): $124K
Data points: 6
$110K
$124K
Data Scientist
Median: $124K
Mean (Average): $119K
Data points: 5
$107K
$115K
Data Engineer
Median: $110K
Mean (Average): $111K
Data points: 4
Product Analyst*
$92K
Product Analyst
Median: $92K
Mean (Average): $92K
Data points: 1
$61K
$80K
Business Analyst
Median: $61K
Mean (Average): $67K
Data points: 5

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

From the graph we can see that on average the Software Engineer role pays the most with a $124,433 base salary while the Business Analyst role on average pays the least with a $66,955 base salary.

Discussion & Interview Experiences

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