Junior Analytics Engineer

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.

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

🧭 Our ways of working

We do things a little bit differently. From inventing letterbox flowers to founding The Thoughtful Marketing Movement. 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 most
• Think deeply, act swiftly: we make sure there’s thoughtful rationale behind our approach and always act swiftly to implement ideas
• Care wildly: we pour care and creativity into everything we do and pay attention to the things that make a difference
• Stay open, be curious: we’re open about what we’re doing and why, and we welcome challenges from each other

We really believe in the power of face-to-face connections - be that through a shared project, a learning and development opportunity, or an after work social - and trust our teams to make the right decisions (for them and us) about where and how they work each day. Our working patterns are flexible and vary across the business, depending on the type of work, need for collaboration, and personal and wellbeing circumstances.

🌟 (Some of) The good stuff

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

🌻 Work that works for you

• Work Abroad for up to 30 days each year
• Share in our success with a choice to take equity options from day 1
• 1 day per year to volunteer on a project that’s close to your heart
• We’ll support your commute to our office and site locations. Depending on your journey to work, this may include a Swapfiets, an NS business card or expense reimbursement

🌴 Time off

• 24 vacation days and an option to buy an extra 5 each year
• Happiness days (1 extra day each quarter for your personal ‘me time’)
• 1 celebration day per year, to celebrate a holiday that’s important to you
• Flexible bank holidays - trade a bank holiday for another day that fits your beliefs, values and celebration calendar

🌱 Health and wellbeing

• Mental health support through Open Up, including access to online therapy sessions
• Allies and champions groups
• Mental Health First Aiders and awareness training for our managers
• In person and virtual yoga every week
• Our office kitchen is stocked with healthy drinks and snacks to keep you going
• Workplace pension contributions

🌳 Growth & Development

• A flexible training framework for every stage of your career development through our Bloom & Learn programme
• Internal & external Speaker Sessions on a variety of different inspirational topics.

💐 Moments that matter

• We love having lunch together! We offer daily fresh and healthy lunch options at our locations in Amsterdam and Amstelveen
• A BBQ-worthy rooftop terrace (Amsterdam HQ)
• Social & wellbeing monthly calendar
• We love to celebrate birthdays, anniversaries and other important milestones!
• Summer and End of Year events, team lunches and post-peak celebrations
• Irresistible discounts on our products, blooms & subscriptions!