Data Analyst in Edtech & Startups India 2026

Learner drop-off analysis by course module

-- Which modules cause the most learner drop-offs?
WITH module_starts AS (
  SELECT
    course_id,
    module_id,
    module_name,
    module_order,
    COUNT(DISTINCT user_id)   AS users_started
  FROM learner_progress
  GROUP BY course_id, module_id, module_name, module_order
),
module_completions AS (
  SELECT
    course_id,
    module_id,
    COUNT(DISTINCT user_id)   AS users_completed
  FROM learner_progress
  WHERE completed = 1
  GROUP BY course_id, module_id
),
course_starts AS (
  SELECT course_id,
         COUNT(DISTINCT user_id) AS total_enrolled
  FROM learner_progress
  WHERE module_order = 1
  GROUP BY course_id
)
SELECT
  ms.module_name,
  ms.module_order,
  cs.total_enrolled,
  ms.users_started,
  mc.users_completed,
  ROUND(100.0 * ms.users_started    / cs.total_enrolled, 1) AS reach_pct,
  ROUND(100.0 * mc.users_completed  / ms.users_started,  1) AS completion_pct,
  ROUND(100.0 * (ms.users_started - mc.users_completed)
        / ms.users_started, 1)                              AS drop_off_pct
FROM module_starts ms
JOIN module_completions mc USING (course_id, module_id)
JOIN course_starts cs ON ms.course_id = cs.course_id
WHERE ms.course_id = 'DATA_ANALYTICS_101'
ORDER BY ms.module_order;

MRR movement analysis (new, expansion, churned)

-- Monthly MRR movement — new, expansion, contraction, churned
WITH monthly_rev AS (
  SELECT
    user_id,
    DATE_FORMAT(billing_month, '%Y-%m')      AS month,
    SUM(amount)                              AS mrr
  FROM subscriptions
  WHERE status = 'active'
  GROUP BY user_id, month
),
mrr_with_prev AS (
  SELECT
    user_id, month, mrr,
    LAG(mrr) OVER (PARTITION BY user_id ORDER BY month)  AS prev_mrr,
    LAG(month) OVER (PARTITION BY user_id ORDER BY month) AS prev_month
  FROM monthly_rev
)
SELECT
  month,
  ROUND(SUM(CASE
    WHEN prev_mrr IS NULL THEN mrr                           -- new customer
    END), 0)                                                 AS new_mrr,
  ROUND(SUM(CASE
    WHEN mrr > prev_mrr THEN mrr - prev_mrr                  -- upgrade
    END), 0)                                                 AS expansion_mrr,
  ROUND(SUM(CASE
    WHEN mrr < prev_mrr THEN mrr - prev_mrr                  -- downgrade (negative)
    END), 0)                                                 AS contraction_mrr,
  ROUND(SUM(CASE
    WHEN prev_mrr IS NOT NULL AND mrr = 0 THEN -prev_mrr     -- churned
    END), 0)                                                 AS churned_mrr
FROM mrr_with_prev
GROUP BY month
ORDER BY month;

What does a data analyst do at an Indian edtech company?

Data analysts at Indian edtech companies work on learner analytics, sales analytics, and product analytics. Key responsibilities: learner journey analytics — tracking where students drop off in a course, which content types have highest completion rates, correlation between engagement and course completion; sales funnel analytics — lead to trial to paid subscription conversion, counsellor performance, discount and offer effectiveness; product analytics — app feature usage, session time, push notification open rates, A/B test results; retention analytics — which learner segments churn and why, cohort-wise renewal rates; and revenue analytics — monthly recurring revenue (MRR), annual recurring revenue (ARR), average revenue per user (ARPU). Most edtech analysts use SQL for querying learner databases, Python or Mixpanel for product analytics, and Power BI or Looker for dashboards.

Is working at a startup good or risky for a data analyst career in India?

Working at an Indian startup is high risk, high reward — and the answer depends on the startup's stage and funding. Early-stage startups (pre-Series A, less than 50 employees): high learning, broad scope, close to founders, but low job security and below-market salary often compensated with equity that may never be worth anything. Series A-B funded startups (₹20-200 crore raised, 50-300 employees): best balance of learning speed, salary, and stability. Series C+ or unicorn startups: closer to large company structure, salaries are market rate or above, equity is more meaningful. For skill growth, a startup gives you 2 years of experience in 1 year — you do everything from data infrastructure to dashboards to business analytics. For job security, an IT services company or established BFSI employer is safer. Many analysts find 2-3 years at a startup invaluable before moving to a product company or starting to freelance.

What is MRR and ARR and why do startup analysts track them?

MRR (Monthly Recurring Revenue) is the predictable revenue a subscription business earns each month. ARR (Annual Recurring Revenue) is MRR × 12 — the annualised version used in investor reporting and company valuations. Startup data analysts track MRR/ARR because they are the north star metrics for subscription businesses (SaaS, edtech, consumer apps with subscriptions). Key breakdowns: New MRR (from new customers this month); Expansion MRR (existing customers upgrading or buying more); Churned MRR (lost from cancellations or downgrades); Net MRR Growth = New + Expansion − Churned. A company growing MRR at 10-15% monthly is considered high growth in India. Analysts also track MRR churn rate (% of MRR lost each month — below 2% monthly is healthy) and LTV:CAC ratio (customer lifetime value divided by acquisition cost — 3:1 or higher is the benchmark).

What data tools do Indian startups typically use for analytics?

Typical data stack at Indian startups in 2026 by company stage: Early stage (pre-Series A) — Google Sheets + Metabase (open-source BI) + BigQuery or PostgreSQL; analysts do everything manually, often SQL + Python. Series A-B — BigQuery or Snowflake as data warehouse, dbt for data transformation, Metabase or Looker or Superset for BI, Mixpanel or Amplitude for product analytics, Python for analysis, Airflow or Prefect for pipelines. Series C+ — Snowflake or BigQuery, dbt, Looker or Tableau, full data engineering team, dedicated analytics engineers. Compared to IT services, startups use modern, cloud-native tools — BigQuery, dbt, and Looker are much more common than SQL Server and Power BI. This is a career advantage: startup tool experience transfers to large product companies and global analytics roles.

What is equity (ESOPs) in Indian startups and is it worth taking?

ESOPs (Employee Stock Option Plans) give you the right to buy company shares at a fixed price (strike price) after a vesting period — typically 4 years with a 1-year cliff. In India, ESOPs are taxed twice: at exercise (when you buy shares — taxed as perquisite, i.e., income tax) and at sale (capital gains tax). Worth of ESOPs depends entirely on whether the company raises more funding at a higher valuation or lists/exits. Most Indian startup ESOPs are worth nothing — the company shuts down, stays flat, or the dilution is too heavy. However, at well-known unicorns (Swiggy, Zepto, Razorpay, Groww pre-IPO), ESOPs have created significant wealth for early employees. Rule of thumb: do not take a salary cut of more than 20% for ESOPs. Treat ESOPs as a lottery ticket — nice to have, but never count on them in your financial planning.

Which edtech and startup companies hire data analysts in Noida and Delhi NCR?

Edtech and startup analytics employers in Delhi NCR in 2026: Noida — Unacademy (Noida office), UpGrad (Delhi NCR presence), several edtech startups in the Noida startup ecosystem (T-Hub Noida, Startup India-registered companies), CodeChef by Directi; Gurugram — PW (Physics Wallah, one of the largest edtech companies, headquartered in Gurugram), Vedantu (Delhi NCR office), Eruditus (executive education), IndiaMart (marketplace/edtech hybrid); Delhi — several D2C and consumer internet startups hiring analysts; broader NCR — the Delhi NCR startup ecosystem is the 2nd largest in India after Bangalore, with strong presence in edtech, fintech, logistics, and SaaS. For fresher analysts, PW (Physics Wallah) in Gurugram is one of the most active edtech recruiters in the region.

What is learner analytics in edtech and what SQL skills does it require?

Learner analytics in edtech tracks how students engage with educational content and whether they achieve their learning goals. Key analyses: completion rate by module and content type (video vs quiz vs live class); time-to-completion vs predicted vs dropout point; engagement heatmaps (which lessons have high rewatch rates or high skip rates); score progression (how quiz scores improve over the course — or plateau); correlation analysis (is time spent on platform correlated with test score improvement?); and churn prediction signals (students who have not logged in for 7+ days have 60% higher churn probability). SQL skills required: date/time functions (DATEDIFF, DATE_TRUNC), window functions (LAG/LEAD for session analysis, FIRST_VALUE for cohort start dates), conditional aggregation (CASE WHEN for engagement scoring), and CTEs for multi-step learner journey queries.