Spring Paid Intern - Business Intelligence
KCET
Los Angeles, CAThis is a Part Time Paid Internship
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)
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!
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.
Salary/Benefits
$18.00 /hour USD
Additional Information
PBS SoCal tells stories that matter through original programs reflecting the region's diversity, alongside a full schedule of trusted PBS and PBS SoCal content. Our channels are accessible for free on internet-connected screens via the PBS and PBS KIDS App, as well as through seven local broadcast channels, including PBS SoCal and PBS SoCal Plus. As a donor-supported community institution, PBS SoCal fosters the sharing of ideas through in-person cultural events and community conversations, while also delivering social impact by providing services that prepare our most vulnerable children for school.
