Analytics Engineer (Middle)

XIMAD; All Cannings; Remote; GBP 50,000 - 70,000; Full time

Benefits offered by this job

Remote work

Bonuses based on KPIs

Training and conferences

Flexible hours

Global project exposure

Job summary

ZiMAD is seeking an Analytics Engineer (Middle) to own the modeling layer behind reporting, ad-hoc analysis, and AI-driven tools. You will shape data marts, metric semantics, and the semantic layer for reliable decision-making across UA, monetization, and LiveOps.

You will collaborate with product and analytics teams while optimizing ClickHouse performance and maintaining data quality. This remote, full-time role offers global scope and opportunities for growth.

Qualifications

• 2+ years in analytics engineering, BI development, data analysis or data engineering.
• Strong SQL: joins, window functions, aggregations, and reading/debugging queries.
• Hands-on experience with ClickHouse: MergeTree engines, ORDER BY and partition keys, arrays.
• Experience with analytical data modeling: table structure and grain for queries, incremental, reliable models.
• English proficiency at the B1–B2 level.

Responsibilities

• Build and maintain reliable data marts for UA, monetization, product and LiveOps teams.
• Prepare data models usable by people and AI agents.
• Maintain core metric definitions with the team for trusted numbers.
• Monitor data quality with tests, freshness checks and comparisons to raw data.
• Optimize ClickHouse query performance.

Skills

SQL proficiency

Data modeling

Analytical mindset

English (B1–B2)

Tools

ClickHouse

dbt

Superset

Job description

Analytics Engineer (Middle)

Office: All geos

Job Description

We are looking for Analytics Engineer. 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

• Build and maintain reliable data marts for the UA, monetization, product and LiveOps teams
• Prepare data models that both people and AI agents can use
• Maintain core metric definitions together with the team so the whole company can trust the numbers
• Monitor data quality with tests, freshness checks and comparisons against raw data, and investigate when numbers don’t match
• Optimize ClickHouse query performance

Requirements

• 2+ years in analytics engineering, BI development, data analysis or data engineering, building data models that others rely on
• Strong SQL: joins, window functions, aggregations, and the ability to read and debug other people’s queries
• Hands‑on experience with ClickHouse: MergeTree engines, choosing ORDER BY and partition keys, and working with arrays
• Experience with analytical data modeling: choosing the right table structure and grain for how data will be queried, and building incremental, reliable models
• English proficiency at the B1–B2 level

Preferred Qualifications

• Experience with data modeling tools such as dbt
• Understanding of mobile app metrics (ROAS, LTV, ARPDAU, retention)
• Experience using AI tools in data work
• Experience with workflow orchestration: scheduling pipelines, managing dependencies and handling failures
• Experience with Superset or another BI tool

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

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!