Clera home
·Dashboard

Operations Planning Analyst

Location
Cairo
Workplace
On-site
Apply now

About this role

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.

\nJob 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.

\n

Tired of cold applications?

Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.

Know someone who'd be great for this?