Data Analyst Jobs Bangalore 2026: SQL, Tableau

Aap Bangalore me data analyst job dhoond rahe ho, SQL aata hai, Tableau bhi thoda bahut kiya hai, phir bhi Naukri, LinkedIn, Instahyre pe “application viewed” ke baad silence? Same scene bahut logon ke saath hai. Problem sirf skills ki nahi hoti, problem hoti hai market ko samajhna, resume ko right keywords se banana, aur interview me business thinking dikhana.

2026 me Bangalore ka data analyst market strong rahega, but competition bhi heavy hai. TCS, Infosys, Wipro jaise service companies se leke Razorpay, Swiggy, Zomato, PhonePe, Paytm jaise product companies tak, sabko data chahiye. But “data analyst” title ke andar ka kaam company to company kaafi change hota hai.

Agar tu fresher hai, career switcher hai, ya 1-3 years experience ke saath better package chahiye, ye guide practical hai. Isme hum dekhenge Bangalore me data analyst jobs 2026 ka real scene, SQL aur Tableau kitna important hai, salary kya expect karna chahiye, resume kaise banana hai, aur interview me kya bolna hai.

Bangalore me Data Analyst Jobs 2026 ka Real Scene#

Bangalore India ka tech capital hai, ye sabko pata hai. But data analyst roles ke liye Bangalore ka advantage sirf “zyada companies” nahi hai. Yahan har type ki company hai:

1. IT services: TCS, Infosys, Wipro, Accenture, Cognizant
2. Product companies: Razorpay, PhonePe, Paytm, Flipkart, Meesho
3. Startups: fintech, edtech, healthtech, SaaS, logistics
4. GCCs: Walmart Global Tech, Target, Lowe’s, Tesco, Wells Fargo
5. Consulting and analytics firms: Mu Sigma, Fractal, Tiger Analytics, LatentView

2026 me companies data analyst se sirf reports nahi banwana chahengi. Unko chahiye banda jo data se answer nikaal sake:

• Sales drop kyun hua?
• App users checkout pe kyun chhod rahe hain?
• Kaunsa city high conversion de raha hai?
• Marketing spend waste kahan ho raha hai?
• Customer churn ka early signal kya hai?
• Delivery delay ka root cause kya hai?

Simple language me, company ko Excel operator nahi chahiye. Company ko problem solver chahiye jisko SQL, Tableau, Excel, basic stats aur business sense aata ho.

SQL aur Tableau Kyun Important Hai?#

Data analyst job me SQL almost mandatory skill hai. Agar job description me SQL nahi likha, phir bhi interview me puch sakte hain. Reason simple hai, company ka data database me hota hai, Excel sheet me nahi.

Tableau visualization ke liye popular hai. Power BI bhi bahut use hota hai, but Bangalore product companies aur analytics teams me Tableau ka demand still strong hai.

SQL ka role kya hota hai?

SQL se tum database se data nikaalte ho. Jaise:

• Last 30 days ka sales data
• Top 10 performing products
• City wise order count
• Customer repeat purchase rate
• Failed payments by bank
• Monthly active users
• Funnel conversion

Interview me SQL ke questions mostly practical hote hain. Example:

1. Second highest salary find karo.
2. Users who purchased in January but not in February.
3. Daily active users calculate karo.
4. Month over month growth nikaalo.
5. Top 3 products by revenue in each category.
6. Duplicate records remove kaise karoge?
7. JOINs me inner, left, right ka difference.
8. Window functions ka use.

Agar tumhe SELECT, WHERE, GROUP BY, HAVING, JOINs, subqueries aur window functions clear hain, tum kaafi interviews crack kar sakte ho.

Tableau ka role kya hota hai?

Tableau me dashboard banta hai. But sirf chart banana enough nahi hai. Dashboard business user ko decision lene me help kare, ye important hai.

Good Tableau dashboard me ye cheezein hoti hain:

• Clear KPIs
• Filters, date range, category, city, product
• Trend lines
• Comparison, current vs previous month
• Drill down option
• Clean colors
• No extra clutter
• Insights, sirf graphs nahi

Example, Swiggy type company ke liye dashboard:

• Total orders
• Average delivery time
• Cancelled orders
• City wise order volume
• Restaurant wise delay
• Peak hour trend
• Customer rating impact

Agar tum Tableau me calculated fields, parameters, filters, LOD expressions, dashboard actions samajhte ho, resume me clearly mention karo.

2026 me Bangalore Data Analyst Salary Expectations#

Chalo salary ki baat seedha karte hain, kyunki motivation wahi hai.

Bangalore me data analyst salary company type, skills, college, experience aur interview performance pe depend karegi. Approx ranges:

Freshers, 0-1 year

• Service companies: ₹3.5 LPA to ₹6 LPA
• Analytics firms: ₹4 LPA to ₹8 LPA
• Startups: ₹5 LPA to ₹10 LPA
• Product companies: ₹8 LPA to ₹14 LPA, agar skills strong hain

Agar tum fresher ho aur SQL, Tableau, Excel ke saath 2-3 solid projects hain, to ₹5 LPA to ₹8 LPA realistic target hai. Top product company me ₹10 LPA plus possible hai, but competition high rahega.

1-3 years experience

• Service companies: ₹5 LPA to ₹10 LPA
• Analytics firms: ₹7 LPA to ₹14 LPA
• Fintech/product: ₹10 LPA to ₹18 LPA
• High growth startups: ₹12 LPA to ₹20 LPA

Razorpay, PhonePe, Paytm, Swiggy, Zomato type companies me data analyst role ₹12 LPA to ₹22 LPA tak ja sakta hai depending on team and experience.

3-5 years experience

• Senior data analyst: ₹15 LPA to ₹28 LPA
• Product analyst: ₹18 LPA to ₹35 LPA
• Analytics consultant: ₹14 LPA to ₹26 LPA
• Business analyst with analytics: ₹12 LPA to ₹24 LPA

Agar tum SQL strong, product metrics clear, A/B testing ka basic idea, stakeholder management aur dashboarding kar sakte ho, salary jump ka chance better hai.

Data Analyst vs Business Analyst vs Product Analyst#

Bangalore me job titles confuse kar dete hain. Same skillset alag title ke under aa sakta hai.

Data Analyst

Focus: data extraction, analysis, reports, dashboards, insights.

Common skills:

• SQL
• Excel
• Tableau or Power BI
• Python basic
• Statistics basic
• Data cleaning

Example kaam: monthly sales dashboard banana, customer cohort analysis karna, revenue drop ka reason find karna.

Business Analyst

Focus: business requirements, process, stakeholders, reporting, documentation.

Common skills:

• Excel
• SQL basic
• PowerPoint
• Requirement gathering
• Process mapping
• Dashboard understanding

Example kaam: sales team ke saath requirement lena, management ke liye weekly report banana, operations process improve karna.

Product Analyst

Focus: app/product user behavior, funnels, retention, experiments.

Common skills:

• SQL strong
• Product metrics
• A/B testing
• Mixpanel/Amplitude
• Tableau
• Python optional

Example kaam: app signup funnel me drop-off analyze karna, new feature ka impact check karna.

Agar tum Bangalore me product companies target kar rahe ho, “Product Analyst” roles bhi apply karo. Bas resume me product metrics include karo:

• DAU, WAU, MAU
• Retention
• Conversion rate
• Churn
• Funnel drop-off
• ARPU
• CAC
• LTV

Skills Roadmap: SQL, Tableau aur Baaki Kya Seekhna Hai?#

Aapko sab kuch ek saath seekhne ki zaroorat nahi hai. Priority wise chalo. 2026 ke liye data analyst roadmap ye rakho.

Step 1: Excel strong karo

Haan bhai, Excel abhi bhi mar nahi gaya. Companies me Excel heavy use hota hai.

Learn:

1. VLOOKUP, XLOOKUP
2. INDEX MATCH
3. Pivot tables
4. Conditional formatting
5. Data validation
6. Text functions
7. Date functions
8. Basic charts
9. Power Query basics

Interview me Excel practical test aa sakta hai. Especially service companies, operations analytics, finance analytics roles me.

Step 2: SQL daily practice karo

SQL ko sirf video dekh ke nahi seekh sakte. Daily queries likho.

Minimum topics:

• SELECT, WHERE, ORDER BY
• GROUP BY, HAVING
• Joins
• Subqueries
• CTEs
• Window functions
• CASE WHEN
• Date functions
• String functions
• Aggregations
• Ranking functions

Practice platforms:

• LeetCode SQL
• HackerRank SQL
• StrataScratch
• Mode SQL tutorial
• DataLemur

Agar tum 100 SQL questions solve kar lete ho, confidence alag level ka ho jayega.

Step 3: Tableau dashboard banao

Tableau Public pe free profile banao. 3-5 dashboards publish karo. Resume me link do.

Good project ideas:

1. Swiggy delivery performance dashboard
2. Zomato restaurant rating analysis
3. IPL player performance dashboard
4. E-commerce sales dashboard
5. UPI transaction trend dashboard
6. HR attrition dashboard
7. Customer churn dashboard

Dashboard me sirf chart mat daalo. Ek story dikhao. Example:

“Bangalore me late deliveries 7 PM to 10 PM ke beech 32% zyada hain, aur Koramangala, Whitefield, Indiranagar top delay zones hain.”

Ye line recruiter ko impress karegi, kyunki insight hai.

Step 4: Python basic add karo

Data analyst ke liye Python mandatory nahi har role me, but plus point hai.

Learn:

• Pandas
• NumPy
• Matplotlib
• Seaborn
• Data cleaning
• Groupby
• Merge
• Basic EDA

Aapko machine learning scientist nahi banna. Bas CSV read karke clean, analyze aur visualize karna aana chahiye.

Step 5: Business metrics samjho

Yahin pe most candidates fail karte hain. SQL aata hai, Tableau aata hai, but business question samajh nahi aata.

Important metrics:

• Revenue
• Profit margin
• Conversion rate
• Retention
• Churn
• Average order value
• Customer acquisition cost
• Lifetime value
• Monthly active users
• Repeat purchase rate
• Gross merchandise value
• Net promoter score

Agar interviewer puche, “Swiggy orders drop ho gaye, kaise analyze karoge?” To answer structured hona chahiye:

1. Time period check karunga.
2. City wise split dekhunga.
3. New vs repeat users compare karunga.
4. Restaurant availability check karunga.
5. Delivery time change hua kya?
6. Discounts reduce hue kya?
7. Payment failures badhe kya?
8. Competitor event ya festival impact hai kya?

Ye business thinking hai.

Resume Kaise Banaye Data Analyst Jobs ke Liye?#

Sach bolo, tumhara resume ATS me reject ho raha hoga. ATS software pehle resume scan karta hai, phir recruiter dekhta hai. Agar keywords missing hain, format weird hai, ya projects weak hain, callback nahi aayega.

Resume me ye sections rakho

1. Header: name, phone, email, LinkedIn, GitHub/Tableau Public
2. Summary: 2-3 lines, skills and target role
3. Skills: SQL, Tableau, Excel, Python, Statistics, dashboarding
4. Projects: 2-4 strong projects
5. Work experience or internships
6. Education
7. Certifications, optional

Summary example for fresher

“Data analyst candidate with hands-on projects in SQL, Tableau, Excel and Python. Built dashboards for e-commerce sales, customer churn and food delivery performance using real-world datasets. Strong in data cleaning, business metrics and dashboard storytelling.”

Summary example for 2 years experience

“Data analyst with 2 years of experience in SQL-based reporting, Tableau dashboards and business analysis for sales and operations teams. Improved reporting turnaround time by 40% and created KPI dashboards used by 20+ stakeholders.”

Skills section example

Technical Skills:

• SQL: Joins, CTEs, window functions, subqueries, aggregations
• Visualization: Tableau, Power BI, Excel charts
• Excel: Pivot tables, XLOOKUP, Power Query
• Python: Pandas, NumPy, Matplotlib, Seaborn
• Analytics: KPI tracking, funnel analysis, cohort analysis, A/B testing basics
• Databases: MySQL, PostgreSQL

Project bullet examples

Weak bullet:

• Made Tableau dashboard for sales data.

Strong bullet:

• Built Tableau sales dashboard analyzing ₹12 crore revenue across 8 cities, identifying that Bangalore and Pune contributed 46% of total revenue.

Weak bullet:

• Used SQL to analyze customer data.

Strong bullet:

• Wrote SQL queries using joins, CTEs and window functions to identify top 15% customers contributing 58% of repeat purchases.

Numbers matter. Even project data fake nahi hona chahiye, but dataset ke numbers use kar sakte ho.

Best Projects for Bangalore Data Analyst Jobs#

Agar tumhare paas work experience nahi hai, projects tumhara proof hain. Random YouTube copy project mat daalo. Thoda personalize karo.

Project 1: Food Delivery Analysis, Swiggy/Zomato Style

Dataset: orders, restaurants, customers, delivery time, ratings.

Questions answer karo:

• Which city has highest order volume?
• Peak ordering hours?
• Average delivery time by zone?
• Cancellation rate by restaurant type?
• Rating impact on repeat orders?
• Discount impact on order value?

Tools:

• SQL for analysis
• Tableau for dashboard
• Excel for cleaning

Resume bullet:

• Analyzed 50,000 food delivery orders using SQL and Tableau, finding that 7 PM to 10 PM contributed 38% of daily orders and late deliveries reduced customer ratings by 0.6 points.

Project 2: Fintech UPI Transaction Dashboard

PhonePe, Paytm, Razorpay type companies ke liye relevant.

Questions:

• Monthly transaction growth?
• Failed transactions by bank?
• Payment method split?
• City wise transaction value?
• Peak transaction hours?
• Refund rate?

Resume bullet:

• Created fintech transaction dashboard tracking ₹25 crore UPI volume, failure rate, refund trends and bank-wise success rate for 1.2 lakh transactions.

Project 3: E-commerce Sales Analysis

Flipkart, Meesho type roles ke liye useful.

Questions:

• Top categories by revenue?
• Return rate by product?
• Discount vs profit relation?
• Customer repeat purchase?
• Monthly growth?
• Region wise performance?

Resume bullet:

• Used SQL and Tableau to analyze e-commerce sales across 20,000 orders, identifying 3 categories with high revenue but low profit due to discount leakage.

Project 4: HR Attrition Dashboard

TCS, Infosys, Wipro, Accenture type service companies ke liye good.

Questions:

• Which department has highest attrition?
• Salary band vs attrition?
• Tenure impact?
• Manager rating correlation?
• Gender and location trends?

Resume bullet:

• Built HR analytics dashboard for 5,000 employees, identifying that employees with 1-2 years tenure had 24% higher attrition risk.

LinkedIn and Job Search Strategy for Bangalore#

Sirf apply apply karna kaam nahi karega. 2026 me referral game strong hai. Especially Bangalore me hiring managers and recruiters LinkedIn pe active hote hain.

Daily job search routine

1. 10 targeted applications
2. 5 recruiter messages
3. 3 employee referral messages
4. 1 LinkedIn post or comment
5. 30 minutes SQL practice
6. 20 minutes interview prep

Consistency boring hai, but result yahi deta hai.

LinkedIn headline examples

For fresher:

“Data Analyst | SQL, Tableau, Excel, Python | Built dashboards on e-commerce, fintech and food delivery data”

For experienced:

“Data Analyst with 2 YOE | SQL, Tableau, KPI Dashboards, Business Insights | Bangalore”

Referral message template

Hi [Name],
I noticed you work at [Company] in the analytics team. I’m applying for the Data Analyst role and have hands-on experience with SQL, Tableau and dashboarding projects. Would you be open to referring me if my profile looks relevant?

Resume: [link]
Portfolio: [link]

Thanks a lot.

Short rakho. Koi long emotional story nahi.

Interview Questions You Must Prepare#

Data analyst interviews usually 4 parts me hote hain:

1. SQL round
2. Case study or business problem
3. Tableau/Excel round
4. HR and manager discussion

SQL questions

Prepare these:

1. Difference between WHERE and HAVING?
2. INNER JOIN vs LEFT JOIN?
3. Find duplicate records.
4. Find second highest salary.
5. Calculate monthly revenue.
6. Find users active for 3 consecutive days.
7. Rank products by revenue within each category.
8. Calculate rolling 7-day average.
9. Find customers who ordered last month but not this month.
10. Use CASE WHEN to create segments.

Tableau questions

1. What are dimensions and measures?
2. What are calculated fields?
3. What is LOD expression?
4. Extract vs live connection?
5. How do filters work?
6. How to improve dashboard performance?
7. How to design executive dashboard?
8. Parameter vs filter difference?
9. How to handle null values?
10. What dashboard have you built and what insight did it give?

Business case questions

Case: Zomato orders dropped by 15% in Bangalore. What will you check?

Good answer:

• First confirm data issue, tracking issue, missing data, date range.
• Compare with previous week, month and same period last year.
• Break down by zone: Koramangala, Whitefield, Indiranagar, HSR, Electronic City.
• Check new users vs repeat users.
• Check restaurant availability and cancellations.
• Check delivery time and rider availability.
• Check discount changes.
• Check payment failure rate.
• Check competitor campaigns or local events.
• Find root cause and suggest action.

Case: Paytm transaction failure increased. What will you do?

Answer:

• Segment by bank, payment method, app version, device type, city and time.
• Check if failure is concentrated in one bank.
• Compare gateway response codes.
• Check recent app release.
• Check peak hour load.
• Measure business impact: lost GMV, user drop-off, support tickets.
• Recommend bank-wise routing, retry logic, user communication.

This is how product companies think.

Common Mistakes Jo Candidates Karte Hain#

Mistake 1: Resume me “Good communication skills” likhna but project weak

Recruiter ko proof chahiye. Skills ka proof projects aur numbers se dikhao.

Mistake 2: Tableau dashboard beautiful but useless

Pretty colors se job nahi milegi. Insight important hai. Har dashboard me 3 business takeaways likho.

Mistake 3: SQL theory aati hai, query nahi likh paate

Interview me live query likhni hoti hai. Practice without seeing solution.

Mistake 4: Har job ko same resume bhejna

TCS ke role aur Razorpay ke role ka same resume nahi chalega. Keywords customize karo.

Mistake 5: Python me ML likh diya but pandas nahi aata

Data analyst role me pandas, SQL, dashboarding more useful hai. Random machine learning algorithms resume me bharne se confusion hota hai.

Mistake 6: Salary expectation unrealistic bolna

Fresher ho aur ₹25 LPA demand karoge, unless IIT/top project/product internship, to recruiter serious nahi lega. Market range samjho.

Mistake 7: No portfolio link

Tableau Public, GitHub, Notion portfolio, Google Drive PDF, kuch to dikhna chahiye. “I have done projects” bolne se nahi chalega.

90-Day Plan to Get Data Analyst Job in Bangalore#

Agar tum serious ho, next 90 days ka plan follow karo.

Days 1-15: Foundation

• Excel revise karo
• SQL basics complete karo
• 30 SQL questions solve karo
• 1 dataset clean karo
• LinkedIn profile update karo
• Resume first draft banao

Days 16-30: SQL and Tableau

• Joins, CTEs, window functions
• 40 more SQL questions
• Tableau basics
• 1 dashboard publish karo
• 5 job descriptions analyze karo
• Resume keywords update karo

Days 31-45: Projects

• Food delivery project complete
• Fintech dashboard complete
• Project README likho
• Resume me project bullets add karo
• LinkedIn pe project post karo
• 50 targeted applications bhejo

Days 46-60: Interview Prep

• SQL medium questions
• 10 business case studies
• Tableau interview questions
• Mock interview with friend
• Referral outreach start karo
• Portfolio polish karo

Days 61-75: Applications and Networking

• 10 applications daily
• 5 referrals daily
• Recruiters ko message
• LinkedIn comments on analytics posts
• Company wise resume versions
• Interview tracking sheet maintain karo

Days 76-90: Conversion

• Weak areas revise karo
• Interview feedback note karo
• Salary negotiation prep
• HR questions prepare
• Final portfolio update
• Offer compare karo

90 days me job guarantee koi nahi de sakta, but agar tum seriously execute karte ho, callback chances kaafi improve honge.

Bangalore Me Kaunsi Companies Target Karein?#

Aap apne level ke hisaab se target list banao.

Freshers ke liye

• TCS
• Infosys
• Wipro
• Accenture
• Cognizant
• Capgemini
• Mu Sigma
• Fractal entry roles
• Tiger Analytics junior roles
• Early-stage startups

1-3 years experience

• Razorpay
• PhonePe
• Paytm
• Swiggy
• Zomato
• Meesho
• Flipkart
• Dunzo type ops analytics
• SaaS startups
• GCC analytics teams

3+ years experience

• Senior analyst roles in product companies
• Product analyst roles
• Analytics manager track
• Business intelligence analyst
• Growth analyst
• Risk analyst
• Revenue analyst

Job title variations search karo:

• Data Analyst
• Business Analyst
• BI Analyst
• Product Analyst
• Growth Analyst
• Revenue Analyst
• Operations Analyst
• Reporting Analyst
• MIS Analyst
• Customer Insights Analyst

Sirf “Data Analyst Bangalore” search karoge to opportunities miss ho jayengi.

ATS Keywords for Data Analyst Resume#

ATS keywords important hain. Job description se exact words pick karo.

Useful keywords:

• SQL
• Tableau
• Power BI
• Excel
• Python
• Pandas
• Data cleaning
• Data visualization
• Dashboard
• KPI reporting
• Business intelligence
• ETL
• MySQL
• PostgreSQL
• Data analysis
• Trend analysis
• Root cause analysis
• Funnel analysis
• Cohort analysis
• A/B testing
• Stakeholder management
• Reporting automation
• Revenue analysis
• Customer analytics

But keyword stuffing mat karo. Natural use karo.

Example:

“Built Tableau KPI dashboard for revenue analysis and trend tracking, reducing manual reporting time by 35%.”

Ye ATS friendly bhi hai aur human friendly bhi.

Salary Negotiation Tips#

Jab offer aaye, jaldi haan mat bolo. Thoda smartly negotiate karo.

If fresher

Aap bol sakte ho:

“Thank you for the offer. Based on my SQL, Tableau projects and current Bangalore market for data analyst roles, is there flexibility to revise the package closer to ₹7 LPA?”

If experienced

“Thanks for the offer. Considering my 2 years of experience in SQL reporting, Tableau dashboards and stakeholder-facing analytics, I was expecting something around ₹14 LPA to ₹16 LPA. Is there room to discuss?”

Polite raho. Aggressive nahi. Aur counter offer hai to use mention kar sakte ho.

Final Checklist Before Applying#

Apply karne se pehle ye check karo:

1. Resume one page hai?
2. SQL, Tableau, Excel clearly mentioned hain?
3. Projects me numbers hain?
4. Tableau Public link working hai?
5. LinkedIn updated hai?
6. Job description ke keywords resume me hain?
7. Formatting ATS friendly hai?
8. No tables, no weird columns?
9. PDF properly named hai?
10. Phone and email correct hai?

Resume file name:

Rahul_Sharma_Data_Analyst_Bangalore.pdf

Not:

final_resume_latest_edited_new2.pdf

Bhai, ye choti cheezein bhi impression banati hain.

Final Thoughts#

Bangalore me 2026 me data analyst jobs milengi, but easy nahi hongi. SQL aur Tableau basic expectation ban chuke hain. Jo candidate SQL queries likh sakta hai, dashboard se clear insight dikha sakta hai, aur business problem ko structure kar sakta hai, uske chances strong hain.

Agar tum fresher ho, projects strong banao. Agar experienced ho, impact numbers dikhao. Agar career switch kar rahe ho, previous domain ko analytics ke saath connect karo. Example, sales background hai to sales analytics project banao. Finance background hai to UPI transaction ya revenue dashboard banao.

Most importantly, resume ko ATS ke liye ready karo. 200 applications bhejne se pehle resume check karna smart move hai. Warna tum mehnat karoge, but bot reject kar dega.

Apna resume free me check karna hai? JobRise ka free ATS checker use karo, keywords, formatting aur score turant samajh aa jayega: Free ATS Resume Checker