Resume Skills
Skills to Put on a Resume for a Data Analyst
A data analyst resume lives or dies on specificity: “analyzed data” says nothing, but “wrote SQL to find why a metric moved 12% in a quarter” says everything. Below are the skills recruiters actually screen for on real data-analyst roles — and, more usefully, exactly how to prove each one when you don't have a job history to point to yet.
The skills real Data Analyst postings screen for
Pulled from our Data Analyst role taxonomy — not a generic list. Each one names what a recruiter reads into it and, more usefully, how to actually back it up.
Technical (hard) skills
Hard skills across roles →Microsoft Excel
Recruiters read “Excel” as shorthand for whether you can wrangle real data without hand-holding — pivot tables, VLOOKUP/XLOOKUP, formulas that aren't just typed-in numbers.
Evidence, not just a bullet: Don't just list it — point to a workbook (even a redacted one) that shows a pivot table or a formula-driven model you built, not just data you copy-pasted.
SQL
TechnicalSQL is one of the most-requested technical skills on data and analyst job posts — it signals you can pull your own numbers instead of waiting on someone else.
Evidence, not just a bullet: Show 2-3 real queries you've written — a join, a GROUP BY with aggregation, ideally a subquery or window function — not just “SELECT * FROM table”.
Python or JavaScript
Listing a language only matters if you can point to something it built — recruiters skim past “Python” unless there's a repo or project attached.
Evidence, not just a bullet: Link a GitHub repo with a script that solves a real problem — data cleaning, an API integration, a small app — with a README that explains what it does.
Statistical Analysis
This tells a hiring manager you can go beyond “what happened” to “why, and how confident are we” — the line between reporting and analysis.
Evidence, not just a bullet: Reference a specific test you've run (t-test, chi-square, regression) on a real or practice dataset, and the decision it informed.
A/B Testing
MethodologyA/B testing is proof you think in experiments, not opinions — you can design a test, pick a metric, and read a result without over-claiming significance.
Evidence, not just a bullet: Describe one test end to end: the hypothesis, the metric that moved (or didn't), and what you'd do next.
Data Modeling
MethodologyShows you can turn messy inputs into a schema that holds up — the unglamorous skill that keeps a whole analytics stack from breaking.
Evidence, not just a bullet: Point to an ER diagram or schema you designed, and name the tradeoff you made (normalization vs. query speed, for instance).
dbt Models
dbt signals modern-stack fluency — transformation-as-code, testing, and version control for data pipelines, not just ad hoc SQL.
Evidence, not just a bullet: Reference a dbt model you wrote, including a test you added (unique, not_null, or a custom assertion).
Agile / Scrum Ceremonies
This is shorthand for “I've worked inside a real delivery cadence” — sprint planning, standups, retros — not that you've read the Scrum Guide.
Evidence, not just a bullet: Name the ceremony you ran or contributed to most (retro facilitation, backlog grooming) rather than just writing “Agile/Scrum”.
Soft skills
Soft skills across roles →Data Visualization
Soft skillThe skill that turns analysis into something a non-technical stakeholder actually acts on — chart choice, not just chart-making.
Evidence, not just a bullet: Link a dashboard or a single chart you built and explain the decision it drove, not just the tool (Tableau, Power BI, matplotlib) you used.
Resume-ready
How to put these on your Data Analyst resume
Don't list them as a word cloud — group them, and back the important ones with proof. A starting point you can copy and adapt:
// Skills
Technical: Microsoft Excel · SQL · Python or JavaScript · Statistical Analysis · A/B Testing · Data Modeling
Soft: Data Visualization
Then turn a claim into proof in your experience bullets:
✗ Weak
“Microsoft Excel — strong.”
✓ Strong
“Microsoft Excel: completed Bookkeeping Reset for a Lisbon Specialty Coffee Roaster — verifiable Ewance credential.”
For the full method — how many to list, hard vs soft balance, and making each one believable — see the skills to put on a resume guide.
No experience yet? Here's what to do instead.
If you're writing a data analyst resume with no professional experience — or what recruiters in India often call a fresher resume — the fix isn't padding the skills section with tools you've clicked through once. It's attaching evidence to a smaller number of real skills: one SQL query you're proud of, one chart that changed a decision (even a practice one), one dataset you cleaned end to end. A short resume with three backed-up skills beats a long one with fifteen unproven ones.
Start building evidence
See all 6 Data Analyst challengesEvery challenge below is an AI-generated practice brief — not a real client engagement — that produces a submission you can point to as evidence for the skills above.
- CodeBeginnerNew
Big Data Dashboard for Urban Mobility Patterns
Using the provided sample dataset (100K anonymized trip records with timestamps, origin/destination coordinates, transport mode, and duration), build a dashboard prototype. Requ…
- Data Analytics
- Digital Business Models
- Web Development
Open coursework - CodeSeniorNew
Real-Time Sentiment Analysis for a Sustainable Fashion Brand
You are to develop a real-time sentiment analysis system for EcoWear. Ingest data from Twitter API (hashtag #EcoWear) and a mock review API, process using Spark Streaming with M…
- Spark Streaming
- Mapreduce
- Nosql
Big Data and Cloud Technologies - AnalysisBeginnerNew
Sales Performance Analysis for a 40-Person SaaS Scale-Up
You will receive a dataset containing 500+ sales opportunities with fields like deal value, stage, source, close date, and account size. Your challenge is to design a data mart …
- Data Warehousing
- Etl
- Olap
Open coursework - DesignBeginnerNew
Optimizing Inventory for a São Paulo D2C Cosmetics Brand
You are given a CSV file with raw sales, inventory, and supplier data. Your task is to design an E/R diagram, create the normalized relational schema in 3NF, populate it with sa…
- SQL
- Database Design
- Normalization
Open coursework - CodeFoundationalNew
Optimizing Inventory for a Barcelona D2C Cosmetics Brand
You are given a CSV file with 6 months of daily sales data for 20 SKUs, including product name, date, units sold, and current stock level. Your task is to write a Python program…
- Python
- Data Cleaning
- Data Analysis
Open coursework - AnalysisFoundationalNew
Sentiment Analysis for Tel Aviv D2C Cosmetics Brand
You are provided with a dataset of 10,000 customer reviews (in English) with no labels. Your task is to preprocess the text, develop a sentiment classification model using NLP t…
- Text Preprocessing
- Sentiment Analysis
- Classification
Open coursework
Frequently asked questions
What skills should I put on a data analyst resume?
Lead with SQL and Excel — the two most consistently required data-analyst skills — then add whichever of statistical analysis, data visualization, data modeling, or A/B testing you can actually back with an example. A short list you can defend beats a long list you can’t.
How do I write a data analyst resume for freshers?
Replace job history with project evidence: a class project, a Kaggle dataset you cleaned, or a practice challenge you completed. For each one, name the specific tool and the specific output — a query, a chart, a model — not just the course title.
What if I have zero experience as a data analyst?
Build one small, real analysis end to end — pick a public dataset, ask a real question, write the SQL or Python to answer it, and visualize the result. One finished, explainable project outweighs a long list of unproven tools.
Which data analyst skill do recruiters check first?
SQL. It's the most consistently required technical skill across data-analyst postings, and it's the fastest one to verify — a recruiter or hiring manager can ask you to explain a query in thirty seconds. If you only have time to prove one skill on this list, prove SQL.
Explore more resume-skills guides
- Decision Analyst resume skills
- Econometrician resume skills
- IoT Data Scientist resume skills
- Machine Learning Engineer resume skills
- Operations Research Analyst resume skills
- Process Analyst resume skills
- Skills to put on a resume (full guide) →
- Employability skills →
- All resume-skills roles →
- Browse every career hub →
Hiring from this pool?
Sponsor a challenge and meet candidates through actual work.
Industry teams can shape briefs around the skills they hire for, then evaluate students on rubric-scored deliverables — not resumes.
Portrait: photo by Lanh Bondol on Unsplash.