# Data analyst CV example and résumé tips

> A data analyst CV example with the SQL, Excel and BI skills, keywords and bullet points that show employers you turn data into decisions.

Updated 2026-10-07 by Litjob. Web version: https://getlitjob.com/cv-examples/data-analyst

A data analyst CV has one job: prove that your analysis changed something. This example shows an analyst who pairs every tool with the decision it informed and the result that followed.

## Sample CV

The person and companies below are fictional.

### Amara Mensah, Data Analyst

Data analyst with 3 years of experience in retail and fintech. I write SQL every day, build dashboards people actually use, and explain findings in plain language so teams can act on them.

#### Experience

**Data Analyst, Kola Retail Group** (Accra), 2024 to present

- Built a Power BI sales dashboard used weekly by 40 store managers, replacing 12 manual Excel reports.
- Analysed basket data in SQL to find products often bought together; the bundle offers that followed lifted average order value by 8%.
- Automated the monthly stock report with Python, saving the finance team about 2 days each month.

**Junior Data Analyst, Paylink Microfinance** (Accra), 2022 to 2024

- Cleaned and merged loan data from 3 systems into one reporting table used across the business.
- Found that reminder messages sent 2 days before a due date reduced late payments by 11%, and helped roll the change out.
- Answered 20+ ad hoc data requests a month from operations and marketing.

#### Education

- B.Sc. Statistics, University of Ghana (2022)

#### Skills

- Analysis: SQL, Excel (pivot tables, Power Query), Python (pandas), A/B testing
- Visualisation: Power BI, Tableau, Looker Studio
- Data: PostgreSQL, BigQuery, Data cleaning, Data modelling

## Data analyst summary examples

**Entry level:** Economics graduate with strong Excel and SQL skills from coursework and a 6-month internship, where I built a churn report for a telecom team. Completed 3 portfolio projects in Python and Tableau.

**Experienced:** Data analyst with 6 years in e-commerce, owning the KPI framework and self-serve dashboards for a 200-person company. Partner with product and marketing to design experiments and size opportunities.

## Skills for a data analyst CV

- Hard skills: SQL (joins, window functions, CTEs), Excel or Google Sheets (pivot tables, lookups, Power Query), A BI tool: Power BI, Tableau or Looker, Python or R for analysis, Statistics and A/B testing, Data cleaning and validation, Defining metrics and KPIs
- Soft skills: Explaining numbers to non-technical people, Asking the right business question, Curiosity, Prioritising requests (show these through your bullet points)

## Keywords recruiters and ATS look for

data analyst, SQL, Excel, Power BI, Tableau, Python, dashboards, KPIs, data visualisation, reporting, stakeholders, A/B testing

Compare your CV with a specific job ad using the free CV keyword checker: https://getlitjob.com/cv-keyword-checker

## Bullet points: before and after

- Weak: Made dashboards for the team.
  Stronger: Built a Tableau dashboard tracking 15 KPIs, now the weekly source of truth for leadership.
- Weak: Analysed customer data.
  Stronger: Segmented 50,000 customers in SQL and found a high-value group that marketing now targets separately.
- Weak: Did reporting in Excel.
  Stronger: Automated 6 weekly Excel reports with Power Query, saving 5 hours a week.
- Weak: Helped with experiments.
  Stronger: Designed and analysed an A/B test on onboarding emails that raised activation by 6%.

## Tips for data analyst CVs

### Show the decision, not just the dashboard

For each project, say what the business did with your analysis. "Led to", "informed" and "resulted in" are your friends.

### Add a portfolio if you are early in your career

Two or three projects on GitHub, Tableau Public or a simple site, with a short write-up, can stand in for experience.

### Be specific about SQL and Excel

Everyone lists them. Mention what you do with them, like window functions, Power Query or building data models.

### Mirror the tools in the posting

If a job asks for Power BI, put Power BI in your skills and in a bullet, as long as you have really used it.

## Data analyst interview questions

### Walk me through an analysis that changed a decision.

Use a real example: the question, your data, what you found and what the team did next.

### How would you find out why sales dropped last month?

Show structure: check data quality first, then break it down by region, product, channel and time.

### Write a query to find the top 3 customers by revenue in each region.

Expect a live SQL test. Practise window functions like ROW_NUMBER() and RANK().

### How do you handle a stakeholder who disagrees with your numbers?

Explain how you would check the definitions together and walk through the data openly.