Logo of Huzzle

Internship

Systems & Data Analytics Intern, US TV Production - Summer 2024

🚀 Summer Internship

Culver City

AI generated summary

  • You must have a technical or STEM Bachelor's degree, expertise in Airtable, SQL, Tableau, Excel, and PowerPoint. Strong communication, problem-solving, and analytical skills are essential. Prior experience in TV production is a plus.
  • You will support data analytics projects, assist in developing user-friendly interfaces, collaborate with team members, normalize and load data, build Tableau dashboards, liaise with cross-functional teams, seek skill enhancement opportunities, and clarify project aspects as needed.

Summer Internship

Data, Media & JournalismCulver City

Description

  • This Summer Internship is from May/June through August 30th (start and end dates are flexible based on school schedules) and all candidates must be able to work 40 hours a week, Monday through Friday in the specified location. This position is ideal for a student enrolled in an accredited college or university. A hybrid work structure may or may not be available. 

Department Description:

  • Sony Pictures US TV Production is in the process of developing Xpanse, a comprehensive digital solution aimed at managing all data related to the development of new TV shows. Xpanse will serve as a central data repository, eliminating existing data silos and operational inefficiencies. The data derived from Xpanse will be integrated with information from SPT’s “TruthInData” (TiD) data warehouse, unlocking strategic views for executive management.
  • As an intern on our team, you will collaborate with cross-functional teams to gather and synthesize business requirements, support the development of data tables and new workflows in Airtable, and provide basic support for deployed modules, all while immersing yourself in the inner workings of TV production and the transformative power of data analytics.

Requirements

  • Pursuing a Bachelor's degree in technical or STEM major
  • Knowledge of Airtable or other no-code applications
  • Knowledge of relational data modeling; strong skills in SQL, Tableau
  • Advanced Excel and PowerPoint skills
  • Excellent verbal and written communication skills are a must as this role requires interaction with production and business development executives.
  • Ability to quickly grasp requirements and convert them into specs for development
  • Curiosity in gaining a thorough understanding of the entire TV show development and production business process
  • Preferred Qualifications:
  • Prior experience working in a TV studio, preferably building solutions using data.

Education requirements

Currently Studying
STEM
Bachelors

Area of Responsibilities

Data
Media & Journalism

Responsibilities

  • Aid in understanding complex business requirements and assist in transforming them into user-friendly application interfaces using Airtable.
  • Assist in the development of underlying data tables and application workflows.
  • Collaborate with the senior team members to ensure that the interface meets user needs effectively.
  • Support the data conversion processes to facilitate a smooth transition to Xpanse for different departments. Learn to normalize existing trackers and load data into Xpanse.
  • Provide support for live modules, including resolving basic queries and escalating issues as needed.
  • Build user-friendly, self-serve Tableau dashboards using the TruthInData warehouse.
  • Assist in liaising with cross-functional teams and contribute to end-to-end process flow discussions.
  • Actively participate in learning sessions and seek opportunities to enhance skills relevant to the role.
  • Take the initiative to understand different aspects of the project and seek clarification when needed.

Details

Work type

Full time

Work mode

hybrid

Location

Culver City