Excel & Data Analysis Intern

About us

Yamuna Advisors is a top-50 accounting and advisory firm with 280 people in offices across India. Our industry groups cover construction, healthcare, manufacturing, real estate and financial institutions. Partners sit on the same floor as staff, with doors usually open.

Overview

Yamuna Advisors needs a data analytics intern to build reports and dashboards for the Analytics team. You can work from home anywhere in India. We have no office requirement. Flexible schedule. We have one team call a day, usually in the morning. You will need a stable internet connection and a backup power source (UPS or inverter).

What you'll do

Document metric definitions so everyone calculates churn and conversion the same way. Track marketing campaign results using Google Analytics 4 data. Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery. Analyse funnel drop-offs and summarise findings in a one-page note. Check numbers across sources and flag mismatches before reports go out. Build and update dashboards in Power BI, Tableau or Looker Studio. Create charts and short slide decks for the monthly review call.

What we're looking for

Have a working laptop and a stable internet connection. Students currently pursuing B.Tech, BE, BCA, MCA, B.Sc or a related degree, or fresh graduates (2026 or 2027 batch). Clear written English for reports and status updates. Comfort with numbers and strong attention to detail. Laptop with Excel or Google Sheets and a stable internet connection. Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.

What you'll learn

Writing SQL against a real production warehouse. How business metrics like CAC, churn and retention are actually calculated. You will build at least one dashboard that managers use every week.

Duration: 1 month

Start date: Immediately

Stipend: ₹23,000 to ₹25,000 monthly

What we offer

Laptop provided for the internship. Internet allowance. Certificate.

Duration: 1 month. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Yamuna Advisors.