Bi Engineer (Gamedev)

TL;DR

BI Engineer (Gamedev): Developing and maintaining Looker dashboards and reports that surface major in-app metrics for Puzzleplay, its corresponding game clients, user acquisition channels and other company wide metrics with an accent on data modeling and fraud detection. Focus on writing custom SQL rules to identify suspicious user flows and leading investigations into irregularities in the metrics.

Location: Hybrid in Barcelona, Spain. 3 days a week in the office - Tuesdays and Wednesdays, and a third day of your choice, with 20 days of remote working from anywhere in the world.

Company

hirify.global is a large independent mobile games company with a global team of 2,500+ 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, including 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.

Requirements

• Experience building out 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 a meticulous approach to organising code, data, dashboards and documentation.
• Strong communication skills, comfortable presenting findings and recommendations.
• Proven experience developing behaviour-based heuristics, rules, or detection systems.

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

• 20 business days paid holiday in addition to bank holidays.
• Hybrid Working: Work in the office 3 days a week, Tuesdays and Wednesdays, and a third day of your choice.
• 20 business days remote working from anywhere in the world.
• 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 provided.

Hiring process

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