Junior Analytics Engineer

Hi, we’re Bloom & 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 & 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 & Analytics Team @ Bloom & Wild Data is at the heart of what we do at Bloom & Wild Group. Our BI & 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.

💻 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.

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 closely with tech & Data Engineering teams on new feature development, ensuring data requirements are understood early and incorporated into data models efficiently.
• Proactively build and maintain data pipelines and models to support new tech initiatives and allow us to progress at pace.
• 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 rest of the BI&A team to optimise performance our existing data models, making them more cost effective & 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 BI&A data models.
• Drive improvements in data processes to enable us to scale and automate tasks where possible

Support AI Usage & 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 & Wild

✅ You’ll love this role if you are…

• Curious about Data - You are passionate about data, understand it’s 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 & Empathetic - You value diversity and inclusion, and are eager to learn from and work with others.
• A Collaborator - You have 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 & 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) & 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 & WildWe 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 workingWe 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 other
🌟 Work 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 & work from abroad 🌴 25 days holiday + your birthday + flexible bank holidays, & option to buy additional holiday each year💛 1 Volunteering day each year🐣 Enhanced family leave and a workplace nursery scheme🌱 A flexible training framework for every stage of your career 💐 Irresistible discounts on our products, blooms & subscriptions!📈 Share in our success with a choice to take equity options from day 1
For more information on our perks & bens, please see www.bloomandwild.com/careers
🫱‍🫲 Getting hired We’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 & Analytics, and another member of the team. You will then have a final interview with Joe, our CTPO.
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 here so we can use this to improve your experience.