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. We are looking for a Software Engineer for Infrastructure Projects. 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