TL;DR

BI Engineer (Gamedev): Develops and maintains Looker dashboards for in-app metrics, user acquisition, and fraud detection across the PuzzlePlay ecosystem with an accent on data modelling and building aggregate tables for large-scale reporting. Focus on identifying suspicious user behavior and documenting BI best practices.

Location: Hybrid in Tbilisi, GE. 3 days a week in the office.

Company

Tripledot Studios is a large independent mobile games company with a global team across 12 studios, focused on creating games that can be enjoyed by everyone.

What you will do

  • Develop and maintain Looker dashboards and reports for in-app metrics and user acquisition channels.
  • Design metric logic and build aggregate tables for high-scale reporting.
  • Create business-facing documentation including metric definitions and dashboard guides.
  • Identify and evaluate new data sources and metrics for production tables.
  • Write custom SQL rules to identify suspicious user flows and redemption behavior.
  • Lead investigations into irregularities in the metrics, combining data from multiple sources.

Requirements

  • Experience building reports within Looker (or a relevant BI tool).
  • Extensive experience in SQL (Snowflake, BigQuery etc.), including complex joins and pattern-recognition queries.
  • Experience in a Data Analytics & BI role, delivering and maintaining metrics and dashboards across various teams.
  • Excellent attention to detail and a meticulous approach to organizing code, data, dashboards, and documentation.
  • Strong communication skills, comfortable presenting findings and recommendations.
  • Proven experience developing behavior-based heuristics, rules, or detection systems OR strong analytical ability to ramp up quickly.

Nice to have

  • Proficiency in one or more programming/scripting languages (e.g. Python/R).
  • Proficiency in Looker APIs.
  • Experience in a mobile app / ad tech / gaming company.
  • Experience with product and user acquisition teams.

Culture & Benefits

  • Hybrid working: In the office 3 days a week, Tuesdays and Wednesdays, and a third day of your choice.
  • 20 business days remote working: Work from anywhere in the world 20 days of the year.
  • Lunch provided daily in the office.
  • Continuous professional development opportunities.
  • Private Medical Cover and sport compensation benefit.
  • Taxi to compensate for travel to the office and English classes.

Hiring process

  • Stage 1: Talent Acquisition Interview
  • Stage 2: Take home Assessment
  • Stage 3: Manager Interview
  • Stage 4: Final Interview