You are viewing a preview of this job. Log in or register to view more details about this job.

Analyst, Data Management & Reporting

Sony Pictures Entertainment
Email

Worldwide Television Distribution is based in Culver City and responsible for licensing features, series and formats to linear and digital platforms worldwide. The team has a very open and collaborative culture with a focus on individual development and innovation. Senior leadership of the team is highly accessible and fosters growth. The working environment is enriched by the mix of talent from sales, engineering, business development and management consulting. The LA based Sales Analytics and Insights team collaborates with teams globally and focuses on both local and international projects.

The Role
The Analyst must have hands on experience in working with Excel, SQL and other BI tools (e.g. Tableau and Alteryx). Good working knowledge of database architectures and systems (Snowflake, Oracle and Teradata) preferred. This role would be best suited to a technically savvy person with an impeccable attention to detail and passion for problem-solving. This role is a great opportunity to learn about the television distribution sales business and the analytics and data science beyond the deal making.

The Analyst’s primary responsibility will be to develop and maintain data flows/pipelines, improve ETL processes/data quality and develop data manipulation workflows in Alteryx automating manual solutions. He/she will develop and enhance existing dashboards in Tableau, providing insightful visualizations and dashboards. In addition, he/she will assist with analytics and insights including deal analysis bringing together deal/licensing nuances, performance data and market dynamics. Analysis will involve excel modelling and data visualizations tools.

This role operates at the intersection of advanced analytics, business intelligence and data systems and as such, the candidate must have a passion for data and analytics. Experience diving into analytical problems and synthesizing disparate data sources is required. Experience in analytics, coding, and/or a basic understanding of machine learning algorithms, data science concepts and SQL are a plus.

Responsibilities

DATA MANAGEMENT

  • Develop data flows/pipelines using SQL queries, i.e. create tables and views
  • Work with IT to improve ETL processes and data quality by having a great attention to detail.
  • Recommend changes to the data structures to improve efficiency and speed of various Tableau dashboards.
  • Synthesize findings and needs into technical requirements and work with cross functional stakeholders to ensure effective implementation.
  • Assist in creating documentation for end-to-end processes.


DATA REPORTING

  • Create and maintain insightful Tableau dashboards. Provide advanced visualization and dashboard customizations to business users.
  • Develop and tune existing Alteryx workflows to automate manual solutions
  • Promote and enable data-driven decision-making across the organization by creating tools to help scale the analytics capability across the organization.
  • Collaborate with users across the globe to identify best practices and build globally scalable solutions for sales planners


ANALYTICS & INSIGHTS

  • Support the business with ad hoc reporting and analyses involving multiple data sets, i.e. performance trends, licensing patterns
  • Translate analyses into actionable insights and recommendations

 

Qualifications

EDUCATION

  • Bachelor’s degree in Data Science, Data Analytics, Information Technology, Business Management, Finance, Computer Science or relevant field.
  • A minimum of 1-2 years relevant experience in TV distribution, sales planning or related areas.


KNOWLEDGE/EXPERIENCE

  • Experience in using BI tools such as Tableau, Alteryx and proficiency in SQL.
  • Highly proficient in Excel (i.e. VBA, pivot tables, formulas) and other Microsoft Office applications.
  • Experience working in cross functional environments with multiple teams such as sales, marketing and IT.
  • Programming experience in any language (R, Python, SQL etc) is a plus


SKILLS

  • Excellent data manipulation, data cleaning and data visualization skills for summarizing large data sets to help facilitate decision making and strategic planning
  • Aptitude to learn new technologies and systems used to pull and analyze data
  • Attention to the layout and design of how analytical information is presented
  • Strong intellectual curiosity and love of problem-solving with a passion for getting involved to drive action for direct impact on business outcomes
  • Curious, quick learner and detail oriented
  • Self-motivated, flexible and able to operate with limited guidance and direction under changing priorities and/or tight timelines
  • Ability to prioritize multiple important projects
  • Proficient at establishing relationships with cross-functional peers
  • Proactive, positive team-player