Data Analyst Resume
Skills & ATS Keywords

The skills and ATS keywords a Data Analyst resume actually needs in 2026, sorted by demand, mapped to seniority, and shown inside real bullets. Written by a former Google recruiter who has spent 12 years screening data resumes and knows the analyst track is its own discipline, not a stop on the way to data science.

Emmanuel Gendre, former Google Recruiter and Tech Resume Writer

Authored by

Emmanuel Gendre

Tech Resume Writer

What this page covers

The Data Analyst resume skills and keywords that matter in 2026

The screen is keyword-based

You are about to redo your analyst resume. The familiar pain: ATS software ranks you on a list of skills and keywords, then recruiters take six seconds to confirm the screen, and you are staring at a blank doc wondering which terms a Data Analyst is supposed to surface in 2026. SQL goes without saying, but how deep? Tableau or Looker first? Does pandas belong on the lead row, or is that crowding the page with data-science vocabulary that does not match the role?

This page is the cheat sheet

What follows is the ranked roster of hard skills, soft skills, and ATS keywords a Data Analyst resume needs today, organized by category and by seniority, in the exact phrasing I would put on the page after 12 years of recruiting (including many years at Google). Want a layout that already has the right rows filled in? See the Data Analyst resume template.

Data Analyst resume keywords & skills at a glance

The fast answer, two ways

Heads up: the rest of this page goes deep on Data Analyst resume skills and ATS keywords. If you only have two minutes, the two tools below do most of the work: a 2026 baseline list of the keywords every analyst resume should carry, and a JD scanner that pulls the terms specific to the role you actually want to apply to.

Industry-standard Data Analyst resume skills

These are the 18 skills and ATS keywords that turn up most consistently across 2026 US Data Analyst postings. No specific JD picked yet? This list is the floor every analyst resume should clear. Color legend: blue means a hard filter, teal means a strong supporting signal, grey means a differentiator that lifts you above the pile.

  1. 1SQL97%
  2. 2Tableau71%
  3. 3Excel82%
  4. 4Python62%
  5. 5A/B Testing58%
  6. 6Dashboards76%
  7. 7Looker48%
  8. 8Power BI52%
  9. 9pandas46%
  10. 10Snowflake44%
  11. 11BigQuery38%
  12. 12KPI Reporting54%
  13. 13dbt32%
  14. 14Statistics42%
  15. 15Cohort Analysis29%
  16. 16Mode / Hex24%
  17. 17Amplitude22%
  18. 18Business Reviews26%

Extract Data Analyst resume keywords from a JD

Drop a Data Analyst job description into the box and the scanner pulls the warehouse, BI, SQL, and storytelling terms worth surfacing on your resume, sorted by tier. Everything runs locally in your browser; the JD never leaves the page.

Data Analyst: Hard Skills

8 categories to include in your resume's Technical Skills section

Starred chips are the ones recruiters expect. The monospace line at the bottom of each card is a ready paste into your Skills section.

SQL & Warehouse

Your strongest signal on the page. Analyst SQL is often deeper than data-science SQL: CTEs, window functions, reading a query plan, partitioning. Pair the language with the warehouse you actually live in.

SQL Snowflake BigQuery Redshift PostgreSQL dbt Star Schema

SQL (CTEs, window functions, optimization), Snowflake, BigQuery, Redshift, dbt

Python for Analytics

Frame Python as a notebook-and-pandas tool, not a modelling stack. Naming pandas, scipy.stats, and a notebook host signals analyst usage. Listing PyTorch or scikit-learn pipelines as a top-row skill miscategorizes you.

pandas NumPy scipy.stats statsmodels openpyxl Jupyter / Hex matplotlib

Python (pandas, NumPy, scipy.stats, statsmodels), Jupyter, Hex, Mode notebooks

BI & Visualization

Where most of your visible output lives. Pick the BI platform you ship in weekly and name it first; depth (LODs in Tableau, LookML in Looker) reads stronger than a list of every tool you once opened.

Tableau Looker Power BI Mode Hex Sigma Metabase Looker Studio

Tableau (LODs, parameter actions), Looker (LookML), Power BI, Mode, Hex

Excel & Spreadsheets

Still the daily surface for finance-adjacent and exec-facing work. Show PivotTables, Power Query, and the formula stack you actually use. Bonus points for Google Sheets paired with a BigQuery connector.

PivotTables Power Query XLOOKUP INDEX/MATCH SUMIFS Array Formulas Google Sheets QUERY()

Excel (PivotTables, Power Query, XLOOKUP, SUMIFS, array formulas), Google Sheets

Statistics & Experimentation

Analysts are graded on reading experiments well, not designing the platform. Distributions, hypothesis testing basics, significance, MDE awareness, cohort and retention curves are the right signals. Causal-inference design belongs further down the page.

A/B Test Reading Hypothesis Testing Significance / MDE Cohort Analysis Retention Curves Descriptive Stats Survival Basics

A/B test interpretation, hypothesis testing, cohort and retention analysis, survival basics

Business Storytelling & Stakeholder

The verb stack that separates analysts from report writers. Name the cadence (WBR, MBR), the audience (Product, Finance, exec board), and the artifact (narrative memo, decision doc, OKR cascade).

Weekly Business Review Monthly Business Review Executive Dashboards OKR Cascade Narrative Memos Decision Docs Board Pre-reads

Weekly and monthly business reviews, executive dashboards, OKR cascades, decision memos

Data Quality & Documentation

The trust layer. Hiring managers want to know that your numbers will not melt under audit. Name a testing pattern, a catalog, and the doc surface where your metric definitions live.

dbt Tests Atlan Collibra Metric Definitions Runbooks Confluence Notion

dbt tests, data catalog (Atlan / Collibra), metric definitions, runbooks, Confluence

Tools & Workflow

Analysts increasingly check SQL and dbt into Git, trigger downstream jobs in Airflow, and live in JIRA-style queues. Naming the workflow tools shows you fit a modern analytics-eng stack, not a copy-paste-into-spreadsheet one.

Git Airflow (consumer) Slack Workflows JIRA Linear Asana

Git (SQL + dbt versioning), Airflow (triggering refreshes), Slack workflows, JIRA

Data Analyst: Soft Skills

How to incorporate soft skills in your Data Analyst resume

Writing “communication” or “detail-oriented” in a Skills row carries no weight on an analyst resume. The recruiter reads soft signals out of your bullets. Here is what hiring teams want to see, and one bullet pattern per skill.

Executive narrative

An analyst's hardest job is making a VP trust a chart they did not build. Bullets that name the room, the cadence, and the call signal that you have actually been in those meetings.

How to show it

Authored the weekly business review deck for the Marketplace SVP, turning a four-segment retention cliff into a recommendation that re-scoped the Q3 launch down to two priority cohorts.

Stakeholder negotiation

Two teams will argue about whose definition of “active user” is right. The senior analyst is the one who calls the meeting, writes the metric memo, and gets sign-off.

How to show it

Negotiated a single activation metric across Product, Growth, and Finance, drafting the canonical definition and shipping it as a dbt-governed view that ended six months of cross-team reporting drift.

Self-service enablement

Senior analysts are scored on whether they reduce future tickets, not how many they personally answer. Show the runbook, the office hours, the curriculum, the dashboard catalog.

How to show it

Built a self-service SQL curriculum and weekly analyst office hours, cutting incoming ad-hoc requests 62% in a quarter and freeing the team for two high-priority deep-dives.

Mentorship of junior analysts

A clear marker for the L3 and L4 line. Show the count, the artifacts, and where your mentees ended up: a guild, a playbook, an onboarded hire who is now shipping.

How to show it

Mentored 3 junior analysts through SQL and dashboard reviews, ran the monthly analytics guild, and authored the team's metric-definition handbook now used across four product surfaces.

Comfort with ambiguity

When the metric is fuzzy and the stakeholder cannot articulate what good looks like. This is the trait Staff-level analyst loops probe hardest, often through a take-home framing exercise.

How to show it

Stood up the first measurement framework for a brand-new creator-tier launch with no historical baseline, defining the north-star and two guardrail metrics that shaped five subsequent quarterly rollouts.

ATS keywords

How ATS read your Data Analyst resume keywords

What the parser is actually doing with your resume, how to pull the right terms out of a target job description, and the 25 ATS keywords every Data Analyst resume should carry in 2026.

01

What the parser is doing

Today's hiring platforms (Workday, Greenhouse, Lever, iCIMS) lift your resume into a structured profile, then score it against a keyword set the recruiter or hiring manager entered. Nobody hits a reject button on your file; you simply slide down the queue. Keywords decide who reads the page.

02

Position changes the weight

A handful of parsers weight where a term sits (in your title line, your Skills row, the opening words of a bullet) more heavily than how many times it appears overall. A keyword that lives only at the bottom of your resume counts less than the same keyword surfaced in your summary and your skills block.

03

Repeat naturally, do not stuff

Putting “SQL” in your Skills row and again in two work bullets reads as normal usage. Pasting it twelve times in white text at the bottom of the page is keyword stuffing and modern parsers catch it. Two to four organic placements per priority term is the sweet spot.

Mining your target JD

A 3-step keyword extraction loop

STEP 01

Pull five target postings

Open five Data Analyst job descriptions at the seniority and company shape you are chasing. Drop them into one scratch document so you can scan them together.

STEP 02

Count the repeats

Highlight every tool, method, or noun that appears in 3 or more of the 5 posts. That is your must-include set. Terms that show up in only one or two move to a smaller “add if honestly true” bucket.

STEP 03

Match against your resume

Each must-include term should live in both your Skills row and at least one bullet. Gaps either get filled with true experience or tell you the posting is not actually a fit for your background today.

The 25 keywords that matter

Data Analyst ATS keywords ranked by importance, 2026

Frequencies reflect ~300 US Data Analyst postings I read across LinkedIn, Indeed, and company career pages in early 2026. The tier reflects how much weight a recruiter or hiring manager puts on each term during a screen.

Keyword
Tier
Typical JD context
JD frequency
SQL
Must
“Advanced SQL, CTEs and window functions”
Excel
Must
“Advanced Excel including PivotTables”
Dashboards
Must
“Build and maintain executive dashboards”
Tableau
Must
“Proficiency with Tableau or similar BI”
Python
Must
“Working knowledge of Python (pandas)”
A/B Testing
Must
“Read and interpret A/B test results”
KPI Reporting
Strong
“Own KPI tracking for the business”
Power BI
Strong
“Power BI dashboards for the finance org”
Looker
Strong
“Looker (LookML modelling)”
pandas
Strong
Notebook-based exploration requirement
Snowflake
Strong
Modern warehouse stack
Statistics
Strong
“Strong grounding in applied statistics”
BigQuery
Strong
GCP-stack companies
dbt
Strong
Modern analytics-eng companies
Cohort Analysis
Strong
Product analytics expectation
Business Reviews
Strong
WBR / MBR ownership at mid+ levels
Mode / Hex
Bonus
Notebook-based analyst tooling
Amplitude
Bonus
Product analytics platforms
Power Query
Bonus
Excel power-user expectation
Retention Curves
Bonus
Consumer and subscription roles
Funnel Analysis
Bonus
Growth and product analyst roles
Metric Definitions
Bonus
Senior analyst, source-of-truth ownership
Sigma
Bonus
Warehouse-native BI tools
Looker Studio
Bonus
Marketing / SMB analyst roles
OKR Reporting
Bonus
Strategy and ops analyst roles

I read your analyst skills for free

Send the PDF. I will tell you which keywords your resume is missing, where the SQL and dashboard bullets are underselling you, and which rows in the Skills section are doing nothing.

Free, within 12 hours, by a former Google recruiter.

Get a Free Resume Review today

I review personally all resumes within 12 hrs

PDF, DOC, or DOCX · under 5MB

Qualifications by seniority

What Junior, Mid, Senior, and Lead Data Analysts are expected to list

The category labels look similar across levels. What shifts is dashboard ownership, query volume, stakeholder ladder, and how much of the metric layer you set. Listing Lead-level work on a junior resume backfires; listing only junior work on a senior resume sinks you below the line.

  1. L1 · JUNIOR

    Data Analyst I / Associate

    0 to 2 years. You ship 4 to 12 dashboards under a senior analyst's review, learn SQL on the warehouse the team uses, and support one or two PMs week to week.

    SQL Tableau Excel PivotTables Google Sheets KPI Tiles dbt (intro) JIRA
  2. L2 · MID

    Data Analyst II

    2 to 5 years. You own analytics for a product surface (10 to 30 dashboards), ship 25 to 60 SQL queries a sprint, run a monthly business review, and read A/B tests for the team.

    SQL (window functions) Tableau / Looker pandas A/B Test Reading Cohort Analysis dbt Snowflake Monthly Business Review
  3. L3 · SENIOR

    Senior Data Analyst

    5 to 8 years. You lead analytics for a product area (50+ dashboards), partner with two or three directors, mentor two or three juniors, and author the metric definitions other teams cite.

    Query Optimization LookML Tableau LODs Metric Governance WBR Authoring Stakeholder Management Mentorship Cross-team Roadmaps
  4. L4 · LEAD / PRINCIPAL

    Lead / Principal Data Analyst

    8+ years. You hold cross-team analytics ownership, brief the exec board on a fixed cadence, set the BI roadmap, and call vendor decisions (Tableau vs Looker migrations, BI consolidation).

    BI Roadmap Tooling Migration Exec-board Cadence Org-wide Metrics Vendor Selection Hiring Loops Analytics Strategy

Placement & format

How to list these skills on your resume

One Skills section, 6 to 8 categorized rows, parked under the Profile Summary. The same keywords then earn their keep again inside your work bullets.

01

Placement

Drop it in immediately after your Profile Summary, above Work Experience. Recruiters scan from the top down, and parsers like Workday or Greenhouse pick up keywords more cleanly when they sit in a clearly labelled block near the top of the page.

02

Format

Categorize the block, do not run it as one long comma-soup paragraph. Pick 6 to 8 row labels (SQL & Warehouse, Python, BI, Excel, Statistics, Storytelling, Data Quality, Workflow). Each row carries one line of 4 to 8 comma-separated tools.

03

How many to include

Aim for 28 to 40 concrete tools and methods. Fewer than 24 reads thin for an analyst at any level; more than 45 reads as padding. Every entry has to be a real noun or technique, not a vague trait.

04

Weaving into bullets

When you cite a number, name the tool that produced it. The version that clears both the recruiter scan and the ATS keyword filter looks like this:

Weak

Built dashboards that helped the team make decisions faster.

Strong

Built 14 Looker dashboards on Snowflake + dbt, used in the Marketplace MBR, cutting weekly prep from 5 hours to under 1.

Same outcome, but the second one surfaces four extra keywords (Looker, Snowflake, dbt, MBR) and reads as senior analyst work.

Quality checks

  • Match the JD spelling exactly. “Power BI” not “PowerBI”; “A/B Testing” not “split testing.”
  • Skip proficiency self-ratings (“Expert SQL”). They are unverifiable and they soften the line.
  • Group rows by intent rather than alphabet order. The recruiter eye lands on the category labels first, not the tool names inside them.
  • Every priority keyword on your Skills row should also appear in at least one bullet. The Skills row states the claim; the bullet proves it.

Skills in action

Five real bullets, with the skills wired in

Each bullet does three things at once: names the work, names the tool, names the result. The chips below each one show what a recruiter (and the parser) will lift out.

01

Wrote production-grade SQL across Snowflake and dbt for 180+ recurring queries, refactoring slow joins with window functions and incremental dbt materializations, cutting average query runtime from 48s to 6s.

SQLSnowflakedbtQuery Optimization
02

Built and maintained 22 Tableau and Looker dashboards for executive, product, and ops audiences with drill-down filters and derived calculations, lifting self-service adoption from 38% to 72% and reaching 1,400+ weekly active users.

TableauLookerDashboardsSelf-service
03

Defined and governed 24 core business metrics including DAU/MAU, retention curves, and gross-order-value composition, shipping them as a dbt metric layer plus a company-wide data dictionary that ended cross-team metric drift across 4 leadership reviews per quarter.

Metric DefinitionsdbtCohort AnalysisGovernance
04

Read 31 A/B tests for Pricing and Subscription, checking sample-size and stratification, applying CUPED variance reduction, and producing causal versus correlational readouts that gated 9 experiment-driven launches without false-positive shipped wins.

A/B TestingStatisticsCUPEDExperiment Reading
05

Authored 48 strategic narratives for executive review including board pre-reads, launch postmortems, and quarterly retros, translating cohort and funnel data into recommendations that shaped 3 multi-quarter strategic bets.

Business ReviewsStorytellingNarrative MemosFunnel Analysis

Pitfalls

Six common mistakes on Data Analyst resumes

I read these on analyst resumes every week. Each one is cheap to fix once you spot it.

Selling yourself as a junior data scientist

Leading with ML frameworks, MLflow, or scikit-learn pipelines for an analyst posting tells the screener you are aimed at a different role. The recruiter passes you on to a DS pool you will not clear.

Fix: Lead with SQL depth, BI ownership, and business reviews. Save modelling vocabulary for the DS resume.

SQL listed as a single bare line

Writing “SQL” with nothing around it suggests basic SELECT comfort. Analyst SQL is often the deepest signal on the page; treat it that way.

Fix: Spell out CTEs, window functions, query optimization, and the warehouse you actually use on the same line.

A wall of BI tools with no depth

Tableau, Looker, Power BI, Mode, Hex, Metabase, Looker Studio, Sigma in one row reads as: this person opened a lot of trial accounts. Recruiters do not believe weekly use of seven BI tools.

Fix: Name the two you ship in (with one depth signal each: LODs in Tableau, LookML in Looker). Drop the rest into a short exposure line.

No named warehouse

“Cloud warehouses” with no specific platform misses keyword filters and reads as imprecise. Recruiters search for Snowflake, BigQuery, or Redshift by name.

Fix: Name the warehouse you use. Add one or two services or patterns (partitioning, micro-partitions, materialized views) on the same line.

Output verbs that hide the work

“Provided insights,” “supported the team with data,” and “delivered analyses” tell the recruiter nothing. They survive ATS once and disappear in the human read.

Fix: Swap the soft verb for the artifact: dashboard, WBR memo, funnel deep-dive, metric definition, A/B test readout.

Skills row that does not match the bullets

Looker on your Skills row but every bullet mentions only Tableau reads as inflation. ATS catches the keyword once; the recruiter notices the mismatch in twenty seconds.

Fix: Every priority tool on the Skills row should show up in at least one bullet as proof. If it does not, cut it.

Not sure if your Skills section is filtering you out?

Send the resume. I will tell you which keywords are absent, which ones are padding, and which bullets are letting your SQL and dashboard work go unseen.

Free, line-by-line feedback within 12 hours, by a former Google recruiter.

Get a Free Resume Review today

I review personally all resumes within 12 hrs

PDF, DOC, or DOCX · under 5MB

Frequently asked

Data Analyst Skills & Keywords, Answered

Aim for 28 to 40 named tools and methods, sorted into 6 to 8 short category rows. Anything thinner reads as a junior profile; anything past 45 reads as padding. The rule of thumb: if a skill is on the row, it should also turn up inside at least one bullet as proof. If you cannot point to where you used it, cut it.

Place it right after your Profile Summary and ahead of Work Experience. Most ATS platforms read a resume top to bottom and weight keywords sitting in a clearly labelled section near the top more heavily than the same words buried at the end. Keep the block to 6 to 8 short rows of categorized tools instead of one long comma-separated paragraph.

Copy the JD into a doc, mark the nouns and tools that show up two or more times, and compile a 10 to 15 item shortlist of recurring terms. Cross-check that list against your Skills row and your bullets. If a recurring term is true for you and missing from the resume, fold it into the most relevant row and the bullet that actually used it. Then run the result through an ATS Checker to confirm the parse.

Lead with the verbs that hiring teams associate with each side. For Data Analyst, the spine is SQL depth, dashboards, business reviews, and stakeholder readouts; bullets sound like reporting, drill-downs, and metric definitions. For Data Scientist, the spine is models, experiments, and ML frameworks; bullets sound like training, deployment, and lift. If you have done both, pick the target role first and rank the bullets so the matching verbs come first. Do not list ML frameworks at the top of an analyst resume unless the role explicitly asks for them.

Name the two or three you can actually defend in an interview. Most analyst job posts ask for one BI platform plus familiarity with a second; collecting every name you ever opened looks padded. Put the platform you use weekly first, add a second one you have shipped real work in, and group the rest under a short Exposure line if you must. Each named tool should also surface inside a bullet that shows what you built with it.

SQL is the non-negotiable. Python is a strong supporting signal but not required for every analyst posting. If you do real work in pandas, scipy, or notebooks, list it and back it with a bullet. If your Python use is limited to one-off scripts, leave it off the lead row and mention it modestly under a Notebooks line. A clean SQL plus Excel plus BI signal is more credible than a vague claim of Python that no bullet supports.

Tie the analysis to a decision and the decision to a number. Name the audience (which exec, which team), the cadence (weekly business review, monthly readout, quarterly retro), and the call that was made because of your work (a launch shipped, a campaign was cut, a guardrail was set). Avoid vague phrases like provided insights; replace them with the specific recommendation and the dollars, percentage points, or hours that moved as a result.

Next steps

From skill list to finished resume

The skills are the raw material. Putting them in the right structure is the work that wins screens.

Tier weights and JD-frequency numbers reflect roughly 300 US Data Analyst postings I read across LinkedIn, Indeed, and company career pages in early 2026. The figures move quarter to quarter; check your own target JDs before leaning on a single keyword.