Systems & Data Analytics Intern, US TV Production – Spring 2025

3 Weeks ago • All levels • Data Analyst

About the job

SummaryBy Outscal

Must have:
  • Airtable knowledge
  • SQL proficiency
  • Tableau expertise
  • Advanced Excel
Good to have:
  • Relational modeling
  • TV studio exp.
  • Data solutions
  • STEM degree
Perks:
  • Paid Internship
  • Hybrid Structure
Not hearing back from companies?
Unlock the secrets to a successful job application and accelerate your journey to your next opportunity.

Our Emerging Talent Programs, which includes Interns, Trainees, and Finance Rotational Associates, offer unique opportunities for students, recent graduates, and emerging talent to work alongside the teams that come together to create movies, TV shows, and other great experiences. These seasonal, paid assignments provide meaningful and productive work that allows you to build on your experience and develop your skills further. You will be provided with challenging tasks, real-world experience, and many educational and social networking opportunities.

                                                                                                                                             

This Spring Internship is from January through May 30th (start and end dates are flexible based on school schedules) and all candidates must be able to work part-time hours (10-29 a week). Our offices are open Monday through Friday, 9-6 pm. 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.

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 initiative to understand different aspects of the project and seek clarification when needed.

QUALIFICATIONS:

  • 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:

  • Bachelor's degree in technical or STEM major
  • Prior experience working in a TV studio, preferably building solutions using data

The anticipated base salary for this position is $22/hour. This role may also qualify for comprehensive benefits. The actual base salary offered will depend on a variety of factors, including without limitation, the qualifications of the individual applicant for the position, years of relevant experience, level of education attained, certifications or other professional licenses held, and if applicable, the location of the position.

Sony Pictures Entertainment is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, veteran status, age, sexual orientation, gender identity, or other protected characteristics.

SPE will consider qualified applicants with arrest or conviction records in accordance with applicable law.

To request an accommodation for purposes of participating in the hiring process, you may contact us at SPE_Accommodation_Assistance@spe.sony.com.

View Full Job Description

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug