Skills needed for a data analyst in 2026, and how to tell which ones you are missing
Most lists of data analyst skills are the same list, and they are not wrong. They are just flat. Everything is presented as equally important, which is the one thing you cannot act on.
This is the same list, sorted by what actually decides whether you get shortlisted, based on what shows up in postings rather than what sounds impressive.
The four that appear in almost every posting
- SQL, and not familiarity. Joins across several tables, window functions, aggregation, and the ability to work out why a number is wrong. If you can only write single table selects, this is the gap that costs you the most interviews, and it is also the fastest one to close.
- Spreadsheets, properly. Pivot tables, lookups, and cleaning a messy export without hand editing cells. Dismissed as basic and asked about constantly.
- A BI tool. Power BI, Tableau or Looker. Which one matters less than being able to build a dashboard somebody else can read without you standing next to it.
- Statistics at a working level. Distributions, sampling, significance, and knowing when a difference is noise. You do not need a degree in it. You do need to not mislead people with a chart.
If all four are solid, you are employable as an analyst. Everything below this line is what separates candidates who are all employable.
The four that appear in maybe half
Python or R, usually pandas rather than modelling. Asked for more in product and tech companies, rarely in finance operations roles.
Data modelling and warehouse concepts. Fact and dimension tables, grain, slowly changing dimensions. This one quietly separates analysts from senior analysts.
Experimentation. A/B test design, sample size, and reading a result honestly. Concentrated in product companies and close to essential there.
A domain. Retail, healthcare, logistics, finance. Nobody lists this as a skill and everybody hires for it, because an analyst who already knows what a good margin looks like is useful in week one rather than month three.
The one that decides the offer, and it is not technical
Communication, which is a vague word for a specific thing: taking a result and telling somebody what to do about it.
Most analyst interviews end with a version of "here is a chart, what would you tell the business?" Candidates who answer with what the chart shows do worse than candidates who answer with what should change and what it is worth.
This is the most common reason a technically strong candidate does not get the offer, and almost nobody practises it because it is uncomfortable to practise.
How to tell which ones you are actually missing
Do not self assess against the list. Everybody rates themselves as intermediate at SQL.
Do this instead. Take five live job postings for the exact title you want, in the market you want. Put every requirement into one of three columns.
Have it, and it is on my resume. Have it, and it is not on my resume. Do not have it.
Then count how many of the five postings each missing skill appears in. A skill missing from your profile that appears in five out of five is your first priority. One that appears once is noise, however senior it sounds.
The full method is in what is a skill gap analysis, and how to run one on yourself.
What to learn first, if you are starting from nothing
SQL until you can answer a question that needs three tables and a window function. Then a BI tool, because it makes your work visible. Then statistics to the point where you can explain why a difference might be nothing.
Build one project that uses all three on data you actually care about, and write up what you found and what you would do about it. One real project beats six certificates, because it gives you something to say in the interview question above.
Doing this against your own resume
SkillDrift does the same three column comparison automatically. Upload a resume free, no account, and it names the specific skills between you and data analyst, scores real jobs and internships out of 100 against what you have, and rescores them as you close gaps.
Start at the free ATS resume checker.