Business Intelligence Intern

Public Media Group of Southern California • Burbank, CA

3d • Hybrid

About The Position

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.

Requirements

• 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

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

What This Job Offers

• Job Type: Part-time
• Career Level: Intern
• Education Level: No Education Listed