Job Description

What will I be doing day to day Support the Media Reporting Team with the management of complex sport audience focused projects and manage smaller ones independently or as part of a small team. Create searches and use bespoke media information tools to find relevant rated audience data and programming schedules. Extrapolate rated broadcast data across unrated markets to confidently estimate full sport programming audiences. Perform advanced media valuation analysis and calculations in Microsoft Excel, using functions such as pivot tables, vlookups, IF formulae and data filters. Quality check and adjust sport event audiences, using logic and understanding of sport programming to assess the application excel formula via macros. Remain abreast of changes in the media broadcasting industry, completing desk based research to familarise self and colleagues with emerging digital channels and changes in consumer viewing habits. Coach and support junior analysts where applicable. To provide support to the Client Services team on ad-hoc projects. Key Accountabilities Collection of linear TV media data through targeted bespoke searches on audience measurement tools Analysis of broadcast data, making logical and accurate estimations where appropriate Preparation of data, making decisions regarding extrapolation and methodology application. Perform data validation and verification checks, quickly addressing any discrepancies Pinpoint key insights, supporting colleagues to build on your analysis to explain emerging trends in the sport event sponsorship industry Advising managers and team members of any scheduling issues. Qualifications What do I need to bring with me Excellent analytical skills with the ability to approach and solve problems. Proven track record of managing multiple projects and hitting deadlines in a fast-moving environment. Enthusiasm for desk-based research to collate robust sport event audience sets High attention to detail when following thorough data cleaning process Passionate about competitive sport Strong understanding of factors influencing sport event audiences Experience of extrapolating data through use of formula and macros, as well as logical adjustment. Experience in the media evaluation sector (in particular sports media) is desirable. Microsoft Office experience essential, including Excel to a high standard (i.e. vlookups, IF formulae, pivot tables and data filters). Possess a good, clear writing style. Effective communication to senior management level. Shift timings - 5 am to 2 pm and 9.30 am to 6.30 pm IST Location: Mumbai and Bangalore Additional information An opportunity to deliver highly complex, specialist research projects. You will be able to stretch your creativity by working with clients who are the leaders in their sector to design innovative solutions to data analysis. We offer some brilliant benefits and perks at YouGov, some of which include: LinkedIn Learning Mental Health First Aiders Headspace App Annual Leave - 20 Days Birthday Leave - An additional day holiday on your Birthday Sick & Casual Leave - 12 Sick leave and 8 Casual Leave Maternity Leave Paternity Leave Private Medical Insurance Life Insurance Sodexo Meal Pass Leave & Travel allowance (LTA) Provident Fund Night Shift Transportation facility Company Description And Culture YouGov is a global online research company, offering insight into what the world thinks. We speak daily to our panel of over 24 million registered members to understand opinion and behaviors around the world. We have a strong reputation as a source of accurate data and we\'re trusted by the world\'s biggest brands to get it right, making us the most quoted market research source in the world. Why join YouGov Join our global team to help us achieve our social mission: to make millions of people\'s opinions heard for the benefit of our local, national, and international communities. Understanding diversity of opinion requires diversity of background. Although our global panel of millions of people worldwide powers our research, our biggest asset is our people. If our research is to be truly representative of what the world thinks, we need people from all walks of life to be part of the team to bring their perspective to the work we do. Life at YouGov We are driven by a set of shared values. We are fast, fearless, and innovative. We work diligently to get it right. We are guided by accuracy, ethics, and proven methodologies. We respect and trust each other, bringing these values into everything that we do. We strive to provide YouGovers with best-in-class benefits to support their physical, financial, and emotional wellbeing. We want our employees to have a sense of belonging and uniqueness in a supportive workplace, so they can bring their full selves to work. Equal Opportunity Employer As an Equal Opportunity Employer, qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, gender identity or expression, and sexual orientation), parental status, national origin, marital status, age, disability, genetic information, HIV status, political affiliation, socioeconomic background, veteran status or any other characteristic protected by law or in line with our responsibilities as a fair and ethic employer. All employment decisions are made based on occupational qualifications, merit, and business need. Data Privacy To find out how we collect and use your personal data when you apply for a role at YouGov, please read our privacy notice at https://jobs.yougov.com/privacy

foundit