About the role

BI Engineer leading fraud analytics within Tripledot Studios. Develops dashboards and investigates metrics irregularities to enhance gaming experiences.

Responsibilities

Develop and maintain Looker dashboards and reports that surface major in-app metrics for Puzzleplay, its corresponding game clients, user acquisition channels and other company wide metrics.
Have a good understanding of the data sources and be able to communicate their limitations and nuances to the business.
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.
Work with the business and Data Engineering, Analytics and Product teams to 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. Guide business areas to ensure consistency in knowledge and practice across the business.

Quick learner
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 meticulous approach to organising code, data, dashboards and documentation.
Comfort manipulating large datasets for exploratory analysis and investigations.
A sophisticated approach to navigating organisations and relationships.
Ability to explain difficult concepts to technical and non-technical stakeholders alike.
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
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.

26 days paid holiday in addition to bank holidays to relax and refresh throughout the year
Hybrid Working: We work in the office 3 days a week, Tuesdays and Wednesdays, and a third day of your choice.
20 days remote working: Work from anywhere in the world, or use the time to cover mandatory office days to WFH, 20 days of the year
Regular company events and rewards: Join in regular events and rewards that celebrate cultural events, our achievements and our team spirit.
Private Medical Cover with Luxmed: Have peace of mind with private medical cover, ensuring your and your family's health is in good hands.
Daily Free Lunch: When working in the office order free food from Pyszne.pl
Multisport Plus Card: Enjoy access to various sports facilities across Warsaw with the Multisport Plus Card
Employee Assistance Program: Anytime you need it, tap into confidential, caring support with our Employee Assistance Program, always here to lend an ear and a helping hand.
Family Forming Support: Receive vital support on your family forming/ fertility journey with our support program [subject to policy]
Continuous Professional Development: Propel your career with continuous opportunities for professional development.
English & Polish Classes: Improve your language skills with access to English and Polish classes.