Two-column resume template

Data Analyst Resume Template

A two-column analyst resume that puts your SQL, Python and dashboard skills in a sidebar and your business results in the main column, so hiring managers see what you can do with data and call you in.

Written by Rajarshi BhowmickUpdated

Two-columnATS-safePDF download
Skills sidebar
Your stack at a glance
1 page
Fits projects and experience
ATS-safe
Text-based, standard headings

Free to start. Used by 500K+ job seekers.

Analyst resume template preview

Why this template works

Your stack in one glance

SQL, Python, Excel and BI tools sit in a sidebar, so a recruiter confirms your technical fit in seconds.

Room for projects

Space for two or three data projects with links, which matters most for freshers and career switchers.

Business impact first

Bullets are built to show decisions your analysis changed, not just the tools you used.

Who it's for

Data analysts, business analysts, MIS executives, BI developers and product analysts, plus freshers and career switchers moving into analytics.

How to fill it in, section by section

Copy these lines and make them yours. Or upload your resume and we fill the template for you.

Summary

Your level, your main tools and one business result your analysis drove.

Data analyst with three years in retail analytics, skilled in SQL, Python and Power BI. Built a pricing dashboard that lifted gross margin by 2.4 points.
Technical skills

Group tools by type and list only what you can use in a live test.

SQL: PostgreSQL, BigQuery | Python: pandas, NumPy | Power BI, Tableau | Excel: pivots, Power Query | A/B testing, regression
Experience

Each bullet: the question, the analysis and the decision or result it led to.

Analysed 18 months of churn data in SQL and found 3 drivers, informing a retention offer that cut churn by 14%.
Projects

Two or three projects with the dataset, method, result and a link.

Delivery delay analysis: cleaned 120,000 orders in Python and built a Tableau dashboard showing the 4 routes behind 60% of delays. github.com/yourname
Certifications

Recognised certificates, with the issuer and year.

Power BI Data Analyst, PL-300, 2025

Analyst template guide

What makes a data analyst resume work?

A strong data analyst resume proves two things fast: that you can handle the tools, and that your analysis changes decisions. Hiring managers scan for SQL, Excel, Python or R, and a dashboard tool such as Power BI or Tableau. Then they look for the outcome: revenue found, costs cut, time saved or a question answered. A resume that lists tools without results looks like a course certificate. This data analyst resume template puts your stack in a sidebar and your impact in the main column, so both are visible in seconds.

Best format for a data analyst resume

Use one page and reverse-chronological order. With experience, the main column runs Summary, Experience, Projects, Education. As a fresher or career switcher, move Projects above Experience, because your projects are your strongest proof. Keep the sidebar for skills grouped by type, certifications and links to GitHub or a portfolio.

Data analyst resume summary examples

  • Fresher: "Statistics graduate skilled in SQL, Python and Power BI. Built three end-to-end analysis projects, including a sales dashboard used by a local retail chain."
  • Two to three years: "Data analyst with three years in e-commerce. Built pricing and churn analyses that lifted margin by 2.4 points and cut churn by 14%."
  • Senior analyst: "Senior analyst with seven years in fintech, leading a team of 4. Designed the A/B testing process now used across 9 product teams."
  • Career switcher: "Former operations executive moving into analytics, with a data analytics certificate and two SQL and Power BI projects built on real logistics data."

These are examples with made-up numbers. Use your own.

Skills to put on a data analyst resume

  • Querying: SQL, with the databases you have used, such as PostgreSQL, MySQL or BigQuery.
  • Spreadsheets: Excel with pivot tables, lookups and Power Query.
  • Programming: Python with pandas and NumPy, or R.
  • Visualisation: Power BI, Tableau or Looker.
  • Statistics: descriptive statistics, hypothesis testing, regression, A/B testing.
  • Business: stakeholder communication, KPI design, presenting findings to non-technical teams.

List only what you can use in a live test, because many analyst interviews include one. To match a specific post, run it with your resume through the resume keyword scanner.

How to write data analyst experience bullets

Use a three-part pattern: the business question, what you did with the data, and what changed. Name the tool inside the bullet so it counts as proof, not just a keyword.

  • "Analysed 2 years of marketing spend in SQL and showed 3 channels drove 70% of conversions, leading to a budget shift that cut cost per lead by 22%."
  • "Built a Tableau inventory dashboard for 40 stores, reducing stock-outs by 18% in one quarter."
  • "Designed and analysed an A/B test on checkout, which raised conversion by 3.1%."

Showing impact when you do not have exact numbers

Not every analysis ends in a clean revenue figure. You can still show impact through scale and use: how much data you worked with, how many people used your dashboard, how often a report is read, or which decision it informed. "Built a weekly sales dashboard used by 25 regional managers to set targets" is credible and specific without inventing a percentage. Never guess a number you cannot explain in an interview.

Keywords hiring managers search for

Recruiters filtering analyst applications usually search for the tool names in the post, such as SQL, Excel, Power BI, Tableau and Python, plus terms like dashboarding, data cleaning, KPI reporting, A/B testing and stakeholder management. Use the same spelling as the post, and repeat your top three tools inside experience bullets so they appear in context, not only in the sidebar.

Linking your GitHub or portfolio

Add one clean link in your header, and a direct link under each project. Make sure each repository has a short readme with the question, data source and key finding, so a busy reviewer understands it in a minute. A public dashboard link is even better, because it shows your work without needing to run any code.

Projects for a data analyst resume

Projects carry fresher and switcher resumes, and they strengthen experienced ones too. Pick real or realistic datasets, such as public sales, transport or health data, rather than the same tutorial datasets everyone uses. For each project, write one line on the question, one on the method and tools, and one on the finding, then add a link to the notebook or dashboard. Good project ideas include a sales performance dashboard, a churn analysis, a delivery delay study or an A/B test write-up.

Data analyst resume for freshers

With no analyst job yet, lead with a summary that names your tools, then two or three projects, then any internship, then education with your score. Add a certificate such as Microsoft's Power BI Data Analyst, PL-300, or an analytics programme from a recognised university or platform. Competitions such as datathons and case challenges also count. For more on first-job resumes, see the fresher resume formats.

Data analyst resume examples by level

  • Entry level: projects first, one internship, tools in the sidebar, one page.
  • Two to four years: experience first with business results, one standout project, certifications.
  • Senior or lead: team size, processes you set up, stakeholders you advised and company-wide decisions your work shaped.
  • Business analyst: requirements gathered, processes mapped and changes delivered, with fewer statistics and more stakeholder results.

Is this analyst template ATS-friendly?

Yes. It uses two columns of real text with standard headings, which most applicant tracking systems read well, and it is marked ATS-safe. Tool names are plain words, never logos or skill bars. If you apply mainly through large company career sites, run your file through the ATS resume checker to confirm every section was read.

Mistakes on data analyst resumes

  • A long list of tools with no result showing you used them.
  • Percentages and skill bars for tools, such as "SQL 90%". They mean nothing to a recruiter.
  • Describing the analysis but not the decision it led to.
  • Broken or private project links. Test every link before you send.

Get started

Fill in the Analyst template with your tools, projects and results, or upload your current resume and let it fill the layout. Check your ATS score and download a clean PDF. Show the decisions your data changed, and you will be the analyst they want to talk to.

Similar templates

Analyst template questions

What should a data analyst put on a resume?

A summary, your technical skills grouped by type, experience bullets that show business results, two or three projects with links, education and any certifications.

How do I write a data analyst resume with no experience?

Lead with projects built on real datasets, each with a question, method and finding. Add internships, certifications and competitions, and list only tools you can use in a test.

Which skills matter most for data analysts?

SQL and Excel come first for most roles, followed by a dashboard tool such as Power BI or Tableau, then Python or R and basic statistics. Clear communication of findings matters as much as any tool.

Should I include projects on a data analyst resume?

Yes, especially in your first few years. Two or three strong projects with links often matter more than certificates.

Is a two-column resume okay for data analyst jobs?

Yes. It suits analysts because it shows many tools at a glance. This template is marked ATS-safe. Check your file with an ATS check before applying to large companies.

Which certifications help a data analyst resume?

Recognised certificates for the tools in the job post, such as Microsoft's Power BI Data Analyst, PL-300, Tableau certifications or a data analytics programme from a known university or platform. Pair each with a project that used the skill.

How long should a data analyst resume be?

One page for most analysts. Senior analysts and analytics managers with long careers can use two.

Can business analysts use this template?

Yes. Swap some technical skills for requirements gathering, process mapping and stakeholder management, and focus your bullets on changes delivered.

Turn your analysis into an interview call

Fill the Analyst template with your tools, projects and results, then check your ATS score before you apply.

Use this template