Internal analytics dashboards for a logistics SaaS (Postgres + React)

Ops managers at the freight companies using our TMS keep asking for reporting we do not have, and exporting CSVs for them is eating our support team alive. We are FreightPath, a 12-person logistics SaaS, and we want embedded analytics built into our existing React app: on-time delivery trends, lane profitability, driver utilization, and carrier scorecards, all filterable by date range and customer. The work splits into two halves. First, design the aggregate tables and materialized views in PostgreSQL so dashboard queries return in under two seconds against ~40M shipment rows. Second, build the dashboard views in React using our existing component library (we use Recharts already, no need to introduce anything new). We will provide designs for the first two dashboards; you will help shape the rest. Our backend lead handles API plumbing, so you can stay focused on queries and UI. Code review turnaround is same-day. We would rather you ship one polished dashboard a week than four rough ones at the end.