THE ROLE

We are looking for a Data Analyst to join Zattoo's BI Team following an internal transition. This is not a typical dashboard-producer role. We want someone who combines deep technical craft — writing production-grade SQL, building DBT models, orchestrating pipelines — with the commercial instinct to turn raw data into decisions. We are also actively exploring how AI and LLM tooling can augment the way we work, and we want someone genuinely curious about that space.

This role sits at the intersection of Data Engineering and Business Analysis. You will own analytical products end-to-end: from schema design and DBT model authorship, through to stakeholder presentations and strategic recommendations - without needing to hand off at either end.

 

THE TEAM

You'll join a compact BI team of four analysts, reporting to the Head of Business Intelligence. We operate across Zattoo's DE, CH, and AT markets, supporting product, commercial, and executive stakeholders. We process 6 TB of event data daily and are mid-way through a migration from a legacy Vertica/Jenkins stack to a modern GCP architecture (BigQuery, Airflow, dbt). There is real scope to shape how we do things - this is not a maintenance role.

 

WHAT YOU’LL DO

• Own analytical domains end-to-end: Design and maintain DBT models, write production SQL in BigQuery, and deliver finished insight - not raw data - to stakeholders.
• Proactively generate business insight: Go beyond answering questions. Identify trends, anomalies, and opportunities autonomously and bring them to the relevant team before they ask.
• Build and maintain Tableau dashboards: Design decision-oriented dashboards tuned for product, commercial, and executive audiences - including external-facing B2B analytics.
• Collaborate on the data stack: Work closely with Data Engineers on Airflow pipelines, schema evolution, data quality and governance. You should be comfortable reading and contributing to pipeline code.
• Partner with stakeholders: Translate ambiguous business questions into analytical frameworks. Run working sessions, present findings, and advocate for data-informed decisions at all levels.
• Support A/B testing and experimentation: Design test setups, validate statistical significance, and communicate results as clear product recommendations.
• Champion data quality: Own data dictionaries, documentation, and DBT tests for your domains. Raise quality issues proactively.

 

WHAT YOU’LL BRING

• 4+ years of experience as a Data or Analytics Engineer in a digital or tech product company
• Expert-level SQL - you write complex, optimised queries without looking things up
• Hands-on experience with BigQuery as a primary data warehouse
• Practical experience with DBT - writing models, tests, documentation, and understanding lineage
• Experience building and scheduling data pipelines with Apache Airflow
• Strong Tableau skills - you build dashboards that drive decisions, not just display numbers
• Strong communication: you can present analytical findings to a CFO and pair-program with an engineer on the same day
• Familiarity with Mixpanel, mParticle, or similar product analytics tools
• Comfort working in ambiguity - you can scope and prioritise your own analytical work

 

Nice to Have

• Experience with ClickHouse
• Python for data manipulation or automation (pandas, scripts, notebooks)
• Background in OTT, media, or subscription businesses
• Experience with A/B testing platforms (Optimizely, etc.)

 

AI & Emerging Tools — Openness to Learn

• Hands-on exposure to LLM APIs (OpenAI, Anthropic Claude, etc.) — e.g. building classification, tagging, or summarisation pipelines on top of text data
• Familiarity with agentic frameworks or workflow automation tools (LangChain, n8n, Airflow with LLM steps, or similar)
• Regular use of AI-assisted development tools such as Cursor or GitHub Copilot in day-to-day coding
• Curiosity about applying AI to BI workflows: auto-commentary on KPI movements, semantic search over data catalogs, or similar

 

WHY JOIN US? 

At Zattoo, you’re always on firm ground with real freedom to explore. You’ll have the support and opportunity you need to go far, while you’re helping us create a sustainable and entertainment-filled future for all.

 

WHAT WE OFFER YOU 

• Reward: strong market competitive salary
• Recharge: 30 days vacation plus public holidays
• Regulate: trust based flexible working hours and the option for remote work worldwide for up to 8 weeks per year

Plus:

• We’re sharing: Free access to the best streaming experience on the market
• We're developing: Your own development budget, German classes and Zattoo all-company hack days
• We’re inclusive: ‘Zattooies’ are a fun, engaged, and diverse team made up of 47 nationalities
• We’re healthy: Health checks, mental wellbeing support, team sports and more!
• We’re responsible: We are carbon neutral, an active employee Green team, discounted BVG tickets and free bike rentals
• We’re sociable: A calendar of events with fireside chats, lunches, in-house bar, BBQ’s, monthly socials, summer party and an annual off-site event