Data Engineer

clickhouse bigquery kafka api sql

Key Responsibilities

Implement affiliate/basic tracking as part of the Foundation phase

Build affiliate tracking (advanced), sub-IDs & attribution, and basic analytics & reporting

Design and build the event pipeline using Kafka for real-time data ingestion

Build and maintain analytical data stores using ClickHouse and/or BigQuery for fast reporting queries

Develop advanced analytics and A/B testing & experiments infrastructure

Build the advanced reporting suite and support scaling the data infrastructure

Design SQL data models and APIs that power dashboards used by merchants, affiliates, and internal teams

Required Skills & Experience

Experience building event-driven pipelines with Kafka (or similar streaming systems)

Hands-on experience with ClickHouse and/or BigQuery for analytical workloads

Strong SQL skills and experience designing data models for reporting and attribution

Experience building and exposing analytics data through APIs

Comfortable working across the stack from ingestion pipelines to reporting UI data contracts

Nice to Have

Experience with marketing attribution, affiliate tracking, or ad-tech data systems

Experience with A/B testing frameworks and experiment infrastructure

Familiarity with data governance and privacy-aware tracking implementations