Business Intelligence Analyst

Описание

Who are we?
Tripledot is one of the largest independent mobile games companies in the world.
We are a multi-award-winning organisation, with a global 2,500+ strong team across 12 studios.
Our expanded portfolio includes some of the biggest titles in mobile gaming, collectively reaching top chart positions around the world 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.
Our ambition is to be the most successful games company in the world, and we’re just getting started.

The role is working within our studio: Tripledot Studios

Tripledot is one of the largest independent mobile games companies in the world.

We are a multi-award-winning organisation, with a global 2,500+ strong team across 12 studios.

Our expanded portfolio includes some of the biggest titles in mobile gaming, collectively reaching top chart positions around the world 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.
Our ambition is to be the most successful games company in the world, and we’re just getting started. Department Marketing Employment Type Permanent - Full Time Location Kyiv, UA Workplace type Hybrid

Key Responsibilities

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.

Skills, Knowledge & Expertise

Required Skills, Knowledge and Expertise Required 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) Proficiency in Looker APIs Experience in a mobile app / ad tech / gaming company Experience with product and user acquisition teams

Job Benefits

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.

About Tripledot