PAID INTERNSHIP IN MUMBAI - Data Analyst Intern at Yocket
- Samkit Shah
- Jan 3
- 3 min read
Complete Role Guide, Skills, FAQs & Preparation
If you’re a student or recent graduate looking to break into Data Analytics, Business Analytics, or Growth Analytics, this opportunity at Yocket is worth your attention.
Yocket, one of India’s largest community-driven platforms for international education, is hiring a Data Analyst Intern to support its growth, marketing, and revenue teams. This role offers hands-on exposure to real business data, decision-making, and performance tracking—exactly what early-career analysts need.
About Yocket
Founded in 2015, Yocket is a leading platform helping students make informed study-abroad decisions. With over 10,00,000+ students impacted, Yocket connects aspirants with top universities worldwide.
The company has been:
Recognized among Top 100 Indian Startups by Google & MeitY Appscale Academy
Ranked #18 on the App Store (Education category)
Yocket operates at the intersection of education, technology, marketing, and data-driven growth.
Yocket Office Address: 1st floor, Chandermukhi Building, Nariman Point, Mumbai, Maharashtra, 400021
Role Overview: Data Analyst Intern
As a Data Analyst Intern, you’ll work closely with growth, marketing, and revenue teams to transform raw data into actionable insights.
This role is ideal if you enjoy:
Working with numbers and structured datasets
Building dashboards and performance reports
Understanding how data impacts business decisions
Key Responsibilities
Here’s what you’ll typically work on:
📈 Performance Tracking & Analysis
Track marketing and revenue performance across campaigns and cities
Monitor KPIs such as ROAS, CPL, CAC, conversions, and revenue
📊 Dashboards & Reporting
Build and maintain weekly and monthly dashboards
Create structured reports for leadership and business teams
🔁 Funnel Analysis
Analyze end-to-end funnels: Leads → Registrations → Sales
Identify drop-offs and optimization opportunities
📉 Trend & Growth Analysis
Create MoM (Month-on-Month) and YoY (Year-on-Year) comparisons
Build projections and estimate return timelines
🗂️ Data Handling
Work with data from CRM tools, ad platforms, and internal trackers
Clean, structure, and present messy datasets clearly
Required Skills & Qualifications
Core Skills (Must-Have)
Advanced Excel skills(Formulas, Pivot Tables, VLOOKUP/XLOOKUP, data cleaning)
Understanding of basic marketing and business metrics
Strong analytical thinking and attention to detail
Ability to convert raw data into business-friendly insights
Technical Knowledge
Basic knowledge of SQL (SELECT, WHERE, GROUP BY, joins)
Familiarity with BI tools (Tableau, Power BI, Looker – any one is enough)
Bonus Skills (Good to Have)
Experience with CRM tools (Salesforce, HubSpot, Zoho, etc.)
Exposure to performance marketing data (Google Ads, Meta Ads)
Who Can Apply?
This internship is suitable for:
Students or recent graduates in Data, Business, Marketing, Engineering, or related fields
Candidates who are curious, detail-oriented, and comfortable working with data
Anyone looking to build a career in analytics, growth, or business intelligence
Common Interview / Screening Questions:
Here are some questions you should prepare for:
Excel & Analytics
How do you calculate ROAS, CPL, and CAC?
Explain how a pivot table works and when you’d use it
How would you analyze a drop in conversions across cities?
Business Understanding
How would you track marketing performance for a new campaign?
What metrics matter most for a lead-to-sales funnel?
SQL / Data Logic
Write a SQL query to group revenue by city
How would you identify top-performing campaigns using data?
Scenario-Based
If leads are increasing but revenue isn’t, what would you analyze?
How would you present insights to a non-technical stakeholder?
Preparation Guide for Aspiring Candidates
1️⃣ Strengthen Excel First
Focus on:
IF, SUMIF, COUNTIF
Pivot tables
VLOOKUP / XLOOKUP
Basic data cleaning
2️⃣ Learn Key Marketing Metrics
Understand formulas and use cases for:
ROAS
CPL
CAC
Conversion Rate
Funnel metrics
3️⃣ Practice SQL Basics
Be comfortable with:
SELECT, WHERE, ORDER BY
GROUP BY, HAVING
Simple joins
4️⃣ Build Mini Projects
Examples:
Analyze ad performance data (dummy or public datasets)
Create a funnel dashboard in Excel or Power BI
Perform MoM comparison on revenue data
5️⃣ Improve Business Communication
Practice explaining insights in simple language, not just numbers.
Helpful Reference Links:
You may include the following clickable learning resources for readers preparing for this role:
Excel for Data Analysis (Microsoft Learn):https://learn.microsoft.com/en-us/training/paths/analyze-data-excel/
SQL Basics (W3Schools):https://www.w3schools.com/sql/
Mode SQL Tutorial (Hands-on Practice):https://mode.com/sql-tutorial/
Marketing Metrics Explained (HubSpot):https://blog.hubspot.com/marketing/marketing-metrics
Google Analytics Academy (Free Courses):https://analytics.google.com/analytics/academy/
Power BI Beginner Learning Path:https://learn.microsoft.com/en-us/power-bi/
Tableau Free Training Videos:https://www.tableau.com/learn/training
How to Apply
Interested candidates can apply directly via the official application form:
👉 Application Link: https://forms.gle/CgXKvLWooKgVMBSW7
For any queries, contact: samkit.shah@yocket.in
Learn more about Yocket: https://www.yocket.com
Comments