Media Planning - Internship

About the internship:Modern media planning is no longer just about choosing TV channels or billboards; it is a highly sophisticated optimization problem. We are looking for an analytical wizard who can look past the surface of marketing vanity metrics and dive deep into data architectures, attribution models, and ROI forecasting.If you are an engineering student who loves numbers, patterns, and structured problem-solving, but also wants to see your analytical insights directly shape the national campaigns of India's premier jewellery brand, this role is for you.

Selected intern's day-to-day responsibilities include:

1..Data Modeling & Excel Crunching: Build and maintain complex media models, scenario planners, and performance trackers. You will be the team's go-to person for writing advanced formulas, building macros/automation tools, and structuring messy, multi-channel data.

2. Media Analytics & Insight Generation: Analyze daily, weekly, and monthly campaign performances across digital (programmatic, search, social) and offline media (TV, Print, OOH). Identify anomalies, trends, and efficiency leaks.

3.Budget Optimization: Apply mathematical and statistical frameworks to solve optimization puzzles maximizing brand reach and conversion metrics within defined budget constraints.

4. Competitive Intelligence: Track, organize, and analyze share-of-voice (SOV) data, transforming raw competitor spending metrics into actionable strategic recommendations.

5. Cross-Functional Collaboration: Partner with brand teams, creative agencies, and external media partners to feed data-driven hypotheses into campaign planning.Who can apply:Only those candidates can apply who:are available for full time (in-office) internshipcan start the internship between 6th Aug'26 and 25th Oct'26are available for duration of 3 monthshave relevant skills and interests* Freshers looking for jobs may also applyStipend:INR₹ 20,000 - 50,000 /monthDeadline:[hidden]:59:59Other perks:Letter of recommendation, Informal dress code, 5 days a week, Free snacks & beverages, Job offerSkills required:MS-Excel, Data Interpretation, English Proficiency (Spoken), English Proficiency (Written) and Data AnalysisOther Requirements:• Academic Pedigree: Graduates from B.E. / B.Tech from a Tier-1 engineering institution (such as NIT Trichy, NIT Surathkal, RVCE, or equivalent).• The Excel Virtuoso: Deep comfort with Microsoft Excel (VLOOKUP/XLOOKUP, Index/Match, Pivot Tables, Power Query, and basic VBA/Macros). If you can solve complex data puzzles without touching your mouse, you will fit right in!• Analytical Rigor: A natural love for numbers, statistics, and quantitative reasoning. You believe that if something cannot be measured, it cannot be optimized.• Structured Communication: The ability to translate complex numerical findings into clean, easy-to-understand visual charts and structured summaries.• Curiosity & Ownership: A self-starter attitude with a keen interest in learning how consumer psychology translates into media metrics (like CTR, CPM, ROAS, and GRPs).About Company:Titan Company Limited is a well-known consumer goods company with the legacy of the Tata Group. We have various business segments in the lifestyle segment, like jewelry, watches, accessories, eyewear, etc.Additional information:Job offer: On successful conversion to a permanent employee, the candidate can expect a salary of ₹ 500000 to 1000000/year

Responsibilities

Modern media planning is no longer just about choosing TV channels or billboards; it is a highly sophisticated optimization problem. We are looking for an analytical wizard who can look past the surface of marketing vanity metrics and dive deep into data architectures, attribution models, and ROI forecasting.If you are an engineering student who loves numbers, patterns, and structured problem-solving, but also wants to see your analytical insights directly shape the national campaigns of India's premier jewellery brand, this role is for you.

Selected intern's day-to-day responsibilities include:

1..Data Modeling & Excel Crunching: Build and maintain complex media models, scenario planners, and performance trackers. You will be the team's go-to person for writing advanced formulas, building macros/automation tools, and structuring messy, multi-channel data.

2. Media Analytics & Insight Generation: Analyze daily, weekly, and monthly campaign performances across digital (programmatic, search, social) and offline media (TV, Print, OOH). Identify anomalies, trends, and efficiency leaks.

3.Budget Optimization: Apply mathematical and statistical frameworks to solve optimization puzzles maximizing brand reach and conversion metrics within defined budget constraints.

4. Competitive Intelligence: Track, organize, and analyze share-of-voice (SOV) data, transforming raw competitor spending metrics into actionable strategic recommendations.

5. Cross-Functional Collaboration: Partner with brand teams, creative agencies, and external media partners to feed data-driven hypotheses into campaign planning.