Operations Planning Analyst

Bosta

Cairo, Cairo Governorate, EgyptFull-timeNo compensation foundPosted 1w agoVerified open 4 days ago

Evaluate my fit

Most applications go out cold — see where you stand first. No sign-up to start.

Don't just apply. Show up ready.

Olive works from this exact posting — no sign-up to start.

Evaluate your fitSee where you stand — strengths, gaps, and what to fix first.Get started →Tailor your résuméRewritten against this posting, with a diff of every change.Get started →Practice the interviewA voice mock interview built from this job description.Get started →

At a glance

Compensation

No compensation found

Location

Cairo, Cairo Governorate, Egypt

Schedule

Full-time

Work Authorization

Not specified

Job overview

Bosta is hiring an Operations Planning Analyst. Bosta seeks an Operations Planning Analyst to build and maintain operational dashboards, connect live databases to Google Sheets, own demand planning and replenishment cycles, and monitor middle‑mile operations while analyzing fulfillment flow and P&L to drive actionable improvements.

Key focus areas include Build and maintain operational dashboards and reports in Metabase using SQL, Connect live databases to Google Sheets for real‑time tracking, and Own demand planning and replenishment cycle forecasting.

Important skills include Metabase, SQL, Google Sheets, Demand Planning, Replenishment Cycles, and Middle-Mile Operations Planning.

Skills & qualifications

RequiredNice to have

Skills

MetabaseSQLGoogle SheetsDemand PlanningReplenishment CyclesMiddle-Mile Operations PlanningCost EfficiencyFulfillment Flow AnalysisP&L AnalysisAnalytical SkillsDetail-OrientedWorking in a Fast-Paced Operational Environment

Qualifications

Experience Building Reports in Metabase or Comparable BI ToolProven Ability to Link Databases With Live Google SheetsSolid Understanding of Fulfillment OperationsExperience With Demand PlanningExperience With ReplenishmentExperience With Middle-Mile PlanningAbility to Read and Work With a P&L

Full job description

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.

You've read the whole posting — now see how you match it.

Evaluate my fit