Wells Oil Ltd is now Green Wells Energies Limited. We are an Oil Marketing Company incorporated in 2011 under the Companies Act of Kenya. As a company, we are focused in importing, distribution, warehousing and marketing of petroleum products Kenya. Today Wells Energies operates a chain of modern retail outlets in Western Kenya with their Head Offices in Kisumu City.

Read more about this company

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:

5 years experience

Academic qualifications:

Bachelor of Commerce degree with IT

• 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

• Power BI
• Tableau
• Data Analysis
• Data Pipelines
• Forecasting
• Risk Management
• Financial Modeling

• Bachelor of Commerce degree with IT