Posted 12h ago
Reporting & Excel Analyst Intern
Posted 2d agoBe an early applicant
What this role pays, in context
This listing does not state its pay. Data Engineer roles in India currently advertise a median of ₹23.8K a month.
25th pct ₹20.4K75th pct ₹27K
Median of 12 other live Data Engineer listings in India on this board that state pay. Roles that do not disclose a salary are excluded rather than counted as zero.
Two months, one very messy workbook
Our employer success team runs on a forty tab Excel workbook that three people are afraid to touch. You will be the one who finally rebuilds it. This internship runs two months from our Andheri office, with two days on site each week and the rest of your time arranged around classes.
What rebuilding looks like
You will map every formula and manual step in the current file, then rebuild it with clean input sheets, named ranges and Power Query refreshes instead of copy paste. Along the way you produce the monthly employer health report, chase down accounts that have stopped posting jobs, and prepare the renewal list the sales team works from. If the workbook behaves by week six, you move on to recreating two of its views in Metabase.
Suited to
Someone on a commerce, finance or statistics course who is genuinely fast in a spreadsheet and does not mind detail work. This is an unpaid internship, so we keep the hours light and the learning dense. No prior employment is needed, and nobody here will ask you to fetch coffee.
Responsibilities
- Document every formula, manual step and dependency in the current employer success workbook
- Rebuild the workbook with clean input sheets, named ranges and Power Query refreshes
- Produce the monthly employer health report for the success team
- Identify and list employer accounts that have stopped posting jobs
- Prepare the renewal pipeline sheet the sales team uses each month
- Recreate two key workbook views as Metabase dashboards
Requirements
- Final year student or recent graduate in commerce, finance, statistics or a similar subject
- Strong Excel skills including pivot tables, INDEX MATCH and conditional formatting
- Attention to detail and patience with repetitive validation work
- Curiosity about Power Query or SQL even if you have never used them
- Able to reach our Andheri office twice a week
Skills
Benefits
- Certificate + Letter of Recommendation
- One on one Excel and Power Query coaching from the operations analyst
- Timings arranged around your college schedule
- Your rebuilt workbook stays in daily use after you leave