Analytics engineer in mobile games

ZiMAD; United States; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Remote work opportunities

Bonuses based on KPI achievement

Conferences and training

Job summary

ZiMAD ищет аналитического инженера, который возьмет на себя проектирование и поддержку трансформационного слоя данных, обеспечение качества и единых метрик ROAS, LTV и ARPDAU. Роль предполагает работу с аналитическими котлами, моделями и BI-дашбордами для UA, монетизации и креативов.

Кандидат должен владеть SQL на продвинутом уровне, опытом работы с ClickHouse и трансформационными фреймворками; удаленная работа приветствуется в международной команде ZiMAD.

Qualifications

• 3–5+ лет в аналитической инженерии, BI-разработке или data engineering, с продакшн-владением трансформационной слой.
• Сильный SQL. Опыт работы с ClickHouse, PostgreSQL, BigQuery или Snowflake.
• Практический опыт работы с трансформационными фреймворками (dbt, SQLMesh, Dataform или аналог).
• Навыки моделирования данных и инженерии метрик; умение превращать бизнес-вопрос в модель данных.

Responsibilities

• Проектирование и поддержка аналитического слоя трансформаций: staging, core и mart модели.
• Узурpождение стандартов аналитического кода: трансформации, тестирование, ревью кода и CI.
• Владение определениями метрик и консолидация источников, ROAS, LTV, ARPDAU.

Skills

Strong SQL

ClickHouse

PostgreSQL

BigQuery

Snowflake

dbt

Python

Git

Tools

ClickHouse

PostgreSQL

BigQuery

Snowflake

dbt

Airflow

Dagster

Superset

Job description

Описание: ZiMAD is a US mobile game publisher and developer that has been at the forefront of the gaming industry since 2009. We are a dynamic multinational team, speaking 15 languages and living in 63 cities across 17 countries.

Задачи:

• Design and maintain the analytical transformation layer - staging, core and mart models that are modular, incremental, tested, documented and version-controlled
• Establish engineering standards for analytics code: transformation tooling, testing, code review and CI
• Own metric definitions across sources.
• Reconcile granularity, attribution windows and naming so ROAS, cohort LTV, retention, ARPDAU and spend mean one thing company-wide
• Build the analytical datasets behind dashboards and reports on UA, monetization, creative performance and incrementality
• Make data self-serve: model and document datasets so product, UA and monetization teams can answer their own questions
• Own data quality for the models in scope - tests, freshness and consistency monitoring, source-to-source reconciliation
• Build the data access layer for AI agents: semantic descriptions, curated query interfaces, guardrails, and evaluation of agent output against trusted data
• Optimize analytical workloads for query performance and cost

Требования:

3-5+ years in analytics engineering, BI development or data engineering, with production ownership of a transformation layer Strong SQL. ClickHouse experience preferred - window functions, arrays, materialized views, AggregatingMergeTree. Deep Postgres, BigQuery or Snowflake experience is welcome if you're keen to go deep on ClickHouse Hands-on production experience with a transformation framework - dbt, SQLMesh, Dataform or equivalent - including modular models, testing, documentation and CI Solid analytical data modeling judgment - knowing when a wide event or user-level table beats a star schema, and why Ability to turn an ambiguous business question into a data model through conversation with stakeholders Git, code review, and enough Python to automate your own work Будет плюсом: Experience with mobile games or apps and fluency in their core metrics - D7 ROAS, cohort LTV, ARPDAU, retention curves - and why numbers differ between sources; Practical experience with AI/LLM tools in a data context: text-to-SQL, RAG over structured data, MCP or similar agent integrations, evaluation of model outputs; Orchestration tools (Airflow, Dagster or similar); Superset or a comparable BI platform

Условия:

Opportunity to work for ZiMAD, a US company with a diverse portfolio of global free-to-play (F2P) projects with a multi-million monthly user base Involvement in the entire product development cycle Career growth prospects within an international company Remote work opportunities Flexible working schedule Bonuses based on the achievement of KPIs and financial results of projects Paid conferences, training (including language courses), and workshops Opportunity to have sessions with psychologists to improve your mental health and well-being Participation in charity projects