Data Analyst Resume: Skills, Projects and Example Bullets
How to write a data analyst resume that gets interviews: the skills to list, how to show impact with numbers, project ideas for freshers, and example bullets.
A data analyst's job is to turn data into decisions. Your resume should show exactly that: not just the tools you know, but the questions you answered and what changed because of it.
What hiring managers look for
Most analyst job descriptions ask for the same core:
- SQL: nearly always required. Joins, aggregations, window functions.
- A spreadsheet tool: Excel or Google Sheets, with pivot tables, lookups and charts.
- A BI tool: Power BI, Tableau or Looker.
- Python or R: often preferred, sometimes required, mainly pandas for cleaning and analysis.
- Statistics basics: averages and distributions, A/B tests, correlation versus causation.
- Communication: explaining a finding to someone who doesn't read SQL.
Your resume needs to show each of these in a bullet, not just list them.
The layout
- Header with a link to your portfolio or GitHub.
- A two-line summary: years of experience (or your degree), your main tools, and the kind of problems you work on.
- Skills, grouped (near the top for analysts).
- Experience, or projects if you're a fresher.
- Education and certifications.
Skills section example
Querying and analysis: SQL (PostgreSQL, BigQuery), Python (pandas, NumPy), Excel (Power Query, pivot tables, XLOOKUP)
Visualisation: Power BI (DAX), Tableau, Looker Studio
Methods: A/B testing, cohort and funnel analysis, forecasting, data cleaning
Other: Git, Jira, dbt (basic)
List the database or warehouse you used (PostgreSQL, MySQL, BigQuery, Snowflake): it's a detail recruiters search for.
Bullets that show impact
The pattern: what you analysed, with what, and what happened as a result.
- Built a Power BI sales dashboard used by 40 regional managers, replacing six weekly Excel reports.
- Found through cohort analysis that customers who used the app in week one were twice as likely to renew; the finding shaped the new onboarding flow.
- Wrote SQL to reconcile payment and order data across two systems, finding ₹12 lakh in unbilled orders.
- Cut the monthly KPI report from two days to two hours by automating data pulls with Python.
- Designed and analysed an A/B test of the checkout page that lifted conversion by 4%.
These are examples. Use your own numbers and only claim results you can explain in an interview. If you don't know the exact impact, describe who used your work and what decision it supported.
No experience? Projects are your experience
Freshers and career changers can get interviews with two or three strong projects. A strong project:
- Uses a real, messy public dataset, not a perfectly clean tutorial file.
- Asks a business question: "Which product categories lose money after returns?" rather than "Exploratory analysis of sales data".
- Shows the full chain: cleaning in SQL or Python, analysis, a dashboard, and two or three findings written in plain English.
- Is published: a GitHub repository with a short README, or a public Tableau or Power BI link.
On the resume, write a project like a job:
E-commerce returns analysis (SQL, Python, Power BI)
- Cleaned and joined 100,000 orders and returns from a public dataset, handling missing and duplicate records.
- Found that two categories caused over half of all returns, and built a dashboard to track return rates by category and region.
Certifications
Google Data Analytics, Microsoft PL-300 (Power BI) and similar certificates can help freshers get past a first screen. List them in their own short section. They don't replace projects: a recruiter will still want to see what you built.
Common mistakes
- A skills list with no proof. Every main tool should appear in at least one bullet.
- Describing tasks, not answers. "Created reports" says little. "Created a weekly churn report that the retention team used to target 500 at-risk customers" says a lot.
- Too many tools. Ten BI tools listed at a beginner level reads as padding. Go deep on one.
- Dashboard screenshots in the resume. An ATS can't read them. Link to them instead.
Before you apply
Check your resume against each job's tool list: some teams use Tableau, some Power BI, some only SQL and Sheets. Reorder your skills to match. Our guide on tailoring a resume to a job description shows how, and the free ATS check shows how screening software reads your resume.