Data Analyst Career Guide
Portfolio building templates, resume frameworks, interview prep for analyst roles, and skill development roadmaps.
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 SampleFile Structure 22 files
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.com/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.