Business Analyst Intern

Internship details

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. As an intern, you will:

1. Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables

2. Join a weekly call with the analytics lead to review your work

3. Maintain the data dictionary and keep dashboard filters up to date.

4. Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery

5. Check numbers across sources and flag mismatches before reports go out.

6. Document metric definitions so everyone calculates churn and conversion the same way

7. Build and update dashboards in Power BI, Tableau or Looker Studio.

8. Analyse funnel drop-offs and summarise findings in a one-page note.

Skill(s) required: Looker Studio, Statistics, English Proficiency (Written)

Who should apply

1. Students currently pursuing B.Tech, BE, BCA, MCA, B.Sc or a related degree, or fresh graduates (2026, 2027 or 2028 batch)

2. Can commit full time, from home, for the whole internship

3. Have a working laptop and a stable internet connection

4. Can start immediately or within two weeks

Stipend: ₹22,000 - ₹24,000 per month (fixed)

Duration: 2 months | Start date: Immediately

Perks: Mentorship from senior team members, Pre-placement offer (PPO) for strong performers, Laptop provided for the internship, Job offer on successful completion, Free access to paid learning courses

Number of openings: 1

About Bank of Purva

Since 1967, the bank has focused on agricultural lending and commercial real estate in Maharashtra. Loan decisions are made locally, usually within a few days.

Only shortlisted candidates will be contacted.

Duration: 2 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Bank of Purva LLP.