Data Analyst interview questions and answers

The questions employers often ask in a data analyst interview, what they want to hear and sample answers you can adapt. Replace anything in [brackets] with your own details.

Data analyst questions

1.Tell me about an analysis that changed a decision.

Why they ask / how to answer: Show the question, method and business impact.

Sample answerOur marketing team wanted to increase spending on a channel. I analyzed customer cohorts and found those customers churned twice as fast. We moved budget to another channel and improved [90-day retention by 12%].

2.What SQL skills do you have?

Why they ask / how to answer: Be specific about joins, window functions, CTEs.

Sample answerI write SQL daily: joins, CTEs, window functions for running totals and rankings, and I optimize slow queries by checking indexes and filtering early.

3.How do you handle messy or missing data?

Why they ask / how to answer: Show a careful process and transparency.

Sample answerI check where the problem comes from, fix it at the source if possible, and document any assumptions, such as excluding test accounts. I share the impact of missing data with stakeholders instead of hiding it.

4.Which visualization tools do you use?

Why they ask / how to answer: Name tools and how you design dashboards.

Sample answerI use [Tableau and Power BI]. I design dashboards around the questions people actually ask, with the key number at the top and filters only where they help.

5.How do you explain results to non-technical people?

Why they ask / how to answer: Plain language, conclusion first.

Sample answerI start with the answer and what to do about it, then show one or two simple charts. Technical details go in an appendix for anyone who wants them.

6.How do you make sure your numbers are right?

Why they ask / how to answer: Show validation habits.

Sample answerI compare results with another source, check row counts after joins and ask a colleague to review important analyses. If a number looks surprising, I investigate before sharing it.

Common questions in every interview

7.Tell me about yourself.

Why they ask / how to answer: Give a 30 to 60 second answer: where you are now, one or two relevant strengths and why you want this job. Your resume summary is a good starting point; say it in your own words, in the first person.

Sample answerHere is a resume summary to build from: "Data analyst with 3 years of experience turning messy data into clear dashboards and recommendations. Strong in SQL, Python and Tableau, and work closely with business teams to answer the questions that matter." Then add one sentence on why you want this particular job.

8.What are your greatest strengths?

Why they ask / how to answer: Pick two strengths from the job ad and prove each with an example.

Sample answerCuriosity and communication. For example: wrote SQL queries across large datasets to answer questions from sales and marketing.

9.What is your greatest weakness?

Why they ask / how to answer: Choose a real but manageable weakness and show what you do about it.

Sample answerI used to find it hard to say no when people asked for help, which sometimes made my days too full. Now I check priorities before I take on more, so the most important work always gets done well.

10.Why should we hire you?

Why they ask / how to answer: Connect your experience to the employer's needs in two or three sentences.

Sample answerI bring hands-on experience in sql and python (pandas), and I care about doing the job right. Built Tableau dashboards that replaced manual weekly spreadsheets.

Questions to ask the interviewer

  • What does a typical day look like in this role?
  • How will you measure success in the first 90 days?
  • What do you enjoy most about working here?
  • What are the next steps in the hiring process?

After the interview, send a short thank you email within 24 hours.

Make sure your resume gets you the interview

Start from our data analyst example: the job title, summary and skills are filled in for you. Edit in a simple form, then download for $5.99, once. No account, no subscription.

Use the data analyst example