Excel & Data Analysis Intern

Internship details

New Delhi Strategies needs a data analytics intern to build reports and dashboards for the Analytics team. Your day-to-day work will include:

1. Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query

2. Track marketing campaign results using Google Analytics 4 data.

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

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

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

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

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

8. Create charts and short slide decks for the monthly review call

Skill(s) required: SQL, Data Analytics, English Proficiency (Written)

Who should apply

1. Own a laptop and have stable internet at home

2. Are available for a full-time work from home internship for the entire duration

Stipend: ₹20,000 - ₹24,000/month

Duration: 3 months | Start date: Within 2 weeks

Perks: 5 days a week, Performance bonus, Internet allowance, Mentorship from senior team members, Laptop provided for the internship, Pre-placement offer (PPO) for strong performers

Number of openings: 10

About New Delhi Strategies

Clients are mostly family-owned manufacturers and distributors in Delhi. Travel is regional, usually driving distance, and rarely more than two nights a week. Still family owned, 85 years on. Expense reports are due every Friday, no exceptions.

Please submit your CV in English.

Duration: 3 months. Start: Within 2 weeks.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at New Delhi Strategies.