Ad Sales Research Analyst

Job Description

Ad Sales Research Analyst

Sony Pictures Television (SPT) operates three complementary lines of business: 1) Distribution of SPE's feature films and television programming to cinemas and television outlets around the world, 2) Local television production in key international markets, 3) International television and digital networks.

The Ad Sales Research Analyst, part of the LATAM Research team, can be defined as someone who has the knowledge and skills to turn raw data into information and insights which can be used to make better and faster business decisions. The analyst supports ad-hoc and ongoing research projects across Sony Pictures Television's (SPT) three lines of business: Distribution, Production and Networks. With an audience-obsessed attitude, the analyst will be focused on connecting the dots between programming, ad sales, marketing, and affiliate departments, through the permanent generation of timely and relevant audience insights and post advertising campaign reports. Some responsibilities include in-depth content trends analysis: TV series, formats and OPs (linear and non-linear); competitive analysis and client investment ROAS analysis. The analysis will also conduct a broad range of market intelligence research on the LATAM television industry, including TVE and social media, synthesizing a variety of resources that will include internet, multiple research data software, industry reports, etc.

Responsibilities:
- Create and automate regular reports and scorecards, on content trends TV Series, Formats and local language Original Productions, and on market specific intelligence across platforms (linear and non-linear).
- Use of statistical tools to identify, analyzed, and interpret patterns and trends that could be helpful for diagnosis and predictions.
- In-depth analysis and reporting on Sony TVE and competition.
- Analyze competitors performance (contents & channels), in LATAM. Track best in class executions, develop guidelines, benchmarks and norms.
- Understand, gather and disseminate intelligence on local, regional and global television business, content and programming trends across multiple platforms: Free TV, Cable, Pay TV, TVE, Social Media and OTT.
- Own the design and creation of presentations and analysis reports on different business areas; preparing final analysis reports for stakeholders to understand the data analysis steps, enabling them to take important decisions based on various facts and trends
- Develop and maintain a direct working relationship with the existing research teams and any business areas, within the regional offices.
- Exploration and detection of relevant and leading edge internal opportunistic projects analyzing local, national and global trends that impact both the organization and the industry.
- Help manage the LATAM research tool kit initiatives.
- Participate in relevant conferences, workshops and research industry groups in order to build and maintain strong industry contacts, develop vendor relationships and stay abreast of latest tools and methodologies.
- Use automated tools to extract data from primary and secondary sources.
- Innovate in ways to share and propagate audience insights across the organization.
-Help pitch to new clients, analyze their campaigns, and provide insights on the results.

Requirements:
- 1+ years of experience working in research/analysis.
- Strong Excel, data visualization and PowerPoint skills are required. Tableau experience is a plus.
- Data nomad with strong skills to collect, measure, organize and analyze data
- Must be numerate, have the ability to analyze audience research data and comfortable working with large data sets.
- Strong attention to detail and ability to write clear, meaningful and concise analyses.
- Experience with at least 1 software is required: TechEdge, Instar, Alteryx, TGI, Ampere, and Monitor is preferred.
- Excellent verbal and written communication skills. Fluency in English and Spanish is required (written and spoken). Portuguese is a plus.
- Strong interest and knowledge of international business, entertainment and cultures and consumer behavior.
- Must be proactive, motivated, highly-organized and a self-starter; with exceptional problem solving skills.
- Team player with ability to work independently and with multiple projects.
- Experience with primary research including building questionnaires and mining meaningful insights and recommendations.
- Proven working experience in data analytics.

Education: Bachelor's degree is required. Needs to have a combination of technical as well leadership skills. A background in Mathematics, Statistics, Computer Science, Information Management or Economics, also a degree in Industrial Engineering, Systems Engineering, Marketing Professional focused on Data, Economics.
#LI-NT1

COL - Bogota - Calle 79

Jobcode: Reference SBJ-rj9eb2-18-226-150-175-42 in your application.