Data Analyst Career Path in India: A Beginner’s Roadmap

Data analyst is one of the few well-paid roles in India you can enter without a computer science degree — and one of the most misrepresented. The job is far less about machine learning than the internet suggests, and far more about cleaning messy spreadsheets and answering a business question clearly.

What the job actually looks like

A realistic week for a junior analyst at an Indian company: pull last month's sales figures from a database, notice that two regions have duplicate entries, clean them, build a summary the sales head can read in thirty seconds, and answer three follow-up questions about why the Pune numbers dipped.

Broadly, the work splits into four parts, and the proportions surprise people:

• Getting the data — roughly 20%. SQL queries, exports, occasionally an API.
• Cleaning it — roughly 40%. This is the largest and least glamorous part. Duplicates, inconsistent spellings, dates stored as text, missing values.
• Analysing it — roughly 20%. Aggregations, comparisons, trends. Rarely anything statistically exotic.
• Communicating it — roughly 20%. A dashboard, a deck, or a two-paragraph email. This is what gets you promoted.

The tools, in order

1. Excel or Google Sheets

Start here, genuinely. Pivot tables, lookups, SUMIFS, and Power Query. A great deal of real analysis in Indian companies still happens in spreadsheets, and the concepts transfer directly to everything that follows.

2. SQL

The single most-tested skill in data analyst interviews. You need SELECT, WHERE, GROUP BY, ORDER BY, the JOIN types, aggregate functions, subqueries and window functions. That list is finite and learnable in six to eight weeks of daily practice.

3. A visualisation tool

Power BI or Tableau. Power BI dominates Indian job postings, largely because of Microsoft's enterprise footprint. Learn Power BI first unless a specific target company uses Tableau.

4. Python — later, and optional at entry

Pandas for data manipulation, matplotlib for charts. Useful, and genuinely not required for most junior roles. Learn it once you are employed, or once SQL and Power BI are solid.

What it pays

• Entry (0–1 year): ₹3.5–6 lakh a year. Service companies lower, product companies higher.
• 2–4 years: ₹7–14 lakh.
• Senior / lead analyst: ₹15–28 lakh.
• Domain specialists (finance, healthcare, supply chain) command a premium at every level.

Two factors move these more than raw skill: whether you work at a product company or a service company, and whether you can explain your findings to a non-technical audience. The second is the reason some analysts plateau at ₹8 lakh and others do not.

Building a portfolio

Nobody hires a junior analyst on certificates alone. They hire on two or three projects you can walk through. What makes a project count:

Three projects of that quality beat ten tutorial follow-alongs. Put them on GitHub or a simple portfolio page, and link that page in your CV header.

Where analysts actually work in India

The role sits in more places than people assume, and the environment shapes what you learn:

• IT services companies — the largest volume of entry-level hiring. You work on a client's data, often with less autonomy but excellent process discipline. Good first job, easy to outgrow.
• Product companies and startups — fewer openings, higher pay, much broader scope. You may own a metric end to end within months.
• Banks, insurers and NBFCs — heavy regulation, strong data governance, stable. Domain knowledge here becomes valuable and portable.
• E-commerce and D2C brands — fast-moving, marketing-adjacent analysis. Lots of cohort and funnel work.
• Consulting and analytics firms — steep learning curve, many domains, demanding hours.

If you are choosing a first role, weigh the quality of the data and the person you report to above the brand name. An analyst who spends a year with a good senior learns more than one who spends two years alone with a clean dataset and no feedback.

A six-month plan

• Month 1: Excel properly — pivot tables, lookups, SUMIFS, Power Query. Clean two messy public datasets.
• Month 2–3: SQL daily. Work through query problems until joins and window functions are automatic.
• Month 3–4: Power BI. Build three dashboards from data you cleaned yourself.
• Month 5: Write up your best two projects properly. Statistics basics — mean vs median, distributions, correlation vs causation.
• Month 6: Apply. Practise explaining each project out loud in four minutes. Expect SQL tests in most first rounds.

How interviews actually go

A typical junior data analyst interview in India has three parts: a SQL test (written or live), a case discussion ("sales dropped 15% last quarter — how would you investigate?"), and a walk-through of one of your projects.

The case discussion is where most candidates underperform, because they jump to an answer. The expected behaviour is to ask clarifying questions first — which segment, which regions, is this seasonal, did anything change in pricing or supply. Interviewers are testing whether you think before you query.