Whoever hires a data analyst wants decisions to get better because of the analyst's work. The technical skills (SQL, a visualization tool, spreadsheets, some Python) are assumed; what the resume has to prove is that those skills were used to answer a real question, that the answer reached the person who needed it and that something changed as a result. A dashboard nobody used is not an achievement; a dashboard that retired fourteen spreadsheets is.
Data analyst resumes fail most often by listing tools and dashboards without the decision behind them. This guide covers what carries weight for the role, which terms postings filter on, how to write bullets that connect analysis to outcomes, what separates junior from senior, and what a complete resume looks like within the technology field.
In this guide
What matters on a data analyst resume
Experience bullets need four elements: the question or business area, the data and tools used, the analysis performed and the decision or metric that moved. "Analyzed customer data" fails all four; "segmented 450,000 customers by purchase behavior in SQL and Python; marketing targeted the top segment and repeat orders rose 17%" hits every one. The reader is usually an analytics manager who wants to know whether the candidate can be handed a vague question and return a recommendation.
SQL depth is checked before anything else. The skills section should name the dialect or warehouse (PostgreSQL, Snowflake, BigQuery) and, for stronger profiles, the constructs (window functions, CTEs) rather than just "SQL." The visualization tool named in the posting (Tableau, Power BI, Looker) should appear in a bullet, not only in a list. Python or R is a plus in most postings and a requirement in some.
A portfolio helps more than in most technical roles: a Tableau Public profile, a GitHub with notebooks or a short write-up of two analyses with the decision they informed. Education still weighs in this role (statistics, economics, business, mathematics), and the Google Data Analytics or Microsoft Power BI certifications help junior candidates get through filters. A restrained single-column resume template keeps the portfolio link and the skills section readable by screening software.
Keywords job postings look for
The terms that recur in US data analyst postings:
- SQL (joins, window functions, CTEs)
- Excel (pivot tables, Power Query, XLOOKUP)
- Tableau, Power BI or Looker
- Python (pandas) or R
- Dashboards and automated reporting
- KPIs and metric definitions
- Data cleaning and validation
- A/B testing and experiment analysis
- Statistical analysis (regression, hypothesis testing)
- Snowflake, BigQuery or Redshift
- dbt and data modeling
- Google Analytics or product analytics tools (Amplitude, Mixpanel)
- Data storytelling and presentations to stakeholders
- Forecasting
- Stakeholder management and requirements gathering
They gain credibility inside bullets that show the question answered, and the skills list repeats those the posting stresses. The tool to tailor a resume to the job compares the document with the description and flags the missing terms.
Experience bullets that work
The difference is the decision at the end of the bullet. The pairs below show it:
| Avoid | Better |
|---|---|
| Created dashboards for management | Built a Power BI dashboard for regional sales leaders that replaced 14 weekly spreadsheets and cut reporting preparation from 12 hours to 1 per week |
| Analyzed customer data | Segmented 450,000 customers by purchase behavior in SQL and Python; marketing targeted the top segment and repeat orders rose 17% in one quarter |
| Wrote SQL queries for reports | Consolidated 30 recurring Snowflake queries into a documented dbt model, eliminating 3 conflicting revenue definitions across departments |
| Supported the marketing team with data | Analyzed 25 A/B tests on email campaigns and identified a subject-line pattern that raised open rates from 19% to 26% |
| Cleaned and prepared data | Audited the CRM export and fixed 38,000 duplicate or malformed records, restoring the monthly pipeline report to above 99% accuracy |
| Presented findings to stakeholders | Presented a churn analysis to the VP of Customer Success that led to a retention program cutting monthly churn from 4.1% to 3.2% |
A data analyst bullet ends with what someone decided or what metric moved. If the bullet stops at "built a dashboard," it stops one sentence too early.
Junior vs. senior
A junior data analyst (bootcamp, degree, or moving from operations, finance or marketing) leans on education, a portfolio with two or three analyses that end in a recommendation, and any work bullet where data changed a decision, even in a non-analyst job. SQL proficiency should be demonstrable; a certificate helps with filters, but an interview will test the queries. Previous domain knowledge (retail, healthcare, finance) is an asset and should be stated.
A senior analyst resume shows ownership of metrics and of a business area: the KPI framework defined, the self-serve reporting that reduced ad hoc requests, the experiments program run, the cross-functional relationships (finance, product, marketing) and the junior analysts mentored. Data modeling and warehouse work (dbt, semantic layers) appear at this level, and so does the decision to say no to an analysis that would not change anything.
Common mistakes in this role
These problems recur in analyst resumes:
- Dashboards without decisions. Six bullets about reports built and none about what changed because of them.
- "Proficient in Excel" as the headline skill. Excel is assumed; the resume should lead with SQL and the visualization tool the posting names.
- Tool list without SQL depth. "SQL" alone next to eight other tools reads as basic. Naming the warehouse and the constructs used signals real practice.
- No business domain. Postings ask for retail, SaaS, healthcare or finance experience by name; a resume that never says which industry the data came from loses that match.
- Portfolio absent or hidden. A Tableau Public link or a short case write-up belongs in the header, not at the bottom of page two.
- Analyst and scientist blurred. Claiming machine learning models from a role that built reports invites questions the candidate cannot answer; the data scientist guide shows where the line sits.
Sample data analyst resume
The example condenses the advice into a one-page resume for a mid-career profile. Names and companies are fictional.
Data analyst with 5 years in e-commerce and financial services, turning SQL, Python and Power BI work into decisions for marketing, sales and customer success teams. Built reporting that replaced dozens of manual spreadsheets and ran experiment analyses that lifted retention and campaign performance. Strong in Snowflake, dbt and stakeholder communication.
Data Analyst, Redwood Home Goods, Chicago, IL. Apr 2022 - Present
- Segmented 450,000 customers by purchase behavior in SQL and Python; marketing targeted the top segment and repeat orders rose 17% in one quarter.
- Consolidated 30 recurring Snowflake queries into a documented dbt model, eliminating 3 conflicting revenue definitions across departments.
- Presented a churn analysis to the VP of Customer Success that led to a retention program cutting monthly churn from 4.1% to 3.2%.
Reporting Analyst, Lakeshore Credit Union, Evanston, IL. Jul 2020 - Mar 2022
- Built a Power BI dashboard for 12 branch managers that replaced 14 weekly spreadsheets and cut reporting preparation from 12 hours to 1 per week.
- Audited the CRM export and fixed 38,000 duplicate or malformed records, restoring the monthly pipeline report to above 99% accuracy.
- Analyzed 25 A/B tests on member email campaigns and identified a subject-line pattern that raised open rates from 19% to 26%.
Bachelor of Arts in Economics, University of Illinois Chicago, 2020. Google Data Analytics Professional Certificate, 2021.
SQL (Snowflake, PostgreSQL), Python (pandas, matplotlib), Power BI, Tableau, dbt, Excel (Power Query, pivot tables), A/B test analysis, Google Analytics, data cleaning, Git.
Frequently asked questions
Is Python required on a data analyst resume?
Not in every posting, but it appears in most and is required in many at larger companies. SQL comes first in any case. A candidate with strong SQL and a visualization tool, plus pandas for cleaning and analysis, matches the majority of postings; R is an acceptable substitute in research and healthcare contexts.
Should a data analyst resume include a portfolio?
Yes, especially under three years of experience. A Tableau Public profile, a GitHub with clean notebooks or a one-page write-up of two analyses (question, data, method, decision) lets the hiring manager verify the skills. The link goes in the header as plain text.
Do certifications like Google Data Analytics help?
They help junior candidates clear keyword filters and show initiative when there is no degree in a quantitative field. They do not carry weight against a bullet with a real decision behind it, so they take one line in the education section.
Data analyst or data scientist: which title should the resume use?
The one the evidence supports. Reports, dashboards, SQL and experiment analysis are analyst work; models deployed and statistical methods designed are scientist work. Applying to the right title with matching bullets works better than reaching for the more senior label.