We operate a distillery and we are building an operational data system to better manage inventory, sales, and forecasting. Our ERP system is Odoo, which currently manages: • inventory • purchase orders • production registers • invoicing Some operational data from Odoo and other sources is already synced into Supabase (PostgreSQL). We started building a COO Cockpit dashboard using Retool, but the previous developer did not correctly implement the data modeling and calculation logic. Most of the raw data is already collected, but the analytics and metrics layer needs to be rebuilt properly. ⸻ Main Objective Build a reliable data pipeline and dashboard system that allows management to monitor operations and make decisions. The cockpit should display: • sales velocity by product • inventory levels • incoming purchase orders • stock coverage • forecasting indicators ⸻ Current Architecture Odoo → operational system (inventory, purchasing, production) Supabase / PostgreSQL → centralized data layer SAQ data → weekly sales data import Shopify API → e-commerce sales Retool → dashboard interface ⸻ Scope of Work The developer will: 1. Review the existing Supabase schema 2. Map all current tables and queries 3. Rebuild the data structure into three layers: Raw Data Layer Transformation / Analytics Layer Dashboard Metrics Layer 4. Write optimized SQL queries to calculate operational metrics 5. Connect these views to dashboards (Retool or similar) ⸻ Expected Outcome A stable and scalable data pipeline where dashboards read clean metrics directly from Supabase. The COO cockpit should allow us to quickly see: • sales trends • stock levels • purchase planning • forecasting indicators ⸻ Required Skills • Supabase / PostgreSQL • SQL data modeling • API integrations • Retool or dashboard tools • Experience with ERP integrations (Odoo is a strong plus) ⸻ Important Most of the infrastructure already exists. The main task is reviewing the current setup and restructuring the data logic so the dashboards work reliably.