Operations Planning Analyst

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.

Job Requirement

• 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.