Role · Data

How to hire a Data Analyst

Data analysts answer business questions using SQL, dashboards, and clear communication. They are the bridge between raw data and decisions. Every department wants one, and the good ones get hired fast.

Start hiring Data Analysts with GoodFit

Why this role is hard to hire

The hiring challenge

Good data analysts are rare because the role needs both SQL depth AND storytelling. Most candidates are strong on one and weak on the other. A candidate who writes perfect SQL but cannot explain what the numbers mean to a VP is only half an analyst. A candidate who tells great stories but cannot join three tables is the other half. You need both in one person.

What to look for in a Data Analyst

Three things matter: SQL fluency (can they write a moderately complex query without hand-holding?). Business judgment (when revenue drops 15%, do they check the right things in the right order?). Communication clarity (can they turn a SQL result into a sentence a non-technical stakeholder can act on?).

For Indian companies specifically, look for comfort with Indian number formatting (lakhs and crores), experience with the BI tools your team actually uses (Metabase, Looker, Tableau, or Power BI), and an ability to work across time zones if analytics supports global teams.

How to structure the interview

A strong data analyst interview has three parts. First, a SQL challenge: give them a schema and ask a business question that requires joins, aggregation, and a window function. Look at query correctness, readability, and whether they ask clarifying questions about the schema. Second, a case study: present a real-ish business scenario (revenue dropped, churn spiked, a feature launch underperformed) and ask them to walk through their investigation. Score on whether they structure the problem before diving in. Third, a dashboard review: ask them to walk through something they built and explain what decisions it drove.

Common mistakes when hiring Data Analysts

Testing SQL trivia instead of SQL thinking. Asking "what is the difference between WHERE and HAVING" tests memorization. Asking "given this schema, find users who churned after their first month" tests thinking. Test thinking.

Ignoring the communication round. An analyst who cannot present findings clearly will produce dashboards nobody opens. Always include a round where the candidate explains something to a non-technical audience.

Not checking for business context. A data analyst is not a SQL robot. They should ask "why does this matter?" before running a query. If they jump straight to code without understanding the business question, that is a red flag.

What to test

Key skills for a Data Analyst

SQL (joins, aggregation, window functions)
Dashboard design and storytelling
Business judgment
Data investigation methodology
Communication to non-technical stakeholders
A/B test interpretation
Excel and spreadsheet fluency
BI tool proficiency

Sample questions

What a great interview looks like

Coding

"Write a SQL query to compute weekly retention cohorts from a signups and logins table."

Scenario

"Revenue dropped 15% last week. Walk me through the five things you would check first and why."

Video

"Show me a dashboard you built and walk me through the decisions it helped your team make."

Voice

"Tell me about a time your analysis changed a decision. What was the question, what did you find, and what happened?"

Scenario

"Your manager asks you to prove that a new feature increased engagement. How do you set up the analysis?"

Every question is from the GoodFit library. Customize the rubric for your context in the platform.

Suggested format

Recommended interview process

Round 1: AI Voice Interview

15 min

Behavioral questions on past analysis work, business judgment scenarios, and communication style.

Round 2: SQL + Case Study

45 min

SQL challenge on a realistic schema, plus a business investigation walkthrough.

Round 3: Hiring Manager Interview

30 min

Dashboard review, team fit, and tool-specific discussion.

Want to set up this interview process for your Data Analyst openings? GoodFit handles Rounds 1 and 2 automatically. Your team only steps in for the final conversation.

Set this up with GoodFit

Ready-made template