If you think all the fun only happens in summer, think again! NBCUniversal has expanded our Academic Year Internship Program. As an Academic Year intern, you’ll get immersed in exciting work, experience our unique NBCU culture, and feel the real support and guidance for 2 whole semesters.The NBCUniversal Internship Program allows students to unlock their potential by contributing to big projects in meaningful ways that matter. To thrive as an NBCU intern, you are ready to bring your passion for media, entertainment, and technology along with your desire to learn each day.In addition to our internships being paid, we will also offer the following for our Academic Year interns:
Paid time off for mental health, school exams, and personal holidays.
Robust networking, learning and development opportunities.
Complimentary Peacock subscription during your internship.
Free admission to Universal Parks to use during your internship.
Access to mental health resources including counseling sessions.
Academic Year Recruitment Timeline:
April 8 – April 26: Applications Open (may close early due to applicant volume)
Mid-April – Late May: First round video interviews
Early – Mid June: Second round interviews
Late June – Early July: Selected candidates receive offers
Academic Year Internship Program:
Applications Close: April 26th at 11:59pm ET. Pro Tip: Submit your application as soon as possible – applications could close earlier due to applicant volume!
Program Dates: September 16, 2024 – April 18, 2025
Time Commitment: 16-24 hours per week. Exact schedule to be determined based on business need. We will do our best to accommodate course schedules.
Format: Opportunities listed will be fully virtual.
To Apply:
Submit a one-page resume that outlines your work experience, accomplishments, and your graduation month and year.
Submit a cover letter that highlights your passion for NBCUniversal, the locations (listed below) you are open to for internships, and your top areas of interest (opportunities listed below).
Upload a transcript (unofficial transcripts are fine) that confirms your status as an actively enrolled student in a degree-granting program.
Content Distribution is a division of NBCUniversal which drives the North American distribution of NBCUniversal’s multi-billion-dollar broadcast and cable network portfolio, accounting for a large percentage of the total NBCUniversal TV revenue. We ensure NBCUniversal’s networks, Peacock and the Olympics have the widest possible distribution across cable, satellite, telco and streaming distribution platforms that reach more than 90M households (e.g. Comcast, DIRECTV, Verizon, Hulu Live TV, YouTube TV, Optimum, Spectrum, etc.). Areas of placement may include, but are not limited to:
Program Management Business Intelligence:this intern will be part of the Content Distribution Digital Products and Operations team. They can expect to play an important role that stretch across multiple teams within Content Distribution and across external technology teams. Project and role responsibilities will include but not limited to creating and deploying data visualizations using Tableau or Metabase and developing alerts to continuously monitor health program streams.
Responsibilities:
Works within a collaborative team environment
Problem solving issues within Content Distribution databases:
Identify problems within processes, break down issues that are causing the problems, identify possible counter measures, conduct experiments to test counter measures to see which one works best, deploy the fix
Cleaning data by de-duping, standardization, and flagging missing values
Extract, Transform, Load (ETL) new datasets into SQL servers, ensuring fit within current database infrastructure
Develop and maintain data models, ETL processes, and data pipelines using Python and SQL Server Integration Services (SSIS)
Manage user access permissions through Active Directory (ADGroup) and Microsoft Security Support Provider Interface (SSPI) for various data platforms and tools
Create and deploy data visualizations using Tableau or Metabase, helping team with the early detection of trends
Develop alerts to continuously monitor health program streams
Basic Requirements:
Must be actively enrolled in a degree-granting program at an accredited institution during the entire duration of the program (September 2024 through April 2025). December 2024 graduates are not eligible for our 2024-2025 Academic Year Program.
Current class standing of sophomore or above (30 credits).
Must be authorized to work in the United States throughout the entire duration of the internship (September 2024 to April 2025). Visa sponsorship is not available for this position.
Must be available to work 16-24 hours per week from September 16, 2024 to April 18, 2025.
Must be working from a location within a U.S. state during all hours worked.
Desired Characteristics:
Students with class standing of junior or above preferred.
Cumulative GPA of 3.0 or above.
Demonstrate experience in the following areas through examples:
Problem solving:
Identified problems within processes
Broken down the issues that were causing the problems
Identified possible counter measures
Conducted experiments to test counter measures to see which one works best
Deployed the fix
Has worked in a collaborative team environment, developing relationships with team members to build out products
Continuously self-develops: constantly explores new methods and technologies
Proficient in using Windows-based workstations
Proficient in using MS Office applications, especially Excel and PowerPoint
Outstanding verbal and written communication skills
Strong organizational skills and outstanding attention to detail
Enrolled in Bachelor or Master degree with one of the following:
Computer Science, Statistics, Information Systems, Data Analytics, Business Analytics, Business Intelligence
Minimum of one (1) year of experience working with the following:
Windows-based workstations
Python, SQL, Tableau, MS Excel, VBA, MS Visual Studio Code
Active Directory (ADGroup) for user access management
Microsoft Security Support Provider Interface (SSPI) for Windows authentication
Developing dashboard and views using data visualization applications (e.g. Tableau; Power BI)
Reading and writing SQL queries
SQL joins and common SQL table expressions
Working with multiple data sources and data types
Evaluating datasets for quality and accuracy by identifying discrepancies within datasets
The hourly rate for student interns is $17.00. INFORMATION FOR INTERNATIONAL STUDENTS ATTENDING U.S. UNIVERSITIES:To participate in NBCUniversal’s 2024-2025 Academic Year internship program, you must confirm at the time of interview that you will be able to provide US work authorization documentation for the entire duration of the internship. Since the NBCU Academic Year Internship Program spans the traditional “Fall” and “Spring” semesters, you should talk to the DSO at your school’s International Students Services Office about your need to apply for CPT work authorization twice to ensure you are authorized to work both semesters and throughout the entirety of the program.Please also note that future visa sponsorship at NBCUniversal is rarely available for post-grad employment opportunities.NBCUniversal is an E-Verify company, requiring all employees to have an active Social Security number. Any candidate receiving an internship offer must complete Form I-9 with their Social Security number within 3 days of hire.NBCUniversal's policy is to provide equal employment opportunities to all applicants and employees without regard to race, color, religion, creed, gender, gender identity or expression, age, national origin or ancestry, citizenship, disability, sexual orientation, marital status, pregnancy, veteran status, membership in the uniformed services, genetic information, or any other basis protected by applicable law. NBCUniversal will consider for employment qualified applicants with criminal histories in a manner consistent with relevant legal requirements, including the City of Los Angeles Fair Chance Initiative For Hiring Ordinance, where applicable.If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation if you are unable or limited in your ability to use or access nbcunicareers.com (https://urldefense.com/v3/http:/nbcunicareers.com;PIZeeW5wscynRQ!tBIiGQl9cEyIpf2fnCplIX7lHcMjOrwjMErBWxBF41wmJ1C2GUQTdFw9U5k8SrRSS2O3wUToIzsrW9iI4of-FaGlc0Ng$) as a result of your disability. You can request reasonable accommodations in the US by calling 1-818-777-4107 and in the UK by calling +44 2036185726.