Intern - Data Analyst

• *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 http://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.