What are the responsibilities and job description for the Business Intelligence Intern position at Public Media Group of Southern California?
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.
Salary : $18