Highmark Health Interview Questions

Highmark Health Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(10)
SQL
(6)
Statistics
(6)
Behavioral
(5)
Data Structures & Algorithms
(4)

Highmark Health Interview Questions

Practice for the Highmark Health interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

Write a SQL query to create a histogram of the number of comments per user in the month of January 2020.

Note: Assume bin buckets class intervals of one.

Note: Comments that were created outside of January 2020 should be counted in a “0” bucket

Example:

Input:

users table

Columns Type
id INTEGER
name VARCHAR
created_at DATETIME
neighborhood_id INTEGER
mail VARCHAR

comments table

Columns Type
user_id INTEGER
body VARCHAR
created_at DATETIME

Output:

Column Type
comment_count INTEGER
frequency INTEGER
SQL
Medium
Statistics
Easy
Loading pricing options

View all Highmark Health questions

Challenge

Check your skills...
How prepared are you for working at Highmark Health?

Highmark Health Salaries by Position

$84K
$133K
Data Scientist
Median: $114K
Mean (Average): $114K
Data points: 14
$93K
$110K
Data Engineer
Median: $110K
Mean (Average): $105K
Data points: 5
Business Analyst*
$78K
Business Analyst
Median: $78K
Mean (Average): $78K
Data points: 1
Business Intelligence*
$65K
Business Intelligence
Median: $65K
Mean (Average): $65K
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 $113,691 base salary while the Business Intelligence role on average pays the least with a $65,000 base salary.

Discussion & Interview Experiences

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