Bain & Company Interview Questions

Bain & Company Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(42)
Data Structures & Algorithms
(37)
SQL
(21)
Probability
(17)
Statistics
(13)

Bain & Company Interview Questions

Practice for the Bain & Company interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.

Given two tables: employees and projects, find the sum of the salaries of all the employees who didn’t complete any of their projects.

Clarification:

We will consider a project unfinished if it has no end date (its End_dt is NULL).

Given this, we’ll say an employee didn’t finish any of their projects when:

  • They were assigned at least one project.
  • None of their projects have an End_dt.

Example:

Input:

employees table

id salary
INTEGER FLOAT

projects table

employee_id project_id Start_dt End_dt
INTEGER INTEGER DATETIME DATETIME

Output:

total_slack_salary
INTEGER
Machine Learning
Medium
Behavioral
Medium
Loading pricing options

View all Bain & Company questions

Challenge

Check your skills...
How prepared are you for working at Bain & Company?

Bain & Company Salaries by Position

Business Analyst*
$90K
Business Analyst
Median: $90K
Mean (Average): $90K
Data points: 1
Software Engineer*
$90K
Software Engineer
Median: $90K
Mean (Average): $90K
Data points: 2
Product Manager*
$80K
Product Manager
Median: $80K
Mean (Average): $80K
Data points: 1
Data Scientist*
$65K
Data Scientist
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 Software Engineer role pays the most with a $90,000 base salary while the Data Scientist role on average pays the least with a $65,340 base salary.

Discussion & Interview Experiences

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