Analytics Engineer at Scorewarrior

ABOUT US Scorewarrior is a game developer and publisher based in Limassol, Cyprus. We are working on Total Battle — a cross-platform MMO 4X strategy game with a deep social system and extensive player interaction. We have 2 million monthly active players and continue to grow with the goal of becoming the #1 game in the genre. Our team consists of 200+ passionate, talented, self-driven, and continually developing professionals who love making high-quality games. ABOUT THE POSITION We are looking for an Analytics Engineer to join our Product Analytics team. With data ingestion and platform stability handled by our Data Engineering team, your primary focus will be on the Transformation layer. You will treat data as code – dedicating your time to architecture, modularity, and testing. You will collaborate with product analysts to translate complex game mechanics into clear semantic layers. Your goal is to minimize analytical debt by building robust data models that make decision-making fast, reliable, and transparent. YOUR MISSION - Enable analysts to focus on insights and decisions instead of data plumbing by: - Designing and evolving a clear, reliable, and scalable analytical DWH and data model - Taking ownership of data stability and query performance WHAT YOU WILL BE DOING - Architecture & Modeling: Build, refactor, and maintain the transformation layer (staging, intermediate, marts) within our dbt codebase. - Quality as Code: Ensure data reliability by applying software engineering practices: version control, code reviews, documentation, and automated testing (dbt tests). - Business Alignment: Partner with analytics leadership to translate business requirements into technical specs and identify missing data marts. - BI Enablement: Design and maintain efficient data sources for Tableau, preparing clean, pre-calculated datasets so analysts can build reports without wrestling with raw data. - Performance: Optimize heavy SQL transformations to ensure query performance matches the speed of business decision-making. WHAT WE EXPECT FROM YOU DATA & ANALYTICS ENGINEERING - SQL You can write complex, performant queries, debug legacy code, and understand execution plans. ClickHouse experience is a plus. - Experience with dbt or similar analytics engineering frameworks - Understanding of query and model-level performance optimization - Python for data manipulation and automation SYSTEM THINKING & DATA MODELING - Strong grasp of modern DWH design patterns (layered architecture, Star Schema, OBT) and modeling methodologies - Ability to design analytical data models with clear granularity, keys, and metric definitions - Willingness to deeply understand the product and backend domain - Ability to collect, structure, and formalize requirements from data users BI & DATA CONSUMPTION - Experience designing and maintaining reports and data sources in Tableau or similar BI tools - Ability to translate business questions into analytical data models NICE TO HAVE - Experience working with large-scale event-driven systems - Experience with experimentation/feature store/feature analytics pipelines - Background in gaming or other complex long-lived products WHAT WE OFFER - A team of professionals with a passion for gamedev and a drive to make Total Battle the #1 MMO 4X strategy game. - An excellent remuneration package, including a 13th salary. - Full relocation coverage for you and your family to Cyprus (Limassol). - A modern, sunny office close to the sea. - Private health insurance for you and your family members. - A monthly pre-school, school, and university allowance for employees' children. - Lunch compensation. - A sports and fitness allowance. - Company-funded personal development opportunities (professional and language courses, books, etc.). - Bonuses for outstanding results, years of service, marriage, and childbirth. - Friendly monthly office parties and epic annual offsite company birthday and Christmas celebrations.