Business Intelligence Analyst

Job Description:

• Design and maintain a single data source for the Enterprise Resource Planning system, Customer Relationship Management platform, supply?chain portals, sales route?plan systems and HR records
• Systematically collect and analyze external data to supplement internal data
• Collaborate with IT to develop automated data pipelines, implement validation rules and maintain documentation for all data sources and transformations
• Use demand forecasts to calculate optimal nomination volumes for OTS imports
• Monitor daily available storage space at KPC and private depots and issue evacuation alerts to logistics and sales teams when capacity is reached
• Produce weekly reports on non?compliant customers, days products stay in pipeline per customer, payment timelines versus order booking, cancelled or edited orders, and evacuation efficiency for Kenya, Uganda and private depots
• Track Platts indices, import trends and competitor pricing in collaboration with the costing team
• Build dynamic models to forecast daily cash requirements for tax and duty payments, OTS settlements and operational expenses
• Monitor foreign?exchange exposure and assess the profit?and?loss impact of exchange rate volatility
• Maintain a risk register for supply, logistics, financial and regulatory risks
• Develop interactive dashboards in Power BI, Tableau or similar tools that provide real?time visibility into liquidity, sales performance, stock days cover, depot congestion and operational efficiency
• Prepare comprehensive monthly business review packs, investment proposals and strategic decision summaries

Requirements:

Academic qualifications: