Resume Example

Data Analyst Resume Example: Prove Your SQL, Dashboards, and the Decisions They Drove

A complete data analyst resume example with summary options, a sample resume, the technical skills to list, achievement bullets, and ATS keywords, for analysts who query, model, and visualize data for the business.

What a Strong Data Analyst Resume Should Show

A data analyst is hired to turn raw data into answers people can act on, and the resume has to show the whole chain: getting the data, cleaning it, analyzing it, and communicating what it means. Hiring managers look first for your query and programming depth. Can you write SQL beyond simple selects, with joins, window functions, and CTEs? Do you use Python or R with pandas, or work mostly in Excel? Next they look for the reporting layer: which BI tool you build in (Tableau, Power BI, Looker), and whether your dashboards are used by real teams on a regular schedule. Then they want statistical judgment, such as A/B test analysis, cohort and funnel analysis, forecasting, or regression, applied correctly and explained plainly. The final and most persuasive piece is the decision your work changed: a pricing adjustment, a marketing budget shift, a fix to a broken signup step. This is what separates a data analyst from a business analyst. A business analyst resume centers on requirements, process mapping, and stakeholder sign-off; a data analyst resume centers on datasets, queries, models, metrics, and the measurable insight that came out of them.

Data Analyst Resume Summary Examples

Two or three sentences are enough. State your tools, the domain you analyze, and the kind of question you answer best:

  • Experienced analyst: Data analyst with five years of experience in e-commerce analytics, writing advanced SQL against Snowflake and building Tableau dashboards used weekly by marketing and merchandising leads. Designs and reads out A/B tests, owns the company’s core conversion metrics, and translates findings into clear recommendations for non-technical managers.
  • Entry-level or certificate holder: Recent graduate with a degree in economics and the Google Data Analytics Professional Certificate, skilled in SQL, Excel, and Python with pandas. Completed a capstone analyzing public transit ridership and built a Power BI dashboard published in a portfolio, plus an internship automating weekly sales reports.
  • Career changer: Former operations coordinator moving into analytics after three years building Excel models to track inventory and vendor performance. Now working in SQL and Power BI, with a portfolio of dashboards built on real operations data and a habit of starting every analysis from the business question rather than the tool.

Sample Data Analyst Resume

This sample shows a mid-level analyst applying for a senior data analyst role on a product analytics team. Employers are described generically, and the figures are illustrative: they show the type of number to include, not a benchmark. Replace each one with results from your own work.

Your Name

Data Analyst — SQL, Product Analytics, and BI Dashboards

City, ST · (555) 010-0142 · you@email.com · github.com/yourname

Professional Summary

Data analyst with four years of experience turning product and customer data into decisions for growth, marketing, and finance teams. Writes production SQL, builds dbt models and Tableau dashboards, and analyzes experiments in Python. Known for defining metrics carefully, documenting assumptions, and presenting results in a way busy stakeholders can act on.

Skills

SQL (window functions, CTEs, query tuning) · Python (pandas, NumPy, Jupyter) · Excel (pivot tables, Power Query, XLOOKUP) · Tableau and Power BI · Looker and LookML · dbt and data modeling · Snowflake and BigQuery · A/B testing and experiment analysis · Cohort, funnel, and retention analysis · Descriptive statistics and regression · Data cleaning and validation · Stakeholder reporting and data storytelling

Experience

Data Analyst II

2023 – Present

Subscription software company, product analytics team · City, ST

  • Built and maintain a Tableau executive dashboard covering activation, retention, and revenue, refreshed daily from dbt models and reviewed in the weekly leadership meeting.
  • Analyzed a two-arm onboarding experiment in Python, showing a 6% lift in seven-day activation with a confidence interval that excluded zero, which led to a full rollout.
  • Rewrote a set of slow reporting queries in Snowflake using CTEs and pre-aggregated tables, cutting dashboard load time from about 40 seconds to under 5.
  • Defined a single company-wide definition of “active user” with product and finance, ending conflicting numbers across three teams’ reports.
  • Ran a cohort retention analysis that identified a drop-off in month two for annual-plan customers and fed directly into a new renewal campaign.

Junior Data Analyst

2021 – 2023

Regional retail chain, finance and merchandising · City, ST

  • Automated a weekly store performance report with SQL and Power Query, replacing roughly six hours of manual copy-and-paste work in Excel.
  • Built Power BI reports on sales, margin, and stock levels for 30 store managers, with row-level security by region.
  • Cleaned and reconciled point-of-sale and inventory data, documenting recurring data quality issues and the fixes agreed with IT.
  • Produced a markdown analysis that helped merchandising adjust end-of-season discounts on slow-moving categories.

Education

  • Bachelor of Science in Economics — University Name, City, ST

Certifications

  • Google Data Analytics Professional Certificate — list only if held
  • Current Microsoft Power BI certification — use the exact credential name the provider shows; list only if held

Projects

  • Public transit ridership analysis in Python and Tableau Public — portfolio link

Data Analyst Skills to Include

List the tools and methods you can use without looking them up, and back the most important ones with a bullet that shows the result:

Skill areaWhat to listHow to prove it in a bullet
SQL and databasesSQL, joins, window functions, CTEs, PostgreSQL, MySQL, SQL Server, Snowflake, BigQuery, RedshiftDescribe a query or dataset you built and what it made possible
ProgrammingPython (pandas, NumPy, Matplotlib, seaborn), R, Jupyter notebooksName an analysis or automation you wrote and the time or insight it produced
SpreadsheetsExcel, Google Sheets, pivot tables, Power Query, XLOOKUP, financial and scenario modelsShow a model or report that others relied on
BI and visualizationTableau, Power BI, Looker, Looker Studio, dashboard design, DAX, LookMLSay who used the dashboard, how often, and what decision it supported
Statistics and experimentationHypothesis testing, A/B testing, confidence intervals, regression, forecastingReport the test result and the business action that followed
Data modeling and qualitydbt, star schemas, data cleaning, validation checks, metric definitionsPoint to a source of truth you created or a data error you caught
CommunicationData storytelling, written summaries, presentations to non-technical audiencesName the audience and the recommendation they adopted

Data Analyst Achievement Bullets

The strongest analyst bullets connect a method to a business outcome. Use these as patterns and fill in your own data, tools, and results:

  • Identified through funnel analysis that a mobile checkout step lost a large share of users, and worked with product to simplify it, improving mobile conversion in the following quarter.
  • Built a demand forecast in Python that replaced a spreadsheet estimate, giving the supply team an earlier warning on likely stockouts.
  • Consolidated 12 overlapping Excel reports into one Power BI workspace with scheduled refresh, cutting the reporting cycle from days to hours.
  • Analyzed marketing channel performance by cohort and recommended moving spend away from a channel with low long-term retention.
  • Wrote data validation tests in dbt that caught a broken upstream feed before it reached finance’s monthly close.
  • Presented quarterly customer churn findings to the leadership team, with a one-page summary and three prioritized recommendations.

ATS Keywords for Data Analyst Resumes

Recruiters filtering for analysts search heavily on tool names, so write them exactly as the posting does. Frequent keywords include data analysis, SQL, Python, pandas, R, Excel, pivot tables, Tableau, Power BI, Looker, dashboards, data visualization, reporting, KPIs, metrics, data cleaning, data modeling, ETL, dbt, Snowflake, BigQuery, statistical analysis, A/B testing, hypothesis testing, regression, forecasting, cohort analysis, funnel analysis, stakeholder communication, and data storytelling. Spell out an acronym once if the posting does, for example key performance indicators (KPIs) or extract, transform, load (ETL). Use only the terms that describe your real work, and repeat the posting’s top tools inside your experience bullets so they are backed by evidence rather than only listed. If a posting names a specific warehouse or BI tool you have not used, do not claim it; name the closest tool you know well and let your bullets show you can learn the rest.

Common Data Analyst Resume Mistakes

These are the gaps that most often keep a capable analyst’s resume from standing out:

  • Describing tasks (“created reports”) without saying who used them or what changed because of them.
  • Listing SQL as a skill with no sign of depth; mention the kinds of queries you write and the data volumes you work with.
  • Showing dashboards only as screenshots or images, which applicant tracking systems cannot read; describe them in text and link the portfolio separately.
  • Reporting a test or analysis result without the decision it led to, which leaves the reader to guess whether it mattered.
  • Blurring the role with business analysis, so a data-focused posting sees requirements and workshops instead of queries, models, and metrics.

Data Analyst Resume FAQs

Questions analysts often ask while writing their resume:

Is the Google Data Analytics certificate worth listing?
It is worth listing if you are entering the field or changing careers, because it shows structured training in SQL, spreadsheets, and visualization. Experienced analysts gain less from it, since their work history already proves those skills. Either way, back it up with a project or job bullet that uses what it taught.
Should I include Python if I mostly use SQL and Excel?
Include it only if you can write and explain working analysis code, such as cleaning a dataset or running a statistical test in pandas. If you are still learning, list it in a projects section with what you built instead of presenting it as a core skill.
What is the difference between a data analyst and a business analyst resume?
A data analyst resume emphasizes querying, modeling, statistics, dashboards, and the insights drawn from data. A business analyst resume emphasizes gathering requirements, mapping processes, and guiding stakeholders through change. Many people do some of both, but the resume should lead with whichever the posting asks for.
Do I need a portfolio as a data analyst?
A portfolio helps most at entry level and for career changers. Two or three projects with a clear question, a documented approach, and a published dashboard or notebook (on GitHub or Tableau Public, for example) give a reviewer something concrete to look at. Use public or anonymized data only.
How do I show impact when I do not control the decision?
Describe the recommendation you made and what the team did with it, such as a campaign that was paused, a feature that was changed, or a budget that was reallocated. If you know the follow-up result, include it; if you do not, the adopted recommendation is still meaningful evidence.

Olyres Optimization Tip

Analyst postings vary widely: one wants Power BI and DAX for finance reporting, another wants Python and experimentation for a product team. Check your resume against the exact job description in Olyres to see which tools and methods it expects that your bullets do not yet show, then add evidence from analyses you actually ran. A finance-reporting version and a product-analytics version of the same resume can share most of their content while leading with different tools and results.

Improve This Resume With Olyres

Upload your resume and a target job description to Olyres to check ATS alignment, missing keywords, weak sections, formatting risks, and AI improvement opportunities.

Check my resume

More Tech and Product Resume Examples

Recommended Next Pages