Data Analyst
Data Analysts turn raw business data into decisions. The day-to-day work spans writing SQL on a warehouse to answer specific business questions, building Tableau / Power BI / Looker dashboards that PMs and ops teams actually use, sizing a problem with quick exploratory analysis, running A/B test reads, and translating findings into 1-page memos that non-technical stakeholders can act on. In India, Data Analyst is the most common 'first analytics job' for graduates from B.Tech, BCA, B.Com, and BBA backgrounds — it sits at TCS, Accenture, Cognizant, EY-Parthenon, ZS Associates, Mu Sigma, and Tiger Analytics for the services side, and at every product unicorn (Flipkart, Swiggy, Razorpay, Cred, PhonePe, Meesho), fintech, and D2C brand on the product side.
Overview
Data Analysts turn raw business data into decisions. The day-to-day work spans writing SQL on a warehouse to answer specific business questions, building Tableau / Power BI / Looker dashboards that PMs and ops teams actually use, sizing a problem with quick exploratory analysis, running A/B test reads, and translating findings into 1-page memos that non-technical stakeholders can act on. In India, Data Analyst is the most common 'first analytics job' for graduates from B.Tech, BCA, B.Com, and BBA backgrounds — it sits at TCS, Accenture, Cognizant, EY-Parthenon, ZS Associates, Mu Sigma, and Tiger Analytics for the services side, and at every product unicorn (Flipkart, Swiggy, Razorpay, Cred, PhonePe, Meesho), fintech, and D2C brand on the product side.
A Day in the Life
Open laptop with chai. Skim Slack for any overnight 'this number looks wrong' pings from product or ops. Triage which ones need a same-day answer vs which can wait.
Open the team's daily metrics dashboard (Tableau/Looker). Eyeball the four big numbers — orders, revenue, conversion, retention. If anything moved more than 5% week-over-week, jot it down to investigate.
Standup with the growth pod over Zoom — PM, designer, two engineers, you. Three-minute update on what you shipped yesterday and what the team needs from analytics today.
First focused SQL block. A PM asked yesterday for a cohort retention pull by acquisition channel. Write the query in DBeaver against Snowflake, validate two segments by hand against the source dashboard, paste a clean result table into Slack.
Investigate the conversion-rate dip you noticed at 9 AM. Open a scratch SQL file, segment by device, by city, by payment method. Find UPI conversion is down 11% on Android — write it up as a 4-line note for the payments lead.
Lunch break. Walk to the office canteen / dabba / Swiggy delivery. Avoid laptop for 40 minutes.
Back to desk. Open the A/B test results dashboard for the new checkout button experiment. Run guardrail metrics, segment by tier-1 vs tier-2 cities, write the ship/kill/iterate recommendation memo.
Pair call with a data engineer about a stale dbt model. The orders_daily_agg table is 6 hours behind schedule because an upstream Kafka topic is lagging. File the ticket, push a temporary workaround query for the morning dashboards.
Build the Monday CXO leadership-review slide. One chart, one number, one paragraph. Iterate three times because the chart axis hides the real story on the first draft.
Review a junior analyst's PR on a new dashboard — the SQL is fine but the dashboard has 14 charts and no clear top-line metric. Suggest collapsing to 4 charts plus a 'big number' header.
Read 30 minutes of a substack post or a Hex blog on experimentation. Forward one useful idea to the team channel.
End-of-day Slack update — what shipped, what's blocked, what's tomorrow. Close laptop. On a non-launch week this is a clean day; during launches and quarter-end the workday extends to 9-10 PM.
Key Skills
12Tools & Tech
8Common Mistakes
7- ⚠️Staying 4+ years at a services firm without switching to product analyticsWhy: Services analytics work plateaus at year 3 — you stop learning new business domains and your comp falls behind product-company peers by ₹8-15L. Recruiters start to view you as 'services-only' after 4 years.Instead: Plan a switch at year 2-3. Build a public portfolio (Tableau Public dashboards on RBI / Kaggle / India ecommerce data), do 1-2 mock product-analyst interviews, target a Razorpay / Swiggy / Cred / Flipkart Senior Analyst role.
- ⚠️Learning 6 BI tools shallowly instead of 1 deeplyWhy: Job descriptions list Tableau OR Power BI OR Looker — almost never all three at depth. Spreading thin makes interviewers suspect you can't solve a real problem in any of them.Instead: Pick one BI tool that matches your target companies (Tableau for Flipkart/Swiggy/most product cos, Power BI for BFSI/GCCs, Looker for Razorpay/Cred-style modern stack), get genuinely strong, and only add a second after 2 years.
- ⚠️Confusing 'Data Analyst' and 'Data Scientist' titles in your job huntWhy: Many Indian JDs misuse both titles — you can end up applying for ML-modeling roles when your skill set is dashboards, or for stakeholder-storytelling roles when your skill set is regression. You waste interview cycles.Instead: Read JDs hard for the actual day-to-day work. If the JD asks for sklearn, PyTorch, or A/B test design at depth, it's a DS role. If it asks for SQL + Tableau + stakeholder management, it's a DA role even if titled 'Junior Data Scientist'.
- ⚠️Treating SQL as the entire skillWhy: SQL is the price of entry, not the differentiator. Senior analysts compete on problem framing, KPI definition, A/B test interpretation, and stakeholder writing — none of which is a SQL skill.Instead: Spend 30% of learning time on SQL (until you can do CTEs, window functions, query optimization in your sleep) and 70% on stats fundamentals, experimentation, and business-writing craft. Read 'How to Measure Anything' (Hubbard) and 'Trustworthy Online Controlled Experiments' (Kohavi).
- ⚠️Doing an MBA at 3 years of experience hoping to escape analyticsWhy: An MBA at 3 years from a non-IIM-A/B/C institute often costs ₹15-25L and only nudges your post-MBA salary 20-30% above where you'd be with one more in-company promotion. The ROI is weaker than founders often assume.Instead: If you want PM or Strategy, try the in-company switch first — most product unicorns (Razorpay, Cred, Swiggy, Flipkart) move strong analysts into APM roles without an MBA. If you do go for an MBA, target only IIM-A/B/C/L or ISB.
- ⚠️Building a fancy dashboard when a 1-pager memo would doWhy: Senior leaders read memos, not dashboards. Building a beautiful 14-chart dashboard for a CXO question signals you don't understand the form-vs-function trade-off. Junior analysts confuse output with impact.Instead: Default to the lowest-friction artifact that solves the problem — a Slack message > a memo > an email > a deck > a dashboard. Build a dashboard only when the question repeats weekly. Build a memo when the question is one-time.
- ⚠️Ignoring the 'why is this number wrong' callsWhy: Data-quality work is unglamorous and rarely shows up in promotion cases — but analysts who duck it become the ones whose dashboards lose trust first. Once a stakeholder stops trusting your dashboards, your career compounds slow.Instead: Treat data-quality issues as P1 work. Pair with the data engineering team, document root cause, and ship a fix with monitoring. Make trust-in-your-numbers a measurable goal in your perf cycle.
Salary by Indian City (Mid-level total cash comp)
6| City | Range |
|---|---|
| Bangalore | ₹14-22L |
| Hyderabad | ₹13-20L |
| Pune | ₹11-18L |
| NCR (Gurugram + Noida) | ₹12-20L |
| Mumbai | ₹12-19L |
| Remote / international | ₹18-35L |
Notable Indians in this career
6Communities + forums
7- Locally OptimisticSlackThe largest serious Slack for analytics + analytics-engineering practitioners globally; strong India presence. Channels for SQL, dbt, Tableau, Looker, careers.
- Analytics India Magazine communityWeb + LinkedInIndia's largest analytics media + community; events (Cypher, MachineCon), industry research, salary surveys for the Indian analytics market.
- DataTalks.ClubSlack + YouTubeFree analytics and data engineering community with weekly office hours; runs the popular Data Engineering Zoomcamp and Analytics Engineering Zoomcamp.
- r/dataanalysis and r/IndianAnalyticsRedditActive Reddit communities for general analytics Q&A and India-specific salary, switch, and learning-path threads.
- MeasureCamp BengaluruIn-person + SlackAnnual unconference for digital analytics practitioners in Bengaluru; strong networking for product-analytics and growth-analytics roles.
- Hex / Mode / Looker user groupsSlackTool-specific communities run by Hex, Mode, and Looker; useful for SQL, notebook, and BI-tool deep-dive questions.
- Kaggle IndiaWeb + meetupsData competitions and learning paths; Indian Kaggle community is active in Bengaluru, Hyderabad, Pune. Useful for portfolio building.
What to read / watch / follow
9- Trustworthy Online Controlled ExperimentsBookby Ron Kohavi, Diane Tang, Ya XuThe gold-standard book on A/B testing in industry. Read cover-to-cover before your second analytics job. Indian product companies reference this book in interviews.
- How to Measure AnythingBookby Douglas HubbardTeaches the most-undervalued analyst skill: turning a vague business question into a measurable one. Foundational reading.
- Storytelling with DataBookby Cole Nussbaumer KnaflicThe best practical guide to charting and dashboard design. Almost every senior analyst at Flipkart, Swiggy, Razorpay has read this.
- Avinash Kaushik's Occam's Razor blogBlogby Avinash KaushikIndian-origin digital analytics thought leader. His writing on framing, KPI design, and 'so what' analysis is foundational.
- Locally Optimistic blog and podcastBlog + podcastby Locally Optimistic teamHonest writing about analytics careers, team structure, and stakeholder management — the soft-skill stuff that interview prep books miss.
- The Analytics Engineering Podcast (dbt Labs)Podcastby Tristan Handy + guestsTracks the evolution of the modern data stack — useful even if you don't write dbt yourself, since most product cos are moving toward it.
- Lenny's NewsletterNewsletterby Lenny RachitskyBest free PM-and-analytics writing on the internet. Read the 'analytics for PMs' and 'metrics' deep-dives — they're how senior PMs at Razorpay and Cred think about analytics.
- ChartMogul / Mode / Hex case study librariesCase studiesby VariousReal dashboards and SQL queries from production analytics teams. Best way to learn 'good' looks like before building your own.
- Analytics India Magazine podcast 'Simulated Reality'Podcast (India)by AIM teamIndia-specific interviews with analytics leaders at Flipkart, Razorpay, Mu Sigma, Tiger Analytics — useful for understanding what Indian heads-of-analytics actually optimize for.
Daily Responsibilities
7- Write or refactor 3-6 SQL queries — usually a mix of recurring metric pulls, a new ad-hoc question from a PM, and one investigation into a metric that moved unexpectedly.
- Build or update one Tableau / Power BI / Looker dashboard — tune the chart choices, add a filter, fix a broken data source, and run it past the stakeholder for sign-off.
- Investigate a 'why did X drop' question — segment the data, isolate the driver, write a 1-paragraph answer, and note open questions for follow-up.
- Attend a 15-30 min daily standup with PM and ops, plus 1-2 ad-hoc syncs about a metric, a feature launch, or a leadership review prep.
- Read an A/B test result — check the guardrail metrics, run the segment cuts, write the recommendation memo (ship / kill / iterate) for the PM.
- Pair with a Data Engineer on a data-quality issue — usually a 30-60 min call about a wrong number, a stale table, or a missing column, ending in a ticket on either side.
Advantages
- The most accessible analytics-track entry point in India — open to B.Com, BBA, and non-engineering graduates in a way that Data Scientist and ML Engineer roles are not.
- Strong learning compounding — once you have SQL, one BI tool (Tableau / Power BI / Looker), and basic experimentation literacy, you can move between fintech, e-commerce, SaaS, and consulting without restarting.
- Direct business impact you can see — your dashboard is what the COO opens every Monday; your A/B read decides whether the new checkout flow ships. Few entry-level roles offer that line-of-sight.
- Wide career-switch optionality — you can move from Data Analyst into Data Science (with focused upskilling), Product Management, Strategy, Finance, or Consulting more easily than from most other entry-level roles.
- Stable, durable demand at large Indian companies — every BFSI, every D2C brand, every product startup hires 5-30 analysts; hiring slowdowns have hit pure-engineering roles harder than analyst roles in 2024-2026.
Challenges
- Salary curve is materially lower than Software Engineer or Data Scientist for the same years of experience — a 5-year DA at most Indian companies earns 30-50% less than a same-tenure SDE-2.
- Job-title inflation works against you — at many Indian companies 'Data Scientist' and 'Data Analyst' titles are confused, and a 'Senior Analyst' role at a service company may be junior-analyst work in practice. Read JDs carefully.
- Heavy stakeholder management with ambiguous wins — you're often blamed when a number looks bad and rarely credited when a number looks good. Ownership of metrics is uncomfortable when business teams want a different answer.
- Dashboard sprawl is real — most analysts inherit hundreds of half-broken dashboards built by people who left. Cleaning that up is unglamorous work that rarely lands in a promotion case.
- AI tooling (Claude / GPT writing SQL, Power BI Copilot, Hex Magic) is compressing the floor of the role — rote SQL-and-dashboard work is increasingly automated, and analysts who don't move toward problem-framing, experimentation, and product strategy will see growth slow.
Education
5- Required: Bachelor's degree — B.Com, BBA, B.Sc (Statistics / Mathematics / Economics), B.Tech, or BCA. Unlike Data Scientist roles, the Data Analyst route is genuinely open to commerce and management graduates in India, not just engineers.
- Strong alternatives: B.Sc Statistics, B.Sc Economics, BBA Analytics, Integrated MSc programs from Christ University, Symbiosis, Loyola, Madras Christian College, and similar — accepted at most product and consulting analytics teams.
- Premium signal: M.Sc Statistics from ISI Kolkata / IIT Madras Online, MBA from IIM-Bangalore (Business Analytics), MS Business Analytics from ISB / Great Lakes / SP Jain, or any quantitative degree from IIT/NIT/IIIT — opens doors to consulting (BCG Gamma, McKinsey QuantumBlack), product unicorns, and FAANG-India analyst roles.
- Certifications that matter: Google Data Analytics Professional Certificate (Coursera), Microsoft Power BI Data Analyst (PL-300), Tableau Desktop Specialist, IBM Data Analyst, plus a strong dbt or SQL course completion. PG Diplomas from upGrad, Great Learning, and Imarticus are widely accepted by Indian recruiters for switchers.
- Self-taught + portfolio: a clean GitHub with 3-5 SQL+dashboard projects (covering CRM data, sales data, operational data) and a public Tableau Public / Power BI portfolio is an accepted route for switchers — common path from B.Com / BBA into product-analyst roles at startups.