Operations Planning Analyst
TLDR
Build Metabase dashboards and SQL reports, connect live databases to Google Sheets, and optimize demand planning, fulfillment flow, and middle-mile operations.
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.
Bosta is an overnight delivery provider focused on E-commerce companies in Egypt and KSA. By leveraging technology, we deliver fast, reliable logistics solutions that enable businesses to track and connect with couriers seamlessly through a unified platform, effectively disrupting traditional logistics models.
- Founded
- Founded 2016
- Employees
- 51-200 employees
- Industry
- Internet Software & Services
- Total raised
- $1.7M raised