Business Intelligence Specialist

This is a Full Time Job

• Position Title: Business Intelligence Specialist

Department: Marketing and Communications

Supervisor: Senior Director, Marketing and Business Intelligence

Classification: Regular, Full-Time, Non-Exempt

Location: Burbank, CA (Hybrid)

Compensation: $33.50-$38.50/ hourly

Work with a Purpose!

PBS SoCal is looking for a Business Intelligence professional to become the driving force behind our data driven- strategies. In this important role you will leverage cutting edge tools and techniques to provide critical business insights. If you are you're ready to make an impact with your analytical expertise and problem-solving skills, submit your cover letter and resume 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 SoCal programs. Our content channels are available for free on internet-connected screens, including six local broadcast channels and one national satellite channel.

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 Specialist is responsible for collecting and reporting multi-platform viewership data to help track organizational KPIs. This includes compiling, organizing, and analyzing various data sets to measure audience reach and campaign success. This role will also support the maintenance and reporting of tools and resources, including annual insights and data dashboards.

Primary Duties/Responsibilities:

60% Reporting
• Complete monthly multi-platform KPIs, campaign wrap, programming deep dives, and ad hoc reporting requests
• Responsible for downloading, formatting, and organizing raw data metrics for audience reporting, across platforms, including broadcast, digital, email and social data sources
• Utilize various third-party tools to query data (Nielsen Arianna & NLTV, Myers ProTrack, Google Analytics, Domo, Sprout Social, etc.)
• Monitor, maintain, and report on multi-platform KPIs using established Tableau dashboards
• Coordinate with internal and external data teams/agencies to ensure changes in reporting platforms are accurate
• Provide admin support, including QC & troubleshooting discrepancies, for Tableau dashboards & data warehouse

25% Analysis
• Interpret and present data into a visual and comprehensive narrative
• Analyze data trends and audience tracking
• Coordinate data request with colleagues’ cross-functionally

15% Administrative
• Create and maintain an archival process for all data and past analysis
• Participation in department and project meetings
• Other duties as assigned

Minimum Qualifications:
• Bachelor’s degree (an emphasis in Business, Marketing, Computer Science or related field is preferred)
• 2-3 years of working with complex data sets, analytics, or related experience
• Experience working with large data sets (broadcast, digital, marketing, or social media data)
• Experience with Google Analytics
• Experience with Nielsen products
• Experience with visualization software (Google Data Studio, Tableau, Microsoft B)
• Proven understanding of the media landscape (Broadcast TV, OTT, mobile viewing, etc.)
• Proficient in Microsoft Office - Word, Excel, PowerPoint, Outlook (advanced level in Excel and experience with CSV files)
• Ability to juggle multiple deadlines at once and effectively prioritize work
• Highly organized and detail-oriented, with a passion for accuracy
• History of communicate effectively and efficiently with internal clients

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 Burbank, CA, Costa Mesa, CA, vendors 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.