Overview

Hi, we’re Bloom and Wild. We don’t just send flowers. We help our customers to care wildly. Caring wildly is celebrating the little things we all do for each other every day. Not just the big occasions. It’s being there for the highs. Stepping up for the lows.We care wildly about people and our planet. Which is why we’re so proud to be a certified B Corp – committed to making long-term positive change for our community, and the world around us.Founded in 2013, our mission back then was to make sending and receiving flowers the joy that it should be, by harnessing technology, brand and letterbox delivery. We announced £75 million Series D funding in 2021 and that same year acquired bloomon in The Netherlands and Bergamotte in France. Together, we’ve fulfilled and delivered over 20 million orders (and counting!), making us the largest direct to consumer flower business in Europe.Now home to a family of 3 beautiful brands, we’re driven by our vision to create the destination for making life a little more thoughtful and beautiful. And we won\''t stop at flowers and plants. Starting with the Bloom and Wild brand, we\''re expanding our gifting offering to other categories like cakes, candles and cocktails. This is all part of our ambition to build Europe\''s #1 direct to consumer gifting destination.? The Business Intelligence and Analytics Team @ Bloom and WildData is at the heart of what we do at Bloom and Wild Group. Our BI and Analytics team empowers growth by transforming data into actionable insights and we\''re passionate about understanding customer behavior and identifying opportunities to delight them even more. We leverage SQL, data visualisation, and rigorous experimentation and analysis to uncover trends, predict user needs, and test hypotheses. We believe data drives positive change and empowers informed decisions and we value collaboration, continuous learning, and a data-driven mindset.Please note:

This role does not currently offer visa sponsorship. Applicants must have the right to work in the UK at the time of application.What you’ll be doing

As a Junior Analytics Engineer , you\''ll be reporting to the Head of Analytical Engineering and will play a crucial role in ensuring our data infrastructure supports our fast-paced, data-driven business.Responsibilities

Supporting Tech Changes:

Evolve our BI data platform by adapting data models and reporting to support our evolving tech landscape to help drive us forward as a business.Collaborate with teams:

Work closely with tech and Data Engineering teams on new feature development, ensuring data requirements are understood early and incorporated into data models efficiently.Data pipelines:

Proactively build and maintain data pipelines and models to support new tech initiatives and allow us to progress at pace.Data integrations:

Work closely with our Data Engineering Team to ensure seamless data flow and integrations.Optimise Existing Data Models

Understand our data across multiple areas of the business such as Product, Operations, Finance, Commercial and Marketing.Work with business stakeholders and the BIandA team to optimise performance of existing data models, making them more cost effective and run faster.Implement DBT best practices for modularity, reusability, and incremental builds to significantly reduce Snowflake compute and storage costs.Monitor data pipeline performance and identify areas for optimisation to ensure efficient data processing.Create New Scalable Data Models

Develop new, robust, and well-documented data models as required by various business areas, ensuring data consistency and reliability across the organisation.Work closely with analysts to understand their data needs and translate them into efficient data structures.Utilise DBT and Snowflake daily to create and maintain robust and scalable BIandA data models.Drive improvements in data processes to enable us to scale and automate tasks where possible.Support AI Usage and Unlock AI Capabilities

Build and maintain the highly curated and optimised datasets necessary to power future AI initiatives, such as natural language querying tools for the wider business.Explore and potentially leverage AI tools (e.g. AI-assisted code generation) to speed up your own analytical engineering tasks.Proactively learn new data modelling techniques and stay up to date with industry trends to challenge the way we do things at Bloom and Wild.You’ll love this role if you are…

Curious about Data

- You are passionate about data, understand its value and are keen to utilise it to drive a business forward.A Problem Solver

- You’re excited about problem-solving and are proactive about investigating innovative solutions.Open and Empathetic

- You value diversity and inclusion, and are eager to learn from and work with others.A Collaborator

- You have a collaborative style that enables you to work and communicate effectively with a range of different people and teams.We’re looking For…

These are some of the skills and experience we think will enable success in this role. We’re committed to building a team made up of different strengths, skills and experiences, so if you’re excited about our values, passionate about what you do and would like to join us in doing things more thoughtfully, we’d love to hear from you.Must haves

1-2 years of experience in an analytical engineering or data analytics role.Proficiency in SQL with regular hands-on experience (Mandatory).Experience designing, building and maintaining dashboards in visualisation tools such as Tableau, Looker or Periscope.Ability to contribute to the development of data and analytical solutions.Problem solving and critical thinking skills including debugging and QA-ing data models and output.Excellent communication skills and ability to work with multiple stakeholders and cross-functional teams.Proactive team member - you take ownership and get stuck in, and you\''re able to balance multiple projects and priorities.Some experience in working with some data pipelines (ELT/ETL concepts) and warehouse knowledge.Nice to haves

Experience utilising Python for data manipulation.Experience using DBT.Experience using AI code assistants like GitHub Copilot to write and debug SQL and Python.Familiarity with leveraging AI for automated data documentation and generating quality tests, preferably within DBT.Knowledge of AI-driven features in modern BI platforms (e.g., Power BI, Tableau).E-commerce experience is a big plus.Belonging @ Bloom and Wild

We know that we learn through our differences, and building a diverse team has always been central to creating the best experience for our customers. We value all backgrounds, perspectives, ideas and experiences, and encourage everyone to share their opinions openly within our caring and inclusive team. Our champions community actively advances our culture of inclusion and belonging, which is organised around 8 pillars of diversity. These cross-business networks offer additional opportunities for connection, education, support and celebration, and ensure that inclusivity continues to be embedded in our ways of working.Our ways of working

We really believe in the power of connection. For us that looks different depending on the team you work in. Some of our teams work together in person every day, whereas others may connect in person every quarter. We also believe in flexibility that supports you, the work you do, and your team. How much you work from home and from our office depends on a balance of those needs, and you\''ll agree this with your manager. Whether it’s through a shared project, a learning and development opportunity, or an afterwork social - we trust our teams to make the right decisions (for them and us) about where and how they work each day.We’re big on collaboration, empathy, knowledge sharing and growth, and our values drive our priorities every day:Lead change for good:

we have the guts to try new things and step up to do what matters mostThink deeply, act swiftly

: we make sure there’s thoughtful rationale behind our approach and always act swiftly to implement ideasCare wildly:

we pour care and creativity into everything we do and pay attention to the things that make a differenceStay open, be curious:

we’re open about what we’re doing and why, and we welcome challenges from each otherWork that works for youTo care wildly for our customers, firstly we care wildly for our teams. We work hard to craft a culture of thoughtfulness and care, where there is a strong sense of inclusion and belonging, enabling all of our people to thrive and be successful each day.Our perks and benefits include:Flexible working and work from abroad25 days holiday + your birthday + flexible bank holidays, and option to buy additional holiday each year1 Volunteering day each yearEnhanced family leave and a workplace nursery schemeA flexible training framework for every stage of your careerIrresistible discounts on our products, blooms and subscriptions!Share in our success with a choice to take equity options from day 1For more information on our perks and bens, please see

Bloom and Wild careers pageGetting hiredWe’ll do everything we can to make sure your interview experience with us is a good one. It’s a 2-way process, and we’re keen to answer all of the questions you may have, so that you can be sure (and excited!) that we’ll be the right place for you.Apply below (it takes 2 minutes!).If your application is successful, the next step will be a brief chat with Billy, our Senior Talent Manager for Tech - to run through your experience, motivations and the role in more detail. Following this you will be invited to an interview with our Head of Analytical Engineering, Joan which will include a SQL competency test. If you advance past this stage, you’ll be asked to work on a case study and talk through your work with Joan, Em, our Director of BI and Analytics, and another member of the team. You will then have a final interview with Joe, our CTPO.Please note:This role does not currently offer visa sponsorship. Applicants must have the right to work in the UK at the time of application.We believe in leading change for good, so if there’s anything that we can do to help throughout your application process, or if you have any feedback, please share this with us anonymously so we can use this to improve your experience.

#J-18808-Ljbffr