Junior Data Analyst Resume Example

A complete, annotated resume for an early-career data analyst. Every section is broken down — so you can see exactly what turns 1.5 years of experience into interview callbacks.

Scroll down to see the full resume, then read why each section works.

Maya Johnson
maya.johnson@email.com | (617) 555-0293 | linkedin.com/in/mayajohnson | public.tableau.com/maya.johnson
Summary

Data analyst with 1.5 years of experience translating business questions into actionable data insights. Currently at HubSpot, where I built a churn prediction dashboard that identified 340 at-risk accounts and directly informed the retention team’s Q3 strategy. Self-taught in SQL and Python with a background in economics that keeps my analysis grounded in business context, not just numbers.

Experience
Data Analyst
HubSpot Cambridge, MA (Hybrid)
  • Built a churn prediction dashboard in Tableau that identified 340 at-risk accounts by scoring engagement drop-offs, directly informing the retention team’s outreach strategy and contributing to a 12% reduction in Q3 churn
  • Optimized 15+ legacy SQL queries using CTEs and window functions, reducing average report generation time from 45 minutes to under 8 minutes and freeing up 6 hours/week of analyst bandwidth across the team
  • Designed and analyzed an A/B test for the onboarding email sequence across 18,000 trial users, identifying the variant that improved activation rate by 9% and was adopted as the new default flow
  • Delivered monthly stakeholder presentations to the VP of Customer Success summarizing retention trends, cohort behavior, and expansion revenue patterns across 3 product lines
Analytics Intern
Catalyst Marketing Group Boston, MA
  • Built weekly campaign performance reports in Google Sheets tracking spend, CPA, and ROAS across 8 client accounts, replacing a manual process that previously took the team 4 hours each Monday
  • Wrote SQL queries against the agency’s PostgreSQL database to segment audiences by engagement tier, enabling targeted email campaigns that improved click-through rates by 22% for the top 3 clients
  • Created a Python script to automate UTM parameter validation across 200+ campaign URLs per month, catching tagging errors before launch and eliminating attribution gaps in Google Analytics reporting
Projects
Tableau Public Portfolio
  • Published 6 interactive Tableau dashboards analyzing public datasets including NYC 311 complaints, U.S. housing affordability trends, and Boston bike-share ridership patterns. Portfolio has 2,800+ views and was featured in Tableau’s Viz of the Day for the housing analysis.
Skills

Analysis: SQL (PostgreSQL, BigQuery), Python (pandas, matplotlib), Excel (pivot tables, VLOOKUP, Power Query)   Visualization: Tableau, Looker, Google Data Studio   Other: Google Analytics, A/B testing, cohort analysis, Git

Education
B.A. Economics
Boston University Boston, MA

What makes this resume work

Seven things this junior data analyst resume does that most early-career resumes don’t.

1

The summary shows analytical thinking, not just tool knowledge

Maya doesn’t open with “proficient in SQL and Tableau.” She opens with what she does with those tools: translating business questions into insights. The summary immediately names a specific accomplishment — the churn dashboard that identified 340 at-risk accounts — which proves she’s not just querying data, she’s driving decisions with it.

“...built a churn prediction dashboard that identified 340 at-risk accounts and directly informed the retention team’s Q3 strategy.”
2

Bullets connect data work to business outcomes

Every bullet goes beyond “created a dashboard” or “wrote SQL queries.” The churn dashboard didn’t just exist — it identified 340 accounts and contributed to a 12% reduction in churn. The A/B test wasn’t just “run” — it improved activation by 9% and became the new default. This is the difference between a data analyst who produces outputs and one who produces outcomes.

“Built a churn prediction dashboard...contributing to a 12% reduction in Q3 churn.”
3

SQL depth is shown through query optimization

Listing “SQL” in your skills section tells a hiring manager nothing. Maya shows SQL depth by mentioning CTEs, window functions, and the concrete impact of optimization: cutting report generation from 45 minutes to 8 minutes. This signals she’s past the SELECT * stage and can actually write performant queries against production data.

“Optimized 15+ legacy SQL queries using CTEs and window functions, reducing average report generation time from 45 minutes to under 8 minutes...”
4

Visualization work is framed as communication, not decoration

The Tableau dashboard isn’t described as “visually appealing” or “interactive.” It’s described by what it communicated: which accounts were at risk and what the retention team should do about it. Maya also delivers monthly presentations to the VP of Customer Success. This positions her visualization skills as a communication tool, not an art project.

5

Self-taught skills are positioned as a strength

Instead of apologizing for not having a CS degree, Maya’s summary frames her self-taught SQL and Python as evidence of initiative. Combined with the Python automation script she built at the agency and her Tableau Public portfolio, the self-taught angle reads as “this person learns fast and builds things on their own” — which is exactly what hiring managers want to hear from junior candidates.

6

Projects compensate for limited experience

With only 1.5 years of work experience, Maya uses a Tableau Public portfolio to add depth. But this isn’t a generic “Projects” section — it has traction: 2,800+ views and a Viz of the Day feature. This proves she’s genuinely curious about data, not just clocking in. For junior analysts, a strong portfolio project can be worth as much as a second job.

“Portfolio has 2,800+ views and was featured in Tableau’s Viz of the Day.”
7

An economics degree becomes an asset for business context

A B.A. in Economics might feel like a weakness when competing against CS grads, but Maya turns it into a differentiator. Her summary mentions “a background in economics that keeps my analysis grounded in business context.” She understands supply and demand, marginal costs, and market dynamics — context that pure technical analysts often lack. The degree isn’t a gap to fill; it’s a lens that makes her analysis more useful.

Common resume mistakes vs. what this example does

Experience bullets

Weak
Created dashboards and reports for the customer success team. Used Tableau to visualize data and help with decision-making.
Strong
Built a churn prediction dashboard in Tableau that identified 340 at-risk accounts by scoring engagement drop-offs, contributing to a 12% reduction in Q3 churn.

The weak version describes a task. The strong version names the exact output, quantifies what it found, and ties it to a business result. Same dashboard, completely different signal.

Summary statement

Weak
Detail-oriented and motivated data analyst with a passion for turning data into insights. Proficient in SQL, Python, Excel, and Tableau. Seeking a role where I can leverage my analytical skills to drive business value.
Strong
Data analyst with 1.5 years of experience translating business questions into actionable data insights. Currently at HubSpot, where I built a churn prediction dashboard that identified 340 at-risk accounts and directly informed the retention team’s Q3 strategy.

The weak version is a template anyone could paste their name onto. The strong version is so specific — HubSpot, churn, 340 accounts, Q3 — that it could only belong to one person.

Skills section

Weak
SQL, Python, Excel, Tableau, Power BI, R, SPSS, Google Sheets, Looker, Data Analysis, Critical Thinking, Communication, Teamwork, Attention to Detail
Strong
Analysis: SQL (PostgreSQL, BigQuery), Python (pandas, matplotlib), Excel (pivot tables, VLOOKUP, Power Query)   Visualization: Tableau, Looker, Google Data Studio

The weak version lists every tool ever touched plus soft skills that don’t belong. The strong version is categorized, shows specific sub-skills within each tool, and only lists what Maya has actually used to ship real work.

Frequently asked questions

Can I become a data analyst without a CS degree?
Absolutely. Many successful data analysts come from economics, statistics, math, psychology, or even liberal arts backgrounds. What matters is demonstrating analytical thinking and technical skills (SQL, Python, Excel, visualization tools) through your work experience, projects, and certifications. A non-CS degree can actually be an advantage — it shows you understand the business context behind the data, not just the mechanics of querying it. On your resume, frame your degree as complementary to your technical skills, not as a gap.
What tools should a junior data analyst list?
Focus on the tools you’ve actually used to produce real work: SQL (the single most important skill), Excel or Google Sheets (including pivot tables, VLOOKUP, and data cleaning), at least one visualization tool (Tableau, Power BI, or Looker), and Python or R if you’ve used them for analysis. Don’t list every tool you’ve touched in a tutorial. Organize skills by category — Analysis (SQL, Excel, Python), Visualization (Tableau, Looker), and Databases (PostgreSQL, BigQuery) — rather than dumping them in a single line.
How do I show SQL skills on a resume?
Don’t just list “SQL” in your skills section and call it done. Show SQL depth through your experience bullets: mention specific techniques like window functions, CTEs, query optimization, or complex joins across multiple tables. Instead of “Used SQL to pull data,” write something like “Wrote SQL queries with window functions and CTEs to analyze 18-month customer retention patterns across 200K+ accounts, reducing report generation time from 3 hours to 15 minutes.” The goal is to show you’re not just writing SELECT * — you’re solving real problems with SQL.
1 in 2,000

This resume format gets you hired

This exact resume template helped our founder land a remote data scientist role — beating 2,000+ other applicants, with zero connections and zero referrals. Just a great resume, tailored to the job.

Try Turquoise free