Media Planning Executive-Agency Role

Job description

**About Tanishq** Tanishq is Indias most-loved and trusted jewellery brand, synonymous with exquisite craftsmanship, impeccable quality, and stunning designs. As a part of the Tata Group and Titan Company Limited, we constantly push the boundaries of marketing innovation. Our Media Planning team sits at the powerhouse intersection of consumer insights, massive data sets, and creative storytelling. We don't just spend budgets; we engineer high-performance campaigns that capture hearts and markets alike. **The Role: Why we need an Engineer in Media Planning** 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. **Key Responsibilities** - **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. - **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. - **Budget Optimization:** Apply mathematical and statistical frameworks to solve optimization puzzles—maximizing brand reach and conversion metrics within defined budget constraints. - **Competitive Intelligence:** Track, organize, and analyze share-of-voice (SOV) data, transforming raw competitor spending metrics into actionable strategic recommendations. - **Cross-Functional Collaboration:** Partner with brand teams, creative agencies, and external media partners to feed data-driven hypotheses into campaign planning. **Who You Are (Required Skills & Qualifications)** - **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).