Analytics Engineer

Nov 15, 2023


About Marshmallow

We started Marshmallow when we found out how unfair insurance prices are for people who move to the UK. All because the industry hasn’t given this huge cohort of people a second’s thought, and isn’t set up to price them properly. 

We saw an opportunity to do things differently, so we made it our mission to back the ones who step outside the norm. Since we started, we’ve helped 100,000s of people get a fairer deal on their car insurance. Using technology, we serve people that are often overlooked by financial services companies, solving important problems for people who need it most. 

We know there are millions of marginalised customers out there. And we know that they face unique problems that most companies aren’t even aware of. We believe that our future is helping these people by learning about their experiences, and building our company around their needs. And there are strong signs that there’s a need for a company like us. Earlier this year we hit profitability, which is a huge milestone, but the most exciting thing is that we’re only just getting started.

How we work

We’re really proud of the culture we’ve created. We push for progress every day, because we know that we’ll only hit big milestones by taking lots of smaller steps. We’re always open to helping our team mates, sharing our ideas, experience and knowledge to solve problems together. We take risks, think creatively and experiment relentlessly to meet our customer’s needs, and never pass blame when things go wrong. We encourage people at all levels to take ownership of their work, and to be bold in challenging how we do things. Everyone has a voice and the opportunity to make an impact. 

And autonomy and ownership are only possible with clear direction. That’s why we collaborate to do in-depth planning twice a year, and make sure we leave with clear goals and objectives that flow from top to bottom. To make sure we’re as aligned as possible across functions, most of our work rolls up into four tribes; Acquisition, Retention, Claims and Pricing, Underwriting & Fraud. Each tribe has multiple teams embedded in it, working cross-functionally to do great work.

We’re so excited for all of the challenges up ahead, and we need more people to help us tackle them! If life at Marshmallow sounds like it could be for you, explore our culture handbook or read our blog to find out more.

The Data Engineering Team

We’re here to empower teams and individuals with data, at all levels at Marshmallow. We work across teams, taking proactive action, evangelising a data driven culture, unlocking data silos and promoting tools which enable self-service.

Learn about our teams and how our engineers work here!

What you’ll be doing

  • The Data Analytics Engineer will act as the subject matter expert for any technical development in DBT, Snowflake or Looker. They will own these platforms, ensuring that any code changes and new features are built in a sustainable way and without contributing to tech debt

  • Data Analytics Engineers will be required to form a deep understanding of our more holistic Data Platform to enable safe work on wider parts of the data stack.

  • The Data Analytics Engineer will partner closely with the analysts, holding them accountable to following best practice when working with these systems. They will view these tools/platforms holistically, designing a longer term strategy for how they can provide the most value to the business. Their success will be measured by the increase in analyst’s efficiency - whether this is achieved through better self-service by stakeholders or easier to analyse datasets.

  • Championing the best practices within the data engineering domain with an emphasis on data quality, governance and a healthy data culture.


Who you are (Must haves)

  • You have commercial experience working on production ETLs (big data and data warehousing) and data modelling as a developer or an analyst

  • You have a deep understanding of SQL and data modelling

  • You are comfortable with general Data Warehousing concepts

  • You have experience with DBT

  • You have experience with Looker or similar data exploration and BI tooling

  • You proactively identify issues and opportunities that can improve work in your domain and beyond

  • You have experience building robust and reliable data sets requiring a high attention to detail and consideration for data quality. 

  • You have experience working closely with (or as) an analyst/s and have collaborated effectively with them


What we're looking for from you (Nice to haves)

  • Exposure to Python, Java or similar languages

  • Any experience working within an insurance function or knowledge of insurance

  • Experience working with orchestration frameworks such as AWS Step Functions/Airflow etc

  • Experience working with AWS cloud services

Perks of the job

  • Flexible working - Spend 3 days a week with your team in our new collaborative London office, and own your own working hours. The rest is up to you  *If this arrangement doesn’t work, don’t let it hold you back. We’re always open to making reasonable adjustments if this is a barrier to you in any way. Let us know and we’ll talk about our options

  • Competitive bonus scheme - designed to reward and recognise high performance 🌟

  • Flexible benefits budget - £50 per month to spend on a Ben Mastercard meaning you get your own benefits budget to spend on things _you w_ant. Whether that’s subscriptions, night classes (puppy yoga, anyone?), the big shop or a forest of houseplants. Pretty much anything goes 💰

  • Mental wellbeing support – Access therapy and mental health sessions through Oliva 💚

  • Learning and development – Personal budgets for books and training courses to help you grow in your role. Plus 2 days a year - on us! - to further your skillset 🤓

  • Private health care - Enjoy all the benefits Vitality has to offer, including reduced gym memberships and discounts on smartwatches 🏥

  • Medical cash plan - To help you with the costs of dental, optical and physio (plus more!)

  • Tech scheme - Get the latest tech for less 🖥

Plus all the rest; 33 days holiday (including bank holidays), pension, cycle to work scheme, monthly team socials and company-wide socials every month!

Our process

We break it up into 3 stages:

  • Initial call with one of our Talent team (30 mins)

  • A skill-based and cultural interview where you will go through your past experience with Randal, Lead Data Engineer, and Ina, our Head of Analytics (75 mins)

  • A technical interview with Kornel and Eddy, our Senior Data/Analytics Engineers, focusing on both analytics and coding (1 hour)

  • We’ll let you know if you’re invited to an interview or not. But, as a small team with a lot of applications to consider, we can’t give personal feedback on each application

Everyone belongs at Marshmallow

At Marshmallow, we want to hire people from all walks of life with the passion and skills needed to help us achieve our company mission. To do that, we're committed to hiring without judgement, prejudice or bias.

We encourage everyone to apply for our open roles. Gender identity, race, ethnicity, sexual orientation, age or background does not affect how we process job applications.

We're working hard to build an inclusive culture that empowers our people to do their best work, have fun and feel that they belong.

Join 27646+ Machine Learning Engineers, receiving daily job alerts.