Data Analyst CV Examples & Writing Guide
A data analyst CV gets an interview when a hiring manager can see, in the first half page, the tools you query and visualise with (SQL dialect, Tableau or Power BI, Python or R, Excel), the business questions you answered and what changed because of your analysis, with numbers. Projects count when you have no job yet. Below: a full sample, personal statements, bullets, skills, project wording and an entry-level version.
Data analyst CV example (4 years of experience)
This sample is for an analyst with about four years of experience, the level most people searching for this page are at or aiming for. The name, employers and university are made up. If you are a graduate or looking for your first analyst job, the entry-level section below shows how to fill the same layout with projects and placements.
Hannah Reid
Data Analyst
Manchester · 07700 900174 · hannah.reid@email.com · linkedin.com/in/hannahreid-data · github.com/hreid-analytics
Summary
Data analyst with 4 years turning e-commerce and logistics data into decisions. Write SQL against Snowflake and PostgreSQL daily, own 14 Tableau dashboards used by 120 people, and run A/B test readouts for the marketing team. Analysis of checkout drop-off led to a change that lifted conversion 0.6 points (about £1.7m in annual revenue). Python (pandas), dbt, Excel, Google Analytics 4. Microsoft PL-300 and Tableau Desktop Specialist certified.
Experience
Data Analyst · Online homeware retailer (£240m annual revenue, 2.4m customers)
Feb 2024 – Present
- Write and maintain 60+ SQL models in Snowflake and dbt covering orders, returns, marketing spend and customer lifetime value; queries feed 14 Tableau dashboards used weekly by 120 people in marketing, merchandising and finance.
- Analysed 18 months of checkout funnel data in GA4 and Snowflake, found a 23% drop at the delivery step for mobile users, and proposed the delivery-cost display change that lifted mobile conversion from 2.1% to 2.7% (about £1.7m a year).
- Design and read out 25+ A/B tests a year for the growth team (sample size, significance, guardrail metrics), with results written up in a one-page template the Marketing Director reads before every test decision.
- Built a returns-rate model by category and supplier in Python that flagged 3 suppliers with return rates over 18%; merchandising renegotiated terms and cut returns costs by £270k in 2025.
- Replaced 9 weekly Excel reports with scheduled Tableau extracts, saving the merchandising team about 12 hours a week.
Reporting Analyst · Regional third-party logistics company (22 warehouses)
Jul 2022 – Jan 2024
- Produced daily and weekly operations reports for 22 warehouses in Power BI (on-time dispatch, pick accuracy, labour hours per order) from SQL Server and a WMS export, serving 40 managers.
- Cleaned and reconciled 1.5m order records a month with SQL and Excel Power Query, cutting reporting errors flagged by managers from 15 a month to 2.
- Built the labour forecasting model that predicted daily order volume within 8% (MAPE) and let 6 sites plan staffing a week ahead instead of a day ahead.
- Documented 30 report definitions and metric formulas in a shared data dictionary that ended monthly disputes about whose numbers were right.
Business Analytics Summer Intern · Retail bank, marketing analytics team
Jun 2021 – Aug 2021
- Segmented 400k customers by product usage in SQL and Python and built the Tableau view the campaign team used to pick 3 target groups for a credit card offer.
Education
BSc (Hons) Economics and Statistics, First Class
University in Manchester, 2022
Certifications
- Microsoft Certified: Power BI Data Analyst Associate (PL-300), 2024, renewed 2026
- Tableau Desktop Specialist, 2023
- Google Data Analytics Professional Certificate (Coursera), 2022
Skills
What analytics managers look for first
Analytics managers and the recruiters who screen for them read hundreds of data analyst CVs, most of them listing the same tools. Four things separate the interview pile from the rest.
- SQL you have actually written. Not "SQL" alone but the dialect (Snowflake, BigQuery, PostgreSQL, SQL Server, MySQL) and a bullet that shows the scale (tables, rows, models) and complexity (window functions, CTEs, performance tuning). Most interview processes include a live SQL exercise or technical test, so managers check the CV promises it.
- A business result, not a technical one. "Reduced query time" is nice. "Found the drop-off that led to a 0.6-point conversion lift" gets the interview. Every experienced analyst needs at least one bullet where a decision changed because of their work.
- One visualisation tool in depth. Tableau or Power BI (Looker, Sigma and Qlik in some companies) with the number of dashboards and the number of people who use them. Listing five BI tools reads as none.
- For entry level: projects with real data and a link. A GitHub repository or Tableau Public profile with two or three clean projects (question, data source, method, finding) does more than any certificate.
“I skip to the bullets and look for a number that a business person would care about. If every line ends in a dashboard or a report and nothing ever changed because of it, I assume they were a report factory.”
Data analyst personal statement examples (graduate, 3–4 years, senior, career change)
Three to four lines under the header. Years and sector first, then the tools you use daily, then your best result with a number, then certifications if they matter. Skip the career objective; even a new graduate has a project to describe.
Statistics graduate (BSc, 2:1, July 2026) with three portfolio projects on GitHub: a 250k-row retail sales analysis in SQL and Tableau, a customer churn model in Python (78% recall), and a public transport usage dashboard built on a city open-data set. Google Data Analytics Certificate. Ready to take on SQL queries, Python data cleaning and Tableau dashboard builds from day one.
Junior data analyst with a 6-month placement at a health insurer, where I built 5 Power BI reports on claims data (2m rows) for 30 users and automated a weekly Excel process with Python, saving 6 hours a week. SQL Server, Power BI (PL-300 certified), Python, Excel.
Data analyst with 4 years in e-commerce and logistics. Daily SQL in Snowflake and dbt, 14 Tableau dashboards for 120 users, and A/B test readouts for marketing. Funnel analysis led to a change worth about £1.7m a year in revenue. Python, GA4, Excel; Tableau and PL-300 certified.
Senior data analyst with 6 years in SaaS, owning product and revenue analytics for a company with £70m ARR. Built the metrics layer in dbt and Looker that 200 employees use, led pricing analysis behind a 2025 plan change that raised net revenue retention from 104% to 109%, and mentor 2 analysts. SQL (BigQuery), Python, Looker, Amplitude.
Financial analyst with 4 years of Excel-heavy forecasting and variance work, now moving into data analysis after completing a SQL and Python certificate and rebuilding my team's monthly reporting in Power BI (cut preparation time from 3 days to 4 hours). Comfortable with SQL joins and window functions, DAX and pandas.
Data analyst work experience bullets: weak to strong
Use this pattern: data (source, size), method (tool, technique), result (what changed, for whom, by how much). Below are common weak bullets rewritten. Change the numbers to your own; interviewers ask about every one.
| Weak | Strong |
|---|---|
| Created dashboards in Tableau. | Built 8 Tableau dashboards on sales, stock and returns from Snowflake, used weekly by 60 people across merchandising and finance; retired 11 manual Excel reports. |
| Wrote SQL queries to pull data. | Wrote 40+ production SQL models in BigQuery and dbt (customer, order and marketing tables, 300m rows), with tests that cut data-quality tickets from 12 a month to 3. |
| Analysed customer data. | Segmented 1.2m customers by purchase frequency and margin in SQL and Python; the marketing team moved 30% of email budget to the two highest-margin segments and raised email revenue 14% in one quarter. |
| Performed A/B testing. | Designed and analysed 20 A/B tests a year (power calculations, significance, guardrails), including the checkout test that raised mobile conversion from 2.1% to 2.7%. |
| Cleaned data in Excel. | Reconciled 1.5m monthly order records from 3 systems using SQL and Power Query, cutting reporting errors flagged by managers from 15 a month to 2. |
| Presented findings to stakeholders. | Delivered a monthly one-page readout to the Operations Director; 4 of the 6 recommendations in 2025 were adopted, including a staffing change that cut overtime 9%. |
| Built forecasts. | Built a daily order volume forecast in Python (Prophet) with 8% MAPE, replacing a spreadsheet that missed by 20%, so 6 warehouses could schedule labour a week ahead. |
| Automated reports. | Automated 5 weekly reports with Python and scheduled SQL, saving about 10 analyst hours a week and delivering numbers by 7am on Monday instead of Tuesday afternoon. |
Start with an example, finish in minutes.
No sign-up needed to start. Pick an example, adapt it with suggestions and preview it as you go.
Data analyst CV skills section (what to list and how)
Group skills by category and keep the list to 12 to 16 items. Name the dialect or version where it matters. Recruiters search applicant tracking systems for exact tool names; "data visualisation" alone does not match "Tableau".
- Querying: SQL (name the databases: PostgreSQL, MySQL, SQL Server, Snowflake, BigQuery, Redshift, Databricks), window functions, CTEs, query optimisation
- Visualisation and BI: Tableau, Power BI (DAX), Looker (LookML), Sigma, Qlik Sense, Google Looker Studio
- Programming: Python (pandas, NumPy, matplotlib, seaborn, scikit-learn), R (tidyverse, ggplot2), Jupyter
- Spreadsheets: Excel (pivot tables, Power Query, XLOOKUP, Solver), Google Sheets
- Data modelling and pipelines: dbt, Airflow basics, data warehousing concepts, star schemas
- Statistics: A/B testing, hypothesis tests, regression, confidence intervals, sampling, forecasting
- Product and web analytics: Google Analytics 4, Amplitude, Mixpanel, Adobe Analytics
- Tools and governance: Git and GitHub, Jira, Confluence, Snowflake or BigQuery consoles, Salesforce reports if relevant; working with personal data under UK GDPR (access controls, anonymisation, retention)
- Sector: e-commerce funnels, insurance or healthcare claims, supply chain KPIs, financial reporting, public sector data, whichever you have worked in
Do not list soft skills as words. "Communication" means nothing; "monthly readout to the Operations Director, 4 of 6 recommendations adopted" shows it. The same goes for "attention to detail": show the error rate you cut.
How to write data analysis projects on a CV (with GitHub)
Projects are the main content of a graduate's CV and a useful extra for anyone with under two years of experience. A project entry should read like a job bullet: the question, the data (source and size), the method and tools, and the finding. Link the code or dashboard. Two or three strong projects beat eight course exercises.
- 1Pick a real dataset, not the Titanic or Iris sets every recruiter has seen: UK open data (data.gov.uk, ONS, local council and transport data), Kaggle competitions with messy data, a public API, your own scraped or exported data.
- 2Start from a business-style question ("which neighbourhoods have rising fly-tipping reports and why?") rather than a technique.
- 3Do the work in SQL and one visualisation tool, plus Python if you use it. Clean the data and say how much cleaning was needed.
- 4Write a README with the question, method, findings and two charts. Recruiters click the link and spend 30 seconds; the README is what they see.
- 5On the CV: title, tools, one or two lines with the size of the data and the finding, and the link. Add a Tableau Public link if the project is a dashboard.
London Cycle Hire Demand Analysis (SQL, Tableau Public). Cleaned and analysed 5.7m journey records (2024) from Transport for London open data in PostgreSQL; found that 31% of weekday rides start at 12 docking stations near mainline rail stations, and built a dashboard proposing rebalancing hours. github.com/yourname/cyclehire
Telecoms Customer Churn Model (Python, scikit-learn). Built a logistic regression and random forest on a 7,000-customer dataset; 78% recall on churners, with contract type and tenure as top drivers. Wrote a one-page recommendation on retention offers.
Personal Finance and Inflation Dashboard (Excel Power Query, Power BI). Combined 3 years of exported bank transactions with ONS consumer price inflation data to compare personal spending against UK inflation by category; 6 DAX measures, monthly refresh.
Entry-level data analyst CV with no experience (graduate)
"No experience" usually means no job with "analyst" in the title. Almost everyone has analysed data somewhere: a dissertation or module project, a part-time job's spreadsheets, a society's membership list, a placement. Here is the order that works when the experience section is thin.
- Header with a GitHub or Tableau Public link that actually has projects in it. An empty profile is worse than no link.
- Personal statement of three lines: degree, apprenticeship or certificate, tools, and your best project with a number.
- Education near the top: degree with classification (or predicted classification), graduation date, relevant modules (Statistics, Database Systems, Econometrics, Data Visualisation), and A-level grades if you graduated recently. For a bootcamp, certificate or Level 4 Data Analyst apprenticeship, list it here with the length.
- Projects section with 2 to 3 entries written as shown above. This is your experience section for now.
- Any job, rewritten around data: a retail job where you tracked stock in Excel, a research assistant role where you cleaned survey data in R, a student job where you built the sign-up report. Give the size of the data and what someone did with your numbers.
- Certifications: Google Data Analytics Professional Certificate, Microsoft PL-300, Tableau Desktop Specialist, IBM Data Analyst Professional Certificate. Useful as keyword matches, but a manager will weigh the projects more.
- Skills section with exact tool names, honest about level. Say "Python (pandas, matplotlib)" not "Python expert" after one course.
Shift supervisor, students' union café: built the weekly sales and waste tracker in Google Sheets from till exports (1,200 transactions a week), which cut milk and pastry waste 15% over one term.
Research assistant, Department of Economics: cleaned and coded 3 waves of survey data (4,800 responses) in R and Stata, ran descriptive statistics and regressions for an academic working paper, and documented the codebook.
Data analyst placement student, health insurer (6 months): wrote SQL Server queries against 2m claims rows, built 5 Power BI reports for 30 case managers, and automated a weekly Excel process in Python, saving 6 hours a week.
Format, length and ATS keywords for a data analyst CV
- Length: one page works up to a few years of experience; two pages are normal in the UK for analysts with longer project lists, senior analysts and people managers. Recruiters read the first half page and decide.
- Order for experienced analysts: header, personal statement, experience, skills, certifications, education. Entry level: header, personal statement, education, projects, experience, skills, certifications.
- Layout: single column, clear headings, no graphics or skill bars. A clean template such as cvplex modern-blue passes applicant tracking systems (ATS) and looks current. No photo and no date of birth on a UK CV.
- Links: LinkedIn, GitHub and Tableau Public in the header as plain text URLs. Make sure the GitHub has READMEs and the Tableau Public dashboards load.
- Keywords to mirror from the advert when they are true for you: SQL, Tableau or Power BI, Python, Excel, dashboards, KPIs, A/B testing, data cleaning, data modelling, stakeholder, reporting, forecasting, plus the exact database (Snowflake, BigQuery, Redshift). The ATS matches exact strings, so write "Power BI" not "PowerBI".
- CV or resume? In the UK it is a CV, usually one to two pages. US employers call the same document a resume and prefer it shorter. Academic CVs (publications, every module) are for research roles, not analyst jobs.
Frequently asked questions
How do I write a data analyst CV?
Start with a three-line personal statement: years and sector, daily tools (SQL dialect, Tableau or Power BI, Python), and your best business result with a number. Give each job 3 to 5 bullets in the pattern data, method, result. Group skills by category with exact tool names, list certifications, and link GitHub or Tableau Public if it has real projects. One to two pages.
What skills should I put on a data analyst CV?
SQL with the databases you have used, one BI tool in depth (Tableau or Power BI), Python or R with the libraries, Excel (pivot tables, Power Query), statistics (A/B testing, regression), data cleaning and modelling (dbt if you use it), handling personal data under UK GDPR, and the sector you know (e-commerce, healthcare, finance). Show soft skills through results, not as words.
How do I write a data analyst CV with no experience?
Lead with education and a personal statement that names your tools and best project, then a Projects section with 2 to 3 entries (question, data size, tools, finding, link), then any job rewritten around the data you handled, then certifications. Put a GitHub or Tableau Public link with real work in the header. Keep it to one page.
How do I write a data analysis project on my CV?
Title, tools in brackets, then one or two lines: the size of the data, what you did, and the finding with a number, plus a link. Example: "Cycle hire demand analysis (SQL, Tableau): analysed 5.7m journeys, found 31% of weekday rides start at 12 docking stations near mainline rail stations, built a rebalancing dashboard."
Career objective or personal statement for a graduate data analyst?
A personal statement. Even without a job, you can say what you have done: your degree or certificate, the tools you used, and a project with a number. A career objective ("seeking a challenging role to grow my skills") tells the manager nothing they can check.
Which certifications help on a data analyst CV?
The Google Data Analytics Professional Certificate and IBM Data Analyst certificate for beginners, Microsoft PL-300 (Power BI Data Analyst Associate) for Power BI teams, Tableau Desktop Specialist or Certified Data Analyst for Tableau teams, and SnowPro Core or a cloud fundamentals certificate if the advert mentions that platform. A completed Level 4 Data Analyst apprenticeship also counts in the UK. They help with ATS keyword matching; projects and SQL skill decide the interview.
Ready to write yours?
The builder suggests a summary from your own experience, then checks it against the job posting.
How this page was made: a first draft was written with AI assistance from cvplex's example library, then edited and fact-checked by the cvplex Careers Team. Examples are fictional composites; numbers are illustrative. Report an error via the editorial policy page.