Analytics Engineer (Middle)

HellaGoodAudio; United States; Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Remote work

Flexible schedules

KPI-based bonuses

Career growth in an international set‑

Paid conferences, training, and work‑h

Support for key life events

Referral program

Access to mental health sessions with

Participation in charitable intiatives

Job summary

HellaGoodAudio, an innovative tech company leading in cutting‑edge free‑to‑play mobile games enjoyed by millions every month, is seeking an Analytics Engineer. You’ll own the modeling layer behind reporting, ad‑hoc analysis and AI‑driven tools, collaborating with a multinational team to deliver compelling player experiences.

In this role you’ll build data marts for UA, monetization, and LiveOps, design scalable data models, ensure metric integrity, and optimize ClickHouse queries.

Qualifications

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

Responsibilities

• Build and maintain 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.

Skills

SQL

ClickHouse

Data modeling

English B1-B2

ETL/BI development

Tools

dbt

Job description

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 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