Business Intelligence Engineer Intern — Ops Excellence

Bigblue; Paris; On-site; EUR 10,155 - 12,164; Full time

Benefits offered by this job

Meal voucher (€5 per working day)

Health insurance (Alan, 100% covered)

Transport card (€42.50/month)

Birthday and anniversary gifts

Job summary

Bigblue is seeking a Business Intelligence Engineer Intern in Paris to join the Ops Excellence team. The intern will design and maintain data pipelines while developing BI solutions that enhance real-time visibility into logistics performance. Ideal candidates are in their 4th or 5th year of an engineering program with strong SQL skills and familiarity with data tools like dbt and BigQuery. Competitive compensation and benefits include meal vouchers, health insurance, and a dynamic startup environment.

Qualifications

• Complex SQL query writing and optimization.
• Experience with ETL pipelines and data modeling.
• Ability to automate recurring reporting tasks.

Responsibilities

• Design, build, and maintain data pipelines.
• Develop scalable BI solutions and dashboards.
• Create robust data models and schemas.
• Automate reporting tasks and identify process improvements.
• Ensure data quality and reliability.

Skills

Strong SQL skills

Familiarity with data engineering tools

Experience with BI and visualization tools

Python or another scripting language

Education

Student in year 4 or 5 in engineering school, computer science, or statistics

Tools

SQL

dbt

BigQuery

Metabase

Job description

About Bigblue

E-commerce is booming — but independent brands still struggle to match the seamless logistics of giants like Amazon. At Bigblue, we're on a mission to change that. We help brands by democratizing best‑class operations: scaling faster while delivering a five‑star customer experience.

Since 2018, we've built a tech‑driven logistics platform powering 500+ brands — from fast‑growing DTC players to global names like MUJI, Aigle, and Cabaïa. With 110+ employees across Paris, Madrid, and London, our proprietary WMS (Warehouse Management System) Atlas, and a network of 7 warehouses across Europe, we're solving logistics challenges that others haven't dared to tackle — making fulfillment faster, smarter, and greener.

Backed by $20+M in funding and trusted by the next generation of e‑commerce leaders, we're scaling rapidly — from 10 million orders in 2024 toward ambitious enterprise expansion. The journey ahead is bold, and we're looking for the right partner to help us lead the way.

What data means for Bigblue

At Bigblue, data is the backbone of how we operate. Our data infrastructure — built on BigQuery and dbt, surfaced through Metabase — powers every operational decision: from tracking fulfillment performance across 7 warehouses to monitoring carrier service rates in real time. As we scale across Europe, our BI layer needs to scale with us.

The Ops Excellence team is at the heart of this challenge: translating raw warehouse and transportation data into reliable, structured, and accessible intelligence — so our operators, product teams, and executives can act fast and act right.

The role

Location: Paris — 7 rue Caumartin, 75009

Type: End‑of‑studies internship or gap year (SFE / césure)

Duration: 6 months

Start: ASAP

Bigblue is looking for a Business Intelligence Engineer Intern to join the Ops Excellence team.

This is a highly technical role at the intersection of data engineering and analytics. You won't just consume data — you'll help build the infrastructure that makes it accessible, reliable, and actionable for our entire Ops organization. This is a unique opportunity to work on real‑scale, production‑grade BI systems in a fast‑moving logistics startup.

Our data challenges

• Data pipeline development: Design, build, and maintain data pipelines that consolidate and transform raw warehouse and operational data into clean, structured datasets ready for analysis — using SQL, dbt, and our BigQuery data warehouse.
• Dashboard & reporting infrastructure: Develop scalable BI solutions — datasets, reports, and Metabase dashboards — that give our Ops teams real‑time visibility into fulfillment KPIs, warehouse performance, and service levels.
• Data modeling & schema design: Create and manage data structures that are robust, well‑documented, and easy for analysts across teams to use — applying best practices in schema design and data governance.
• Automation & process improvement: Write secure, maintainable code that automates recurring reporting tasks and frees our analysts to focus on higher‑value work. Identify opportunities to replace manual processes with scalable, engineered solutions.
• Data quality & reliability: Troubleshoot data and pipeline issues, propose solutions, and take ownership of resolutions — ensuring that the numbers our teams rely on are always accurate and up to date.

Your profile

• Student in year 4 or 5 of an engineering school, computer science, statistics, or equivalent program
• Strong SQL skills — able to write complex queries, optimize for performance, and model data from scratch
• Familiarity with data engineering tools and concepts: dbt, BigQuery, ETL pipelines, data modeling
• Experience with BI and visualization tools (Metabase, Looker, Power BI, or similar)
• Python or another scripting language is a strong plus
• You think in terms of systems: you care about code quality, reusability, and long‑term maintainability
• Curious and rigorous — you go deep to understand the data before trusting it
• Comfortable in a fast‑paced, startup environment with evolving requirements
• Fluency in English and French

What we offer

• Meal: €5 per working day (100% tax‑exempt) + free meals at the office twice a week
• Health: Alan health insurance, 100% covered
• Transportation: Swile card with €42.50/month for transport
• Buy from our merchants program: birthday, anniversary & end‑of‑year gifts from Bigblue brands
• Compensation: €1,000/month
• Brand new offices in Paris' largest tech hub (9th arrondissement)
• MacBooks as standard, plus any equipment you need to do your best work