Business Intelligence Intern

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/hour

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.

• Extract, organize and report on data from Tableau dashboards, You Tube 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, You Tube 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

• 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., You Tube Analytics, Google Analytics) is a plus
• Strong communication skills, with the ability to present data clearly to non-technical audiences

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.

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.

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.