Social Media Analyst

TheSmallBigIdea; Mumbai; On-site; INR 400,000 - 600,000; Full time

Job summary

A digital marketing agency in Mumbai is seeking a candidate to track and analyze social media performance, preparing detailed reports aligned with brand KPIs. The ideal candidate will have a strong understanding of social media metrics, experience within a digital agency, and advanced skills in Excel and Google Sheets. Effective communication skills are essential for assisting with client presentations and discussions. This role offers an opportunity to contribute to impactful marketing strategies.

Qualifications

• Strong understanding of social media metrics and KPIs.
• Experience working in a digital/creative agency environment.
• Advanced skills in Excel / Google Sheets (pivot tables, formulas).

Responsibilities

• Track and analyse performance across social media platforms.
• Prepare reports aligned to brand and campaign KPIs.
• Translate data into insights and optimisation recommendations.

Skills

Social media metrics understanding

Digital agency experience

Advanced Excel/Google Sheets skills

Good communication skills

Familiarity with social listening tools

Understanding of content formats

Job description

• Track and analyse performance across social media platforms (organic & paid)
• Prepare daily, weekly, and monthly reports aligned to brand and campaign KPIs
• Translate data into clear insights and optimisation recommendations
• Monitor content, campaign, and audience performance trends
• Support campaign analysis, launches, and moment-based activities
• Build dashboards and maintain accurate reporting using analytics tools
• Assist with client presentations, reviews, and performance discussions
• Conduct competitive and category-level social media analysis

Skills & Requirements

• Strong understanding of social media metrics and KPIs
• Experience working in a digital/creative agency environment
• Advanced skills in Excel / Google Sheets (pivot tables, formulas, data cleaning)
• Good communication skills—written and verbal
• Familiarity with social listening tools
• Understanding of content formats, trends, and platform algorithms