Analytics Engineer (Middle) - ZiMAD

Analytics Engineer (Middle) Office: All geos Apply Join our innovative tech company, a leader in developing cutting‑edge free‑to‑play (F2P) mobile games enjoyed by millions every month. We value a friendly, inclusive culture that encourages creativity, learning, and collaboration. You’ll work with a multinational team building engaging products and delivering great player experiences. Job Description We are looking for a Software Engineer for Infrastructure Projects. 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. Key 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 Preferred Qualifications 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 Working Conditions Schedule Full‑time with flexible hours; remote Benefits Work on global F2P projects reaching millions monthly Involvement across all stages of product development Remote work and flexible schedules KPI‑ and success‑based bonuses Career growth in an international setting Paid conferences, training, and workshops Support for key life events (one‑time assistance options) Referral program Access to mental health sessions with psychologists Participation in charitable initiatives Application Process Selection Stages Screening call – interviews with the teams – final interview Are you passionate about your work and ready to grow? Join the ZiMAD team and let’s create exceptional games together!