The Data Analyst CV Guide (With Examples)

Data analyst hiring sits at the intersection of technical screening and business storytelling. Employers want someone who can pull data, yes — but also translate it into decisions. Your data analyst CVmust name the tools recruiters search for (SQL, Excel, Python, Tableau, Power BI) and prove you have used them to change outcomes, not just build another dashboard that nobody opened. This guide covers structure, keywords, and bullets that pass ATS and impress hiring managers.

What recruiters and hiring managers look for

Recruiters often run boolean searches: "SQL AND Power BI", "analyst AND stakeholder", "Python AND retail". Missing tokens mean you never appear in the shortlist. Hiring managers then read for:

• Comfort with messy real-world data (not just clean coursework datasets)
• Stakeholder communication — who consumed your analysis and what they did with it
• Relevant domain: e-commerce metrics differ from NHS operational metrics
• Progression from reporting to insight to recommendation

If your CV only says "created reports", you sound interchangeable. If it says "identified £240K annual overspend in supplier contracts and presented options to procurement lead", you sound hireable.

Recommended CV structure

1. Contact details
2. Professional summary — role, years, domain, primary tools, one impact line
3. Technical skills — grouped: Querying, Languages, BI, Spreadsheets, Other
4. Experience — reverse chronological with quantified bullets
5. Education — degree in quantitative field if applicable; bootcamp or conversion course if career changer
6. Certifications — e.g. Google Data Analytics, Microsoft PL-300, only if completed

Keep a single-column layout. Embedding dashboard images looks impressive to humans but often confuses parsers — describe the dashboard's purpose and impact in text. More on format in our ATS formatting guide.

Skills and keywords to include

Match the job ad, but typical clusters include:

• Querying: SQL (PostgreSQL, BigQuery, Snowflake, T-SQL)
• Analysis: Excel (pivot tables, Power Query), Python (pandas), R
• Visualisation: Tableau, Power BI, Looker, Google Data Studio
• Methods: A/B testing, cohort analysis, forecasting, regression (only if true)
• Soft delivery: stakeholder workshops, executive summaries, KPI definition

Spell acronyms once where helpful: "Key Performance Indicators (KPIs)". Use our keyword matching method per application.

Three before-and-after bullet examples

SQL and reporting

Before: Used SQL to extract data for weekly reports.

After: Wrote SQL queries across Snowflake warehouse (8 tables, 4M+ rows/week) to automate customer retention dashboard in Power BI; replaced manual Monday report and freed 6 analyst hours weekly.

Business insight

Before: Analysed sales data and presented findings to management.

After: Cohort analysis on 18-month transaction data identified drop-off at day 30 onboarding; recommended pricing trial that lifted 60-day retention by 9% (£1.1M projected annual revenue).

Stakeholder delivery

Before: Created Excel spreadsheets for the operations team.

After: Partnered with operations director to define SLA KPIs; built Excel/Power Query model tracking fulfilment across 3 depots — escalations for late orders fell 23% in one quarter.

Sample professional summary

Data analyst with 4 years in e-commerce and subscription businesses. Advanced SQL, Power BI, and Python (pandas); comfortable presenting to commercial and product leaders. Recently automated churn reporting covering 500K active users, enabling weekly retention decisions. Seeking analyst role in growth or product analytics.

Career changers and bootcamp graduates

Lead with a strong Projects section if commercial experience is thin: capstone, Kaggle with clear write-up, freelance analytics for a small business — each with stack and outcome. In your summary, name the pivot: "Former retail manager transitioning to data analytics; completed Data Science bootcamp (distinction) with portfolio in SQL and Tableau." Connect transferable skills: stakeholder management, KPI ownership, process discipline.

Our complete CV writing guide has more on career-change framing.

Common data analyst CV mistakes

• Listing tools without proof in experience bullets
• Bullets about "data cleaning" with no scale or consequence
• Jargon-heavy statistical terms without plain-English outcome
• Ignoring the business function you supported (marketing, finance, ops)
• One generic CV for "data analyst" roles spanning wildly different stacks
• Typos in tool names (PowerBI vs Power BI) — minor but signals carelessness

Junior, mid, and senior differences

Junior: Coursework, internships, personal projects with clean SQL and one BI tool. Show curiosity and accuracy.

Mid: Own metrics for a function; automate recurring reporting; influence team decisions.

Senior / lead: Metric strategy, cross-functional analytics roadmap, mentoring juniors, governance and data quality advocacy.

Portfolio and interview prep

Link a portfolio in contact details. Best portfolios show problem → approach → visualisation → recommendation, with readable README files. The CV still needs text keywords — interviewers may never click the link before screening.

Next steps

Name your tools, prove your impact, tailor to domain. For dual ATS and human optimisation, read how to optimise for the robot and the recruiter. Then run your CV through Cvaluate's free analysis against a real data analyst job description — you will see keyword gaps and bullet rewrites in under a minute.