About the role

BI Engineer leading fraud analytics and advanced reporting at Tripledot Studios, one of the largest independent mobile gaming companies.

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
Preferred: Proficiency in one or more programming/scripting languages useful (e.g. Python/R)
Preferred: Proficiency in Looker APIs
Preferred: Experience in a mobile app / ad tech / gaming company
Preferred: Experience with product and user acquisition teams.

20 business 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 business 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.
Lunch: provided daily in the office to keep you fueled and focused.
Continuous Professional Development: Propel your career with continuous opportunities for professional development.
Private Medical Cover: ensure your health is in good hands through private health insurance
Sport Compensation Stay fit and active with our sport compensation benefit.
Taxi to compensate for travel to the office.
English Classes Enhance your English skills with our provided English classes.