Data Analyst Resume Example (2026): Skills, Projects & ATS Tips

Data analyst hiring is brutally competitive — and the resumes that win share a pattern: specific tools, real datasets, and business impact — the measurable effect of your work, stated in numbers. "Proficient in Excel" tells a hiring manager nothing. "Built a churn model in Python that identified $400K in at-risk revenue" gets you the interview.

Here's a complete annotated example plus the skills, project strategies, and ATS keywords for data analyst roles.

Data Analyst Resume Example (Annotated)

DANIEL OKONKWO
Lagos, Nigeria | +234 801 234 5678 | daniel.okonkwo@email.com
linkedin.com/in/danielokonkwo | github.com/danielokonkwo

PROFESSIONAL SUMMARY
Data analyst with 3 years' experience turning raw data into business decisions in fintech. Skilled in SQL, Python, and Tableau; built dashboards used by 200+ stakeholders. Seeking a senior analyst role.

TECHNICAL SKILLS
Languages: SQL (advanced), Python (pandas, NumPy, scikit-learn), R
Visualization: Tableau, Power BI, Looker, Matplotlib, Seaborn
Databases: PostgreSQL, MySQL, BigQuery, Snowflake
Other: Excel (advanced), dbt, Airflow, Git, A/B testing, statistics

Grouped by function, proficiency noted where it matters ("SQL (advanced)"). Every tool here is a searchable ATS keyword.

WORK EXPERIENCE

Data Analyst — PayStack-like Fintech, Lagos | Feb 2023 – Present
• Built Tableau dashboards tracking 15 KPIs for 200+ stakeholders; reduced ad-hoc report requests 40%
• Wrote SQL queries over 50M-row transaction tables; optimized a daily pipeline from 3 hours to 25 minutes with dbt
• Ran A/B test on checkout flow (n=80K users) that lifted conversion 7%, worth ₦45M annual revenue
• Automated monthly regulatory reports in Python, saving the compliance team 20 hours/month

Each bullet: tool + scale + business outcome. "Wrote SQL" is table stakes; "50M rows, 3h → 25min" proves seniority.

Junior Data Analyst — Retail Chain, Abuja | Aug 2021 – Jan 2023
• Cleaned and analyzed sales data for 30 stores; identified underperforming SKUs, informing a restock that cut waste 15%
• Created Power BI sales dashboard adopted by regional managers across 5 states
• Presented monthly insights to leadership in plain-language summaries

PROJECTS
Lagos Housing Price Predictor — Regression model on 10K listings (Python, scikit-learn) | github.com/danielokonkwo | 2023
• 0.82 R²; deployed as Streamlit app with 2K+ visits
Customer Segmentation Analysis — K-means clustering on e-commerce data; Tableau story with findings | 2022

EDUCATION
B.Sc. Statistics — University of Ibadan | 2017 – 2021
NYSC: 2021 – 2022 (PPA: National Bureau of Statistics, Abuja)

For Nigerian applicants: NYSC details are expected — see our Nigerian CV format guide.

Data Analyst Skills Recruiters Search For

• Querying: SQL (joins, CTEs, window functions), BigQuery, Snowflake
• Programming: Python (pandas, NumPy), R, scikit-learn
• Visualization: Tableau, Power BI, Looker, Excel dashboards
• Statistics: hypothesis testing, regression, A/B testing, cohort analysis
• Engineering adjacent: dbt, Airflow, ETL, data modeling, Git
• Business: KPI design, stakeholder communication, storytelling with data

Be honest about proficiency — "advanced SQL" should mean window functions and query optimization, not just SELECT statements. Interviewers will test you.

Writing Bullets With Business Impact

The formula: [analysis performed] + [tool/data scale] + [business decision or outcome]

• Weak: "Analyzed sales data and created reports."
• Strong: "Analyzed 2 years of sales data (SQL, 5M rows); found weekend promo drove 30% of revenue — marketing reallocated ₦10M budget accordingly."
• Weak: "Made dashboards in Tableau."
• Strong: "Built self-serve Tableau dashboard for marketing team; cut ad-hoc requests from 20/week to 3."

If you don't know the revenue impact, use operational metrics: time saved, error rates reduced, stakeholders served, decisions informed.

Projects: Your Secret Weapon

For juniors and career changers, projects are your experience. What makes a project resume-worthy:

• Real data: Kaggle datasets, public APIs, scraped data — not toy CSVs with 50 rows
• A question answered: "Which factors predict churn?" beats "I did EDA on a dataset"
• Deployed or visualized: Streamlit app, Tableau Public dashboard, or a well-written GitHub README with charts
• Documented process: data cleaning steps, methodology choices, limitations — this is what interviewers ask about

Link the GitHub repo and the live demo. A project nobody can click might as well not exist.

ATS Tips for Data Analyst Resumes

• Name tools exactly: "PostgreSQL" not just "SQL databases"; "Tableau" not "data viz tools"
• Include both "data analysis" and "data analytics" — postings use both
• Certifications help parsing: "Google Data Analytics Certificate," "Microsoft PL-300" are strong keyword signals
• Standard headings: "Technical Skills," "Work Experience," "Projects," "Education"
• Verify parsing: dashboards-as-images don't count — ensure all text is selectable, then test with the free ATS grader

Entry-Level Data Analyst Path

Breaking in? This combination works:

1. 2–3 portfolio projects with real data, deployed and documented
2. One certification (Google Data Analytics is widely recognized and affordable)
3. SQL fluency — the single most-tested skill in analyst interviews
4. Reframed experience: "Tracked inventory in Excel for retail job; built pivot reports used by manager" counts

Put Projects above Work Experience until you have 1–2 years of analyst work.

SQL Interview Prep: What They Actually Test

Most data analyst interviews include a live SQL test. The patterns that appear constantly:

• Joins: INNER, LEFT, and self-joins across 2–3 tables. Practice joining orders to customers to products.
• Aggregation with GROUP BY + HAVING: "Find customers with more than 5 orders." Filtering aggregated results trips up beginners.
• Window functions: ROW_NUMBER, RANK, LAG/LEAD — "rank employees by salary within each department."
• CTEs: Breaking complex logic into readable WITH clauses instead of nested subqueries.
• Date manipulation: Month-over-month growth, cohort retention, running totals.

If your resume claims "advanced SQL," be ready for all five. Practice on LeetCode's database problems or StrataScratch until they're automatic.

Data Analyst Salary Benchmarks (2026)

Know your market before negotiating:

• Entry-level (0–2 years): $65K–$85K US; ₦2.5M–₦5M annually in Nigeria; ₹6–10 LPA in India
• Mid-level (2–5 years): $85K–$120K US; ₦5M–₦10M Nigeria; ₹10–18 LPA India
• Senior (5+ years): $120K–$160K+ US; ₦10M–₦20M Nigeria; ₹18–30 LPA India

Specialists (analytics engineering, ML-adjacent roles) command 15–25% premiums. Remote roles at US/EU companies often pay between local and US rates — a major opportunity for analysts in Nigeria and India.

Building a Portfolio That Gets You Hired

Your GitHub is your second resume. Here's how to make it hiring-manager-ready:

1. Pin 3–4 best projects — each with a README containing: the business question, data source, methodology, key findings (with charts), and limitations.
2. Show the messy middle: data cleaning notebooks prove real-world skill. Anyone can run a model on clean data; employers want to see you handle the ugly parts.
3. Write like an analyst: plain-language summaries alongside the code. "Churn concentrated in the 18–24 segment (34% vs 12% average), driven by onboarding drop-off" — that's what stakeholders read.
4. Keep it current: a profile untouched for 18 months signals you've stopped learning. One commit a month keeps it alive.
5. Tableau Public: publish 2–3 polished dashboards there and link them. Visual proof complements code.

From Analyst to Senior: What Changes on the Resume

• Scope grows: "Analyzed campaign data" → "Owned analytics for $5M marketing budget across 4 channels"
• Influence appears: senior bullets mention decisions influenced, teams enabled, strategy shaped — not just analyses completed
• Mentorship: "Onboarded 3 junior analysts; created SQL style guide adopted org-wide"
• Ambiguity handling: "Defined North Star metric for product team amid conflicting stakeholder definitions" — senior analysts create clarity, not just charts
• Engineering depth: dbt, Airflow, data modeling appear more; pure Excel work disappears

Most data analyst resumes that get interviews lead with quantified business outcomes rather than tool lists.

The majority of hiring managers shortlist analysts whose resumes prove impact with numbers over those who merely list technical skills.

Frequently Asked Questions

What should a data analyst resume include?

A data analyst resume should include: a technical skills section grouped by function (languages, visualization, databases, other tools) with proficiency noted where relevant, work experience bullets that quantify business impact, portfolio projects with real datasets, education, and certifications. Every tool you name doubles as an ATS keyword, so mirror the job posting's stack.

How do I show impact as a data analyst on my resume?

Translate every responsibility into an outcome with numbers: dashboards built and how many stakeholders use them, query runtimes reduced, report requests eliminated, A/B test results with revenue impact. "Built Tableau dashboards tracking 15 KPIs for 200+ stakeholders; reduced ad-hoc requests 40%" beats "created reports" every time.

Do I need a portfolio for data analyst roles?

A portfolio dramatically strengthens a data analyst application, especially for career changers and juniors. Publish 2–3 projects with real datasets, documented methodology, and clear business takeaways on GitHub or a personal site, and link it in your resume header. It's the closest thing to proof of work analysts have.

What SQL level should I claim on my resume?

Be specific and honest: "SQL (advanced)" with evidence ("wrote queries over 50M-row tables; optimized a daily pipeline from 3 hours to 25 minutes") is credible. Claiming "expert" invites hard interview questions. Match your claimed level to what you can defend live — analysts are routinely tested on SQL in interviews.

How do I make my data analyst resume ATS-friendly?

Use a single-column layout with standard headings, list every tool as plain text in a dedicated skills section, and mirror the posting's exact keywords ("Power BI" vs "PowerBI" matters to literal text matching). Then verify with Cvyon's free ATS grader against the actual job posting — it shows your score and the exact keyword gaps to close.

What certifications help a data analyst resume?

Relevant ones: dbt Analytics Engineering, Google Data Analytics, Microsoft PL-300 (Power BI), Tableau Desktop Certified, AWS Certified Data Analytics. Certifications help most for career changers and juniors; for experienced analysts, quantified impact outweighs credentials. List only current, relevant certifications.

Build Your Data Analyst Resume Free

Build your resume free on Cvyon — ATS-friendly templates that keep your skills section machine-readable — then grade it against the real job posting. No signup, no watermark, no paywall.