Intern - Data Analyst

Amber; Pune District; On-site; INR 167,000 - 246,000; Full time

Job summary

Amberstudent is seeking an AI Data Analyst Intern to work on real analytical projects for business, operations, and product teams. You will write and optimize SQL queries, build dashboards in Tableau/Power BI, and use AI tools to accelerate workflows while validating results yourself.

The role requires hands-on AI usage, familiarity with SQL and Excel, and the ability to deliver independent project work with strict timelines.

Qualifications

• Pursuing or recently completed degree in Business Analytics, Data Science, Economics, Engineering, or related field.
• Hands-on SQL (joins, aggregations, window functions).
• Working knowledge of Excel/Google Sheets and Tableau and/or Power BI.
• Regular, hands-on use of AI chatbots for real work.
• Basic experience with at least one AI coding tool or agent.
• Have built something with AI: app, script, dashboard, automation or analysis.
• Habit of checking AI output against source data.
• Able to work independently on defined projects and meet timelines.

Responsibilities

• Own project-specific analyses for business, operations, or product teams.
• Write, debug, and optimize SQL queries using AI assistants.
• Build and maintain dashboards in Tableau/Power BI to track metrics.
• Use AI tools to explore data, automate reporting, and prototype tools.
• Find patterns and opportunities and turn them into recommendations.
• Present insights to stakeholders clearly and succinctly.
• Document prompts, workflows, and automations for reuse.

Skills

SQL

Excel/Sheets

Tableau/Power BI

AI chatbots

AI coding tools

Independent work

Education

Pursuing or recently completed degree in Business Analytics, Data Science, Economics, Engineering

Tools

Python (pandas)

APIs

Metabase

GA4

Job description

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.

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.

Required Skills

Communication & Availability Python Consistency Approachability Analytical Thinking & Problem Solving AI SQL and Database Skills