How to write a data analyst resume summary
Write two or three sentences on your domain and tools, with one result or the scope of what you own.
- Data analyst (entry level)
- Data analyst with 14 months of SQL reporting for a regional retailer. Builds Power BI reports used weekly by 30 buyers and checks the numbers behind them.
- Product data analyst (mid level)
- Product data analyst with five years in subscription software. Designs and reads out A/B tests in SQL and dbt; a checkout test lifted trial-to-paid conversion by 8%.
- Lead data analyst (senior)
- Lead data analyst with 10 years across retail and logistics, leading four analysts. Delivered the routing analysis behind a saving of about $2.1M a year.
| Instead of | Write |
|---|---|
| Detail-oriented data analyst passionate about turning data into actionable insights, with strong analytical and communication skills. | Product data analyst with five years in subscription software. Owns activation metrics in SQL and Looker; a checkout test lifted trial-to-paid conversion by 8%. |
Use a result you can explain end to end in an interview, from the query to the decision someone made with it.
Summary or objective?
Use a summary once you have done analysis in a job, even a first one. It gives your tools and domain, which is what a screener checks first.
An objective only helps when you are changing field or graduating. Keep it to one sentence that names the analyst job you want and your strongest project: "Economics graduate seeking a marketing analyst role; built a SQL and Tableau churn analysis on 50,000 public records."
Resume headline examples
Put the kind of analyst and your main tools under your name.
- Data Analyst | SQL, Power BI, Python (Entry)
- Senior Data Analyst, Product | A/B testing, dbt, Looker (Product)
- Marketing Data Analyst | Attribution, SQL, Tableau (Marketing)
- Lead Data Analyst | Metric governance, team of four (Lead)
Experience bullets that show results
Each bullet should end with the decision or result that followed your work. The tool can sit in the middle.
| Instead of | Write |
|---|---|
| Created dashboards in Power BI. | Built a Power BI sell-through dashboard for 30 buyers, replacing six weekly spreadsheets. |
| Ran A/B tests. | Designed and read out 31 A/B tests, setting sample sizes and guardrail metrics before launch. |
| Cleaned data. | Found a duplicate-SKU join that overstated returns by 4% and fixed the source model with the data engineer. |
| Automated reports. | Automated the Monday stock report in Python, cutting preparation from three hours to 20 minutes. |
| Analysed sales data. | Analysed markdown timing for 800 seasonal items; the recommendation was adopted for the spring range. |
| Did pricing analysis. | Designed and analysed 14 pricing tests in a year; two shipped and raised trial-to-paid conversion by 3 points. |
| Fixed conflicting numbers. | Built a validated customer table that replaced five conflicting sources and ended weekly disputes over numbers. |
Missing a number? Write a bracket now, such as "cut the run from [X] to [Y] minutes", and check the figure in your team's dashboards or tickets before you send. A bracket you can't fill means the bullet needs rewriting.
Bullet ideas by area
Bullets for the work most often hired for. Swap in your figures where the brackets are and keep only the work you have done.
SQL and data quality
- Wrote SQL against [warehouse] to answer [X] questions a month from [team]
- Found [error] overstating [metric] by [X]% and fixed it at the source
- Added [X] data tests that caught [problem] before it reached reports
Dashboards and reporting
- Built a [Power BI / Tableau / Looker] dashboard for [X] users, replacing [old process]
- Retired [X] unused reports and moved [Y] to governed datasets
- Automated [report] in [tool], cutting [X] hours a week
Analysis and experiments
- Designed and read out [X] A/B tests on [product area]
- Showed that [change] moved [metric] by [X]%, which led the team to [decision]
- Sized [decision] using [data]; the forecast landed within [X]% of actuals
Working with the business
- Ran a weekly metrics review with [team], replacing [X] ad hoc requests
- Trained [X] colleagues to answer their own questions in [tool]
Skills and keywords for a data analyst resume
Sort skills into a few groups, and list only what you could use in an interview exercise.
Query and code
SQL, Python (pandas), R, dbt
Warehouses
Snowflake, BigQuery, Redshift, SQL Server
Reporting
Power BI, Tableau, Looker, Excel
Analysis
A/B testing, Cohort analysis, Regression, Forecasting, Metric definitions
Working with others
Writing findings for non-technical readers, Scoping vague requests, Data documentation
Matching the data analyst job description
Ads name tools: SQL, Excel, Python, R, Tableau or Power BI. Put the ones you really use in your headline and first bullets.
If the ad names a domain, such as marketing, product or finance, lead with analysis in that area.
Use the ad's words for the work, such as "experimentation" or "forecasting", where you've done it.
Certifications and how to list them
Most data analyst jobs ask for no certificate, and there's no licence. Your SQL and work samples carry more weight. A tool certificate helps most early on, or when the ad names that tool.
| Credential | Earned | In progress |
|---|---|---|
| Microsoft Certified: Power BI Data Analyst AssociateMicrosoft | Microsoft Certified: Power BI Data Analyst Associate, Microsoft, [year] | Exam PL-300 scheduled for [month year] |
- Microsoft Certified: Power BI Data Analyst Associate: Earned by passing exam PL-300. It expires unless renewed every 12 months through a free online assessment, so keep yours current before listing it. Microsoft Learn, Power BI Data Analyst Associate
Master's, MBA or certificate: what helps a data analyst
According to the U.S. Bureau of Labor Statistics, data scientists typically need at least a bachelor's degree, and some jobs require a master's or doctoral degree. Common fields include mathematics, statistics, computer science, business and engineering. Many analyst ads ask for a bachelor's and strong SQL.
A master's in business analytics, statistics or data science helps if you want to move into data science, modelling or a senior analytics role. Many analysts study part-time while working, often with employer support.
An MBA fits a move toward analytics management, strategy or a business role where you make the decisions yourself. Some organisations prefer a graduate degree, including business administration, for computer and information systems managers.
A degree in progress goes under Education as "MS Business Analytics, [School], expected [year]". Short courses and tool certificates belong under Training, with the provider and year.
Data Analyst resume with no experience
Show two or three analyses that start with a question and end with a conclusion someone could act on. Analysis from other jobs counts, such as sales reports or stock counts.
- Use public data and write up one decision your analysis would support.
- Show the SQL or notebook, tidied, with a readme.
- Give one chart that makes the point on its own.
- List coursework in statistics, databases or economics.
- Include analysis from other jobs, such as sales reports or stock counts.
Moving up: analyst, senior, lead
Data analyst. Accuracy comes first, so open with reports people rely on and one decision your work informed.
Senior analyst. Your work should be shaping plans. Give an analysis that changed one and an experiment you designed.
Lead analyst. Put the metric standards you set and the analysts you guide first, then the business results tied to your team's work.
Data analyst resume format and length
Use reverse-chronological order, one page for most analysts, and consider two only past 10 years if the second page earns its place.
Keep it easy to parse: a simple layout, standard headings and your tools written as plain text. A skills sidebar is fine if the file still reads in order when copied as plain text.
Questions
What should a data analyst put on a resume?
Your tools, the data you work with and the decisions your analysis informed. Lead with SQL and the main reporting tool, then give bullets that name a question, your method and what changed. Add a link to a work sample if you can share one, and keep the skills section short and honest.
How do I write results when I don't know the business impact?
Describe the decision your work fed and who used it: "weekly churn report used by the retention team to choose which customers to call". Then add what you can measure: time saved, errors removed or reports replaced. Ask your manager what happened next, since the answer often makes a better bullet than the one you have.
Should I list Python if I only use it a little?
Yes, but be honest about the level. Put it after SQL and your main tool, and give one bullet showing a real use, such as automating a report. Interviewers may test anything you list, so make sure you can write a short script and explain a library or two.
Do I need a portfolio?
It helps most when you're new or changing fields. Two or three analyses with a clear question, tidy code and a conclusion are enough. Use public data, never an employer's. For experienced analysts, a portfolio matters less, because bullets showing decisions and results do the same job.
Data analyst or business analyst: which am I?
If you spend most of your time querying data, building reports and testing ideas with numbers, you're a data analyst. If you mostly gather requirements, map processes and work with IT on systems, you're a business analyst. Many jobs mix both, so read the ad and lead with the half it stresses.
What is the best certification for a data analyst?
The one for the tool the ads name. Microsoft's PL-300 covers Power BI, and Tableau has its own certifications. Course certificates, such as an online data analytics programme, belong under Training and help most when you're switching fields. None replaces a work sample with clean SQL and a clear conclusion.
Is a master's or MBA worth it for a data analyst?
For analyst jobs, skills and results count most. A master's in analytics, statistics or data science pays off if you're aiming at data science or modelling, where some jobs require one. An MBA suits a move into analytics management or strategy. A degree in progress can go on the resume with its expected year.
How do I show I'm ready for senior or lead?
Show work that reached beyond your own reports, such as a metric definition other teams adopted or an analysis that changed a plan. Tie it to a business number. Cut routine reporting bullets to make room, and add analysts you've trained.