Analyst Interviews

Analyst Interview Questions

Analysts work in a variety of fields to break down complex problems and find solutions. When interviewing candidates, employers are looking for applicants who have strong analytical and problem-solving skills as well as in-depth knowledge of the field. For more information on the specific questions you'll be asked, try researching a particular role such as business analyst, financial analyst, programming analyst, or data analyst.

Top Analyst Interview Questions & How to Answer

Question 1

Question #1: What do you think are the key strengths of an analyst?

How to answer
How to answer: Compose a list highlighting both the behavioral and technical attributes that you're able to apply to the role. The job description should include specific skills an employer is looking for and abilities that are valued, which you should incorporate into your answer.
Question 2

Question #2: How do you handle requirement changes?

How to answer
How to answer: This question is meant to assess your logical thinking and problem-solving skills. It's important to discuss how you prioritize changes, evaluate their impact on projects and resources, and uncover new gaps the change is introducing to functional and technical designs.
Question 3

Question #3: Which intelligence tools or systems have you worked with?

How to answer
How to answer: List specific tools and systems and how you've used them; if you've used a system the interviewing company employs, it's important to highlight that. If you're unfamiliar with their technology, talk about how you plan to learn.

432,899 analyst interview questions shared by candidates

Ok Suppose My Daughter said to me that in 2016 , her age is same as the last two digits of her birthday year and then her Grandfather came into the room and he also said the same thing that his age is also the same as last two digits of his birthday year. Find out what is age of Daughter and her Grandfather
avatar

Associate Analyst

Interviewed at Fractal

4.1
Dec 25, 2017

Ok Suppose My Daughter said to me that in 2016 , her age is same as the last two digits of her birthday year and then her Grandfather came into the room and he also said the same thing that his age is also the same as last two digits of his birthday year. Find out what is age of Daughter and her Grandfather

Flip a fair coin 1000 times. What's the probability that the number of heads come up more than 550 times? What theorem would you use to describe probabilities of rare events as number of coin flips goes to infinity?
avatar

Quantitative Analyst

Interviewed at D. E. Shaw & Co. - Investment Firm

3.8
Nov 17, 2014

Flip a fair coin 1000 times. What's the probability that the number of heads come up more than 550 times? What theorem would you use to describe probabilities of rare events as number of coin flips goes to infinity?

Prepare 6-7 situations for behavioral questions and be flexible if they questions is not asked in the way as you are prepared. Try to find the character they asked from your prepared examples. Cases are easy, if you make mistake and feel your answer is awkward, ask for help and modify your calc. I did make a mistake. It was a typo carried to next step's calc. And I found out and asked for help, and found out what's wrong with the formula I wrote.
avatar

Senior Data Analyst

Interviewed at Capital One

3.6
Mar 4, 2014

Prepare 6-7 situations for behavioral questions and be flexible if they questions is not asked in the way as you are prepared. Try to find the character they asked from your prepared examples. Cases are easy, if you make mistake and feel your answer is awkward, ask for help and modify your calc. I did make a mistake. It was a typo carried to next step's calc. And I found out and asked for help, and found out what's wrong with the formula I wrote.

Interview Questions were average on difficulty level if you put some thought to it. Screening rounds were more of question answers based where they gave you a problem and expected an answer. Python: Find the max no from the given set of elements in an array (without using max function) Find the minimum absolute difference between the set of elements of an array. Python Coding Questions that involved a hashmap. Know your basics well Print Max element of a given list Print median of a given list Print the first nonrecurring element in a list Print the most recurring element in a list HCF/Greatest common Factor of List LCM of list Sql: find the highest salary per department Select employee from departments where max salary of the department is 40k Select employee assigned to projects Select employee which have the max salary in a given department Select employee with second highest salary Table has two data entries every day for # of apples and oranges sold. write a query to get the difference between the apples and oranges sold on a given day Typical questions around Group by, Joins during screening round they used MYSQL so practice solutions with basic SQL as the version i was working on didn't support analytical functions or other advanced features. Face To Face Rounds (Fullstack): To begin I was asked about different metrics which could be reported given the dataset/information or scenario. Then interviewer picked up a metrics and asked to draw on whiteboard what kind of graph/chart will I use to display the information. Then going further asked about the table structures and data model which will be required to support the dashboard. Interviewer then provided the initial data set which is 1 case was a log file and in another some detail level tables, I was asked to write a programming code to read, parse and load data to tables. Then along the way once we have our code tables and dashboard finalized i was asked to write SQL's for different steps in the whole pipeline.
avatar

Data Analyst

Interviewed at Meta

3.5
Dec 16, 2016

Interview Questions were average on difficulty level if you put some thought to it. Screening rounds were more of question answers based where they gave you a problem and expected an answer. Python: Find the max no from the given set of elements in an array (without using max function) Find the minimum absolute difference between the set of elements of an array. Python Coding Questions that involved a hashmap. Know your basics well Print Max element of a given list Print median of a given list Print the first nonrecurring element in a list Print the most recurring element in a list HCF/Greatest common Factor of List LCM of list Sql: find the highest salary per department Select employee from departments where max salary of the department is 40k Select employee assigned to projects Select employee which have the max salary in a given department Select employee with second highest salary Table has two data entries every day for # of apples and oranges sold. write a query to get the difference between the apples and oranges sold on a given day Typical questions around Group by, Joins during screening round they used MYSQL so practice solutions with basic SQL as the version i was working on didn't support analytical functions or other advanced features. Face To Face Rounds (Fullstack): To begin I was asked about different metrics which could be reported given the dataset/information or scenario. Then interviewer picked up a metrics and asked to draw on whiteboard what kind of graph/chart will I use to display the information. Then going further asked about the table structures and data model which will be required to support the dashboard. Interviewer then provided the initial data set which is 1 case was a log file and in another some detail level tables, I was asked to write a programming code to read, parse and load data to tables. Then along the way once we have our code tables and dashboard finalized i was asked to write SQL's for different steps in the whole pipeline.

Viewing 781 - 790 interview questions

Glassdoor has 432,899 interview questions and reports from Analyst interviews. Prepare for your interview. Get hired. Love your job.