Junior Analytics Engineer at Bloom & Wild

Job Description

🔊Please note: This role does not currently offer visa sponsorship. Applicants must have the right to work in the Netherlands at the time of application.🔊

bloomon is turning the flower industry on its head – for the better. How? By disrupting the traditional supply chain! We skip the auction and wholesale, to shorten the journey for our flowers. And we harness technology, brand and innovation to deliver gifts and subscriptions that delight our customers across Europe.

We launched in Amsterdam in 2014, and in 2021 joined forces with Bloom & Wild, the UK's fastest growing ecommerce company (according to the Financial Times). Our group is backed by top tier investors and is now home to a family of 3 strong brands, Bloom & Wild, bloomon and Bergamotte. Together, we’ve delivered over 20 million orders (and counting!), making us the largest direct to consumer flower business in Europe.

Our vision is 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.

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.

🛠️ 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 at Bloom & Wild Group

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 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!

🫱‍🫲 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 an interview with our Head of Analytical Engineering, Joan and Principal Engineer, Mavis - to run through your experience, motivations, go over the role in more detail and it will also 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.

🔊Please note: This role does not currently offer visa sponsorship. Applicants must have the right to work in the Netherlands at the time of application.🔊

We believe in leading change for good, so if there’s anything that we can do to help you flourish throughout your application process with us, or if you have any feedback, please share this with us anonymously here so we can use this to improve your experience.

#Bloom&Wild

Apply