Senior Data Analyst interview questions

How to use these questions

• Start with Screening questions — that's what you'll hear first (recruiter, HR).
• Prepare Technical questions with a concrete case from your experience that proves mastery.
• For Behavioral questions, use the STAR method (Situation, Task, Action, Result).
• Practice out loud — fluency is 50% of interview performance.

Technical (10)

1. 1

   How do you optimize a complex SQL query that runs too slow?

   Medium

   Scenario — Core Technical Skills (1)

   Tip. Discuss EXPLAIN, indexing, CTEs, partitioning, subquery rewriting.

2. 2

   How do you design a robust end-to-end A/B test?

   Hard

   Scenario — Core Technical Skills (1)

   Tip. Cover hypothesis, sample size, statistical power, duration, metrics, causal analysis.

3. 3

   When do you use Chi-squared vs Fisher's exact vs proportion test?

   Hard

   Scenario — Core Technical Skills (2)

   Tip. Distinguish by sample size, data type and distribution assumptions.

4. 4

   Explain how you build a cohort analysis to measure retention.

   Medium

   Scenario — Core Technical Skills (2)

   Tip. Detail cohort definition, retention metrics, heatmap visualization.

5. 5

   Describe your approach to optimize a slow SQL query

   Hard

   Scenario — Advanced SQL Optimization

   Tip. EXPLAIN PLAN, indexing, query rewriting, execution analysis. Profile first.

6. 6

   When would you create index and on which columns?

   Hard

   Scenario — Advanced SQL Optimization

   Tip. Query frequency, data size, indexing cost. Composite vs single-column.

7. 7

   Design ETL pipeline to load 1TB data daily

   Hard

   Scenario — ETL Pipeline Design

   Tip. Data sources, incremental loads, validation, error handling, monitoring, scheduling.

8. 8

   How would you handle failures and errors in ETL pipeline?

   Hard

   Scenario — ETL Pipeline Design

   Tip. Logging, alerting, rollback, retry logic, data reconciliation, monitoring.

9. 9

   Build predictive model for customer churn

   Hard

   Scenario — Predictive Analytics

   Tip. Feature engineering, model selection, validation, threshold tuning, business impact.

10. 10

    How would you evaluate predictive model quality?

    Medium

    Scenario — Predictive Analytics

    Tip. Train/test split, cross-validation, appropriate metrics, baseline comparison.

Behavioral (6)

1. 1

   Describe a situation where two teams interpreted the same data differently.

   Medium

   Scenario — Collaboration & Teamwork

   Tip. Show your mediator role, analytical rigor and diplomacy.

2. 2

   How do you prioritize between multiple urgent analysis requests?

   Medium

   Scenario — Collaboration & Teamwork

   Tip. Discuss business impact evaluation, transparent communication and deadline negotiation.

3. 3

   Describe a situation where you had to collaborate with a difficult team

   Medium

   Scenario — Teamwork & Collaboration

   Tip. Use STAR. Focus on your role as facilitator and results achieved despite difficulties.

4. 4

   How do you handle disagreements within a team?

   Easy

   Scenario — Teamwork & Collaboration

   Tip. Show your listening skills, consensus-seeking and focus on common goal.

5. 5

   Tell me about a professional conflict you resolved

   Medium

   Scenario — Conflict Resolution

   Tip. STAR required. Show empathy, communication and win-win solution.

6. 6

   Tell me about a major conflict you handled at work.

   Medium

   Scenario — Conflict Resolution

   Tip. STAR: situation, both sides' positions, resolution approach, result.

Situational (4)

1. 1

   Tell me about a situation with an unhappy client

   Medium

   Scenario — Handling Difficult Clients/Customers

   Tip. STAR. Show active listening, empathy, proposed solution and follow-up.

2. 2

   How do you handle an unhappy client?

   Medium

   Scenario — Handling Difficult Clients/Customers

   Tip. Active listening, empathy, factualizing the problem, concrete action plan.

3. 3

   How did you handle a project with an impossible deadline?

   Medium

   Scenario — Managing Tight Deadlines

   Tip. Show prioritization, proactive communication and value delivery despite constraints.

4. 4

   You have 3 days to deliver what would take you 5. What do you do?

   Medium

   Scenario — Managing Tight Deadlines

   Tip. Negotiate scope, prioritize essentials, communicate transparently.

Leadership (4)

1. 1

   How do you manage an underperforming team member?

   Medium

   Scenario — People Management

   Tip. Show constructive approach: clear feedback, improvement plan, regular follow-up.

2. 2

   Describe your management style.

   Medium

   Scenario — People Management

   Tip. Authentic, examples, awareness of your strengths and watch points.

3. 3

   What is the most important strategic aspect of your last role?

   Medium

   Scenario — Strategic Thinking

   Tip. Vision, structuring choices, long-term impact.

4. 4

   How do you balance short and long term?

   Hard

   Scenario — Strategic Thinking

   Tip. Explicit trade-offs, dedicated resources, communication.

Case Studies (2)

1. 1

   Churn rate increased 15% this quarter. How do you structure your investigation?

   Hard

   Scenario — Problem Solving

   Tip. Break down by segments, analyze cohorts, identify correlated variables, propose actions.

2. 2

   Design a KPI framework to drive revenue for a SaaS product.

   Hard

   Scenario — Problem Solving

   Tip. Cover MRR, ARR, LTV, CAC, churn, expansion revenue, funnel conversion, cohort analysis.

Screening (2)

1. 1

   Tell me about yourself

   Easy

   Scenario — Tell Me About Yourself

   Tip. Structure: present (current role), past (key background), future (why this role). Max 2 min.

2. 2

   Walk me through your resume

   Easy

   Scenario — Walk Me Through Your Resume

   Tip. Chronological, focus on transitions and progression. Explain career choices.

Negotiations (2)

1. 1

   What are your salary expectations?

   Medium

   Scenario — Salary Negotiation (New Job)

   Tip. Give a market-based range. Justify with your added value.

2. 2

   Which elements of the package are most important to you?

   Easy

   Scenario — Compensation Package Discussion

   Tip. Be honest but flexible. Show you understand total compensation.

Cultural Fit (2)

1. 1

   How do you assess our organization's data maturity?

   Medium

   Scenario — Company Knowledge

   Tip. Research their stack, data culture and suggest improvement areas.

2. 2

   How would you structure the analytics function in our company?

   Hard

   Scenario — Company Knowledge

   Tip. Discuss centralization vs decentralization, tools, governance, skills.

Career Dev (2)

1. 1

   What career path led you to becoming a Senior Data Analyst?

   Easy

   Scenario — Motivation & Career Path

   Tip. Highlight your progression, key projects and growing business expertise.

2. 2

   What do you think distinguishes a Senior Data Analyst from a Junior?

   Easy

   Scenario — Motivation & Career Path

   Tip. Mention autonomy, business vision, mentoring, and ability to frame problems independently.

Prepare your interview with confidence

With Traject, simulate the interview with AI, get detailed feedback and improve your pitch in days.

Other roles in the same family