About this Operations Planning Analyst role at Bosta
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.
