TL;DR

BI Engineer (Gamedev): Developing and maintaining Looker dashboards and reports to surface in-app metrics for PuzzlePlay, its game clients, user acquisition channels and company-wide metrics with an accent on data modelling and building aggregate tables. Focus on identifying suspicious user flows, login patterns, and redemption behavior via custom SQL rules and leading investigations into irregularities.

Location: Hybrid in Barcelona, ES. Must work in the office 3 days a week (Tuesdays, Wednesdays and a third day of your choice).

Company

Tripledot Studios is one of the largest independent mobile games companies in the world with a global 2,500+ strong team across 12 studios.

What you will do

  • Develop and maintain Looker dashboards and reports that surface major in-app metrics.
  • Design metric logic, build aggregate tables, and own data modelling required for high-scale reporting.
  • Create business-facing documentation: metric definitions, data dictionaries, and dashboard guides.
  • Identify, evaluate and incorporate new data sources and metrics into production tables.
  • Write custom SQL rules to identify suspicious user flows, login patterns, and redemption behaviour.
  • Lead investigations into irregularities in the metrics, combining data from multiple sources to answer complex questions.
  • Define and document BI best practices and conventions.

Requirements

  • Experience building reports within Looker (or relevant BI tool, Looker preferred).
  • Extensive experience in SQL (Snowflake, Bigquery etc.), including complex joins, CTEs, 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 meticulous approach to organising code, data, dashboards and documentation.
  • Comfort manipulating large datasets for exploratory analysis and investigations.
  • Strong communication skills, comfortable presenting findings and recommendations.
  • Proven experience developing behaviour based heuristics, rules, or detection systems OR strong interest and analytical ability to ramp up quickly.

Nice to have

  • Proficiency in one or more programming/scripting languages useful (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

  • 26 days paid holiday in addition to bank holidays.
  • Hybrid work: in the office 3 days a week.
  • 20 days remote working from anywhere in the world.
  • Regular company events and rewards.
  • Private Medical Cover.
  • Daily Free Lunch when working in the office.
  • Employee Assistance Program.
  • Continuous Professional Development.
  • English & Polish Classes.

Hiring process

  • Talent Acquisition Interview.
  • Take home Assessment.
  • Manager Interview.
  • Final Interview.