ClayCV

Data analyst resume examples

By Gaurav Sharma. Updated .

A data analyst resume should show that your analysis changed decisions. Name your tools early, then show what happened because of your work. Clean SQL and clear reporting carry an entry-level application. A lead analyst also needs the questions they shaped and the analysts they guided.

Rohan Banerjee, Data analyst, five years, product analytics

Why Crown works for this data analyst resume

  1. Decisions, not dashboards. The 8% conversion result leads Rohan's strongest bullets, tying his analysis to a change the product team actually shipped.
  2. Experimentation has its own group. Crown's labelled skill rows separate A/B testing from tools, so a product hiring manager sees that skill without hunting for it.
  3. Domain named up front. "Product data analyst in subscription software" tells the reader which kind of analyst this is in the first few words.
Read Rohan's resume as text

Rohan Banerjee, Senior Data Analyst, Product

rohan.banerjee@example.com | (206) 555-0163 | Seattle, WA

Summary

Product data analyst with five years in subscription software, working in SQL, dbt and Looker. Designs and reads out A/B tests, owns activation and retention metrics for a 12-person product group, and turns findings into decisions: a checkout test lifted trial-to-paid conversion by 8%.

Experience

Senior Data Analyst, Product, Relecloud | Seattle, WA, Apr 2023 – Present

  • Own activation and retention metrics for a 12-person product group, reviewed in the weekly product meeting
  • Designed and read out 31 A/B tests over two years, setting sample sizes and guardrail metrics before launch
  • Showed that a shorter checkout lifted trial-to-paid conversion by 8%, and the change shipped to all plans
  • Rebuilt 22 Looker dashboards on tested dbt models, reducing metric disputes and retiring 60 unused reports
  • Traced a 3% fall in week-four retention to a billing email bug, which engineering fixed within a sprint
  • Coach two junior analysts on SQL review and on writing findings for product managers

Data Analyst, Proseware | Bellevue, WA, Feb 2021 – Mar 2023

  • Built the customer health score from usage and support data, covering 4,000 accounts for the success team
  • Wrote dbt models for product events and added 120 tests to catch broken tracking
  • Sized a pricing change using 18 months of plan data, and the forecast landed within 2% of first-quarter results
  • Trained 25 colleagues to answer routine questions in Looker, cutting ad hoc requests by about a third

Junior Analyst, Tailspin Toys | Portland, OR, Jul 2019 – Jan 2021

  • Reported weekly online sales across four channels in SQL and Excel
  • Automated the channel report in Python, saving about five hours a week

Education

University of Washington | Seattle, WA, Sep 2015 – Jun 2019

  • Bachelor of Science, Statistics

Skills

Data

SQL, dbt, BigQuery, Python, R

Reporting

Looker, Tableau, Metric design

Experimentation

A/B testing, Power analysis, Cohort and funnel analysis

Everyone and every company in these examples is fictional, and the figures are there to show how a good bullet is built, not to set a standard.

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 ofWrite
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 ofWrite
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.

CredentialEarnedIn progress
Microsoft Certified: Power BI Data Analyst AssociateMicrosoftMicrosoft 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.

Build your data analyst resume

Related examples: BI Analyst, Data Scientist, Data Engineer, Analytics Manager, BI Developer

Build my resume