About the Company
Tripledot Studios is one of the largest independent mobile games companies in the world. We are a multi award winning organisation with a global team of 2,500+ people across 12 studios. Our portfolio includes some of the biggest titles in mobile gaming, collectively reaching top chart positions worldwide and engaging over 25 million daily active users. Tripledot's guiding principle is that when people love what they do, what they do will be loved by others. We're building a company we're proud of - one filled with driven, incredibly smart and detail orientated people who LOVE making games.
The Role
As PuzzlePlay scales its loyalty and rewards ecosystem across Tripledot Studios' portfolio, we are looking for a BI Engineer who will also lead the fraud analytics function. This role combines advanced BI engineering, dashboard ownership, data modelling, and hands on fraud detection. You will build the data foundations that power our insights while designing and operationalising the systems that protect PuzzlePlay from fraudulent behaviour. You will sit within the internal PuzzlePlay team and work closely with UA, Product, Data Engineering, and the rest of the team's core members.
Key Responsibilities
- A proactive self starter with strong organisational skills and a systematic approach to problem solving.
- 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.
Required Skills, Knowledge and Expertise
- 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 a 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).
- Proficiency in Looker APIs.
- Experience in a mobile app / ad tech / gaming company.
- Experience with product and user acquisition teams.
- 25 days paid holiday in addition to bank holidays.
- Hybrid working - 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 that celebrate cultural events, achievements and team spirit.
- Private medical cover.
- Life & critical illness cover.
- Family forming support - vital support on family forming/fertility journey with our support program subject to policy .
- Employee assistance program - confidential support anytime.
- Sport compensation - stay fit and active.
- Meal and transport vouchers.
- English & Spanish classes.
- Continuous professional development.
Additional Information
Tripledot's operating language is English across all business areas and locations, and this role requires participation in English meetings, documentation, tools and written communication. This requirement ensures consistent collaboration, quality and compliance across our global teams.