Global Insights Industry Analyst

Job Description

ABOUT THIS JOB

The Market Insights team is responsible for providing standard, critical, insights to Product Business leaders that enable them to support Client needs and make data- driven decisions and action.This role would be responsible for building global entertainment industry reports for the Product Organization and business intelligence initiatives. Country- by- country metadata needs to be studied from our internal database and from industry and 3rd party sources on total content availability. This role would be responsible for creating and managing reporting via popular data visualization tools such as reports and dashboards, preparing WBRs, MBRs, and QBRs, as well as automating reporting to stakeholders

. RESPONSIBILITIES: Use SQL, ETL and databases in a business environment with large- scale, complex datasetsFormulating SQL queries and optimizationGathering business requirements, standard business intelligence tool(s), formulate metrics/KPIs and build reportsCreating / Designing dashboards with the use of visualization tool Amazon Quicksight or PowerBI or Tableau that are able to communicate insights into the dataAnalyzing the data so as to identify trends and share meaningful insights with customersLead discussions with diverse global teams to understand data structures, and design solutions in the form of reports / dashboardsDevelop Market Grading Framework : Help grade key markets by comparing the universe of content with internal coverages.Analyze internal coverage of metadata rich media across verticals (video, music, and sports)Define standardized measurement techniques for internal coverage across countries, data sets, verticals, and offices.Define Universe of Content (video, movies, music, and sports) in the entertainment industry for various key markets based on content available and consumed by the end users.Collate list of top content / content providers per market using Nielsen reports, third party reports, and secondary research.Identify new sources of information to provide target lists to internal teams and aid operational efficiency.Create clear, comprehensive documentation including process maps, SOPs, training materials, presentations, reference guides.

A LITTLE BIT ABOUT YOU

Proactive Able to influence and persuade Strong interpersonal communication skills. Ability to analyse and interpret data in a challenging and insightful manner. Strong and articulate verbal and written communication skills. Efficient time management, ability to multi- task and detail- oriented. Displays maturity and creative problem- solving skills in handling crises. Recommend improvements in work processes within the area of responsibility.Analyses and interprets information to ensure the achievement of business targets and early identification of issues/crisis.

QUALIFICATIONS: Experience: 5- 7 years experience in a similar role (data analytics / secondary research for insights or data modelling) Experience with large- scale data warehousing and analytics projects, including using AWS technologies Postgres, AWS- Redshift, S3, etc.Working knowledge of running advanced Sql queries to create reports is a mustKnowledge of Reporting and Analytical tools like AWS Quicksight, TIBCO Spotfire, Tableau, QlikviewAbility to create robust, reusable data querying, transformation, and visualization processes in SQL and ExcelExperience with large data sets, ability to write/execute SQL queries to extract, review and understand; Experience with reporting, data management, or data analytics, including standard and ad- hoc reportingStrong Communication Skills: Ability to explain data to business / operations leadersAbility to understand and learn usage of new reporting and analytics toolsAnalytical and Problem Solving ApproachCreative approach towards data visualization and story- tellingInclination towards secondary research and data analyticsKnowledge of Coding in PySpark or Scala, AWS Redshift, AWS RDS would be an added advantage.

Keyskills :
data analyticsdata warehousingbenchmarkingforecastingcounter terrorist checkindustry analysisdata structuresproblem solvingbusiness operationsmarketingindustry reportsdata managementrich mediatime managementwork processessecondary research