Operations Planning Analyst

🏢 Bosta
📍 EgyptFull-timeOn-site
📅 Posted: 3w ago🔄 Updated: 3w ago
CV%
✨ AI Summary
Bosta is seeking an Operations Planning Analyst to join their team in Egypt. This role involves building and maintaining operational dashboards using Metabase and SQL, connecting live databases to Google Sheets, and owning demand planning and replenishment cycles. The analyst will also plan and monitor middle-mile operations, analyze the full fulfillment flow to identify bottlenecks, and track the fulfillment P&L by linking operational KPIs to cost drivers and margin. Collaboration with operations leadership to translate analysis into actionable plans is key. The ideal candidate has strong SQL skills, experience with BI tools like Metabase, live database to Google Sheets integration, a solid understanding of fulfillment operations, and experience with demand and middle-mile planning. Analytical and detail-oriented individuals comfortable in a fast-paced environment are encouraged to apply.
Required Skills
Information Technology
Metabase
Soft Skills & Professional Competencies
Planning
Operations, Logistics & Supply Chain
Demand Planning
Other
replenishment
Finance, Legal & Governance
Payment Operations
Requirements
Requires strong SQL skills and experience with Metabase or comparable BI tools, along with the ability to connect live databases to Google Sheets. Proven experience in demand planning, replenishment, middle-mile planning, and analyzing fulfillment operations (inventory, inbound, outbound, RTO, RTV) is essential. Must be able to interpret a P&L and link operational KPIs to financial outcomes, possessing strong analytical and detail-oriented skills for a fast-paced environment.
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 QualificationsStrong 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.We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
✨ Premium Match Details
Deep-dive CV analysis, customized Cover Letters, and Interview prep!
📊 Match Analysis
Insights against your active CV
📊
Personalized Match Analysis
Upload your CV to see exact matching percentages, detailed skills mapping, and gap analysis for this role.
🎯 Overalli74%
⚡ Skillsi85%
View Breakdown
Ontology Match: 85.0
Matched:✓ Requirements Matching✓ Ontology Skills Mapping
📜 Eligibilityi49%
View Breakdown
Local: 19600%
🏗️ Career Fiti91%
View Breakdown
Seniority: 91.0
📋 Requirementsi67%
View Breakdown
Domain: 67.0
🔥 Motivationi78%
View Breakdown
Title Fit: 78.00