Skip to main content
CreateCVOnline

CV advice for data analysts

How to write a data analyst CV

The defining weakness of data analyst CVs is that they describe outputs. Dashboards built, reports automated, queries written. None of it answers the question the hiring manager actually has, which is whether anything different happened in the business because you were there.

The role sits between two disciplines and gets filtered by both. A technical screen checks the stack — SQL first, then the warehouse, the BI tool and whatever you use for modelling. A business screen checks whether you can turn a question into an analysis and an analysis into a decision somebody acted on. A CV that satisfies only the first reads as a report writer; one that satisfies only the second reads as someone who will need help writing a join.

The good news is that analysts usually have the material and simply have not written it down. Every analyst has at some point told a stakeholder something they did not want to hear, killed a bad idea with a cohort chart, or found the reason a number was wrong. Those are the bullets. The dashboards are the context around them.

The first minute

What a hiring manager reads first — and in what order

Four things, in this sequence. Everything else on your CV is read in the light of them, so anything that answers one of these belongs above the fold rather than on page two.
  1. 1

    SQL, then everything else

    SQL is the non-negotiable and the first thing checked. After that: the warehouse (Snowflake, BigQuery, Redshift, Databricks), the BI layer (Power BI, Tableau, Looker), transformation (dbt, Airflow), and Python or R if the role has any modelling in it. Excel still counts, but only stated with depth.

  2. 2

    A decision that changed

    The strongest thing on an analyst CV is a sentence in the form: I looked at X, found Y, and the business did Z. Hiring managers read for this specifically, because it is the difference between an analyst who answers tickets and one who is trusted with a question.

  3. 3

    The shape of the data you have handled

    Row counts, number of sources, refresh cadence, whether it was clean or a mess, how many systems you had to reconcile. This is the analyst equivalent of scale, and it tells the reader whether your experience transfers to their environment.

  4. 4

    Domain fluency

    Retail, healthcare, finance, marketplace, SaaS, public sector. Analysis is only useful when the analyst understands what the numbers describe, so the sector you know is a real credential — and the vocabulary of that sector should show up in your bullets.

Numbers that carry weight

The metrics that actually matter for data analysts

Not every profession is measured the same way, and using the wrong kind of number is close to using none at all. These are the figures a reader in this field recognises immediately.

The decision or the money

What changed as a result of the analysis: a price adjusted, a campaign stopped, a route reallocated, a supplier renegotiated, a churn intervention launched. Where a value can be attached — cost avoided, revenue protected — attach it and say how it was estimated.

Data scale and complexity

Rows, tables, source systems, update frequency and the number of teams consuming the output. “A 400M-row events table joined to three finance systems” tells a reader more about your capability than any tool list.

Time recovered

Hours of manual reporting removed per week or per month, query runtime reduced, close reporting cycle shortened. Automation savings are easy to state precisely and are almost always understated on analyst CVs.

Adoption of what you built

Weekly active users of a dashboard, teams that replaced a spreadsheet with your model, self-serve queries run against the layer you designed. An unused dashboard is not an achievement, and stating usage is what proves yours was not one.

Structure

Section order for this role — and what to drop

Section order is the cheapest edit available to you and one of the most effective. This is the sequence that suits the way this profession is read.

Recommended order

  1. 1Contact and linksName, city, email, phone, and a portfolio or GitHub link only if the work behind it is genuinely presentable.
  2. 2Summary — three linesAnalyst type (product, commercial, financial, operational), sector, stack in one clause, and the kind of question you are used to being handed.
  3. 3Technical skillsDirectly under the summary, grouped: query languages, warehouse, BI, transformation, statistics. Order the groups to match the advert and state depth honestly rather than uniformly.
  4. 4ExperienceEach role gets a context line — data estate, team, who the stakeholders were — then bullets that end in a decision, a saving or an adoption figure.
  5. 5ProjectsWorth including early in your career or when changing sector. Two projects with a stated question, a method and a conclusion beat six notebooks on a public dataset.
  6. 6Education and certificationsDegree in two lines. Certifications only where the platform is the one the employer runs; a generic online analytics certificate adds very little after your first role.

Leave these off

  • The dashboard inventoryA list of every report you have produced is a work log. Pick the two that changed something and describe those.
  • Skill percentage bars“SQL 90%” means nothing to a reviewer who is going to test you, and the bar itself carries no text for a parser.
  • Excel listed as a headline skillOnly worth space with specifics — Power Query, Power Pivot, DAX, model auditing. On its own it signals the opposite of what you intend.
  • Tutorial projects on famous public datasetsThe reviewer has seen the Titanic dataset a great many times. A small, messy, real dataset with a genuine question is worth far more than a polished exercise everyone has done.

Before and after

Three bullets rewritten

The same work, described twice. What changes is not the vocabulary but what the sentence is willing to commit to.

Rewrite 1

Weak bullet

Created dashboards in Power BI for the sales and operations teams.

Rewritten

Built the weekly commercial dashboard in Power BI on a dbt model over Snowflake, replacing four manually maintained spreadsheets; used by 60 people across sales and operations and it removed roughly six hours of analyst time a week.

What changed: The original names a tool and an audience; the rewrite names the pipeline underneath, states what it replaced, and adds the two figures that prove it mattered — how many people use it and how much manual work it removed.

Rewrite 2

Weak bullet

Analysed customer data to identify trends and support business decisions.

Rewritten

Ran a cohort analysis of 180k subscriptions that showed churn concentrated in accounts onboarded without a setup call; the resulting change to onboarding cut 90-day churn in that cohort from 19% to 12% over the following two quarters.

What changed: The original describes the activity; the rewrite states the question, the method, the finding, the action the business took and the measured result — which is the full arc a hiring manager is reading for.

Rewrite 3

Weak bullet

Automated reporting processes to improve efficiency.

Rewritten

Rewrote the month-end reporting pack as a scheduled dbt job with tests on the six source tables; the pack now lands at 07:00 on working day two instead of day five, and three recurring reconciliation errors have not recurred since the tests were added.

What changed: “Efficiency” is replaced by two concrete outcomes — a timetable that moved by three days and a class of error that stopped happening — and the mention of tests signals engineering discipline rather than a scheduled query.

Parsers and keywords

What a parser is likely matching for in data analysts

Screening behaviour differs from employer to employer, so treat this as a checklist of terms you have genuinely earned — not a list to paste in.

Analyst screening is unusually literal because the required skills have exact product names. A filter looking for “Power BI” will not credit “BI dashboards”, and one looking for “dbt” will not infer it from “data transformation”. Spell out the tools, and spell out SQL even though it feels too obvious to state.

There is a second, quieter filter in this field: job families. “Data analyst”, “business analyst”, “BI analyst”, “analytics engineer” and “data scientist” are different roles with overlapping skills, and a CV that never uses the target title anywhere will look like a near-miss. Where your experience genuinely fits, mirror the wording of the advert in your summary.

How applicant tracking systems read a CV covers the mechanics in more detail, and the ATS-friendly templates are the layouts least likely to lose any of this.

Terms in this job family
Query and programming
SQLPythonRpandasDAXVBA
Warehouse and pipeline
SnowflakeBigQueryRedshiftDatabricksdbtAirflowETLELT
Visualisation
Power BITableauLookerLooker StudioQlikExcel
Method vocabulary
cohort analysisA/B testingregressionforecastingsegmentationdata modellingstatistical significance

None of this guarantees a shortlisting — parsers differ, and many analytics teams screen with a SQL test rather than a keyword filter. The aim is only that a term you genuinely know is present in your own sentences, so nothing you can actually do is invisible.

Avoid these

Mistakes specific to data analysts

Not the generic list. These are the failures that recur in this field in particular, and that a reader in it will notice immediately.

Stopping at the output

The most common failure in the field: the bullet ends with the dashboard, the model or the report rather than with what somebody did about it. If the analysis changed nothing, the reader has no reason to prefer you to any other analyst.

No domain context

Numbers without a business behind them are unreadable. Say what the data described — subscriptions, deliveries, patients, claims, stores — because domain fluency is a substantial part of what makes an analyst quickly useful.

Overclaiming data science

Describing a linear regression in Excel as machine learning, or a one-week course as modelling experience, is exposed in the first technical conversation. Analysts who are honest about the boundary are trusted more inside it.

Claiming statistical significance loosely

If you quote an experiment result, be ready to say what the sample was and how it was tested. Analysts get asked this, and a shaky answer damages the rest of the page in a way it would not in another profession.

A two-column layout that splits the stack

A sidebar full of tool names is the section most likely to be scrambled or dropped by a parser — and in this field the tool names are the filter. One column is a cheap insurance policy.

Build order

How to write it, in 5 steps

Written in the order that wastes least time: gather the facts first, then shape them, then cut.
  1. 1

    List the questions you were asked, not the reports you built

    Go back through the last two years and write down the actual business questions you were handed. These become the spine of your bullets.

  2. 2

    Find the decision at the end of each one

    For each question, what did the business do afterwards? If the honest answer is nothing, pick a different question — you will have several where something did change.

  3. 3

    Write the stack as it really is

    Group query, warehouse, transformation, BI and statistics, and mark depth honestly. Put SQL first even though it feels obvious.

  4. 4

    Add scale to one bullet per role

    Rows, sources, refresh frequency, consumers. One scale figure per role is enough to calibrate the whole entry.

  5. 5

    Quantify the time you gave back

    Work out the manual hours removed by anything you automated, per week or per month. It is the easiest credible number on an analyst CV and it is almost always missing.

Templates

3 templates that suit this role

Chosen for how this profession is actually read, not for how they look in a gallery. You can switch between any of them later without retyping a word.

Data Scientist

technology · one column

Pro

Modern ATS

modern · one column

Free

Modern Clean

modern · one column

Free
  • Data Scientist (one column, parsing score 4/5) Bracketed headings, a dated gutter and room for a real technical section — a layout that looks like the working documents analysts produce, without turning skills into decorative bars.
  • Modern ATS (one column, parsing score 5/5) The parser-proof choice: one column, one rule, no graphics. When you are applying through a large employer’s portal, this is the version of your CV least likely to lose the stack.
  • Modern Clean (one column, parsing score 5/5) A hairline spine threads the sections into one continuous read, which suits a CV with a long skills block followed by three or four dense roles.

US market

If you are applying for a US résumé instead

US analytics hiring uses the same tools and much of the same vocabulary, so the adjustments are about length, framing and the way seniority is signalled.
  • One page, and expect the technical skills block to be scanned before anything else — keep it near the top and keep it tight.
  • No photo or personal details, and no degree classification: state a GPA only if it is recent and strong, otherwise just the degree, institution and year.
  • US titles skew towards “Analytics Engineer”, “Business Intelligence Analyst” and “Insights Analyst”; mirror the advert’s title in your summary rather than assuming your current one translates.
  • Quantify impact in dollars where you can, and note the scale of the business as well as the data — American readers calibrate on company size more than European ones do.

One document, two versions

The advice above is the same profession, not a different one — which is why there is no separate résumé guide for this role. Keep one document, switch the paper size to US Letter, trim to a page and remove anything personal.

Data analyst CVs: common questions

The questions that come up repeatedly in this field, answered without hedging.

The analyst CV is organised around decisions and the scientist CV around methods. An analyst leads with the business question, the data they reconciled and what changed; a scientist leads with modelling approach, evaluation and deployment. Applying for analyst roles with a methods-first CV makes you look overqualified and impractical, and applying for science roles with a decisions-first CV makes you look like you have not built a model. Write for the one you want and be honest about the boundary.

Write your data analyst CV tonight

Open the editor with one of the templates above, work through the five steps, and download a PDF when it reads the way you want. Switching template later keeps every word.

Free plan includes the editor and PDF download.