Summary

Data analyst with 4 years of experience turning messy operational data into decisions. Built the reporting layer used daily by 120 staff, cut a weekly executive report from 6 hours to 20 minutes, and saved $340K/year by finding a pricing-rule bug in billing data.

Experience
Data Analyst
Jul 2023 - Present
Lakeshore Logistics · Chicago, IL
  • Found and quantified a pricing-rule bug in billing data (SQL audit across 2.1M invoices) that was undercharging contract clients — recovery and fix worth $340K/year
  • Built the company's operational dashboard layer in Looker (14 dashboards, 120 daily users), replacing ad-hoc spreadsheet requests that consumed ~15 analyst hours/week
  • Automated the Monday executive report with dbt + scheduled queries: 6 hours of manual assembly down to 20 minutes of review
  • Partnered with ops leadership to define 9 canonical KPIs, ending three months of dueling-numbers disputes between departments
Junior Data Analyst
Jun 2021 - Jun 2023
Midwest Retail Group · Chicago, IL
  • Analyzed promotion performance across 84 stores; findings shifted $1.1M of annual promo budget toward the two mechanics that actually lifted margin
  • Wrote and maintained 40+ production SQL queries feeding weekly merchandising reports
  • Cleaned and merged POS + loyalty data (Python/pandas) to build the chain's first repeat-purchase analysis
Projects
Chicago Transit Delay Analysis
2025
  • Public portfolio project: analyzed 3 years of CTA delay data (BigQuery, 40M rows) and published an interactive dashboard covered by a local transit blog
Skills
Analysis
SQL (advanced)Python (pandas)ExcelA/B testingStatistics
Tools
LookerTableaudbtBigQueryGit
Education
B.S. Economics
2017 - 2021
University of Illinois Urbana-Champaign
Classic resume template — ATS-friendly, free Word, PDF and Google Docs download

Writing a data analyst resume

What the ATS is matching on a data analyst resume

Analyst postings are keyword-dense, and the screeners at companies running Workday, Greenhouse or Taleo match hard skills literally. Name your tools exactly as the posting does: SQL, Python, Excel, and your BI layer (Tableau, Looker, or Power BI) belong in a dedicated skills section AND inside experience bullets where you used them — parsers weight both, humans only trust the second.

Spell out variants once: if the posting says "Power BI" don't write only "BI dashboards"; if it says "A/B testing" don't write only "experimentation." Literal matching is dumb, and it's the first gate.

The bullet formula that separates analysts

Weak analyst resumes describe activity: "analyzed sales data and created dashboards." Strong ones follow analysis → decision → number: what you examined, what changed because of it, and the measured result. "Analyzed promotion performance across 84 stores; findings shifted $1.1M of budget to the two mechanics that lifted margin" survives both a screener's skim and an interviewer's follow-up.

If you're early-career and short on business outcomes, quantify scale instead: rows processed, users of your dashboards, hours automated away. Numbers about the work beat adjectives about you.

Sections that matter for this role

Projects earn their place on an analyst resume at every level — a public analysis with a link is verifiable evidence of the whole pipeline (data acquisition, cleaning, analysis, communication). One strong project with a live dashboard outweighs five course listings.

Certifications are supporting cast, not the lead: list Google Data Analytics, Tableau, or cloud certs in education/skills, but never let them displace demonstrated work. Hiring managers read certs as "trained," projects as "can do."

Frequently asked questions

What skills should a data analyst resume include?+

The non-negotiables recruiters and parsers look for: SQL, Excel, one scripting language (usually Python), one BI tool (Tableau, Power BI, or Looker), and statistics/A-B testing literacy. Mirror the exact tool names from each posting — ATS keyword matching is literal.

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

Lead with projects: pick a public dataset, produce an analysis with a decision-shaped conclusion, publish the dashboard, and link it. Two or three of those plus SQL/Python coursework beats an empty experience section — and this template's projects block is built for exactly that.

Should a data analyst resume be one page?+

Under ~8 years of experience, yes. Analyst hiring moves fast and screeners skim; one tight page of quantified bullets outperforms two loose ones.

Is this template ATS-friendly?+

Yes — single column, standard section names, no tables or graphics, contact details in the document body. It parses cleanly through Workday, Greenhouse, Lever and Taleo, and the Word export uses real document structure rather than layout boxes.