Business Intelligence Analyst

•           Designing and maintaining a single data source for the Enterprise Resource Planning (ERP) system, Customer Relationship Management (CRM) platform, supply‑chain portals (KPC portal, depot logs), sales route‑plan systems and HR records.

•           Systematically collecting and analyzing external data to supplement internal data.

•           Collaborating 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.

•           Monitoring daily ullage (available storage space) at KPC and private depots and issue evacuation alerts to logistics and sales teams when capacity is reached.

•           Producing 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.

•           Analyzing sales data captured in the previous six months from the CRM, route‑plan system, sales KPIs and the sales balanced scorecard (BSC).

•      Tracking 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.

•           Monitoring foreign‑exchange exposure (USD/KES) and assess the profit‑and‑loss impact of exchange rate volatility.

•           Analyzing the cash conversion cycle by correlating inventory holding periods with customer payment behaviour.

•           Maintaining a risk register for supply, logistics, financial and regulatory risks.

•      Developing 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.

•      Liaising daily with the Supply Chain Manager to translate gaps identified in the supply department into actionable analytics projects.

•           Contributing to capacity‑building programmes by training colleagues in data literacy, dashboard usage and basic.

•           Prepare comprehensive monthly business review (MBR) packs, investment proposals (e.g., leasing additional storage at private terminals) and strategic decision summaries.

•           Creating and maintaining documentation, aligning with industry best practices.