Senior BI / Data Analyst – Inventory Overview Dashboard (BigQuery, Looker Studio)

Senior BI/ Data Analyst for Inventory Dashboard (BigQuery/ Locker Studio/ Google Stack)

Project: Build a decision-ready Inventory Overview Dashboard for a premium e-commerce brand (leather goods).

Goal: Create a daily updated inventory dashboard to analyze stock levels, sell-through, velocity, and aging stocks supporting purchasing, sell-off and reordering decisions.

Scope and Requirements:

Dashboard must support multi dimensional drill-down analysis, flexible dimensions, product type, product SKU (including B/ C filters), Product Title, Parent SKU, Click to drill and free reordering of dimensions, data range selection affecting all KPIs

Required KPIs: Units Sold, Inventory Level, Inventory Value, Sales Velocity, Stock Coverage (Days), Units Received, Sell through Rate (period and all time)

KPI logic must be correct, consistent and documented.

Tech Stack

Inventory: JTL Wawi

Shop: Shopware

Warehouse: Google BigQuery

Visualization: Looker Studio

Deliverables

Looker Studio Inventory Dashboard

Clean BigQuery data models (SQL)

Short documentation (KPIs, logic, assumptions)

Who We’re Looking For

Strong hands-on experience with:

- BigQuery (SQL-heavy)

- Looker Studio

- Inventory & sales data

- Focus on data modeling & correctness (not a design role)

- English or German communication

Project Details

- Paid, project-based (fixed price preferred)

- Market-rate compensation for senior profiles

- High chance of follow-up work

Please Include

- Relevant BI projects (inventory/ops preferred)

- Experience with Google BI stack

- Estimated effort (hours)

- Fixed-price proposal

- Short description of your approach

Apply Now

Apply Now