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

📌 BI Engineer (Madrid)
🏢 Talanto
📍 Madrid