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.

The Opportunity

‍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 robust and scalable data models that drive efficiencies and empower more easily interpretable insights that have real impact on product decisions.

The Day to Day

• Work efficiently with product, marketing, and finance teams to translate business needs into various data solutions (data modeling, dashboards etc);
• Design and develop new data ingestion pipelines as new requirements emerge;
• Design and implement high-performance, scalable and cost-optimized data models that enable data analysts and data scientists to deliver impactful analyses efficiently;
• Independently design, build and launch new data extraction, transformation and loading processes in production, mentoring others around efficient queries;
• Develop and configure dashboards and reports in BI tool (Tableau) that enable stakeholders to self-serve;
• Build data expertise and leverage data controls to ensure privacy, security, compliance, data quality, and operations for allocated areas of ownership.

About you

• Bachelor's degree in Computer Science, Computer Engineering, relevant technical field, or equivalent practical experience;
• 3+ years of work experience in data/analytics engineering;
• Advanced SQL skills
• Experience with DBT or another transformation tool
• Intermediate level on one programming language (e.g., Python, C++, C#, Scala, etc.)
• Past experience with data modeling and ETL;
• Familiarity with developing/building within a BI tool (Looker, Mode, Tableau etc);
• Good written and verbal communication skills;

Nice to have

• Consumer facing app or game industry experience preferred;

• Past experience with developing dashboards with Tableau;
• Cloud-native Data Warehouse, BigQuery preferred;

Our London Studio Location

At Trailmix, we've embraced a hybrid work model, balancing in-person collaboration and remote flexibility. Our team gathers at our vibrant studio in Kings X three days a week—Mondays, Thursdays, and Fridays—while enjoying the convenience of remote work for the remaining days.

Our Benefits

• Investing in Your Growth: Unleash your potential with our generous development budget. After completing your three-month probation, all team members receive a £1,000 allowance to fuel their professional growth each year.
• Fueling Your Day: Our kitchens are fully stocked with delicious treats and drinks, and we provide breakfast and lunch supplies to keep you energised throughout the day.
• Building Connections: Join us every Friday for a team lunch courtesy of Just Eat - a chance to connect and recharge for the week ahead..
• Planning for Your Future: Take control of your financial future with our contributory pension scheme. Plus, enjoy the added benefit of tax-free contributions.
• Unlocking Ownership: As a valued team member, you'll have the opportunity to own a stake in our success through tax-advantaged stock options.
• Caring for Your Well-being: Your health is our priority. Enjoy peace of mind with our fully comprehensive private medical care, with premiums paid by Trailmix. Plus, access mental health support 24/7 with the Spill Mental Health App.
• Time to Recharge: Our generous holiday allowance allows you to take a well-deserved break. You'll enjoy 28 days of annual leave, including three company holiday days around Christmas.
• Trailbreak: We close the office for one week each year to give the whole team time off to recharge and reset.
• Surprise and Delight: Feel appreciated and valued with various company gifts throughout the year.
• Celebrations: Join us for various socials and events throughout the year, from team outings to themed parties.
• Setting You Up for Success: Receive a £250 work-from-home budget to ensure you have the proper home setup to perform at your best.

Our Inclusive Culture

Trailmix was founded to make a positive impact on our players, our community, and our colleagues. We are committed to creating an inclusive culture, and our priority is fostering an environment where people can flourish. We think it’s vital that players see themselves represented in games, and Love & Pies, we showcase the beautiful diversity of life. Love & Pies represents the people we are and the people we love, and we’re always looking to add more people who want to design games for everyone.