Associate - Ad Sales Coordinator, Sports

Viacom18; Mumbai; On-site; INR 900,000 - 1,200,000; Full time

Job summary

Viacom18 is seeking a contractual data analyst to partner with Ad Sales, Strategy and Revenue teams. You will analyze audience behavior, track campaign delivery, and build data-driven narratives for commercial decisions across the JioStar ecosystem.

You will extract, clean, and analyze large datasets, prepare weekly dashboards, and work with BARC data to interpret reach and ratings. The role emphasizes automation and rapid adaptation to new tools and systems.

Qualifications

• Advanced Excel skills including Pivot Tables, VLOOKUP/HLOOKUP, Index-Match and dashboards.
• Data analysis and reporting expertise.
• Power BI dashboarding and data visualization.
• Proficiency with Google Suite.
• Familiarity with Ad Server Tools.

Responsibilities

• Extract, clean, and analyze large datasets related to Digital & LTV viewership and ad delivery.
• Prepare and share weekly reports, dashboards, and insights using Advanced Excel, Power BI, and Google Suite.
• Work on BARC (Broadcast Audience Research Council) data to analyze reach, ratings, and viewership trends.
• Handle basic analysis and queries related to Reach and TVR (Television Viewership Rating).
• Present insights in a clear and structured manner to support business decision-making.
• Support process improvements through automation tools and quickly adapt to new tools and systems.

Skills

Advanced Excel

Data Analysis & Reporting

Power BI

Google Suite

Ad Server Tools

Tools

Power BI

Google Suite

Ad Server Tools

Job description

About the Role

This contractual role will partner with Ad Sales, Strategy and Revenue teams to analyze audience behavior, track campaign delivery, and build data-driven narratives that influence commercial decisions across the JioStar ecosystem.

Responsibilities

• Extract, clean, and analyze large datasets related to Digital & LTV viewership and ad delivery.
• Prepare and share weekly reports, dashboards, and insights using Advanced Excel, Power BI, and Google Suite.
• Work on BARC (Broadcast Audience Research Council) data to analyze reach, ratings, and viewership trends.
• Handle basic analysis and queries related to Reach and TVR (Television Viewership Rating).
• Present insights in a clear and structured manner to support business decision-making.
• Support process improvements through automation tools and quickly adapt to new tools and systems.

Skills Required

• Advanced Excel (Pivot Tables, VLOOKUP/HLOOKUP, Index-Match, Charts, Dashboards, etc.)
• Data Analysis & Reporting
• Power BI (Dashboarding & Data Visualization)
• Google Suite
• Familiarity with Ad Server Tools