Data Analyst Resume & CV: 2 Free Word Templates, Skills & Keywords (2026)
Data analyst hiring in 2026 is more boolean-search-driven and more decision-outcome-focused than ever. Recruiters scan for named stack components (SQL + Snowflake/BigQuery/Databricks + dbt + a BI tool + Python + an experimentation or activation tool) and outcome metrics (decisions shipped, $ revenue influenced, dashboard adoption, experiment win-rate, forecast accuracy). This guide covers the skills, stack, summary templates, bullet formulas and domain-specific framing for every data analyst role from Junior to Head of Analytics.
- Put SQL first and prove depth: window functions, CTEs, query optimisation, and the warehouse you worked in (Snowflake, BigQuery, Redshift, Databricks). SQL is the single most screened skill in data-analyst hiring.
- Name the domain and the metrics you owned — marketing, product, finance, operations, healthcare — and the specific measures. Owning a metric definition, not just reporting it, is what separates an analyst from a report builder.
- Quantify a decision your analysis drove: a pricing change, a campaign reallocation, a churn intervention, a process fix. 'Analysis reallocated $340k of spend and lifted trial-to-paid conversion 3.1 points' is the strongest available line.
- Show the modelling and BI layer: dbt models you built, the semantic layer, dashboards in Tableau, Power BI or Looker, and how many people actually use them. Adoption numbers are unusual on analyst CVs and read as impact.
- Add statistical and experimentation credibility — A/B test design and readout, cohort and retention analysis, regression or forecasting, and how you communicate uncertainty. This is what moves an analyst towards senior and analytics-engineering roles.
Data analyst resume examples (free Word templates)
Two complete one-page examples. The first is a mid-level product and growth analyst resume on US Letter (SQL, dbt, Looker, Python); the second is a junior data analyst CV on A4 in the UK style, with projects for someone early in their career (SQL, Power BI, Excel, Python). Every name, employer and number is a placeholder showing the shape of a line that names a decision and its result, not a real person. Each downloads as a Word file in one serif font with no tables or columns; replace every line with your own.
[City, State] · [email] · [phone] · linkedin.com/in/[your-name] · github.com/[your-name]
Professional summary
Data analyst with 4 years in B2B SaaS, owning activation and retention analytics on a Snowflake + dbt + Looker stack. Write the SQL, build the dbt models and read out the A/B tests the product team ships on. Last year: 11 analyses that changed a roadmap or pricing decision, including an onboarding test that lifted Day-7 activation from 31% to 37%.
Technical skills
SQL (window functions, CTEs) on Snowflake and BigQuery · dbt (models, tests, exposures) · Looker (LookML) · Tableau · Python (pandas, statsmodels, scikit-learn) · A/B testing in Statsig · Amplitude · Excel (pivots, Power Query) · Git · Airflow
Professional experience
- Own analytics for activation and retention at a 220-person SaaS company with 14,000 paying accounts; the product and growth teams use my analyses to decide what ships each quarter.
- Designed and read out 19 experiments in Statsig; the simplified onboarding test lifted Day-7 activation from 31% to 37% (95% CI, n=41,000) and shipped to all new signups.
- Built a churn-driver analysis in Python on 2 years of account data that named 3 early warning signs; the CS team's outreach on those accounts cut 90-day churn from 9.1% to 7.4%.
- Rebuilt the revenue and retention models in dbt with 64 tests; weekly dashboard users rose from 22 to 85 and finance stopped keeping its own spreadsheet copy.
- Replaced 9 hours a week of manual reporting by moving the Monday leadership pack into 6 Looker dashboards with scheduled delivery.
- Answered 10-15 ad-hoc SQL requests a month from sales, marketing and support, each with the query and a short written answer, so the same question was not asked twice.
- Wrote the company's first metric definitions document (32 metrics, one owner each) after finding 3 versions of "active customer" in use.
- Found a duplicate-lead bug in the CRM sync that had overstated pipeline by $640K; the fix and a daily data check went live within a week.
- Built the marketing funnel dashboard in Tableau that the team now uses to set monthly channel budgets.
- Tracked fulfilment times for 3 warehouses in Excel and SQL; the weekly report flagged a carrier problem that, once fixed, cut late deliveries from 8% to 3%.
- Automated the daily inventory report with Python and a scheduled query, saving the operations team about 5 hours a week.
Projects
- Modelled 3 years of public trip data in dbt and BigQuery and forecast weekly demand by station with Prophet; published the dashboard and a write-up of what the model gets wrong.
Certifications
dbt Analytics Engineering Certification · Tableau Desktop Specialist · Google Data Analytics Professional Certificate
Education
- Coursework: Econometrics, Probability and Statistics, Database Systems, Data Visualization.
[Town] · [email] · [phone] · linkedin.com/in/[your-name] · github.com/[your-name]
Personal profile
Maths graduate with 1 year as an analyst in a retail head office and 3 portfolio projects on public data. Write SQL against the company's sales database every day, build the Power BI reports the trading team reads on Monday, and explain the numbers in plain English. Looking for a data analyst role where the analysis changes a decision.
Technical skills
SQL (joins, CTEs, window functions) on SQL Server and PostgreSQL · Power BI (DAX, Power Query) · Excel (pivot tables, XLOOKUP, charts) · Python (pandas, matplotlib) · Tableau Public · Git · Google Analytics 4
Employment history
- Answer 20-30 data requests a month from the buying, trading and finance teams with SQL on a 40-million-row sales database, each written up with the query and the answer.
- Rebuilt the weekly trading report in Power BI, cutting the time to produce it from a day to 2 hours and giving 35 managers a version they can filter themselves.
- Analysed 18 months of markdown data and showed that promotions on 2 product ranges sold no extra units; the buying team ended them, saving an estimated £120K a year.
- Found and documented 6 places where store codes did not match between systems; the fixes stopped a recurring gap in the regional sales figures.
- Present a 10-minute data summary at the monthly trading meeting.
- Worked 16 hours a week through university; trusted with cashing up and the weekly waste log, which I moved from paper to a shared spreadsheet.
- Used the waste log to show the store manager which bakery lines were overproduced on weekdays; the morning bake plan was cut back and weekly bakery waste fell by about a quarter.
Projects
- Cleaned 10 years of Land Registry data in Python, loaded it into PostgreSQL and built a Power BI report comparing price growth with local earnings.
- Built an interactive dashboard from published NHS England data showing which trusts miss the 4-hour target most and how that changed through the year.
- Fitted a Poisson regression in Python to 5 seasons of league results and checked its predictions against the next season, with a write-up of where it fails.
Education
- Modules: Statistics, Probability, Linear Algebra, Operational Research, Programming in Python.
- Dissertation: forecasting electricity demand with time-series models.
Certifications
Microsoft Certified: Power BI Data Analyst Associate (PL-300) · Google Data Analytics Professional Certificate
Responsibilities
- Translate business questions into SQL, dbt models and dashboards that ship a decision — not a report that sits unread
- Author and maintain the SQL transformation layer (dbt Core / dbt Cloud) on the cloud warehouse (Snowflake, BigQuery, Databricks, Redshift) with tests, exposures and documentation
- Build and own executive-tier dashboards (Looker / LookML, Tableau, Power BI / DAX, Hex, Mode, Sigma, Metabase) consumed weekly by the CFO, CRO, CEO or head of product
- Design, instrument and read out A/B tests in Statsig / Eppo / GrowthBook / Optimizely; quote sample size, confidence interval and the decision shipped from each
- Run causal and statistical analyses in Python (pandas, NumPy, scikit-learn, statsmodels) or R (tidyverse, fable) — regression, time-series forecasting, cohort and survival analysis, difference-in-differences, propensity-score matching
- Operate the experimentation → activation loop end-to-end: hypothesis → ship test → read out → sync winning variant via Hightouch / Census to Iterable / Customer.io / Braze for production rollout
- Define and steward the metric layer (dbt Semantic Layer, Cube, Lightdash) so a single revenue / activation / retention definition flows across BI tools, ops dashboards and ML features
- Author dbt tests + Monte Carlo / Bigeye / Datafold monitors that catch upstream defects before stakeholder impact and protect quarter-end exec readouts from misreporting
- Partner with FP&A, RevOps, MarketingOps and ProductOps on forecast models, variance attribution, lifecycle re-architecture, pricing tests and board-tier readouts
- Mentor junior analysts on SQL performance, dimensional modelling, statistical interpretation and stakeholder communication; lead the analyst capacity model and sprint planning
- Operate AI-assisted workflows (Cursor + warehouse MCP for SQL drafting, Hex Magic for exploratory notebooks, Claude / GPT for stakeholder narrative summarisation) with dbt-test-backed validation gates
- Present findings and recommended decisions to non-technical executive audiences in a concise (3-slide, 1-page memo, or async written readout) format that makes the call easy to ship
Required skills
- SQL: advanced — window functions, recursive CTEs, performance tuning, dialect-specific quirks (Snowflake LATERAL FLATTEN, BigQuery ARRAY/STRUCT, Databricks Photon, Redshift Spectrum)
- Cloud data warehouse: Snowflake (Snowpark, Streams, Tasks, Dynamic Tables) OR BigQuery (Standard SQL, scheduled queries, BI Engine) OR Databricks (Delta Live Tables, SQL Warehouse) OR Redshift (RA3, materialised views)
- Transformation: dbt Core / dbt Cloud (models, tests, exposures, contracts, semantic layer, dbt-utils, dbt-expectations) or Dataform; orchestration via Airflow / Dagster / Prefect
- BI / dashboards: Looker (LookML modelling, Looker Studio, embedded), Tableau (Desktop, Server, Cloud, Prep), Power BI (DAX, Power Query, Fabric), Hex, Mode, Sigma, Metabase, Superset, Lightdash, Preset, ThoughtSpot
- Python: pandas, NumPy, polars, scikit-learn, statsmodels, SciPy, matplotlib / seaborn / plotly / altair; causal libraries (DoWhy, EconML, CausalImpact, PyMC, lifelines for survival)
- R (where required): tidyverse, ggplot2, dplyr, broom, fable for forecasting; mixed-effects modelling with lme4
- Statistics: hypothesis testing, regression (linear, logistic, GLM), A/B testing with confidence intervals and power calculations, sequential / Bayesian testing, time-series forecasting, causal inference (diff-in-diff, propensity-score matching, instrumental variables, synthetic control)
- Experimentation & activation: Statsig, Eppo, GrowthBook, Optimizely, VWO, Amplitude Experiment, Mixpanel Experiments, PostHog; Hightouch / Census for reverse-ETL; Segment / RudderStack / mParticle / Snowplow for event collection
- Data quality / observability: Monte Carlo, Bigeye, Lightup, Soda, Datafold (data diff, regression testing for dbt); data catalogue (Atlan, Alation, Collibra, Select Star)
- Communication: stakeholder requirements gathering, executive readout writing (1-page memo, 3-slide deck), data SLA negotiation, RACI authoring, async written communication, mentor / hire / promote loops at Senior+
Salary range
US: $62-85k entry / $85-115k mid / $115-160k senior / $150-210k staff or lead / $180-260k+ analytics manager / $230-380k+ director or VP of analytics. UK: £35-48k entry / £45-65k mid / £60-90k senior / £80-130k lead or principal / £110-170k+ head of analytics. Premiums: AI/ML adjacent +15-25%, fintech / hedge fund / quant +25-50%, FAANG-tier total comp +50-100% via equity refresh.
Typical career path
Junior / Associate Data Analyst → Data Analyst → Senior Data Analyst → Lead / Staff / Principal Data Analyst → Analytics Engineer (lateral, dbt + warehouse focus) → Analytics Manager / Head of Analytics → Director of Analytics / VP of Data → Chief Data Officer (CDO) / Chief Analytics Officer
Top resume keywords for this job
Data analyst job descriptions in 2026 vary by domain (product, marketing, finance, operations, healthcare, fintech, DTC, hedge fund), but the modern stack overlaps heavily: SQL on a cloud warehouse (Snowflake, BigQuery, Databricks, Redshift), dbt for transformation, a BI tool (Looker / LookML, Tableau, Power BI, Hex, Mode, Sigma), Python or R for analysis (pandas, scikit-learn, statsmodels, tidyverse), and a tool from the experimentation or activation layer (Statsig, Eppo, GrowthBook, Hightouch, Census). Resumes that omit the warehouse + dbt + semantic-layer literacy get filtered out of Senior+ analyst roles in 2026. See the full pillar at /data-analyst-resume for the role-by-role bullet templates.
Domain framing matters. Product analyst CVs lead with experimentation and funnel analysis — Statsig / Eppo / GrowthBook win-rate, Day-N activation lift, retention curves, pricing tests, feature-flag rollouts in Amplitude / Mixpanel / PostHog. Marketing analyst CVs lead with attribution, MMM and channel mix — incrementality tests, geo-holdout reads, marketing-mix model lift, channel reallocation $, lifecycle-program revenue contribution. Finance / FP&A analyst CVs lead with forecast accuracy, variance attribution and unit economics — quarterly forecast-vs-actual %, board-readout deliverables, scenario-modelling for the executive team, dbt + Snowflake + Excel-add-in stack. Operations and supply-chain analyst CVs lead with cost optimisation, throughput, inventory turn and forecast vs actual on inventory, freight or labour. Healthcare analyst CVs lead with population-health metrics, HEDIS measures, claims analysis, and HIPAA-compliant warehouse design. Fintech analyst CVs lead with transaction analytics, fraud signal modelling, regulatory reporting (SOX, SOC 2) and the read on quant trading desks if relevant.
The single most under-claimed metric on data-analyst resumes is decisions shipped — the count of business decisions that used your analysis as the load-bearing input. Senior analysts: 8-20 decisions/quarter, with 2-4 of them at the executive tier. Lead the experience section with 'shipped 14 decisions in 2025 including the Q3 pricing change ($1.2M ARR), the EMEA hiring freeze ($2.8M opex saved) and the lifecycle-email re-architecture (+8pp activation)' — this immediately separates you from the dashboard-builder pile.
The second most under-claimed signal is dashboard adoption. Replace 'built X dashboards' with weekly active dashboard users, hours saved per stakeholder, and time-to-decision. 'Built 12 dashboards' is weak; 'Built 11 dashboards consumed weekly by 134 GTM users replacing 22 hours/week of manual reporting (≈0.6 FTE)' is a Senior+ signal.
AI fluency is the 2026 differentiator. Name the workflow (Cursor + Snowflake MCP for first-draft SQL, Hex Magic for exploratory notebooks, Claude for stakeholder narrative summarisation), the FTE-equivalent productivity gain, and the guard-rails (review-before-ship, dbt test suite as output-validation). 'Familiar with ChatGPT' reads as a non-signal; 'Cursor + Snowflake MCP for first-draft SQL on ad-hoc requests; the dbt test suite (142 tests) plus a manual review-before-ship gate keeps the false-positive rate under 2%; saves ≈6 hours/week per analyst across the 5-person team' reads as Senior.
WadeCV tailors your data analyst resume to the specific role you are applying for — product / marketing / finance / ops / healthcare / fintech — surfacing the right stack components and outcome metrics from your experience.
Common mistakes to avoid
- Bullets that say 'analysed data', 'built dashboards' or 'wrote SQL queries' without the question being answered, the method, or the decision shipped
- Listing tools without proficiency tier or use case ('SQL, Python, Tableau, Power BI, R, Excel, Looker, dbt') instead of '(Snowflake) SQL: complex window functions, recursive CTEs, performance tuning; Python: scikit-learn, statsmodels for causal inference; Looker: LookML modelling, embedded analytics'
- Quoting dashboards built without adoption — 'built 12 dashboards' is weak; 'built 11 dashboards consumed weekly by 134 GTM users' is the screening pass
- Senior / Lead / Manager resumes framed at Junior level (ad-hoc query throughput) rather than function level (decisions shipped, $ influenced, team scope, mentor count, dbt mart authorship)
- Missing the modern stack — 'SQL + Excel + Tableau' alone reads as a 2018 analyst. The 2026 minimum is SQL + warehouse (Snowflake / BigQuery / Databricks) + dbt + a BI tool + Python + an experimentation or activation tool
- Statistical illiteracy at Senior+ — quoting 'increased conversion 23%' with no sample size, no confidence interval and no baseline reads as causally weak. Add (95% CI, n=48,000) or (vs control, p<0.05) where you have it
- AI fluency listed as 'familiar with ChatGPT' instead of the workflow — 'Cursor + Snowflake MCP for first-draft SQL, reviewed against dbt tests; saves ≈6 hours/week per analyst' is the Senior signal
- Generic positioning ('detail-oriented data analyst with strong analytical skills') instead of role-targeted (Senior product analyst, 5 years, B2B SaaS activation + retention, Snowflake + dbt + Looker + Statsig stack, 14 decisions shipped in 2025 including a $1.2M ARR pricing change)
Interview tips for this role
- Prepare a portfolio piece you can walk through end-to-end: the question, the SQL or Python, the analysis, the decision shipped and the outcome 30/60/90 days later. Always defendable live — never include a piece you cannot defend
- Practice live SQL on the dialect of the role (Snowflake, BigQuery, Postgres) — expect window functions, recursive CTEs, performance-tuning questions, and a dimensional-modelling whiteboard for Senior+
- Be ready to explain statistical concepts in plain language to a non-technical interviewer — confidence interval, p-value, sample-size calculation, multiple-comparison correction, regression-vs-causal interpretation
- Know your decisions story: for every analysis on your resume, know the question, the method, the recommended decision, the actual decision shipped, and the outcome 30/60/90 days later
- Prepare a stakeholder-conflict story: a time you disagreed with a stakeholder on the read of an analysis or the decision to ship; how you communicated it; how it resolved. Senior+ rounds always probe this
- Have a current-stack POV: which BI tool would you pick for a Series B SaaS today, and why? Which experimentation platform? Which observability tool? What dbt-test patterns do you mandate? Senior+ interviewers test for opinion + reasoning, not tool list
Frequently asked questions
What skills should a data analyst put on their resume in 2026?
The 2026 baseline is SQL (advanced — window functions, recursive CTEs, performance tuning) + a cloud warehouse (Snowflake, BigQuery, Databricks, Redshift) + dbt for transformation + a BI tool (Looker / Tableau / Power BI / Hex / Mode / Sigma) + Python or R for analysis (pandas, scikit-learn, statsmodels) + an experimentation or activation tool (Statsig / Eppo / GrowthBook / Hightouch / Census). Add named statistical methods you have actually run. For Senior+ roles, add semantic-layer authorship, data observability (Monte Carlo / Bigeye / Datafold) and AI tooling (Cursor / Hex Magic / text-to-SQL workflows). Recruiters use boolean search — 'SQL + dbt + Snowflake + Looker' beats 'data tools' every time.
How do I write a data analyst summary that gets read?
3-4 lines, top of the resume. Include level (Junior / Mid / Senior / Lead / Manager / Head), years in the role, your domain (product / marketing / finance / ops / healthcare / fintech), the named stack, and your top two outcome metrics. Strong example: 'Senior product analyst with 5 years across B2B SaaS, owning activation, retention and pricing analytics on a Snowflake + dbt + Looker + Statsig stack. Shipped 14 decisions in 2025 including the Q3 annual-default pricing test (+14% ARR-per-signup, +$1.2M ARR run-rate) and the onboarding-checklist redesign (+8pp Day-7 activation, n=82K, 95% CI).' Avoid 'detail-oriented', 'data-driven', 'passionate about insights' as openers.
How do I transition into a data analyst role from a non-data background?
Build a public portfolio of 2-3 projects with real or open datasets (Kaggle, NYC Open Data, FRED, COVID datasets); include the question, SQL or Python, analysis and recommended decision in each README. Get certified in one stack: Google Data Analytics Professional Certificate (entry), IBM Data Analyst, Microsoft Power BI Data Analyst Associate (PL-300), Tableau Desktop Specialist, dbt Analytics Engineering, Snowflake SnowPro Core. On the resume, reframe past work to highlight data-adjacent tasks (KPI reporting, metric definition, process analysis, ad-hoc reporting in Excel). Apply to roles framed as 'data analyst (career-changer welcome)' or analytics rotation programs at large enterprises.
What is the difference between a data analyst, business analyst, analytics engineer and data scientist?
Data analyst: lives in SQL + a BI tool + Python; ships decisions via dashboards, ad-hoc analyses and experiments; typically reports to head of analytics, head of product or CFO. Business analyst: lives in requirements documents, process maps, business-process modelling (BPMN), JIRA / Confluence and Excel; ships decisions via business cases and process redesigns; typically reports into a PMO, COO or business-transformation function. Analytics engineer: lives in dbt + warehouse + version control; owns the transformation layer and the metric layer; typically reports into a data-engineering or data-platform function. Data scientist: lives in Python / R + a notebook env + experimentation; ships decisions via models (forecasting, recommendation, classification, propensity, uplift) and feature stores; typically reports into product or ML platform. Pick the job title that matches your stack and your delivery shape; do not put 'data scientist' on your resume if your output is dashboards.
Should I learn dbt for a data analyst role?
Yes — in 2026, dbt literacy is the single highest-ROI skill for an analyst. dbt + warehouse (Snowflake / BigQuery / Databricks) + a semantic layer (dbt Semantic Layer / Cube / Lightdash) is now the median Senior hire baseline. Even at Mid level, dbt + tests + exposures + documentation will pull you up the salary band. Free path: dbt Learn (the official online course), the Coalesce conference talks on YouTube, and contributing one PR to dbt-utils or dbt-expectations. Add dbt Analytics Engineering Certification (paid) when you are ready.
How important is Python or R for a data analyst in 2026?
Mid+ data analyst roles now expect Python at minimum (pandas, NumPy, scikit-learn, statsmodels). R is preferred in pharma, biotech, academia and some quant trading desks; Python is preferred everywhere else. Beyond pandas, name the analysis you actually run — 'CausalImpact for marketing-campaign incrementality', 'survival analysis on subscription churn with lifelines', 'Prophet for daily revenue forecast at SKU level'. Generic 'Python (pandas)' is invisible at Senior+ screens. For Junior roles, SQL + a BI tool will get you hired; learn Python in the first 6 months on the job.
What certifications are worth getting for a data analyst CV?
Highest-ROI: dbt Analytics Engineering Certification (the 2026 differentiator), Snowflake SnowPro Core (or Databricks Lakehouse Fundamentals), Microsoft Power BI Data Analyst Associate (PL-300), Tableau Desktop Specialist or Tableau Certified Data Analyst, Google Data Analytics Professional Certificate (entry-only). Domain-specific: AWS Certified Data Analytics Specialty (cloud-heavy roles), CFA Level 1 (finance / FP&A roles), HEDIS / RHIA (healthcare analytics), HubSpot Inbound + GA4 Skillshop (marketing analytics). Skip generic Coursera 'data science' specialisations on a CV with 3+ years of real experience — they read as filler.
How do I show AI fluency on a data analyst resume in 2026?
Name the workflow, the tool, the FTE-equivalent productivity gain, and the guard-rail. Weak: 'Familiar with ChatGPT and Claude.' Strong: 'Operate Cursor + Snowflake MCP for first-draft SQL on ad-hoc requests; the dbt test suite (142 tests) plus a manual review-before-ship gate keeps the false-positive rate under 2%; saves ≈6 hours/week per analyst across the 5-person team.' For exploration: 'Use Hex Magic + Claude to draft cohort-analysis notebooks; the analyst owns hypothesis framing and outcome interpretation; this lifted ad-hoc throughput from 9 to 17 requests/sprint at the same headcount.' AI fluency without guard-rails reads as a junior signal in 2026; AI fluency with the validation layer + outcome metric is the Senior+ marker.
Related guides
Explore more guides
- ATS Resume Guides
- Career Change Resumes
- Company-Specific Resumes
- Skills Resume Guides
- Resume Bullet Examples
- Best AI Resume Builders 2026