At a Glance
- Tasks: Lead fraud analytics and develop insightful dashboards to protect PuzzlePlay.
- Company: Join a dynamic team at PuzzlePlay, part of Tripledot Studios.
- Benefits: Enjoy 25 days paid holiday, competitive salary, and a collaborative work environment.
- Other info: Great opportunity for career growth in a fast-paced tech environment.
- Why this job: Make a real impact by safeguarding our loyalty ecosystem with your analytical skills.
- Qualifications: Experience in BI tools like Looker and strong SQL skills required.
The predicted salary is between 60000 - 75000 € per year.
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.
Key Responsibilities- A proactive self-starter with strong organizational 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.
- 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.
- 25 days paid holiday in addition to
Business Intelligence Engineer London employer: Tripledot Studios Limited
PuzzlePlay is an exceptional employer that fosters a collaborative and innovative work culture, particularly in the vibrant city of London. With a strong focus on employee growth, we offer extensive opportunities for professional development, including hands-on experience in advanced BI engineering and fraud analytics. Our commitment to work-life balance is reflected in our generous holiday policy, making PuzzlePlay an ideal place for those seeking meaningful and rewarding employment in the tech industry.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Engineer London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with current employees at PuzzlePlay. A friendly chat can sometimes lead to opportunities that aren’t even advertised.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your BI projects, dashboards, and any fraud detection work you've done. This gives you a chance to demonstrate your expertise beyond just a CV.
✨Tip Number 3
Prepare for interviews by brushing up on SQL and Looker. Be ready to discuss how you’ve tackled complex data challenges in the past. We love seeing candidates who can think on their feet!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the PuzzlePlay team.
We think you need these skills to ace Business Intelligence Engineer London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the BI Engineer role. Highlight your experience with Looker, SQL, and any relevant projects that showcase your skills in data modelling and dashboard creation. We want to see how you can bring value to our team!
Showcase Your Problem-Solving Skills:In your application, don’t just list your skills; demonstrate how you've used them to solve real problems. Share specific examples where you’ve tackled complex data challenges or improved reporting processes. This will help us see your proactive approach in action!
Be Clear and Concise:When writing your cover letter or any additional documentation, keep it clear and concise. Use straightforward language to explain your experience and how it relates to the role. We appreciate clarity, especially when it comes to complex concepts!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates directly. Plus, it shows you're keen on joining our PuzzlePlay team!
How to prepare for a job interview at Tripledot Studios Limited
✨Know Your BI Tools Inside Out
Make sure you’re well-versed in Looker and any other relevant BI tools. Familiarise yourself with how to build dashboards and reports, as this will likely come up in your interview. Be ready to discuss specific examples of dashboards you've created and the impact they had on decision-making.
✨Brush Up on SQL Skills
Since SQL is a key part of this role, practice writing complex queries, especially those involving joins and CTEs. Prepare to demonstrate your ability to identify suspicious user flows or patterns using SQL during the interview. You might even be asked to solve a problem on the spot!
✨Understand the Business Context
Get a good grasp of PuzzlePlay’s loyalty and rewards ecosystem. Research their games and user acquisition strategies. This will help you tailor your answers to show how your skills can directly benefit their operations and fraud detection efforts.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving skills and how you handle data irregularities. Think of past experiences where you’ve had to investigate metrics or work with multiple data sources. Be ready to explain your thought process and the steps you took to resolve issues.
