How Seven.One Entertainment Orchestrates Data Pipelines with Prefect

In 2019, Seven.One Entertainment, part of the ProSiebenSat.1 Media SE Group, revamped its data infrastructure when relaunching its streaming service Joyn, transitioning from outdated on-premise systems to a modern, cloud-based setup using Snowflake for data warehousing and dbt for data modeling. This shift enabled the data engineering team, led by Conrad Fritzlar, to build a flexible and efficient system to support the company's B2C streaming service and its strategic B2B partnerships across Germany, Austria, and Switzerland. Prefect was chosen over Airflow for its Python-native, code-centric approach to orchestration, offering ease of adjustment, flexibility, and cost-effectiveness, which were essential for managing complex data pipelines. Prefect plays a crucial role in orchestrating data flows from various APIs and source systems into Snowflake, handling tasks from data extraction to quality testing, and facilitating seamless integration with reporting tools, CRM, and analytics teams. This modern infrastructure not only enhances performance and monitoring but also provides deep control and visibility, allowing the team to efficiently manage interconnected data pipelines and make data-driven decisions that shape programming and advertising strategies.