Supply Chain Data & Planning Analyst Job African Coffee Roasters Machakos, Kenya
Role Summary
- The Supply Chain Data & Planning Analyst will support the Supply Chain team by ensuring accurate, timely, and reliable operational data for planning, reporting, and decision-making. The role will work closely with warehouses, sourcing teams, operations, finance, commercial and product teams to collect, consolidate, validate, analyze, and maintain data across the organization.
Key Responsibilities
Data Management
- Collect and consolidate supply chain data from warehouses, sourcing teams, production facilities, commercial teams and other stakeholders into standardized databases.
- Validate and maintain accurate inventory, sourcing, and planning data.
Reporting & Dashboarding
- Prepare weekly and monthly supply chain reports and dashboards using Advanced Excel and Power BI.
- · Monitor and report KPIs related to inventory, sourcing, logistics, and operational performance.
Planning Support
- Support demand, inventory, and sourcing planning through data analysis and stock projections.
- Identify potential risks, shortages, and improvement opportunities.
Inventory & Reconciliation
- Monitor inventory levels and reconcile physical stock with system records.
- Investigate discrepancies and support month-end stock closing.
Cross-Functional Coordination
- Coordinate with Supply Chain, Operations, Finance, Commercial, and Product teams to ensure timely data submission and reporting.
- Support project tracking and information management initiatives when required.
- Support to other team members for creating automation reports and dashboards.
Qualifications and Competencies
- Bachelor’s degree in Supply Chain Management, Business Administration, Statistics, Engineering, or a related field.
- 2–3 years of experience in supply chain, planning or operations.
- Must have at least 1 year of data analyst experience.
- Advanced proficiency in Microsoft Excel (Pivot Tables, Power Query, formulas, scenario analysis).
- Must have basic to intermediate Power BI skills.
- Strong analytical and problem-solving abilities.
- Experience with inventory management systems or ERP platforms.
- Knowledge of supply chain processes, inventory control, and planning methodologies.
- Familiarity with data visualization and reporting best practices.
- Excellent attention to detail and data accuracy.
- Ability to manage multiple priorities and work independently.
Key Performance Indicators
- Improved data accuracy and consistency.
- Reduced effort required for monthly reporting and reconciliation.
- Timely delivery of dashboards and reports.
- Enhanced visibility for planning and decision-making.
- Increased capacity within the Supply Chain team to focus on strategic initiatives.
How to Apply
🎯 Before You Apply For this Job.
This job will attract 1000+ applicants.
Many qualified professionals will miss out on getting shortlisted and interviews — not because they lack experience, but because their CV doesn’t clearly show how they fit this specific job.
🎯 Want to get an interview fast? Customize your CV specifically for this job.
Using the same CV for every application will not get you interviews.
Contact Rose our client service manager and together with our recruiters she will review your CV and show you exactly how to improve it for the job you are targeting. Click Here For Us To Customize Your CV For This Job Opportunity
Is your AI CV not getting you interviews? Click Here To Get A Professionally Written CV
Read Job Seeker Testimonials Below: Professionals Who Got Jobs Through Corporate Staffing
Related Jobs To Check Out
Jobs Managed by Our Recruitment Team
The vacancies below are managed directly by the Corporate Staffing recruitment team on behalf of our clients. Review the job advert, then submit your application through our recruitment team for consideration.
Browse Other Jobs Posted Today
Explore the latest job opportunities posted now. Apply early to maximize your chances, as many employers begin reviewing applications as soon as suitable candidates apply.