Who we'd reach at WonderBrains agencyFound and reached by Power Apply
Best leadHiring manager
Leads the team this role joins
Team director
Heads the group this role sits in
Recruiter
In-house, owns the opening
From your own Gmail and LinkedIn.
About the role
This is a full-time remote role for a senior data engineer who also does analysis, covering pipelines and reporting for a social casino and mystery-box ecommerce business. The person owns data from end to end, including the move from BigQuery to ClickHouse as the main analytics warehouse. The company builds social casino games and mystery-box ecommerce apps for web and mobile.
What you’ll do
- Build ingestion from PostgreSQL and MongoDB change data capture, client and server events, payment providers and AppsFlyer into ClickHouse and BigQuery.
- Run and extend Airflow DAGs for bronze, silver and gold layers, keeping jobs idempotent, backfillable and monitored.
- Add freshness and quality checks with alerts when tables are late or wrong.
- Design ClickHouse schemas, sort keys, materialized views and retention policies.
- Migrate pipelines, models and dashboards, running both warehouses side by side until the numbers match.
- Keep BigQuery reliable and cost-controlled during the transition.
- Maintain the KPI layer covering DAU, revenue, retention, LTV, ROAS and economy health.
- Replace Tableau and older analytics tools with in-house AI dashboards.
- Design A/B tests and promotion experiments and interpret their results.
- Agree event schemas with backend and client engineers and document tables and metrics.
What they’re looking for
- 6 or more years in data engineering, analytics engineering or data analysis, owning production pipelines.
- Expert SQL, including window functions, cohort queries and query plan tuning.
- Production ClickHouse experience with MergeTree engines, sort keys, materialized views and TTLs.
- Production BigQuery experience with partitioning, clustering and cost control.
- Python for pipelines and an orchestrator such as Airflow.
- Experience with change data capture or event streaming from operational databases.
- Data modeling skills, including layered or dimensional models and slowly changing dimensions.
- Product analytics skills covering retention, LTV, ARPDAU, funnels and A/B test significance.
- Ability to design tables and metric definitions that AI dashboards can query correctly.
- English at Upper-Intermediate (B2) level or higher.
Nice to have
- Social casino, free-to-play or mobile gaming analytics.
- Ecommerce or mystery-box analytics, including conversion, order value and repeat purchase.
- AppsFlyer or similar attribution data, plus user acquisition and ROAS modeling.
- OpenTelemetry or ClickStack experience.
- Terraform on Google Cloud or AWS.
- Enough TypeScript to add or fix events at the source.
- dbt or a similar modeling tool.
- Privacy-safe data handling, including PII separation and account deletion requests.
What’s on offer
- Full-time, remote work.
- Ownership of data for live social casino and ecommerce products.
Skills
Questions about this role
Is this Senior Data Engineer role remote?
Yes, the listing is remote and full-time.
How many years of experience are needed?
At least 6 years in data engineering, analytics engineering or data analysis.
How do I apply?
Applications go through the original listing on djinni.co, not through this site.
Is there a deadline?
The listing sets a deadline of 4 December 2026.