Job
- Level
- Experienced
- Job Field
- BI
- Employment Type
- Full Time
- Contract Type
- Permanent employment
- Location
- Berlin
- Working Model
- Onsite
Job Summary
In this role, you will develop BI solutions, lead fraud analytics, and create Looker dashboards to monitor key metrics and detect fraudulent behavior while collaborating with various teams.
Job Technologies
Your role in the team
- 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 operationalizing 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.
- 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.
- Leiten Sie die Geschäftsbereiche an, um Konsistenz im Wissen und in der Praxis im gesamten Unternehmen sicherzustellen.
This text has been machine translated. Show original
Our expectations of you
Qualifications
- Quick learner
- 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.
- Proficiency in one or more programming/scripting languages useful (e.g. Python/R)
- Proficiency in Looker APIs
Experience
- 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.
- Proven experience developing behaviour-based heuristics, rules, or detection systems OR strong interest and analytical ability to ramp up quickly
- Experience in a mobile app / ad tech / gaming company
- Experience with product and user acquisition teams
This text has been machine translated. Show original
What we offer
- Enjoy 20 days of paid holiday plus an additional 5 days per annum, in addition to bank holidays to relax and refresh throughout the year.
- Propel your career with continuous opportunities for professional development.
- Annual budget of 1200 EUR - reimbursement for healthcare outside of public plans (glasses, massages, dental treatments, etc.)
- 100% of public transportation to the office via BVG ticket is covered
- Order free food from Wolt when at the office
- Opt-in to employer contributed pension plan, operated with Degura
This text has been machine translated. Show original
Topics that you deal with on the job
Job Locations
This is your employer
Tripledot
Tripledot Studios is an innovative developer of mobile casual games based in London, experiencing strong growth through strategic acquisitions and data-driven approaches.
Description
- Company Type
- Startup
- Working Model
- Full Remote, Hybrid, Onsite
- Industry
- Internet, IT, Telecommunication
Business Intelligence Engineer
- Location
- Berlin
- Working Model
- Onsite
- Diversity
- Open for all genders
- English Only
- English only required
