Associate, Marketplace and Partnerships

Reporting of the role This role reports to: Group Head, CTG Analytics. 3 best things about this job: Understand how the media & advertising sector works: YouTube, Facebook, Instagram, Podcasts, TV, Newspapers, etc.; Wide variety of work, humongous things to learn; Opportunity to attend media events – new program launches, music/film awards, tickets to sports/concerts, etc. In this role, your goals will be: In three months: Understand media fundamentals – audience & market definitions, measurement metrics, audience behavior, etc.; Be comfortable using media measurement tools; Become thorough with periodic reports sent out by the team. In six months: Track media consumption habits by independently working on reports: TV viewership report; Radio listenership report; Track commercial inventory through: Time sale analysis; Radio and Print volume tracker; Track digital campaign data; Maintain & update VLOOKUP's accurately; Help with ad hoc data requests; Understand & remember insights generated from the above work.

Responsibilities

Clean, compile & analyze huge volumes of data; Develop & use logic checks to test for data accuracy at each step: extraction, compilation, cleaning & analysis; Present insights from the data in PowerPoint/Excel in a concise and clear manner; Work on ad-hoc queries as required; Daily reading to stay up to date on various topics: business news, tech, media, consumer behavior, and make sense of how developments in each sector intersect to arrive at key media trends; Track media consumption habits; Track commercial inventory through time sale analysis, radio and print volume tracker; Track digital campaign data; Maintain & update VLOOKUP's accurately; Help with ad hoc data requests

Requirements

Strong logical thinking capability; Attention to detail; Willing to work – to deliver tasks accurately and on time; High levels of healthy curiosity, eagerness to learn; Minimum Experience of 1 to 4 years; Proficient in MS Office tools (especially Excel – should be comfortable using formulae); Sound knowledge of high school level mathematics

Nice to have

Python; R; Tableau; Power BI

Benefits

Opportunity to attend media events – new program launches, music/film awards, tickets to sports/concerts, etc.; Competitive medical insurance; Group retirement plans; Vision insurance; Dental insurance; Significant paid time off; Preferential partner discounts; Employee mental health awareness days