# Data Scientist Roadmap 2026: A Seven-Month Path from SQL to Offer

> A stage-gated data scientist roadmap for 2026: SQL, statistics, modelling and communication, weighted as interviews test them, with projects and free resources.

- **Author:** Vanshika Nigam — ETL & Data Engineer, Accenture (https://www.1stepgrow.com/authors/vanshika-nigam/)
- **Published:** Aug 1, 2026 · **Updated:** Sep 17, 2026
- **Topic:** Data Science · **Format:** Roadmap · **Read time:** 7 min
- **Canonical URL:** https://www.1stepgrow.com/articles/data-scientist-roadmap-2026/

## Key takeaways

- SQL is tested in almost every data science interview and is one of the most common reasons capable candidates fail early rounds.
- Statistics matters more than modelling. Most real work is experiment design and inference, not tuning gradient boosters.
- A portfolio of analyses that changed a decision beats a portfolio of Kaggle notebooks.
- Communication is a graded interview competency, not a soft skill footnote.

This data scientist roadmap takes you from SQL to a job offer in about seven months at 10–14 hours a week. It follows the order interviews test: can you get the data, can you tell whether a result is real, can you model it responsibly, and can you explain it to someone who will act on it.

Most self-study plans over-weight the third and neglect the first and fourth. That mismatch is why capable people fail interviews they should pass, so this roadmap is weighted the way the interviews are.

It is written for analysts, graduates and career changers who can give it 10–14 hours a week. Each of the six stages ends in an exit test, so you know when to move on. The sections after the roadmap add hours per stage, free official resources, portfolio projects that work and what official pay data actually shows.

- **Total duration:** 7 months
- **Weekly commitment:** 10-14 hours
- **Typical entry salary:** Varies by market — see the pay section

### Stage 1: SQL until it is boring (Weeks 1-5)

The most under-rated stage. SQL appears in nearly every data science interview and is where most candidates are quietly filtered out in round one.

**Skills:** Joins & set operations, Window functions, CTEs & subqueries, Aggregation logic, Query performance basics

**Projects:**
- Fifty medium and hard SQL problems solved without hints
- One analysis answered entirely in SQL, no pandas

**Outcome:** You can write a window-function query under observation without freezing.

### Stage 2: Statistics that survives scrutiny (Weeks 6-12)

Inference, not just descriptive summaries. The ability to say whether a result is real, and how confident you are, is the core of the job.

**Skills:** Distributions & sampling, Hypothesis testing, Confidence intervals, A/B test design, Power analysis, Common statistical traps

**Projects:**
- Design and analyse a simulated A/B test, including power calculation and a written recommendation

**Outcome:** You can explain why a result is or is not significant to someone who wants it to be significant.

### Stage 3: Python for analysis (Weeks 13-17)

Pandas, visualisation and reproducible analysis. Focus on clarity and correctness rather than clever one-liners.

**Skills:** pandas, NumPy, matplotlib/seaborn, Notebook hygiene, Reproducible pipelines

**Projects:**
- An end-to-end exploratory analysis of a messy public dataset, with data quality issues documented

**Outcome:** You can take a raw, dirty dataset to a defensible conclusion and someone else can rerun your work.

### Stage 4: Modelling with judgement (Weeks 18-24)

Regression, classification, trees and the evaluation discipline around them. The hard part is choosing the metric and knowing when a model is the wrong answer.

**Skills:** Linear & logistic regression, Tree ensembles, Cross-validation, Metric selection, Feature engineering, Leakage detection

**Projects:**
- A predictive model with honest validation, an error analysis section, and a stated business threshold

**Outcome:** You can justify your metric choice and identify leakage before a reviewer does.

### Stage 5: Communication as a graded skill (Weeks 25-28)

The stage that separates offers from rejections at the final round. Written memos, verbal explanation and stakeholder pushback.

**Skills:** Analytical writing, Data visualisation for decisions, Executive summaries, Handling disagreement

**Projects:**
- A one-page decision memo from your stage-four project, written for a non-technical reader
- A ten-minute recorded walkthrough of an analysis

**Outcome:** A non-technical person can read your memo and know what to do differently.

### Stage 6: Interview and apply (Weeks 29-32)

Case studies, SQL under time pressure, product sense and the behavioural round. All practised deliberately, not improvised.

**Skills:** Case interview practice, Product sense questions, Timed SQL, Behavioural stories

**Projects:**
- Eight mock interviews covering SQL, stats, case and behavioural

**Outcome:** You can hold a case interview conversation without needing the answer to be right immediately.

## How long does each stage of the data scientist roadmap take?

The whole plan runs 32 weeks, which at 10–14 hours a week is roughly 320–450 hours. The hours below are simply weeks multiplied by that range.

| Stage | Weeks | Approximate hours | You are ready to move on when… |
|---|---|---|---|
| 1. SQL | 1–5 | 50–70 | You write window-function queries under observation |
| 2. Statistics | 6–12 | 70–98 | You can design an A/B test, including sample size |
| 3. Python for analysis | 13–17 | 50–70 | Someone else can rerun your analysis end to end |
| 4. Modelling | 18–24 | 70–98 | You can justify your metric and spot leakage |
| 5. Communication | 25–28 | 40–56 | A non-technical reader acts on your memo |
| 6. Interviewing | 29–32 | 40–56 | Eight mock interviews done, weak rounds fixed |

If you already work as an analyst, stages one and three may take half the time. However, do not skip the exit tests, because they are what the interview will check.

## Why does the SQL round stop so many candidates?

If you take one thing from this page, take this: a common point of failure in data science hiring is a live SQL round early in the process.

Not because the questions are exotic. Rather, candidates practised modelling for six months and SQL for six days, then had to write a window function while a stranger watched.

SQL is also simply everywhere. In the [Stack Overflow Developer Survey 2025](https://survey.stackoverflow.co/2025/technology), 58.6% of all respondents said they had done extensive work in SQL over the past year, slightly more than Python at 57.9%.

Five weeks at the start of this roadmap looks disproportionate. It is not. In fact, it is the stage with the highest return per hour in the entire path.


## Which free, official resources cover each stage?

You do not need a paid course for any single stage, although you do need a deadline and feedback. As of September 2026, these primary resources cover the ground:

- **SQL:** the PostgreSQL manual's [tutorial on window functions](https://www.postgresql.org/docs/current/tutorial-window.html), which is short, precise and exactly what the interview round tests.
- **Statistics for data science:** [OpenIntro Statistics](https://www.openintro.org/book/os/), a free PDF textbook covering inference, categorical data and regression.
- **A/B testing and power:** the power and sample-size tools in [statsmodels](https://www.statsmodels.org/stable/stats.html), such as `TTestIndPower`, so that your test design includes a sample-size calculation rather than a guess.
- **Python for analysis:** the pandas [10 minutes to pandas](https://pandas.pydata.org/docs/user_guide/10min.html) guide, then the rest of the user guide as you need it.
- **Modelling:** scikit-learn's [common pitfalls page](https://scikit-learn.org/stable/common_pitfalls.html). It defines data leakage and recommends splitting data before any preprocessing and using pipelines.

For deeper SQL practice with the reasoning written out, work through these [SQL interview questions and answers](https://www.1stepgrow.com/articles/sql-interview-questions-answers).

## What should a data science portfolio contain?

Two or three analyses that each end in a recommendation, rather than a folder of modelling notebooks. The portfolio advice for data science is different from software engineering, and people get it wrong by copying the wrong template.

A software portfolio shows you can build. A data science portfolio needs to show you can *decide*. That means the artefact is not really the notebook — it is the memo at the end that says: here is what I found, here is my confidence in it, here is what I would do, and here is what would change my mind.

Two well-scoped analyses with clear recommendations will out-perform ten polished modelling notebooks in almost every hiring conversation. Some ideas that work well:

1. **An experiment readout.** Simulate or find an A/B test dataset, compute the power the test needed, then write a recommendation that includes what you would *not* conclude.
2. **A messy public dataset, cleaned honestly.** For example, local government or transport data, with every data quality problem logged and its effect on the conclusion stated.
3. **A churn or demand model with a business threshold.** Choose the metric from the cost of errors, show the leakage checks you ran, and include an error analysis.
4. **A decision memo.** One page, written for a manager, based on one of the projects above.

## How do data science interviews actually screen?

Most processes test the same competencies in a fairly stable order, even though the formats vary by company:

- **Screening call and CV review.** They look for evidence of analyses, not tool lists.
- **SQL round.** Usually live or timed, with joins, aggregation and window functions.
- **Statistics and experimentation.** Hypothesis tests, confidence intervals, A/B test design and common traps such as peeking.
- **Case or product sense.** "Sign-ups fell 10% last week — what do you check first?"
- **Modelling discussion.** Metric choice, validation and leakage, often built around your own project.
- **Behavioural round.** Disagreement, ambiguity and influence without authority.

The round-by-round breakdown in [data science interview rounds](https://www.1stepgrow.com/articles/data-science-interview-rounds) goes further on each format.

## What does a data scientist earn?

The cleanest official figures are American. The [US Bureau of Labor Statistics](https://www.bls.gov/ooh/math/data-scientists.htm) reports a median annual wage of $120,230 for data scientists in May 2025, with 275,600 jobs in 2025, employment projected to grow 35% from 2025 to 2035, and about 24,800 openings a year.

| Source | Population | Median annual pay |
|---|---|---|
| US BLS, May 2025 | US data scientists | $120,230 |
| [Stack Overflow Developer Survey 2025](https://survey.stackoverflow.co/2025/work) | Data scientists, global, self-reported | $82,910 |
| Stack Overflow Developer Survey 2025 | Data scientists, US, self-reported | $145,000 |
| Stack Overflow Developer Survey 2025 | Data scientists, India, self-reported | $11,624 |

Read the survey rows as a rough guide only, because respondents choose themselves and the India sample is small. No official Indian source publishes data scientist salary bands, which is why the roadmap card does not quote one. For more on what the official figures do and do not show, see [data science salary by role](https://www.1stepgrow.com/articles/data-science-salary-by-role).

## Which mistakes stall a data scientist roadmap?

Most people who stall on this path make one of a handful of avoidable errors:

- **Starting with deep learning.** It feels like progress, yet it is rarely what an entry-level interview tests.
- **Treating statistics as a formula sheet.** Interviewers ask *why* a test applies, not only how to run it.
- **Leaking the target.** Scaling or imputing on the full dataset before splitting inflates every score, which a reviewer will catch.
- **Portfolios with no conclusion.** A notebook that ends in a confusion matrix, rather than a recommendation, shows method but not judgement.
- **Applying before the SQL stage is solid.** An early SQL failure can close a company's door for months.



## Related reading

Still choosing a track? Start with [Data Science vs Machine Learning vs AI](https://www.1stepgrow.com/articles/data-science-vs-machine-learning-vs-ai), or the narrower [Data Analyst vs Data Scientist](https://www.1stepgrow.com/articles/data-analyst-vs-data-scientist) comparison. For course options, see the [best data science courses in India](https://www.1stepgrow.com/articles/best-data-science-courses-india), and before paying for a structured programme, read [is a data science bootcamp worth it](https://www.1stepgrow.com/articles/is-a-data-science-bootcamp-worth-it).

## Frequently asked questions

### Do I need a master's degree to become a data scientist?

In research-heavy teams and some large enterprises, it still functions as a filter. In product companies, a portfolio of analyses that changed decisions carries more weight. It helps; it is not a prerequisite outside specific sectors. The US Bureau of Labor Statistics lists a bachelor's degree as the typical entry-level education for the occupation.

### How important is SQL really?

More important than any other single technical skill on this list. It is tested in nearly every hiring process, often first, and it is where a large share of otherwise strong candidates are eliminated. Window functions, joins that change row counts and aggregation logic are the usual stumbling points, so practise them under a timer.

### Are Kaggle competitions good portfolio pieces?

As evidence of modelling skill, yes. As evidence you can do the job, only partly — competitions hand you a clean dataset and a fixed metric, which is the part of real work that does not exist. Pair one with an analysis you scoped yourself, including the question, the data cleaning and a written recommendation.

### Is data science still a growing field?

In the United States, the Bureau of Labor Statistics projects data scientist employment to grow 35% between 2025 and 2035, much faster than average. Within the field, routine reporting is being absorbed by better tooling, while experimentation, causal inference and decision support are where the demanding work sits. Aim your learning at the second group.

---
_Source: 1stepGrow (https://www.1stepgrow.com/articles/data-scientist-roadmap-2026/). Cite with the title, "1stepGrow" and a link._