Consultant Analyst Interview Questions

858 consultant analyst interview questions shared by candidates

Interview 1 (Telephone)- With Senior Manager Actuary Explained the role and responsibilities Can you go through your resume? Then the interviewer asked to explain each experience. Then asked, do have any questions for me Interview 2 (Video) Panel Interview – With 2 Associate Data Analysts and 1 Senior Data Analyst Tell me about yourself How have you worked in a cross-functional team, how you conveyed the technical result/part to non-technical people? Give an example. You have mentioned tableau in your resume, how was your experience with tableau? Can you please explain why do you want to work in healthcare? Can you explain why this position? What is your biggest strength? What is your biggest weakness? Do you have any questions for us? What are your hobbies? Interview 3 (Video)– With Senior Directory Actuary Explained about the company, how it works, business case Tell me about yourself and how you relate your background, experience with this position? Which geographical locations your previous workplaces were? I see that you have knowledge of Machine Learning and Data Mining. I know you are not aware of the model that we are having/working on. I want to know how much time you might require to fully understand the model and become an expert on that, I mean how confidant are you on that? Tell me are you confident that you can do it? Then tell me why you are confident, give me an example? Interview 4: With Senior Manager Actuary Technical Interview(Video) Task 1- Asked to write a SQL query on their internal data set. Query involved aggregation - sum and writing cases in select. Task 2- Showed a VBA script and asked to explain it. Interview 5 (Video)- With Manager from another team. Asked to tell about myself Asked to rate my skills - SQL & Python Asked whether I was having any questions about the role, process, or anything. Interview 6 (Video)- WIth the Team Lead. Asked to tell about myself Technical Task 1- SQL query to get people from all the departments with top 3 salaries. Technical Task 2 - How to get a large amount of data from excel to SQL server. Explained about the role and requirements.
avatar

Data Analyst, Health Consultant

Interviewed at Blue Shield Of California

3.5
Jan 25, 2021

Interview 1 (Telephone)- With Senior Manager Actuary Explained the role and responsibilities Can you go through your resume? Then the interviewer asked to explain each experience. Then asked, do have any questions for me Interview 2 (Video) Panel Interview – With 2 Associate Data Analysts and 1 Senior Data Analyst Tell me about yourself How have you worked in a cross-functional team, how you conveyed the technical result/part to non-technical people? Give an example. You have mentioned tableau in your resume, how was your experience with tableau? Can you please explain why do you want to work in healthcare? Can you explain why this position? What is your biggest strength? What is your biggest weakness? Do you have any questions for us? What are your hobbies? Interview 3 (Video)– With Senior Directory Actuary Explained about the company, how it works, business case Tell me about yourself and how you relate your background, experience with this position? Which geographical locations your previous workplaces were? I see that you have knowledge of Machine Learning and Data Mining. I know you are not aware of the model that we are having/working on. I want to know how much time you might require to fully understand the model and become an expert on that, I mean how confidant are you on that? Tell me are you confident that you can do it? Then tell me why you are confident, give me an example? Interview 4: With Senior Manager Actuary Technical Interview(Video) Task 1- Asked to write a SQL query on their internal data set. Query involved aggregation - sum and writing cases in select. Task 2- Showed a VBA script and asked to explain it. Interview 5 (Video)- With Manager from another team. Asked to tell about myself Asked to rate my skills - SQL & Python Asked whether I was having any questions about the role, process, or anything. Interview 6 (Video)- WIth the Team Lead. Asked to tell about myself Technical Task 1- SQL query to get people from all the departments with top 3 salaries. Technical Task 2 - How to get a large amount of data from excel to SQL server. Explained about the role and requirements.

Tell me about a time when you worked as part of a team and faced a challenge as a unit? This question was followed by a case study. You then then repeat this progress with the second interviewer to round off the first round. Successful candidates are then invited to the final round set of interviews.
avatar

Management Consultant Business Analyst

Interviewed at McKinsey & Company

4.1
Nov 11, 2016

Tell me about a time when you worked as part of a team and faced a challenge as a unit? This question was followed by a case study. You then then repeat this progress with the second interviewer to round off the first round. Successful candidates are then invited to the final round set of interviews.

The problem solving test was hardest for me as the materials to prepare for it were provided by McKinsey, but ultimately, unrelated to the actual test. There were a few questions that could have been answered in a number of ways, but it was a multiple choice format.
avatar

Business Analyst/Management Consultant

Interviewed at McKinsey & Company

4.1
May 23, 2016

The problem solving test was hardest for me as the materials to prepare for it were provided by McKinsey, but ultimately, unrelated to the actual test. There were a few questions that could have been answered in a number of ways, but it was a multiple choice format.

Viewing 211 - 220 interview questions

Glassdoor has 858 interview questions and reports from Consultant analyst interviews. Prepare for your interview. Get hired. Love your job.