Analytics Engineer

Are you passionate about your work and want to pursue your dreams? Join the ZiMAD team, and let’s collaborate to create exceptional games together! 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. With an impressive portfolio of world-class free-to-play projects, including titles like Magic Jigsaw Puzzles, Puzzle Villa, Art of Puzzles, Dominoes, and many others, we constantly push boundaries and believe that games can be more than just entertainment.

We’ve forged partnerships with internationally renowned IPs (like Disney, Nickelodeon, LIFE, Sony Pictures etc.) and strive to develop games that sharpen mental well-being and deliver remarkable user experiences.

About the role

We build mobile games. User acquisition, monetization, LiveOps and product decisions all run on data — and this role owns the modeling layer everything else depends on: the data marts, metric definitions and semantic layer behind reporting, ad-hoc analysis and our AI-driven tools.

Responsibilities

• 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

Requirements

• 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

Nice to have

• 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

We offer:

• 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