Business Intelligence Analyst

OVERVIEW OF THE COMPANY

Fox TV Stations

FOX Television Stations owns and operates 29 full power broadcast television stations in the U.S. These include stations located in 14 of the top 15 largest designated market areas, or DMAs, and duopolies in 11 DMAs, including the three largest DMAs (New York, Los Angeles and Chicago). Of these stations, 18 are affiliated with the FOX Network. In addition to distributing sports, entertainment and syndicated content, our television stations collectively produce approximately 1,200 hours of local news every week. These stations leverage viewer, distributor and advertiser demand for the FOX Network’s national content.

JOB DESCRIPTION

Business Intelligence Analyst

Location: Los Angeles, CA Team: Digital Strategy & Product Position Type: Full-time

About the Role

We’re looking for a detail-oriented and analytical Business Intelligence Analyst to join our fast-paced team. In this role, you’ll be responsible for managing, analyzing, and reporting on key performance metrics across our FAST (Free Ad-Supported Streaming TV) channels and digital platforms, including CTV, mobile, and web. You’ll collaborate closely with teams across Digital Strategy, Product, and Data Platforms to deliver insights that drive data-informed decisions and influence content and product strategies. This role will report directly to and working closely with the VP Digital Strategy & Business Development.

Key Responsibilities

Digital Platform Metrics Management & Reporting:

• Analysis & Interpretation: Interprets viewership metrics, audience demographics, and engagement data to provide actionable insights for content acquisition and programming decisions. Goal is to identify patterns, trends, and opportunities for growth.
• Reporting & Dashboarding: Creating clear, actionable reports and real-time dashboards for non-technical stakeholders (programming, marketing, ad sales teams).
• Collaboration: Working cross-functionally with content, product, ad sales, and engineering teams to ensure data needs are met and insights are integrated into workflows.
• Present findings and recommendations to leadership team (including C-Suite), supporting implementation of business solutions and functional initiatives.
• Drives the execution of data strategies for the channel, identifying trends, and presenting findings to stakeholders to improve performance.
• Manage the weekly end-to-end data pipeline for FAST platform metrics including data extraction, transformation, and loading.
• Run and maintain Python scripts to standardize data from various partner platforms for ingestion into our data warehouse.
• Collaborate with leadership partners to define goals, develop hypotheses, and establish research plans addressing key business challenges.
• Serve as the primary point of contact for all FAST data inquiries and ad-hoc reporting requests from stakeholders, including Digital Strategy, Marketing, and Sales.

Data Integrity & Pipeline Maintenance:

• Conduct regular data quality checks to ensure the accuracy and reliability of our reporting, identifying and investigating anomalies such as missing values, odd patterns, or significant deviations.
• Follow a structured process for issue resolution: identify the root cause, notify stakeholders with a timeline for correction, resolve the issue, and confirm resolution.
• Collaborate with the Data Platforms team to maintain and enhance the logic of the FAST data pipeline in Snowflake.
• Manage and update mapping tables to ensure consistent channel naming and structure across all platforms.
• Conduct market research on emerging trends and technologies (e.g., AI tools) to provide strategic recommendations and inform the product roadmap.

Required Qualifications & Skills

• Skilled at turning data into insights with visualization tools — especially Tableau.
• Fluent in SQL, with the ability to navigate and manipulate large datasets — ideally in a cloud environment like Snowflake.
• Hands-on with Python, R, or other scripting languages using it to transform data, automate processes, and streamline workflows.
• Analytical by nature, with strong problem-solving instincts and the drive to tackle complex data challenges from start to finish.
• Excellent written and verbal communication skills; able to simplify complex data and present to diverse audiences with clarity and confidence.
• Understanding of statistical methods such as regression, forecasting, and experimentation frameworks
• Clear communicator and collaborator, able to partner seamlessly with cross-functional teams and translate data findings into actionable business outcomes.
• Ability to frame ambiguous or unstructured business problems into clearly defined requirements with minimal oversight.
• Proactive and curious problem solver, driven to uncover patterns and performance drivers within a complex direct-to-consumer environment.
• Strong communication skills, with the ability to adjust to a variety of audiences and tell compelling stories with data.
• Familiarity with the FAST/CTV ecosystem and associated performance metrics.

Preferred Qualifications

• Experience in the digital media, streaming, or broadcast industry.
• Direct experience with digital analytics platforms, such as Adobe Analytics.
• Experience managing manual ETL (Extract, Transform, Load) processes.
• Strong background in statistics, mathematics, or economics.
• Hands-on experience working with event/clickstream data from web and mobile applications.
• Skilled in designing and analyzing A/B tests and interpreting results with statistical rigor.
• Familiarity with causal methods (propensity score matching, difference-in-differences, synthetic controls, etc.).