← Back to all products

Data Analyst Career Guide

$19

Portfolio building templates, resume frameworks, interview prep for analyst roles, and skill development roadmaps.

📁 20 files
Markdown

📄 Product Preview

Try the interactive reader and demo tools below, or get the full product with all content unlocked.

📖 Interactive Reader (Free Preview) ⚙ Try Demo Tools 📦 Download Free Sample

📁 File Structure 20 files

analyst-career-guide/ ├── LICENSE ├── README.md ├── examples/ │ ├── career-progression-timeline.md │ └── portfolio-writeup-example.md ├── free-sample.zip ├── guide/ │ ├── 30-60-90-plan.md │ ├── project-ideas.md │ ├── salary-negotiation.md │ └── skill-roadmap.md ├── guides/ │ ├── 30-60-90-plan.md │ ├── project-ideas.md │ ├── salary-negotiation.md │ └── skill-roadmap.md ├── index.html ├── interview-prep/ │ ├── behavioral-questions.md │ ├── case-study-questions.md │ └── sql-questions.md └── templates/ ├── portfolio-template.md ├── resume-examples.md └── resume-framework.md

📖 Documentation Preview README excerpt

Data Analyst Career Guide

A comprehensive career development resource for data analysts at every level — from your first job through senior and lead roles. Includes portfolio templates, resume frameworks, interview question banks with worked answers, onboarding plans, and skill development roadmaps.

What's Inside

Guides

  • Skill Development Roadmap — Clear progression from Junior → Mid → Senior → Lead with specific skills, projects, and milestones at each level
  • Salary Negotiation Guide — Research frameworks, negotiation scripts, and counter-offer strategies specific to data roles
  • 30/60/90 Day Plan — Structured onboarding template for your first 90 days in a new data analyst role
  • Project Ideas — 15 portfolio-worthy project ideas with difficulty levels and skill focus areas

Interview Prep

  • SQL Question Bank — 25 SQL problems ranging from intermediate to advanced, with complete solutions and explanations
  • Case Study Questions — 10 business case questions with structured answer frameworks
  • Behavioral Questions — 20 behavioral interview questions with STAR-format example answers tailored to data roles

Templates

  • Resume Framework — Structure and guidelines for data analyst resumes
  • Resume Examples — 3 complete example resumes (junior, mid, senior levels)
  • Portfolio Project Template — Structure for writing up analysis projects that showcase your skills

Examples

  • Portfolio Writeup Example — A complete, real-format portfolio project writeup you can use as a model

How to Use This Guide

If you're job hunting now:

1. Start with interview-prep/ — drill the SQL and case study questions

2. Use templates/resume-framework.md to rebuild your resume

3. Review templates/resume-examples.md for inspiration

4. Use templates/portfolio-template.md to write up your best projects

If you're planning your career:

1. Read guides/skill-roadmap.md — identify your current level and gaps

2. Pick 2-3 projects from guides/project-ideas.md to build over the next quarter

3. Use the 30/60/90 plan when you land your next role

If you're negotiating an offer:

1. Go straight to guides/salary-negotiation.md — it has scripts you can adapt

Who This Is For

  • Junior analysts (0–2 years) preparing for their first or second role
  • Mid-level analysts (2–5 years) planning their path to senior
  • Senior analysts (5+ years) considering the lead/management track
  • Career switchers entering data analysis from other fields

License

MIT License — see LICENSE file.

Part of [Data Analyst Toolkit](https://datanest-stores.pages.dev/data-analyst/)

📄 Content Sample examples/career-progression-timeline.md

Career Progression Timeline: Real-World Examples

Three realistic career progression paths showing how data analysts move through levels, including the key decisions and transitions at each stage.

Path 1: The Fast-Track IC (Technical Excellence)

Timeline


Year 0-1:  Junior Analyst at mid-size SaaS company
Year 1-2:  Promoted to Data Analyst (dropped "Junior")
Year 2-4:  Senior Analyst at same company (internal promotion)
Year 4-5:  Senior Analyst at high-growth startup (external move, 30% comp increase)
Year 5-7:  Staff Analyst / Analytics Lead (IC track, not management)
Year 7+:   Principal Analyst or Head of Analytics (IC)

Key Moves

Year 0→1 (Getting Established)

  • Focused on: Learning the codebase, business model, and stakeholder needs
  • Key achievement: Automated the weekly metrics report, freeing 6 hours/week
  • Signal for promotion: Started getting direct requests from stakeholders (not just through manager)

Year 1→2 (Promotion to Mid-Level)

  • What changed: Went from executing assigned work to scoping own analyses
  • Key achievement: Identified a $200K revenue leak from a misconfigured pricing rule
  • What unlocked the promotion: Demonstrated independent judgment — proposed analyses rather than waiting for assignments

Year 2→4 (Growing into Senior)

  • What changed: Started influencing roadmap decisions, not just measuring outcomes
  • Key achievement: Designed the experimentation framework used company-wide
  • Skills developed: Causal inference, stakeholder management, executive communication
  • Salary progression: $72K → $95K → $120K (moved from LCOL to MCOL area)

Year 4→5 (External Move)

  • Why move: Hit the compensation ceiling at current company; wanted exposure to faster growth
  • How found the role: Recruiter outreach + strong portfolio on GitHub
  • Negotiation: Used current total comp + competing offer to negotiate 30% increase
  • Risk: New company, unproven culture fit

Year 5→7 (Staff/Lead IC)

  • Focus shift: Less individual analysis, more defining what the team should analyze
  • Key achievement: Architected the analytics platform (self-serve layer) that scaled team output 3x without adding headcount
  • Chose IC over management because: Loves technical depth, doesn't enjoy people management

... and much more in the full download.

Buy Now — $19 Back to Products