Data Analyst Resume Examples & Writing Guide
A data analyst resume gets an interview when a hiring manager can see, in the first half page, the tools you query and visualize with (SQL dialect, Tableau or Power BI, Python or R, Excel), the business questions you answered and what changed because of your analysis, with numbers. Projects count when you have no job yet. Below: a full sample, summaries, bullets, skills, project wording and an entry-level version.
Data analyst resume example (3 years of experience)
This sample is for an analyst with about three years of experience, the level most people searching for this page are at or aiming for. The name, employers and school are made up. If you are a fresher, the entry-level section below shows how to fill the same layout with projects and internships.
Hannah Reyes
Data Analyst
Chicago, IL · (312) 555-0174 · hannah.reyes@email.com · linkedin.com/in/hannahreyes-data · github.com/hreyes-analytics
Summary
Data analyst with 3 years turning e-commerce and logistics data into decisions. Write SQL against Snowflake and PostgreSQL daily, own 14 Tableau dashboards used by 120 people, and run A/B test readouts for the marketing team. Analysis of checkout drop-off led to a change that lifted conversion 0.6 points (about $2.1M in annual revenue). Python (pandas), dbt, Excel, Google Analytics 4. Microsoft PL-300 and Tableau Desktop Specialist certified.
Experience
Data Analyst · Online home goods retailer ($300M annual revenue, 2.4M customers)
Feb 2024 – Present
- Write and maintain 60+ SQL models in Snowflake and dbt covering orders, returns, marketing spend and customer lifetime value; queries feed 14 Tableau dashboards used weekly by 120 people in marketing, merchandising and finance.
- Analyzed 18 months of checkout funnel data in GA4 and Snowflake, found a 23% drop at the shipping step for mobile users, and proposed the shipping-cost display change that lifted mobile conversion from 2.1% to 2.7% (about $2.1M a year).
- Design and read out 25+ A/B tests a year for the growth team (sample size, significance, guardrail metrics), with results written up in a one-page template the VP of Marketing reads before every test decision.
- Built a returns-rate model by category and supplier in Python that flagged 3 suppliers with return rates over 18%; merchandising renegotiated terms and cut returns cost by $340K in 2025.
- Replaced 9 weekly Excel reports with scheduled Tableau extracts, saving the merchandising team about 12 hours a week.
Reporting Analyst · Regional third-party logistics company (22 warehouses)
Jul 2022 – Jan 2024
- Produced daily and weekly operations reports for 22 warehouses in Power BI (on-time shipment, pick accuracy, labor hours per order) from SQL Server and a WMS export, serving 40 managers.
- Cleaned and reconciled 1.5M order records a month with SQL and Excel Power Query, cutting reporting errors flagged by managers from 15 a month to 2.
- Built the labor forecasting sheet that predicted daily order volume within 8% (MAPE) and let 6 sites plan staffing a week ahead instead of a day ahead.
- Documented 30 report definitions and metric formulas in a shared data dictionary that ended monthly disputes about whose numbers were right.
Business Analytics Intern · Consumer bank, marketing analytics team
Jun 2021 – Aug 2021
- Segmented 400K customers by product usage in SQL and Python and built the Tableau view the campaign team used to pick 3 target groups for a credit card offer.
Education
Bachelor of Science in Economics, minor in Statistics
University of Illinois Chicago, 2022
Certifications
- Microsoft Certified: Power BI Data Analyst Associate (PL-300), 2024
- Tableau Desktop Specialist, 2023
- Google Data Analytics Professional Certificate (Coursera), 2022
Skills
What analytics managers look for first
Analytics managers and the recruiters who screen for them read hundreds of data analyst resumes, most of them listing the same tools. Four things separate the interview pile from the rest.
- SQL you have actually written. Not "SQL" alone but the dialect (Snowflake, BigQuery, PostgreSQL, SQL Server, MySQL) and a bullet that shows the scale (tables, rows, models) and complexity (window functions, CTEs, performance tuning). Most interviews include a live SQL exercise, so managers check the resume promises it.
- A business result, not a technical one. "Reduced query time" is nice. "Found the drop-off that led to a 0.6-point conversion lift" gets the interview. Every experienced analyst needs at least one bullet where a decision changed because of their work.
- One visualization tool in depth. Tableau or Power BI (Looker, Sigma and Qlik in some companies) with the number of dashboards and the number of people who use them. Listing five BI tools reads as none.
- For entry level: projects with real data and a link. A GitHub repository or Tableau Public profile with two or three clean projects (question, data source, method, finding) does more than any certificate.
“I skip to the bullets and look for a number that a business person would care about. If every line ends in a dashboard or a report and nothing ever changed because of it, I assume they were a report factory.”
Data analyst resume summary examples (fresher, 2–3 years, senior, career change)
Three to four lines under the header. Years and domain first, then the tools you use daily, then your best result with a number, then certifications if they matter. Skip the objective; even a fresher has a project to describe.
Statistics graduate (B.S., May 2026) with three portfolio projects on GitHub: a 250K-row retail sales analysis in SQL and Tableau, a customer churn model in Python (78% recall), and a public-transit ridership dashboard for a city open-data set. Google Data Analytics Certificate. Ready to take on SQL queries, Python data cleaning and Tableau dashboard builds from day one.
Junior data analyst with a 6-month internship at a health insurer, where I built 5 Power BI reports on claims data (2M rows) for 30 users and automated a weekly Excel process with Python, saving 6 hours a week. SQL Server, Power BI (PL-300 certified), Python, Excel.
Data analyst with 3 years in e-commerce and logistics. Daily SQL in Snowflake and dbt, 14 Tableau dashboards for 120 users, and A/B test readouts for marketing. Funnel analysis led to a change worth about $2.1M a year in revenue. Python, GA4, Excel; Tableau and PL-300 certified.
Senior data analyst with 6 years in SaaS, owning product and revenue analytics for a $90M ARR company. Built the metrics layer in dbt and Looker that 200 employees use, led pricing analysis behind a 2025 plan change that raised net revenue retention from 104% to 109%, and mentor 2 analysts. SQL (BigQuery), Python, Looker, Amplitude.
Financial analyst with 4 years of Excel-heavy forecasting and variance work, now moving into data analysis after completing a SQL and Python certificate and rebuilding my team's monthly reporting in Power BI (cut prep time from 3 days to 4 hours). Comfortable with SQL joins and window functions, DAX and pandas.
Data analyst work experience bullets: weak to strong
Use this pattern: data (source, size), method (tool, technique), result (what changed, for whom, by how much). Below are common weak bullets rewritten. Change the numbers to your own; interviewers ask about every one.
| Weak | Strong |
|---|---|
| Created dashboards in Tableau. | Built 8 Tableau dashboards on sales, inventory and returns from Snowflake, used weekly by 60 people across merchandising and finance; retired 11 manual Excel reports. |
| Wrote SQL queries to pull data. | Wrote 40+ production SQL models in BigQuery and dbt (customer, order and marketing tables, 300M rows), with tests that cut data-quality tickets from 12 a month to 3. |
| Analyzed customer data. | Segmented 1.2M customers by purchase frequency and margin in SQL and Python; the marketing team moved 30% of email budget to the two highest-margin segments and raised email revenue 14% in one quarter. |
| Performed A/B testing. | Designed and analyzed 20 A/B tests a year (power calculations, significance, guardrails), including the checkout test that raised mobile conversion from 2.1% to 2.7%. |
| Cleaned data in Excel. | Reconciled 1.5M monthly order records from 3 systems using SQL and Power Query, cutting reporting errors flagged by managers from 15 a month to 2. |
| Presented findings to stakeholders. | Delivered a monthly one-page readout to the VP of Operations; 4 of the 6 recommendations in 2025 were adopted, including a staffing change that cut overtime 9%. |
| Built forecasts. | Built a daily order volume forecast in Python (Prophet) with 8% MAPE, replacing a spreadsheet that missed by 20%, so 6 warehouses could schedule labor a week ahead. |
| Automated reports. | Automated 5 weekly reports with Python and scheduled SQL, saving about 10 analyst hours a week and delivering numbers by 7 a.m. Monday instead of Tuesday afternoon. |
Start with an example, finish in minutes.
No sign-up to start. Download works. One-time $12 for a clean PDF, no subscription.
Data analyst resume skills section (what to list and how)
Group skills by category and keep the list to 12 to 16 items. Name the dialect or version where it matters. Recruiters search applicant tracking systems for exact tool names; "data visualization" alone does not match "Tableau".
- Querying: SQL (name the databases: PostgreSQL, MySQL, SQL Server, Snowflake, BigQuery, Redshift, Databricks), window functions, CTEs, query optimization
- Visualization and BI: Tableau, Power BI (DAX), Looker (LookML), Sigma, Qlik Sense, Google Looker Studio
- Programming: Python (pandas, NumPy, matplotlib, seaborn, scikit-learn), R (tidyverse, ggplot2), Jupyter
- Spreadsheets: Excel (pivot tables, Power Query, XLOOKUP, Solver), Google Sheets
- Data modeling and pipelines: dbt, Airflow basics, data warehousing concepts, star schemas
- Statistics: A/B testing, hypothesis tests, regression, confidence intervals, sampling, forecasting
- Product and web analytics: Google Analytics 4, Amplitude, Mixpanel, Adobe Analytics
- Tools: Git and GitHub, Jira, Confluence, Snowflake or BigQuery consoles, Salesforce reports if relevant
- Domain: e-commerce funnels, healthcare claims, supply chain KPIs, financial reporting, whichever you have worked in
Do not list soft skills as words. "Communication" means nothing; "monthly readout to the VP of Operations, 4 of 6 recommendations adopted" shows it. The same goes for "attention to detail": show the error rate you cut.
How to write data analysis projects on a resume (with GitHub)
Projects are the main content of a fresher's resume and a useful extra for anyone under two years. A project entry should read like a job bullet: the question, the data (source and size), the method and tools, and the finding. Link the code or dashboard. Two or three strong projects beat eight course exercises.
- 1Pick a real dataset, not the Titanic or Iris sets every recruiter has seen: city open data, Kaggle competitions with messy data, a public API, your own scraped or exported data.
- 2Start from a business-style question ("which neighborhoods have rising 311 complaint rates and why?") rather than a technique.
- 3Do the work in SQL and one visualization tool, plus Python if you use it. Clean the data and say how much cleaning was needed.
- 4Write a README with the question, method, findings and two charts. Recruiters click the link and spend 30 seconds; the README is what they see.
- 5On the resume: title, tools, one or two lines with the size of the data and the finding, and the link. Put a Tableau Public link if the project is a dashboard.
Chicago Bike-Share Demand Analysis (SQL, Tableau Public). Cleaned and analyzed 5.7M trip records (2024) in PostgreSQL; found that 31% of weekday rides start at 12 stations near commuter rail, and built a dashboard proposing rebalancing hours. github.com/yourname/bikeshare
Telecom Customer Churn Model (Python, scikit-learn). Built a logistic regression and random forest on a 7,000-customer dataset; 78% recall on churners, with contract type and tenure as top drivers. Wrote a one-page recommendation on retention offers.
Personal Finance and Regional Price Index Dashboard (Excel Power Query, Power BI). Combined 3 years of exported bank transactions with BLS CPI data to compare spending against regional inflation; 6 DAX measures, monthly refresh.
Entry-level data analyst resume with no experience (fresher)
"No experience" usually means no job with "analyst" in the title. Almost everyone has analyzed data somewhere: a class project, a part-time job's spreadsheets, a club's membership list, an internship. Here is the order that works when the experience section is thin.
- Header with a GitHub or Tableau Public link that actually has projects in it. An empty profile is worse than no link.
- Summary of three lines: degree or certificate, tools, and your best project with a number.
- Education near the top: degree, graduation date, GPA if 3.3 or higher, relevant coursework (Statistics, Database Systems, Econometrics, Data Visualization). For a bootcamp or certificate, list it here with the hours or duration.
- Projects section with 2 to 3 entries written as shown above. This is your experience section for now.
- Any job, rewritten around data: a retail job where you tracked inventory in Excel, a research assistant role where you cleaned survey data in R, a campus job where you built the sign-up report. Give the size of the data and what someone did with your numbers.
- Certifications: Google Data Analytics Professional Certificate, Microsoft PL-300, Tableau Desktop Specialist, IBM Data Analyst Professional Certificate. Useful as keyword matches, but a manager will weigh the projects more.
- Skills section with exact tool names, honest about level. Say "Python (pandas, matplotlib)" not "Python expert" after one course.
Shift supervisor, campus coffee shop: built the weekly sales and waste tracker in Google Sheets from POS exports (1,200 transactions a week), which cut milk and pastry waste 15% over one semester.
Research assistant, Department of Economics: cleaned and coded 3 waves of survey data (4,800 responses) in R and Stata, ran descriptive statistics and regressions for a faculty working paper, and documented the codebook.
Data analyst intern, regional health insurer (6 months): wrote SQL Server queries against 2M claims rows, built 5 Power BI reports for 30 case managers, and automated a weekly Excel process in Python, saving 6 hours a week.
Format, length and ATS keywords for a data analyst resume (and the CV question)
- Length: one page up to about 7 years of experience. Two pages for senior analysts with long project lists or people managers. Recruiters read the first half page and decide.
- Order for experienced analysts: header, summary, experience, skills, certifications, education. Entry level: header, summary, education, projects, experience, skills, certifications.
- Layout: single column, clear headings, no graphics or skill bars. A clean template such as cvplex modern-blue passes applicant tracking systems (ATS) and looks current. No photo in the US.
- Links: LinkedIn, GitHub and Tableau Public in the header as plain text URLs. Make sure the GitHub has READMEs and the Tableau Public dashboards load.
- Keywords to mirror from the posting when they are true for you: SQL, Tableau or Power BI, Python, Excel, dashboards, KPIs, A/B testing, data cleaning, data modeling, stakeholder, reporting, forecasting, plus the exact database (Snowflake, BigQuery, Redshift). The ATS matches exact strings, so write "Power BI" not "PowerBI".
- Resume or CV? In the US it is a resume, one to two pages. "Data analyst CV" is the UK, Ireland, India and much of Europe; the document is the same length and layout, and in the UK you also leave out the photo. Academic CVs (publications, every course) are for research roles, not analyst jobs.
Frequently asked questions
How do I write a data analyst resume?
Start with a three-line summary: years and domain, daily tools (SQL dialect, Tableau or Power BI, Python), and your best business result with a number. Give each job 3 to 5 bullets in the pattern data, method, result. Group skills by category with exact tool names, list certifications, and link GitHub or Tableau Public if it has real projects. One page under about 7 years.
What skills should I put on a data analyst resume?
SQL with the databases you have used, one BI tool in depth (Tableau or Power BI), Python or R with the libraries, Excel (pivot tables, Power Query), statistics (A/B testing, regression), data cleaning and modeling (dbt if you use it), and the domain you know (e-commerce, healthcare, finance). Show soft skills through results, not as words.
How do I write a data analyst resume with no experience?
Lead with education and a summary that names your tools and best project, then a Projects section with 2 to 3 entries (question, data size, tools, finding, link), then any job rewritten around the data you handled, then certifications. Put a GitHub or Tableau Public link with real work in the header. Keep it to one page.
How do I write a data analysis project on my resume?
Title, tools in parentheses, then one or two lines: the size of the data, what you did, and the finding with a number, plus a link. Example: "Bike-share demand analysis (SQL, Tableau): analyzed 5.7M trips, found 31% of weekday rides start at 12 stations near commuter rail, built a rebalancing dashboard."
Objective or summary for a data analyst fresher?
A summary. Even without a job, you can say what you have done: your degree or certificate, the tools you used, and a project with a number. An objective ("seeking a challenging role to grow my skills") tells the manager nothing they can check.
Which certifications help on a data analyst resume?
The Google Data Analytics Professional Certificate and IBM Data Analyst certificate for beginners, Microsoft PL-300 (Power BI Data Analyst Associate) for Power BI shops, Tableau Desktop Specialist or Certified Data Analyst for Tableau shops, and SnowPro Core or a cloud fundamentals cert if the posting mentions that platform. They help with ATS keyword matching; projects and SQL skill decide the interview.
Ready to write yours?
The builder suggests a summary from your own experience, then checks it against the job posting.
How this page was made: a first draft was written with AI assistance from cvplex's example library, then edited and fact-checked by the cvplex Careers Team. Examples are fictional composites; numbers are illustrative. Report an error via the editorial policy page.