Analytics Engineer

We are the makers of casual mobile hit Love & Pies, which globally launched in September 2021 and has now found its way into the hands of millions of players around the world. We’re backed by Supercell, one of the biggest and best in the industry.

We make games for everyone that are snackable yet nourishing — built to fit into your daily life, but with the emotional depth of your favorite TV show. Our team always comes first at Trailmix, and our culture is built on both high performance and high care — we strive to be the best versions of ourselves, but always within an environment based on inclusivity, respect and safety, no matter who you are or where you come from.

Analytics Engineer

‍We’re looking for an Analytics Engineer to join us on our journey of extraordinary growth. At Trailmix we’re always looking for new insights that result in tangible impacts: impact on our players, our marketing efforts and on our game & portfolio level strategy.

As our Analytics Engineer you'll be joining a talented Data team as well as a wider product and development team who have a real passion for data informed decisions. By utilizing your technical expertise you’ll help design and deliver powerful dashboards and models that drive efficiencies and offer more easily interpretable insights that have real impact on product decisions.

The responsibilities include:

Building coherent, optimized, cost-effective, and well-documented data models in DBT;
Optimize the data warehouse to enable efficient reporting;
Clean, transform, test, and deploy datasets that are ready for use by Data Analysts, Scientists and the product team;
Work efficiently with product, marketing, and finance teams to build out use cases; depending on partner briefs and deliver successful analytic outcomes;
Setup and configure dashboards and reports in BI tools;
Work closely with the wider data team, to ensure the reliability and stability of our data platform;
Design and implement high-performance, reusable, and scaleable data models to ensure your internal customers get consistent and reliable answers when running their own analyses;
Create and maintain data pipelines;

Requirements:

Advanced SQL, with the understanding of how to write well-optimized queries;
Cloud-native Datawarehouse (Snowflake, Amazon Redshift or BigQuery) BigQuery preferred;
Designing and Building data models;
Data Visualisation experience;
Experience with or exposure to data transformation tools such as DBT would be advantageous;
Extensive experience in data modeling, to enable accurate and reliable reporting, which will also be used for self-serve;
Familiarity with developing/building within a BI tool (Looker, Mode, Tableau etc);
Game industry experience preferred;
2+ years' experience working with data warehousing/lake architectures;

Location:

Trailmix is currently operating under a hybrid work model - we have 3 days a week (Monday, Thursday & Friday) in person at our brand new studio in Kings Cross with the remaining 2 days available to work from home.

Benefits:

Flexible working
Contributory Pension
Tax advantaged Stock options
Fully comprehensive Private Medical Care (premiums paid by Trailmix)
28 days Holiday (including 3 company holiday days around Christmas)
Free drinks and snacks in the office
Company gifts and swag
Socials and events

‌