Analytics Engineer - Data Marts for AI Games (Remote)

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

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.