DEV Community

Thesius Code
Thesius Code

Posted on • Originally published at datanest-stores.pages.dev

Data Analyst Career Guide

#datascience #analytics #python #sql

Data Analyst Career Guide

A comprehensive career accelerator for aspiring and mid-level data analysts. Covers portfolio building, resume optimization, interview preparation, salary negotiation, and career progression from junior analyst to senior/lead roles.

Key Features

  • Portfolio Blueprint — step-by-step guide to building 5 showcase projects that hiring managers actually look for
  • Resume Templates — ATS-optimized resume templates with quantified impact bullets for analyst roles
  • Technical Interview Prep — 80+ SQL, Python, and statistics questions with detailed solutions
  • Case Study Framework — structured approach to product/business case interviews
  • Salary Negotiation Scripts — tested negotiation language for offers, promotions, and counteroffers
  • Career Ladder Map — clear progression paths: Junior → Analyst → Senior → Lead → Manager → Director
  • Networking Templates — cold outreach, informational interview, and follow-up email templates
  • 30-60-90 Day Plan — onboarding template for starting a new analyst role

Quick Start

  1. Assess your current level — use docs/self-assessment.md to identify gaps
  2. Build your portfolio — follow the project guides in templates/portfolio/
  3. Optimize your resume — use templates/resume/ with the bullet formula
  4. Prepare for interviews — work through docs/interview-prep/ by topic

Usage Examples

Portfolio Project: Cohort Retention Analysis 

-- Portfolio-worthy SQL: Monthly cohort retention
WITH cohorts AS (
    SELECT
        user_id,
        DATE_TRUNC('month', first_purchase_date) AS cohort_month
    FROM users
),
activity AS (
    SELECT
        c.user_id,
        c.cohort_month,
        DATE_TRUNC('month', o.order_date) AS activity_month,
        DATE_DIFF('month', c.cohort_month,
                  DATE_TRUNC('month', o.order_date)) AS month_number
    FROM cohorts c
    JOIN orders o ON c.user_id = o.user_id
)
SELECT
    cohort_month,
    month_number,
    COUNT(DISTINCT user_id) AS active_users,
    ROUND(
        COUNT(DISTINCT user_id) * 100.0
        / MAX(COUNT(DISTINCT user_id))
            OVER (PARTITION BY cohort_month),
        1
    ) AS retention_pct
FROM activity
GROUP BY cohort_month, month_number
ORDER BY cohort_month, month_number;
Enter fullscreen mode Exit fullscreen mode

Resume Bullet Formula 

[Action verb] + [what you did] + [using what tool/method] + [quantified result]

Examples:
- "Built automated KPI dashboard in Tableau tracking 15 metrics across 3 business
   units, reducing weekly reporting time from 8 hours to 45 minutes"
- "Designed cohort retention analysis in SQL identifying a 23% drop-off at Day 7,
   leading to onboarding flow changes that improved D30 retention by 11%"
Enter fullscreen mode Exit fullscreen mode

Technical Interview: Statistics Question 

import math

def z_test_proportions(p1: float, p2: float, n1: int, n2: int) -> dict:
    """Two-proportion z-test — a classic interview question."""
    p_pool = (p1 * n1 + p2 * n2) / (n1 + n2)
    se = math.sqrt(p_pool * (1 - p_pool) * (1/n1 + 1/n2))
    z_stat = (p2 - p1) / se
    p_value = 2 * (1 - 0.5 * (1 + math.erf(abs(z_stat) / math.sqrt(2))))
    return {"z_statistic": round(z_stat, 4), "p_value": round(p_value, 4)}

# Control 12% conversion, variant 14%, 5000 users each
result = z_test_proportions(0.12, 0.14, 5000, 5000)
print(result)  # {'z_statistic': 2.9851, 'p_value': 0.0028}
Enter fullscreen mode Exit fullscreen mode

Content Structure 

docs/
├── self-assessment.md          # Skills gap analysis worksheet
├── career-ladder.md            # Role definitions and progression criteria
├── salary-research.md          # How to benchmark and negotiate comp
├── interview-prep/
│   ├── sql-questions.md        # 30 SQL problems (easy → hard)
│   ├── python-questions.md     # 25 Python/pandas problems
│   ├── statistics-questions.md # 15 probability and stats problems
│   └── case-studies.md         # 10 business case frameworks
templates/
├── portfolio/
│   ├── project-01-cohort.md    # Retention analysis project guide
│   ├── project-02-funnel.md    # Conversion funnel project guide
│   ├── project-03-dashboard.md # Executive dashboard project guide
│   ├── project-04-forecast.md  # Time series forecasting guide
│   └── project-05-ab-test.md   # A/B test analysis project guide
├── resume/
│   ├── junior-analyst.md       # 0-2 years experience
│   ├── mid-analyst.md          # 2-5 years experience
│   └── senior-analyst.md       # 5+ years experience
└── networking/
    ├── cold-outreach.md        # LinkedIn and email templates
    └── informational-interview.md
Enter fullscreen mode Exit fullscreen mode

Best Practices

  1. Lead with impact, not tools — hiring managers care about business outcomes, not that you know pandas
  2. Show your process — portfolio projects should include problem framing, not just the solution
  3. Practice SQL on paper — many interviews are whiteboard; know syntax cold
  4. Quantify everything — "improved dashboard" is weak; "reduced reporting time by 60%" wins
  5. Tailor each application — one-size-fits-all resumes get filtered by ATS

Troubleshooting

Issue Solution
No professional data for portfolio Use public datasets: Kaggle, data.gov, Google BigQuery public datasets
Resume rejected by ATS Remove graphics/tables; use standard section headers; save as .docx
Failing SQL interviews Drill window functions and CTEs daily for 2 weeks
Low response rate on applications Rewrite first bullet of each role with measurable impact; add LinkedIn URL

This is 1 of 11 resources in the Data Analyst Toolkit toolkit. Get the complete [Data Analyst Career Guide] with all files, templates, and documentation for $19.

Get the Full Kit →

Or grab the entire Data Analyst Toolkit bundle (11 products) for $129 — save 30%.

Get the Complete Bundle →

Related Articles

Top comments (0)