Business Intelligence Intern

P

Public Media Group of Southern California

Posted 2 months ago

Internship

Burbank, California

Hybrid

Smart Summary

Responsibilities

The intern will support reporting and analytics workflows by producing KPI reports and managing data organization. They will also create data visualizations and conduct research to inform strategic decision-making.

Qualifications

You have proficiency in Excel, including formulas and pivot tables, and a strong interest in working with data to identify trends and insights. You are also eager to learn data visualization tools like Tableau and possess strong attention to detail for data accuracy.

Must Have Skills for ATS

Excel

Tableau

YouTube Analytics

Google Analytics

KPI tracking

Data visualization

Data cleaning

Data validation

Job Description

Position Title: Business Intelligence Intern

Department: Marketing & Communications

Classification: Temporary, Intern, Part-Time (20-25 hours), Non-Exempt

Reports to: Business Intelligence Specialist

Duration: July 20, 2026 – October 9, 2026

Location: Burbank, CA (Hybrid)

Compensation: $18.00/ hourly

Work with a Purpose!

PBS SoCal is looking for a Business Intelligence Intern to join our organization. If you enjoy working with data, uncovering trends, and supporting data-driven decision-making, please send your resume and cover letter today!

About PBS SoCal

PBS SoCal tells stories that matter through original programs that reflect the diversity of the region and the full schedule of trusted PBS and PBS SoCal programs. Our content channels are available for free on internet-connected screens through the PBS and PBS KIDS App, as well as seven local broadcast channels including PBS SoCal and PBS SoCal Plus.
 

A donor-supported community institution, PBS SoCal sparks the sharing of ideas at in-person cultural events and community conversations as well as delivers social impact through services that prepare our most vulnerable children for school.

Job Overview

The Business Intelligence Intern will support PBS SoCal’s reporting and analytics workflows by supporting data needs, including producing KPI reports, and assisting with data organization and visualization.

Primary Duties/Responsibilities:

  • Extract, organize and report on data from Tableau dashboards, YouTube Analytics, and internal sources
  • Edit and update Excel spreadsheets, including adjusting formulas, pivot tables, and reporting templates 
  • Perform data cleaning, validation, and organization to ensure accuracy 
  • Generate recurring reports (KPI tracking, departmental reports, YouTube performance summaries)
  • Create and edit data graphs and other data visualizations to communicate key findings
  • Update and edit PowerPoint presentations or stakeholders or cross functional use
  • Identify trends and patterns in audience, content performance, and KPIs
  • Conduct industry and audience research to inform decision-making
  • Provide basic insights and summaries to support strategic initiatives

Qualifications:

  • Familiarity and/or interest in Media & Entertainment
  • Interest in working with data and translating it into clear trends, insights, and actionable takeaways 
  • Proficiency in Excel (formulas, pivot tables, data organization)
  • Experience with or willingness to learn data visualization tools (e.g., Tableau)
  • Strong attention to detail, especially in data cleaning, validation, and reporting accuracy 
  • Ability to manage multiple projects, prioritize tasks, and meet deadlines independently 
  • Basic understanding of analytics platforms (e.g., YouTube Analytics, Google Analytics) is a plus
  • Strong communication skills, with the ability to present data clearly to non-technical audiences 

Physical Demands

While performing the duties of this job, it is regularly required to sit; use hands to finger, handle, or feel objects, tools, or controls reach with hands and arms; and talk or hear. The employee is also required to stand and walk.

Work Environment

The working conditions are primarily a telecommuting setting. However, the position will require some mandatory and optional off-site travel to our Burbank, CA and Costa Mesa, CA offices, printers and/or other locations as needed. 

Equal Opportunity Employer

PBS SoCal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regards to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. 

P

Public Media Group of Southern California

PBS SoCal takes pride in sharing stories that matter—with original programs that reflect the diversity, culture and beauty of our region, and the full schedule of trusted PBS programs. Our content channels are available on TV or your favorite device via the free PBS app. Within our community we deliver experiences that inspire, inform and entertain—both in-person and virtually. And our education efforts are at the center of early learning in California. We are dedicated to providing accessible resources, community events and free programming because we believe every child deserves to be prepared for school and that learning doesn’t stop in adulthood.
Runway Icon
Boost Your Interview Chances

With Runway

See Your Fit for This Role

1-5 min

Your Score

?

Top Applicants

90%

Your Job Search Advantage

Key Gaps & Next Steps:

Address these in your resume & Interview

Top Strengths For This Role

Highlight these in your cover letter & interview

Your Interview Guide

A Personalized Interview Strategy

Freshest Opportunities

Never Miss a Good Fit

Get notified when jobs mach your criteria