Data Analyst in Banking & Finance India 2026

Pattern 1 — NPA identification and ageing bucket analysis

-- Classify overdue loan accounts into RBI ageing buckets
-- Standard buckets: SMA-0 (1-30 days), SMA-1 (31-60), SMA-2 (61-90), NPA (90+)

SELECT
  loan_id,
  customer_id,
  branch_code,
  product_type,
  outstanding_amount,
  DATEDIFF(CURDATE(), last_payment_date)          AS days_overdue,
  CASE
    WHEN DATEDIFF(CURDATE(), last_payment_date) BETWEEN 1  AND 30 THEN 'SMA-0'
    WHEN DATEDIFF(CURDATE(), last_payment_date) BETWEEN 31 AND 60 THEN 'SMA-1'
    WHEN DATEDIFF(CURDATE(), last_payment_date) BETWEEN 61 AND 90 THEN 'SMA-2'
    WHEN DATEDIFF(CURDATE(), last_payment_date) > 90              THEN 'NPA'
    ELSE 'Current'
  END                                             AS delinquency_bucket
FROM loan_accounts
WHERE loan_status = 'active'
ORDER BY days_overdue DESC;

-- Summarise NPA exposure by product type
SELECT
  product_type,
  delinquency_bucket,
  COUNT(*)                   AS accounts,
  ROUND(SUM(outstanding_amount) / 1e7, 2)  AS outstanding_cr
FROM (
  -- above query as subquery or CTE
) bucket_data
GROUP BY product_type, delinquency_bucket
ORDER BY product_type, days_overdue;

Pattern 2 — Transaction fraud flag rules

-- Flag potentially fraudulent transactions using rule-based logic

WITH customer_baseline AS (
  -- Calculate 90-day average transaction for each customer
  SELECT
    customer_id,
    AVG(amount)         AS avg_txn_90d,
    STDDEV(amount)      AS std_txn_90d,
    COUNT(*)            AS txn_count_90d
  FROM transactions
  WHERE txn_date >= DATE_SUB(CURDATE(), INTERVAL 90 DAY)
  GROUP BY customer_id
),
recent_txns AS (
  SELECT
    t.*,
    b.avg_txn_90d,
    b.std_txn_90d,
    LAG(t.txn_date) OVER (PARTITION BY t.customer_id ORDER BY t.txn_date)
      AS prev_txn_date,
    LAG(t.city)     OVER (PARTITION BY t.customer_id ORDER BY t.txn_date)
      AS prev_city
  FROM transactions t
  JOIN customer_baseline b USING (customer_id)
  WHERE t.txn_date >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)
)
SELECT
  customer_id, txn_id, txn_date, amount, city, merchant_category,
  CASE
    WHEN amount > (avg_txn_90d + 3 * std_txn_90d)    THEN 'HIGH_AMOUNT'
    WHEN city <> prev_city
      AND TIMESTAMPDIFF(HOUR, prev_txn_date, txn_date) < 2 THEN 'GEO_ANOMALY'
    WHEN merchant_category = 'JEWELLERY'
      AND amount > 50000                              THEN 'HIGH_RISK_MERCHANT'
    ELSE NULL
  END AS fraud_flag
FROM recent_txns
WHERE
  amount > (avg_txn_90d + 3 * std_txn_90d)
  OR (city <> prev_city AND TIMESTAMPDIFF(HOUR, prev_txn_date, txn_date) < 2)
  OR (merchant_category = 'JEWELLERY' AND amount > 50000);

Pattern 3 — Collections prioritisation score

-- Score overdue accounts to prioritise collections effort
-- Higher score = call this account first

SELECT
  loan_id,
  customer_id,
  outstanding_amount,
  days_overdue,
  cibil_score,
  -- Simple weighted scoring model
  ROUND(
    (outstanding_amount / 1000 * 0.4)        -- higher outstanding = priority
    + (days_overdue * 0.3)                   -- more days overdue = priority
    + (CASE
        WHEN cibil_score < 600 THEN 20       -- very low score = higher risk
        WHEN cibil_score BETWEEN 600 AND 699 THEN 10
        ELSE 0
       END * 0.3)
  , 2) AS collection_priority_score
FROM overdue_accounts
WHERE days_overdue BETWEEN 1 AND 90          -- focus on pre-NPA accounts
ORDER BY collection_priority_score DESC
LIMIT 500;   -- top 500 accounts for today's calling list

What does a data analyst do in an Indian bank or NBFC?

Data analysts in Indian banks and NBFCs work across several functions: credit risk analysis (evaluating loan default probability using historical repayment data), fraud detection (identifying unusual transaction patterns), MIS reporting (monthly performance reports for branch managers and leadership), collections analytics (which overdue accounts to prioritise), product performance (credit card usage, loan disbursement trends), and regulatory reporting (submitting data to RBI in specified formats). Day-to-day tools typically include SQL on Oracle or SQL Server databases, Excel for MIS, Power BI or Tableau for dashboards, and Python for more advanced analytics at data-mature banks.

What skills do you need to become a data analyst in the BFSI sector in India?

For BFSI data analyst roles in India: technical skills — SQL (often Oracle SQL or T-SQL in banks), Excel (advanced — pivot tables, VLOOKUP, VBA for automation), Python basics (pandas for data manipulation), Power BI or Tableau for dashboards; domain knowledge — basic understanding of loan products (EMI, LTV, NPA), credit scores (CIBIL), banking KPIs (NIM, NPA ratio, CAR), and RBI regulatory frameworks; soft skills — accuracy (errors in financial data have compliance consequences), ability to explain numbers to non-technical branch managers, and comfort working with large, sensitive datasets under strict access controls. A finance or commerce background (B.Com, BBA, MBA Finance) combined with data skills is a strong combination for BFSI analyst roles.

What is the salary of a data analyst in banking and finance in India in 2026?

Data analyst salaries in Indian BFSI in 2026: at public sector banks (SBI, PNB, Bank of Baroda) — ₹5-8 LPA for entry-level analyst roles; at private sector banks (HDFC, ICICI, Kotak, Axis) — ₹6-12 LPA for analysts with 1-3 years experience; at NBFCs (Bajaj Finance, Muthoot, Shriram) — ₹5-10 LPA depending on team and location; at fintech companies (Razorpay, Zerodha, Paytm, PhonePe) — ₹8-18 LPA with strong SQL and Python skills; at Gurugram-based BFSI MNCs — ₹12-22 LPA for analytics roles with 3+ years experience. Fintech consistently pays 30-50% more than traditional banking for equivalent skills.

What is NPA and why does it matter for data analysts in Indian banks?

NPA stands for Non-Performing Asset — a loan where the borrower has not made interest or principal repayments for 90 days or more. It is one of the most important metrics in Indian banking. RBI requires banks to report their NPA ratios, and high NPAs reduce bank profitability and capital. Data analysts in BFSI track NPA ratios by loan product, branch, region, borrower segment, and vintage (when the loan was disbursed); build early warning models to identify accounts likely to become NPAs; and prepare regulatory reports for RBI submission. For an interview at a bank or NBFC, understanding NPA, NIM (Net Interest Margin), and CIBIL scores is as important as knowing SQL.

Is fintech or traditional banking better for data analyst career growth in India?

Fintech is better for skill growth and salary; traditional banking is better for job stability and regulatory exposure. At Indian fintech companies (Razorpay, Zerodha, CRED, Groww, PhonePe), analysts work with modern tech stacks (Python, BigQuery, dbt), move quickly, and get broad exposure. The learning curve is steep and the work is visible. At traditional banks, analysts work with older systems (Oracle, SQL Server, legacy reporting tools), processes are slower, but domain expertise in credit risk, regulatory compliance, and treasury analytics builds deep, specialised value. Many analysts spend 2-3 years at a bank building domain knowledge, then move to fintech for a salary jump and modern tools — this combination is highly sought after.

What is fraud analytics in Indian banks and how do data analysts do it?

Fraud analytics in Indian banks involves identifying suspicious transaction patterns that indicate fraud — stolen credit cards, money mule accounts, loan application fraud, and identity theft. Data analysts use SQL to write rules: transactions above a threshold from a new device, multiple failed OTPs followed by a large transfer, unusually high spending in a short window. More advanced teams use Python for anomaly detection — calculating a baseline of normal behaviour per customer and flagging statistical outliers. Common fraud signals tracked: velocity (too many transactions too quickly), geographic anomaly (card used in Mumbai and Delhi within 30 minutes), merchant category mismatch (high jewellery spending on a student account), and round-number transactions (₹10,000, ₹50,000 — often indicate structuring).

Which BFSI companies hire data analysts in Noida and Gurugram in 2026?

Major BFSI employers of data analysts in Delhi NCR in 2026: Noida — Paytm (Noida Expressway), Paisabazaar/PolicyBazaar (Gurugram but accessible), HCL Finance analytics teams (Sector 62), several NBFC analytics and collections centres; Gurugram — HDFC Bank analytics team, ICICI Bank data science, Bajaj Finance, American Express (India analytics hub), Mastercard India, McKinsey and BCG analytics practices (BFSI clients), Capital One India, Genpact BFSI analytics, WNS BFSI analytics, Mphasis financial services analytics. The Gurugram Cyber City and DLF Phase clusters are the highest-density BFSI analytics hiring zones in India outside Mumbai.