Senior BI Engineer
Marshmallow, City of Westminster
Senior BI Engineer
Salary not available. View on company website.
Marshmallow, City of Westminster
- Full time
- Permanent
- Onsite working
Posted today, 18 Oct | Get your application in now to be one of the first to apply.
Closing date: Closing date not specified
job Ref: 320082ab485c4544b5e8b98860b88f00
Full Job Description
- Data Modelling: Develop and maintain robust data models that ensure data consistency and availability for analytics, data science and reporting.
- Lead and Mentor: Act as the subject matter expert for DBT, Snowflake, and Looker. Guide and mentor analysts, data scientists and junior members of the team to ensure best practices are followed and that data is well-tested.
- Collaborate Across Teams: Work closely with analysts to design and build reliable, well-structured data models that enhance the business's analytical capabilities and efficiency. You will also be working closely with our software engineers to bring new source data into our data warehouse.
- Performance Optimisation: Identify and implement optimisations within our data warehouse, ensuring that the analytics infrastructure operates efficiently, in a cost-effective manner.
- Champion Best Practices: Ensure we're following data modelling and data architecture best practices while promoting data quality, integrity, governance, and a healthy, secure data culture within the engineering domain and wider data team.
- Solve Complex Problems: Develop a deep understanding of our Data Platform to safely tackle and solve challenging problems across the data stack.
Expertise in: Production ETLs (big data, data warehousing) and data modelling, with strong proficiency in SQL and Snowflake architecture. - Experience with: DBT, Looker (or similar Business Intelligence tools), and general Data Warehousing concepts.
- Skills: Proactive in identifying opportunities for improvement, with a keen eye for data quality and detail. You have experience building reliable datasets and collaborating effectively with analysts.
- Additional Skills (Desirable): Familiarity with Python, Java, or similar languages; experience with orchestration frameworks (e.g., AWS Step Functions, Airflow); and AWS cloud services. Any background in the insurance sector is a plus.
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., Insurers thrive on data, and Marshmallow competes in one of the world's most advanced markets globally. To fulfil our mission, our data teams must be exceptional, equipped to solve complex problems with intelligence and passion. We're committed to empowering our teams and individuals through data. We collaborate across departments, championing a data-driven culture, breaking down silos, and promoting tools for self-service. - Flexible benefits budget - £50 per month to spend on a Ben Mastercard meaning you get your own benefits budget to spend on things you want. Whether that's subscriptions, night classes (puppy yoga, anyone?), the big shop or a forest of houseplants. Pretty much anything goes
- Sabbatical Leave - Get a 4-week fully paid sabbatical after being with us for 4 years
- Work From Anywhere - 4 weeks of work from anywhere to use, with no need to come to the office
- 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, pension, cycle-to-work scheme, monthly team socials and company-wide socials every month!, We break it up into 4 stages:
- Initial call with one of our Talent team (30 mins)
- A skill-based interview focusing on your past experience (60 mins)
- A technical interview focusing on both analytics and coding (1 hour)
- Final stage behaviour-based culture interview (60 mins)