# Prepare for a data analyst or data scientist technical interview

A targeted prep plan and practice set covering SQL, statistics, case questions, and take-home tips for a specific data role.

- Topic: Career & Job Search
- Framework: Few-Shot
- Level: Standard
- Tags: Data & Analytics, Analyze, Fill-in Template, Interactive
- Source: https://www.thinkwithprompt.com/prompts/prepare-for-a-data-analyst-or-data-scientist-technical-interview

## Prompt

```text
Help me prepare for a technical interview for a data role.

**Role and level:** [e.g. "senior data analyst", "data scientist, product analytics", "BI developer"]
**Company and industry:** [NAME, and what they do]
**Job description:** [PASTE]
**Interview stages I know of:** [e.g. SQL live coding, stats, product case, take-home, ML system design, behavioral]
**My background and weak spots:** [e.g. "strong SQL, rusty on probability"]
**Time until interview:** [e.g. "10 days, 1 hour a day"]

Give me:
1. **What they are likely to test**, based on the job description and stages, ranked by likelihood.
2. **A day-by-day prep plan** that fits my time, weighted toward my weak spots.
3. **Practice questions** with model answers:
   - 5 SQL problems at the right level (window functions, self-joins, cohorts, deduplication, date logic), with solutions and common mistakes.
   - 5 statistics or experimentation questions (e.g. p-values, power, a confusing A/B result).
   - 2 product or business case questions with a structured answer approach (clarify, define metrics, hypothesize, size, recommend).
   - For data science roles: 3 modeling questions (bias-variance, choosing metrics, leakage).
4. **Take-home tips:** how to scope, document assumptions, and present results.
5. **Behavioral stories** to prepare, using situations data people typically face (influencing without authority, a wrong number shipped, ambiguous requests).

Then offer to run a mock interview with me, one question at a time, and give feedback on each answer.
```

## What to fill in

- NAME, and what they do
- PASTE
- e.g. "strong SQL, rusty on probability"
- e.g. "10 days, 1 hour a day"

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.