Skip to content
Data & Analytics

Data Analyst resume example

Prove you turn questions into decisions. Show the analyses you ran, the tools you used and the choices stakeholders made because of them.

Updated

Desmond Faircloth

Data Analyst | SQL & BI | Turning Reporting into Decisions

  • Chicago, IL
  • desmond.faircloth@example.com
  • +1 (312) 555-0156
  • linkedin.com/in/your-name

Summary

Data analyst with six years building reporting and self-serve dashboards that teams actually use. Strong in SQL and BI tooling, with a habit of turning ambiguous questions into clear, decision-ready answers.

Work Experience

Senior Data Analyst

Jun 2021 – Present

Halcyon Logistics · Chicago, IL

  • Built a self-serve Tableau suite adopted by 9 departments, cutting ad hoc report requests to the data team by 60%.
  • Modeled delivery performance in SQL and dbt, surfacing a routing change that reduced late deliveries 14%.
  • Automated executive KPI reporting, replacing a 6-hour weekly manual process with a refreshed dashboard.

Data Analyst

Mar 2019 – May 2021

Brightpath Media · Chicago, IL

  • Analyzed campaign performance across 40+ accounts, recommending budget shifts that improved blended ROAS 19%.
  • Designed a Power BI dashboard tracking 25 marketing KPIs used in weekly leadership reviews.
  • Cleaned and consolidated 5 data sources into a single model, reducing reporting discrepancies to near zero.

Junior Analyst

Jan 2018 – Feb 2019

Cobalt Insurance · Chicago, IL

  • Produced weekly claims reports in SQL and Excel for a 30-person operations team.
  • Identified a data-entry error pattern that, once fixed, reduced reconciliation rework 25%.

Education

Bachelor of Science, Economics

2013 – 2017

University of Illinois Urbana-Champaign

Skills

Core competencies

  • SQL
  • Tableau
  • Data Modeling

Technical

  • SQL
  • Excel
  • Tableau
  • Power BI
  • Python (pandas)
  • dbt
  • Snowflake

Soft Skills

  • Stakeholder Communication
  • Requirements Gathering
  • Attention to Detail

Certifications

  • Google Data Analytics Professional Certificate · Google, 2020
  • Microsoft Power BI Data Analyst Associate · Microsoft, 2022

Languages

  • English · Native
  • Spanish · Professional working proficiency

The full sample as text. Rendered in the Compact template, a layout applicant tracking systems read in order.

Fictional person: the name and contact details are invented. Any resemblance to a real person is coincidental.

Data Analyst resume summary examples

Pick the one closest to your level and replace the specifics with your own.

  • Entry level

    Data analyst with a statistics degree and a year of experience at a healthcare nonprofit. Writes SQL queries against PostgreSQL, builds Tableau dashboards for program managers and automated a monthly report that saved 8 hours. Completed a Google Data Analytics certificate and is seeking a team where analysis directly shapes decisions.

  • Mid level

    Data analyst with five years in ecommerce analytics. Uses SQL, Python and Looker to analyze funnel, retention and pricing, and delivered an analysis that lifted repeat purchase rate by 6%. Presents findings to marketing and product leaders and builds data checks that cut reporting errors by half.

  • Senior

    Senior data analyst with nine years in subscription businesses. Leads analytics for growth and pricing, mentors three analysts and defines the company's core metrics with finance. Skilled in SQL, Python, experiment analysis and executive storytelling, with analyses credited for roughly $2M in annual revenue and cost improvements.

  • Career changer

    Former retail operations lead moving into data analysis after two years of building the store network's weekly sales reports in Excel and SQL. Comfortable cleaning messy point-of-sale data, explaining a variance to a regional manager and turning a recurring question into a dashboard people actually open.

  • Domain specialist

    Healthcare data analyst who knows claims, encounter and EHR data and the privacy rules around them. Builds Power BI reporting for clinical and finance teams, reconciles numbers across systems before anyone quotes them, and writes up methods so a second analyst can rerun the work.

Data Analyst resume objective examples

An objective fits when you have no direct experience in the role yet. Name the role, the proof you already have and what you will bring to the team.

  • Graduate

    Statistics graduate with SQL, Python and Tableau coursework and a capstone that analyzed city bike-share demand. Looking for an entry-level data analyst role where I can own recurring reports and learn how the business uses them.

  • Career changer

    Finance associate with four years of variance analysis and Excel modeling, now applying for data analyst roles. Bringing a habit of checking numbers twice and explaining them plainly, and adding SQL and Power BI from recent projects.

  • Bootcamp

    Analytics bootcamp graduate with three portfolio projects in SQL and Python, including a churn analysis on a public telecom dataset. Seeking a junior analyst role on a team that reviews code and asks good questions.

Common mistakes on a data analyst resume

  • Showing tools but not decisions

    Fix: Anyone can list SQL and Tableau. Describe a question you answered and the action that followed, such as 'identified a pricing gap that led to a 3% revenue lift.' Decisions are the proof of impact.

  • Writing 'proficient in Excel' as the only technical line

    Fix: State specific skills like pivot tables, XLOOKUP and Power Query, then add SQL joins or window functions and a BI tool. Hiring managers check for stack breadth and depth together.

  • Ignoring data cleaning and validation

    Fix: Most analyst time goes to messy data. Mention the sources you cleaned, the checks you set up and the errors you caught, since stakeholders trust analysts who prove their numbers are right.

  • Omitting the audience

    Fix: Say who consumed your analysis: marketing leads, a CFO, product managers. It shows communication skill and lets recruiters see whether you can present to the level they need.

What should a data analyst resume include?

A data analyst resume should open with a two or three line summary of your focus, then show each role as results rather than duties. Name the skills the posting asks for, such as SQL, window functions and Python. Start bullets with verbs like Analyzed, Reported and Automated, and give each one a number where you honestly have one. If you hold a credential such as Google Data Analytics Professional Certificate, list it in its own section.

Querying and analysis

  • SQL
  • window functions
  • Python
  • pandas
  • R
  • statistical analysis
  • A/B test analysis

Visualization and reporting

  • Tableau
  • Power BI
  • Looker
  • Excel
  • Google Sheets
  • dashboard design
  • data storytelling

Data work

  • data cleaning
  • data validation
  • ETL
  • BigQuery
  • Snowflake
  • PostgreSQL
  • data modeling

Business focus

  • KPI reporting
  • cohort analysis
  • funnel analysis
  • customer segmentation
  • forecasting
  • root cause analysis

Action verbs

  • Analyzed
  • Reported
  • Automated
  • Surfaced
  • Visualized
  • Recommended

Certifications

  • Google Data Analytics Professional Certificate
  • Microsoft Power BI Data Analyst Associate

Match these against the job posting you are applying to: the free resume checker shows which keywords your resume is missing.

Skills to put on a data analyst resume

List the hard skills the posting names in your skills section. Soft skills belong in your bullets, shown through something you did.

Hard skills

  • SQL (joins, CTEs, window functions)
  • Excel or Google Sheets (pivot tables, lookups)
  • Tableau, Power BI or Looker
  • Python or R for analysis
  • Descriptive statistics and A/B test reading
  • Data cleaning and validation
  • Data warehouses such as BigQuery or Snowflake
  • Metric definitions and documentation

Soft skills

  • Turning a vague request into a clear question
  • Explaining a result to people who will not read the query
  • Attention to detail before numbers leave your hands
  • Prioritizing ad hoc requests against recurring work

Data Analyst keywords recruiters scan for

Use the wording of the posting itself, and back each term with a line that proves it.

SQL
Name the warehouse and the kind of query, such as cohort retention in BigQuery, in a bullet with its result.
Tableau / Power BI
Say who used the dashboard and what decision it supported, not only that you built one.
Python or R
Point to an analysis or an automation, such as a weekly report that now runs on its own.
A/B testing
Describe the test, the metric you read and the call the team made after it.
KPI reporting
List the metrics you owned and the audience that reviewed them.
Data cleaning
Mention the source you fixed and what stopped going wrong afterwards.
Stakeholder management
Name the teams you worked with, such as marketing or finance, and how often.
Forecasting
State the horizon and how close the forecast came, with a figure you can explain.
Data modeling
Mention tables or models you designed and who builds on them now.
ETL
Say which pipeline you maintained or built and the tools behind it.

Data Analyst resume bullet examples

The numbers are illustrative. Keep the structure (verb, action, measurable result) and use figures you can back up.

  • Analyzed 2 years of order data in SQL to find an underperforming shipping tier, and the pricing change that followed raised margin by 3 points.
  • Built a Tableau dashboard used weekly by 30 managers, replacing 9 separate spreadsheets.
  • Automated a monthly KPI report with Python and scheduled queries, saving about 14 hours of manual work each month.
  • Ran cohort analysis showing that customers who used a key feature in week one retained 22% more, which changed the onboarding flow.
  • Evaluated 18 A/B tests with proper sample size checks and flagged 3 invalid results before they influenced product decisions.
  • Cleaned and merged 5 data sources totaling 4 million records, reducing duplicate customer entries by 31%.
  • Forecasted weekly demand with a seasonal model that came within 7% of actual sales over the following quarter.
  • Presented a churn analysis to the executive team that led to a $150K retention campaign and a 4% drop in cancellations.
  • Created a data dictionary of 60 metrics that resolved recurring disagreements between finance and marketing.
  • Taught SQL basics to 12 colleagues in four sessions, increasing self-service requests and reducing ad hoc ticket volume by about 25%.

How to stand out as a data analyst applicant

Tailor every application to the posting: the resume, the cover letter and the answers you prepare for the interview.

  • Mirror the posting's stack and questions

    Analyst roles differ more than the title suggests: one team wants SQL and Looker for product metrics, another wants Excel and finance reporting. Move the tools and the business questions the posting names to your summary and first bullets, and drop what it never mentions. Tailor your resume to the job

  • Lead with one finding in the cover letter

    Open the letter with a short story of a question you answered, the data you used and what changed because of it. Then connect that to a problem the company is likely to have, and keep the letter under a page. Draft a cover letter for this posting

  • Prepare a walkthrough of one analysis

    Interviews often include a SQL exercise and a case question. Practice explaining one project end to end: the question, how you checked the data, the method, the result and what you would do differently. Practice likely interview questions

  • Link a small, readable portfolio

    If you are early in your career, one or two well-documented projects on GitHub or Tableau Public help more than a long list of courses. Put the link in your header and describe the project in one line on the resume.

Salary (official data)

Official pay statistics for the occupation that matches this role, copied exactly as each statistics office publishes them.

  • United Kingdom

    Median gross annual pay: £41,247 a year

    Middle half of earners: £34,079 to £50,448

    Official occupation: Data analysts (SOC 2020 3544)

    Gross annual pay of full-time employee jobs (employees on adult rates in the same job for more than a year).

    Provisional figures: the publisher revises them a year later.

    Source: Office for National Statistics, Annual Survey of Hours and Earnings, tax year to 5 April 2026, licensed under the Open Government Licence v3.0.

  • Canada

    Median gross hourly pay: CA$ 50.48 an hour · Median gross weekly pay: CA$ 1,923 a week

    Official occupation group: Professional occupations in applied sciences (except engineering) (NOC 2021 212)

    Usual gross wages of full-time employees (30 hours or more a week) at their main job, including tips, commissions and bonuses.

    Source: Statistics Canada, Table 14-10-0417-01 Employee wages by occupation, annual, 2025. Reproduced and distributed on an "as is" basis with the permission of Statistics Canada (Statistics Canada Open Licence). This does not constitute an endorsement by Statistics Canada of this product.

  • Ireland

    Mean gross annual pay of the whole major group: €70,522 a year

    Major occupation group: Professionals (ISCO-08 2)

    Mean gross annual earnings, including bonuses, for the whole major occupation group in enterprises with 10 or more employees. Eurostat publishes no median by occupation.

    Source: Eurostat, Structure of Earnings Survey (earn_ses22_28), 2022, CC BY 4.0. Ruubu matched the role to an ISCO-08 major group; Eurostat is not responsible for this use of its data.

No official figure in our sources for: United States.

Figures cover everyone in the official occupation, at every experience level. They are not a job offer, a forecast or a Ruubu estimate. Ruubu matches each role to the closest official occupation. An official occupation can include related jobs.

How we choose and show official salary data

Data Analyst resume questions

What is the difference between a data analyst and data scientist resume?

Analysts emphasize reporting, dashboards and stakeholder decisions; scientists emphasize models in production. Frame your bullets accordingly.

Is Excel still worth listing?

Yes, advanced Excel still matters in many teams. Pair it with SQL and a BI tool so it does not read as your only skill.

How do I show impact without owning revenue?

Quantify decisions enabled, hours saved through automation, error reductions and adoption of the dashboards you built.

Should a data analyst resume include a portfolio?

Yes. Link two or three projects with a clear business question, the method and the finding. Use public datasets or anonymized work, and write short summaries instead of long code dumps.

Do I need Python as a data analyst?

Not for every role, but it helps. SQL and a BI tool are the baseline, and Python with pandas shows you can handle larger or messier data. Include it only if you can use it without help.

Keep reading

How we write and review resume examples: editorial policy.

Start from this data analyst example and build yours free

Open it in the editor, put in your own details and download a PDF free. Already have a resume? Get a score out of 100 from 14 checks, with a list of what to fix first.

Check my resume free