- Salary
- ₹25k – ₹30k
- Location
- Pune, India
- Workplace
- Onsite
- Type
- Internship
- Seniority
- Internship
- Source
- Keka
Description
Job Title: AI Data Analyst Intern
Location: Pune (on-site)
Shift Timings: 12:00 PM – 8:30 PM IST
Duration: 6 months
About Amber
Amber is a long-term accommodation booking platform for students (think booking.com for student housing). We help 80M+ students globally find and book full-time accommodation near their universities, without the hassle of negotiations, non-standardized paperwork, or broken payment processes.
We are the largest and fastest-growing student housing platform globally, with 1M+ units across 6 countries and 100+ cities, backed by $21M in institutional funding led by Gaja Capital.
Role Overview
As an AI Data Analyst Intern, you’ll work on real analytical projects for our business, operations, and product teams, using AI tools as a core part of how you work. We want someone who uses AI to move faster and still checks every number before it reaches a stakeholder.
Key Responsibilities
- Own project-specific analyses for business, operations, or product teams.
- Write, debug, and optimize SQL queries, using AI assistants to speed up the work and validating every result yourself.
- Build and maintain dashboards in Tableau / Power BI to track key metrics and trends.
- Use AI chatbots (ChatGPT, Claude, Gemini) and AI coding tools (Claude Code, Cursor, Codex, or similar) to explore data, automate repetitive reporting, and prototype small tools.
- Find patterns, gaps, and opportunities in the data, and turn them into clear recommendations.
- Present insights to stakeholders in a clear, structured way.
- Document prompts, workflows, and automations so the team can reuse them.
Must-Have Requirements
- Pursuing or recently completed a degree in Business Analytics, Data Science, Economics, Engineering, or a related field.
- Hands-on SQL (joins, aggregations, window functions).
- Working knowledge of Excel/Google Sheets (pivots, lookups) and Tableau and/or Power BI.
- Regular, hands-on use of AI chatbots for real work, not just casual use.
- Basic experience with at least one AI coding tool or agent (Claude Code, Cursor, Codex, Copilot, or similar).
- Have built something of your own using AI: an app, a script, a dashboard, an automation, or an analysis. Shipped, rough, or half-broken all count. We want to see that you built it.
- Habit of checking AI output against the source data.
- Able to work independently on defined projects and meet timelines.
Nice to Have
- Python (pandas) for analysis.
- Familiarity with APIs, MCP, or connecting AI tools to data sources.
- Experience with Metabase, GA4, or product analytics tools.
How to Apply
Send your resume along with:
- A link to something you built with AI (GitHub repo, live demo, Loom walkthrough, or Notion write-up).
- 3–5 lines covering what it does, which AI tools you used, and one thing the AI got wrong that you had to fix.
Applications without a project link will not be considered.
Why Join Amber?
- Work on real business problems at a global, high-growth startup.
- Live projects, not mock assignments.
- AI-first workflows: you’ll use and help shape how our analytics team works with AI.
- Learn hands-on from experienced analysts and business leaders.
- Fast-paced, collaborative, learning-focused culture.
Skills
PythonSQLData ScienceGitHubExcelTableauPower BI