Legal Counsel

About Bosta:
Launched in 2017, Bosta is an overnight delivery provider for E-commerce companies in Egypt. Leveraging technology to empower businesses is what we do best. Our goal is to disrupt the logistics industry by bringing technology and experience altogether to provide a one-stop-shop for delivery solutions.
We rely on advanced technology to deliver orders to our customers in a fast way. Businesses can track and connect with couriers and follow up on their orders - all in one system.

Role Summary We're looking for an Operational Analyst & Planner to own the data, reporting, and planning layer of our fulfillment operation. You'll turn raw operational data into clear dashboards, forecasts, and replenishment plans that keep inbound, outbound, and middle-mile running smoothly and you'll be comfortable digging into the P&L to connect operational decisions to cost.

Job Responsibilities

Build and maintain operational dashboards and reports in Metabase, writing and optimizing SQL queries against the operational database.

Connect live databases to Google Sheets to power real-time trackers and shared operational views.

Own demand planning and replenishment cycles forecasting volumes, setting replenishment triggers, and keeping stock availability aligned with sales demand.

Plan and monitor middle-mile operations, including capacity, routing, and cost efficiency.

Analyze the full fulfillment flow: inventory, inbound, outbound, RTO, and RTV — surfacing bottlenecks and process gaps.

Track and analyze the fulfillment P&L, linking operational KPIs to cost drivers and margin.

Partner with operations leadership to translate analysis into actionable plans and process improvements.

Job Qualifications

Strong SQL skills, with hands-on experience building reports in Metabase (or a comparable BI tool).

Proven ability to link databases with live Google Sheets for operational reporting.

Solid understanding of fulfillment operations — inventory, inbound, outbound, RTO, and RTV.

Experience with demand planning, replenishment, and middle-mile planning.

Ability to read and work with a P&L, connecting operations to financial outcomes.

Analytical, detail-oriented, and comfortable working in a fast-paced operational environment.