Systems & Data Analytics Intern, US TV Production – Fall 2025
Job Description
- Prior experience in a TV studio
- Experience building solutions using data
- Pursuing a Bachelor's Degree in a technical or STEM field
- Knowledge of Airtable or other no-code applications
- Knowledge of relational data modeling
- Strong skills in SQL and Tableau
- Advanced Excel and PowerPoint skills
- Excellent verbal and written communication skills
- Ability to grasp requirements and convert them into specs
- Curiosity about TV show development and production processes
- Paid assignment
- Meaningful and productive work
- Skill development opportunities
- Challenging tasks
- Real-world experience
- Educational and social networking opportunities
- Comprehensive benefits may apply
PROGRAM DETAILS
SPE INTERN:
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 builds on your experience and develops your skills further. You will be provided with challenging tasks, real-world experience, and many educational and social networking opportunities.
This Fall Internship is from September through December 12th (start and end dates are flexible based on school schedules) and all candidates must be able to work 10-29 hours/week, in person in the specified office location. This position is ideal for a student enrolled in an accredited college or university interested in continuing their education through professional experience.
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 data warehouse on Snowflake, 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, build and deploy executive dashboards using Tableau 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 in Airtable
- 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 Airtable.
- Provide support for live modules, including resolving basic queries and escalating issues as needed.
- Build user-friendly, self-serve Tableau dashboards using the Snowflake data 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:
- Currently pursuing a Bachelor's Degree in a technical field or STEM
- 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
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.
