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