How to Write a Data Analyst Resume That Shows Real Impact
How to write a Data Analyst resume, for experienced analysts and career switchers: impact bullets, a clear skills section and where to put your portfolio.
Many Data Analyst resumes look the same: a long skills list of SQL, Python, Excel, Power BI, Tableau and Statistics, and work experience that says built dashboards and analysed data. Recruiters reading dozens a day cannot tell who is truly good. What sets you apart is showing that your analysis helped someone decide something, and what happened next.
What a Data Analyst resume must answer
Teams hiring analysts want to know three things. Can you really pull and manage data? Can you ask the right business question? Can you communicate results so non-data people understand and act on them? The third is what most resumes miss.
Recommended structure
- Contact details, with a portfolio or GitHub link.
- A 2 to 3 line summary: what kind of data you analyse, in which industry, and your main tools.
- Work experience: 3 to 5 bullets per role.
- Projects: essential for career switchers and new graduates.
- Skills, clearly grouped.
- Education and certifications.
Write bullets that show impact
Formula: business question, method, result
Before: Built a sales dashboard in Power BI.
After: Built a branch-level sales dashboard in Power BI to replace a weekly Excel report. Regional sales teams used it to spot underperforming branches within a day, cutting the team's reporting time from half a day to minutes.
Before: Analysed customer data.
After: Used SQL to segment customers by purchase frequency and value, finding that customers who repurchased within 30 days made up a larger share of revenue than the team expected. This led to a campaign designed to bring new customers back for a second purchase.
Every number must come from your real work. If data is confidential, use proportions or describe the outcome instead, such as cut time by more than half.
Useful verbs
Designed, extracted, cleaned, modelled, tested, recommended, presented, automated. Use action words instead of responsible for or handled.
Make the skills section easy to read
- Data: SQL (JOINs, window functions), Excel (Pivot Tables, Power Query)
- Visualization: Power BI (DAX), Looker Studio
- Programming: Python (pandas) for analysis
- Business: sales analysis, customer segmentation, basic A/B testing
Include only what you are ready to be tested on. Many companies run an SQL test or case study before the interview.
A dashboard is not the achievement. The decision made because of it is.
If you are switching from another field
People in accounting, marketing or operations often use data already. Pull those tasks out, such as building monthly cost reports in Excel or tracking ad campaign results, and add 2 to 3 personal projects using public data. Write each with a question, method and conclusion, not just pretty charts. Domain knowledge from your old job is a strength, because you understand context that new analysts do not have yet.
Where to put your portfolio
Put the link in your contact section and refer to it in the projects section. Make each portfolio piece readable in 2 minutes: a dashboard image, a summary of the question, and what you found. Never include confidential data from a previous employer.
Common mistakes
- Listing 15 tools when you really use 4.
- Describing only technical steps without saying whom the result helped.
- Using bar graphics for skill levels, which systems cannot read and readers cannot interpret.
How to start
- List the 5 pieces of analysis you are proudest of.
- For each, answer who it helped decide what.
- Rewrite your bullets with the formula: question, method, result.
- Group your skills and remove anything you are not ready to be tested on.
- Compare with the JD you are applying for and reorder bullets to match.
Prepare further with Data Analyst interview prep and writing achievements with the XYZ formula. Check your resume in Resume Lab, then browse data roles in job search.