Data Analysis

About the Role

Actively hiring Data Analysis Saregama India Limited Mumbai Start Date Starts immediately Immediately Duration 3 Months Stipend ₹ 7,000 - 10,000 /month APPLY BY 12 Jun' 26 Posted 3 weeks ago Internship 648 applicants About the internship We are looking for a detail-oriented intern to join our business planning team.

In this role, you will support customer segmentation, data analysis, and WhatsApp campaign execution by transforming raw data into actionable insights. Selected intern's day-to-day responsibilities include: 1. Clean, organise, and maintain customer and transaction data using Excel. 2.

Identify and resolve data quality issues, including duplicates and inconsistencies. 3. Segment customers using predefined tagging logic and analyse behavioural patterns through pivot tables. 4. Create campaign-ready target groups (TGs) for WhatsApp campaigns, ensuring data accuracy and compliance. 5.

Coordinate with the Tech team to upload TGs onto WhatsApp platforms. 6. Track and analyse campaign performance metrics such as delivery, open rates, CTR, opt-outs, and conversions. 7. Build dashboards to evaluate campaign effectiveness and identify high-performing customer segments. 8. Present insights and recommendations to optimise future campaigns.

Skill(s) required Data Analytics HLOOKUP MS-Excel Python SQL VLOOKUP Earn certifications in these skills Learn Data Analytics Learn MS-Excel Learn Python Learn SQL Who can apply Only those candidates can apply who: 1. are available for full time (in-office) internship 2. can start the internship between 9th Jun'26 and 14th Jul'26 3.

are available for duration of 3 months 4. have relevant skills and interests Other requirements 1. Advanced MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS) 2. Data cleaning and validation 3. Customer segmentation and data tagging 4. Reporting and dashboard creation 5. Strong attention to detail 6. Familiarity with WhatsApp campaign tools and CRM basics 7.

Basic knowledge of Python or SQL (preferred) 8. Strong analytical and communication skills

Benefits

Certificate 5 days a week Free snacks & beverages Number of openings 1 About Saregama India Limited Website Saregama India Limited, an RP Sanjiv Goenka Group company, is India's oldest music label, youngest film studio, and multi-language TV content producer. It owns India's largest catalog of music IP of over 130K songs across languages and produces films under the brand of Yoodlee Films. Saregama also owns and retails the digital music player Carvaan. Carvaan is a perfect blend of digital technology and a retro form factor. Saregama's film production house, Yoodlee Films, is the country's youngest boutique film production studio that has produced over twenty films over the last three years. Over the last 20 years, Saregama has created over 6k hours of content for Sun TV and at any given time broadcasts 3-4 serials, creating around 15-16 hours of content per week. Activity on Internshala Hiring since December 2021 163 opportunities posted 40 candidates hired Closed for applications Additional Questions Close Sign up to continue Candidate sign up Sign up/ Login with Google Sign up with Email OR By continuing as a candidate, you agree to our T&C Already registered? Login Mumbai Start Date Starts immediately Immediately Duration 3 Months Stipend ₹ 7,000 - 10,000 /month APPLY BY 12 Jun' 26 We are looking for a detail-oriented intern to join our business planning team. In this role, you will support customer segmentation, data analysis, and WhatsApp campaign execution by transforming raw data into actionable insights. Selected intern's day-to-day responsibilities include: 1. Clean, organise, and maintain customer and transaction data using Excel. 2. Identify and resolve data quality issues, including duplicates and inconsistencies. 3. Segment customers using predefined tagging logic and analyse behavioural patterns through pivot tables. 4. Create campaign-ready target groups (TGs) for WhatsApp campaigns, ensuring data accuracy and compliance. 5. Coordinate with the Tech team to upload TGs onto WhatsApp platforms. 6. Track and analyse campaign performance metrics such as delivery, open rates, CTR, opt-outs, and conversions. 7. Build dashboards to evaluate campaign effectiveness and identify high-performing customer segments. 8. Present insights and recommendations to optimise future campaigns. Only those candidates can apply who: 1. are available for full time (in-office) internship 2. can start the internship between 9th Jun'26 and 14th Jul'26 3. are available for duration of 3 months 4. have relevant skills and interests 1. Advanced MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS) 2. Data cleaning and validation 3. Customer segmentation and data tagging 4. Reporting and dashboard creation 5. Strong attention to detail 6. Familiarity with WhatsApp campaign tools and CRM basics 7. Basic knowledge of Python or SQL (preferred) 8. Strong analytical and communication skills Saregama India Limited, an RP Sanjiv Goenka Group company, is India's oldest music label, youngest film studio, and multi-language TV content producer. It owns India's largest catalog of music IP of over 130K songs across languages and produces films under the brand of Yoodlee Films. Saregama also owns and retails the digital music player Carvaan. Carvaan is a perfect blend of digital technology and a retro form factor. Saregama's film production house, Yoodlee Films, is the country's youngest boutique film production studio that has produced over twenty films over the last three years. Over the last 20 years, Saregama has created over 6k hours of content for Sun TV and at any given time broadcasts 3-4 serials, creating around 15-16 hours of content per week.