Amber is a fastβgrowing, global studentβhousing platform that operates like a booking.com for university accommodation. With more than 80β―million students worldwide using the service, Amber manages over 1β―million housing units across six countries and 100+ cities. Backed by $21β―million of institutional funding led by Gaja Capital, the company has positioned itself as the largest and most trusted marketplace for student accommodation, simplifying negotiations, paperwork, and payments for both students and property owners.
The AI Data Analyst Intern role is a sixβmonth, fullβtime onβsite internship based in Pune. Working directly with business, operations, and product teams, the intern will leverage AIβdriven tools to accelerate data exploration, reporting, and insight generation. The position is designed for fresh graduates or finalβyear students who are comfortable writing SQL, building visual dashboards, and using generative AI assistants (ChatGPT, Claude, Gemini) as part of their daily workflow. The intern will be expected to validate every AIβproduced output against source data, ensuring accuracy before presenting findings to stakeholders.
Key Responsibilities:
1. Own endβtoβend analytical projects for business, operations, or product teams.
2. Write, debug, and optimise complex SQL queries, using AI assistants to speed up development while personally verifying results.
3. Design, develop, and maintain interactive dashboards in Tableau or Powerβ―BI to monitor key performance indicators.
4. Employ AI chatbots and coding assistants (Claude Code, Cursor, Codex, Copilot) to automate repetitive reporting tasks and prototype small analytical tools.
5. Identify patterns, gaps, and growth opportunities within large datasets and translate them into actionable recommendations.
6. Present insights and recommendations to crossβfunctional stakeholders in a clear, structured manner.
7. Document prompts, workflows, and automation scripts for team reuse and knowledge sharing.
8. Collaborate with senior analysts to refine AIβfirst analytical methodologies.
9. Contribute to building a repository of AIβgenerated analytical assets for future projects.
10. Continuously learn and experiment with emerging AI and dataβvisualisation technologies.
Tech Stack: SQL, Tableau/Powerβ―BI, Excel/Googleβ―Sheets, AI chatbots (ChatGPT, Claude, Gemini), AI coding tools (Claude Code, Cursor, Codex, Copilot), optional Python (pandas) for deeper analysis.
Growth Path: Highβperforming interns can transition to fullβtime Data Analyst or Business Analyst roles, with exposure to product analytics, AIβdriven automation, and strategic decisionβmaking. The role offers a unique blend of handsβon data work and cuttingβedge AI experimentation, positioning interns for rapid career advancement in dataβcentric product companies.
Why Join Amber? You will work on real business problems that impact millions of students globally, not on contrived assignments. The AIβfirst culture means you will shape how analytics is done in a highβgrowth startup, learning directly from seasoned analysts and product leaders. The collaborative, fastβpaced environment encourages innovation, continuous learning, and visible impact from day one.