Data Analyst resume example
A complete example you can copy from. The person and companies are made up; the structure is what works.
Priya Shah
Data Analyst · SQL, Tableau and product analytics
Chicago, IL·priya.shah@email.com·(312) 555-0126·linkedin.com/in/priya-shah
Summary
Data analyst with 5 years of experience turning sales and product data into dashboards and decisions for e-commerce teams. Write SQL daily, build Tableau reports used by 80+ people and run the A/B test analysis behind a checkout change worth $1.1M a year.
Experience
Data Analyst·Northpoint OutfittersMay 2023 – Present
Chicago, IL
- Built the weekly sales and margin dashboard in Tableau, now the main report for 80+ merchandising and finance staff.
- Analyzed a checkout A/B test across 400,000 sessions; the winning version lifted conversion 3.2%, about $1.1M a year.
- Wrote SQL models in Snowflake that replaced 12 manual Excel reports and saved the team around 15 hours a week.
- Found a pricing error in 300 SKUs by comparing margin by category, recovering $60,000 in the first quarter.
Junior Data Analyst·Harbor Lane InsuranceAug 2021 – Apr 2023
Evanston, IL
- Cleaned and merged claims data from three systems in Python (pandas) for the monthly loss report.
- Built an Excel model of renewal rates by region that helped the sales team focus on the two weakest markets.
- Answered 20+ ad hoc data requests a month from underwriting and customer service, usually within a day.
Education
B.S. Economics, minor in Statistics2017 – 2021
University of Illinois Chicago
Skills
SQL · Excel (pivot tables, Power Query) · Tableau · Power BI · Python (pandas) · Snowflake · dbt · Google Analytics 4 · A/B testing · Data cleaning · Dashboard design · Stakeholder reporting
Certifications
Tableau Certified Data Analyst
Languages
English (Native or Bilingual) · Gujarati (Professional Working)
Make yours from your LinkedInFree, no sign-up. Your PDF never leaves your browser.
What a data analyst resume needs to show
Most data analyst postings ask for the same core: SQL, Excel, a BI tool and the ability to explain results to people who don’t read SQL. What separates candidates is not the list of tools but the last step. Did a dashboard get used? Did an analysis change a price, a campaign or a product? A hiring manager has seen hundreds of “created dashboards and reports”; they remember “found a pricing error in 300 SKUs worth $60,000”.
So every bullet should connect the data work (what you queried, cleaned or modelled) to the decision or result it led to. And because these roles get many applicants, the resume has to pass an applicant tracking system first, which means using the exact tool names from the posting.
Resume summary examples
Name the tools, the business area and one result someone acted on.
Experienced: Data analyst with 5 years in e-commerce analytics. Write SQL daily, build Tableau dashboards for 80+ users and ran the A/B test analysis behind a $1.1M checkout change.
Career changer: Former operations coordinator who built the team’s Excel tracking models and taught myself SQL and Power BI. Recently completed the Google Data Analytics certificate and three portfolio projects on public retail data.
Entry-level: Economics graduate with coursework in statistics and regression, an internship cleaning survey data in Python, and a Tableau Public portfolio of four dashboards. Looking for a first analyst role in marketing or product.
See more patterns in our resume summary examples.
Skills to list
Group them, and use the posting’s exact spelling (“Power BI”, “Google Analytics 4”, “Looker Studio”):
Querying and data
- SQL (PostgreSQL, BigQuery, Snowflake)
- Excel (pivot tables, XLOOKUP, Power Query)
- Python with pandas or R
- dbt
Visualization
- Tableau
- Power BI
- Looker
- Looker Studio
Analysis
- A/B testing
- cohort and funnel analysis
- forecasting
- descriptive statistics
- data cleaning
Business
- KPI definition
- stakeholder reporting
- presenting findings
- documentation
If you list Python, be ready for a live exercise in it. It is better to list SQL and Excel honestly than to add a language you used in one course.
Bullet points that show results
Start with an action verb, name the data and tool, finish with what changed:
- Built a weekly sales and margin dashboard in Tableau that became the main report for 80+ staff.
- Analyzed a checkout A/B test across 400,000 sessions; the winning version lifted conversion 3.2%.
- Replaced 12 manual Excel reports with SQL models in Snowflake, saving about 15 hours a week.
- Spotted a pricing error in 300 SKUs by comparing margin by category, recovering $60,000 in one quarter.
- Built a churn cohort analysis that showed most cancellations came in month two, leading to a new onboarding email.
- Cleaned and merged claims data from three systems in pandas, cutting the monthly report from three days to one.
- Defined five shared KPIs with finance and marketing so both teams finally reported the same revenue number.
The “so what” can be money, hours saved, a decision made or a number that became trustworthy. All of them count.
Portfolio projects
If you are new to the field, a portfolio is the fastest way to close the gap. Two or three projects are enough; each one should:
- use real, messy data (a city’s open data portal, a public retail dataset, sports stats) rather than a perfectly clean course file,
- ask a business-style question (“which stores should close?”, “what predicts late deliveries?”),
- show the SQL or notebook, the final chart and a short paragraph on what you’d recommend.
Put a link to Tableau Public, GitHub or a simple portfolio page in your summary. On the resume itself, list each project like a job: name, tools and one or two bullets with the finding.
Tips for a data analyst resume
- Lead with SQL. If the posting mentions it, it should be in your first lines and in at least one bullet.
- Show the audience. “Presented to the VP of sales” or “used by 80 people” proves your work was read, which is half the job.
- Mention the domain. Marketing, finance, healthcare and product analytics each have their own metrics. If you know CAC, LTV, loss ratio or retention curves, say so.
- Keep charts off the resume. A chart inside a resume is unreadable to parsers. Link to it instead.
- One page, one column. Analysts are expected to communicate clearly; a tidy one-page resume is the first proof.
LinkedIn headline examples
Recruiters search LinkedIn for “data analyst” plus tools, so put both in your LinkedIn headline:
- Data Analyst · SQL, Tableau, Snowflake · E-commerce and product analytics
- Marketing Data Analyst | GA4, BigQuery, Looker Studio | Turning campaign data into decisions
- Aspiring Data Analyst · SQL, Excel, Power BI · Portfolio on Tableau Public
To skip the blank page, save your LinkedIn profile as a PDF and open it in LinkedIn to resume. It lays your profile out as an ATS-friendly resume in your browser, ready for you to sharpen the bullets with numbers like the ones above.
Pixelin
The same resume as a Pixel CV
This is Priya's profile as a 16-bit character sheet: years of experience become a level, languages become hearts. It is not for job applications, it is for your LinkedIn feed, where a picture gets far more attention than a text post.
Create your Pixel CVFAQ
What skills should be on a data analyst resume?
SQL first, then Excel and one BI tool such as Tableau or Power BI, because almost every posting asks for them. Add Python or R, statistics basics like A/B testing, and the business area you know, such as marketing, finance or product.
Do I need a portfolio for a data analyst job?
It is not required, but it helps a lot if you have little work experience. Two or three projects with a public dashboard or a short write-up show your process better than a list of skills.
How do I write a data analyst resume with no experience?
Lead with projects that use real, messy public data, list the tools you used in each, and include any analysis you did in school, an internship or another job. A short objective that names the role you want helps explain the switch.
Should I list Google or other online certificates?
Yes, in a certifications section, especially early in your career. They show you learned the basics, but recruiters will still look for a project or job where you used those skills.
