BILLY FRANKLIN ADWAR
Nairobi
Summary
Data Engineer with 3+ years of experience designing and scaling ELT & ETL pipelines with SQL, Python, and dbt across agriculture, manufacturing, and financial-services businesses. Skilled at working across the business-technical divide: translating operational and stakeholder needs into reliable data infrastructure, from earth-observation ML models to enterprise-wide ERP data platforms. Brings a geospatial-science background into data engineering — from satellite-based crop models to production PostGIS/pgRouting route-optimization and asset-mapping systems. Track record of measurable impact — 25% lower logistics costs, 35% gain in operational efficiency, and 100% data-quality conformance on core master data. Currently leading data, ERP, and geospatial systems at Nevira Minerals for a 450+ person organization.
Overview
4
4
Certificate
7
7
years of professional experience
Work History
Data Engineer
Nevira Minerals LTD
Nairobi, Kenya
01.2026 - Current
- Own the company's data strategy, architecture, and governance (privacy and data-sharing standards) end to end, leading a team of two data analysts and one business analyst across finance, manufacturing, procurement, sales, and HR for a 450+ employee organization.
- Stood up the production data and ERP infrastructure on a Contabo VPS, plus a separate low-cost VPS for development and testing, establishing a safe release path for infrastructure and pipeline changes.
- Built and orchestrated batch ELT pipelines in Python/Airflow, moving transactional data from the operational MySQL database into Parquet on object storage, then into a PostgreSQL warehouse via DuckDB, modeled in dbt using a medallion (bronze/silver/gold) architecture.
- Implemented change data capture (CDC) for core ERP doctypes to keep downstream analytics accurate and consistent.
- Introduced pipeline observability with Prometheus and Grafana, giving the team visibility into pipeline health and faster detection of failures.
- Own the company's geospatial data systems: mapping company assets (sites, equipment, and facilities) and building a route-optimization tool on PostGIS and pgRouting, currently used in production to plan and evaluate delivery-vehicle routes — extending prior GIS/earth-observation experience into core data infrastructure.
- Partner directly with finance, manufacturing, procurement, sales, and HR stakeholders to turn analytics requirements into dbt models and Metabase dashboards, and to review analysts' SQL.
Data Engineer
OdukTech
Nairobi, Kenya
09.2025 - 01.2026
- Built 5 reusable dbt models on top of ERPNext source systems, adopted across credit/finance, manufacturing, and retail accounts.
- Built 5 reusable dbt models on top of ERPNext source systems, adopted across credit/finance, manufacturing, and retail accounts.
- Deployed and ran a self-managed, open-source analytics stack (dbt, Airflow, Metabase) on Contabo VPS with Object storage, keeping infrastructure costs low for clients.
- Cut query times for finance and other downstream users tracking daily KPIs, and removed teams' dependence on manual Excel exports by delivering governed dashboards in Metabase.
Business Engineer
agriBORA
Nairobi, Kenya
09.2024 - 09.2025
- Led the functional deployment and optimization of ERPNext, automating inventory, finance, and sales workflows — a 35% improvement in operational efficiency and higher data accuracy across departments.
- Automated critical processes in inventory, finance, and sales for enhanced efficiency.
- Created a route optimization tool using QGIS, OSM Data and PostgreSQL to plan and schedule deliveries to customers leading to a 25% reduction in logistics costs.
- Built SQL-driven reporting for external partners to track credit scores, loan repayments, and customer-success metrics.
- Developed customer segmentation for targeted chatbot interactions, enhancing engagement for customer success team at agriBORA.
- Implemented training and internal capacity development on metabase for self-service analytics, solidifying culture of data-driven decision making at Agribora.
Earth Observation Engineer
agriBORA
06.2023 - 08.2024
- Developed and maintained ML pipelines to automate and streamline the training, deployment and monitoring of machine learning models, ensuring scalability and reliability of models and infrastructure for continuous updates and predictions.
- Developed and trained machine learning models to forecast yield at field level for over 1000 small-holder farmers in western Kenya leading to enhanced risk monitoring.
- Developed workflows for extracting vegetation indices using DEA STAC-enabled data-cube, supporting seasonal field monitoring and improving credit scoring.
- Designed the spatial database, queries and query optimization to support route optimization for logistics at agriBORA.
- Introduced analytics to the business using SQL and Metabase, uncovering insights that improved logistics operations and cut costs by 25%, while supporting 20+ downstream dashboards.
- Created loan monitoring system for tracking individual farmer loans, streamlining repayment tracking and reducing loan default risks for over 1000 farmers in Western Kenya.
- Facilitated field mapping operations and conducted training data collection and quality testing for crop-cut and crop type surveys.
- Implemented data collection surveys using the KOBO open data kit for collecting non spatial data and QField for conducting crop type mapping.
Geospatial Engineering Intern
Geo-Explicit Systems
01.2020 - 06.2020
- Deployed web map services with Geo Server and Geo Node to facilitate access to geospatial data adhering to OGC Standards: WFS, WMS.
- Managed spatial databases and synchronized with open source spatial databases using PostGIS on PostgreSQL to ensure data consistency.
- Conducted digital image analysis for land use and land cover using ERDAS Imagine and ENVI to support environmental assessments.
Education
Bachelor of Science - Geomatics and Geospatial Information Systems
Dedan Kimathi University of Technology
Nyeri, Kenya01-2022
Kenya Certificate of Secondary Education -
Kakamega School
Kakamega, Kenya01-2016
Skills
- Languages: SQL, Python, Scala, Bash
- Data Processing: dbt, Spark
- Orchestration: Airflow, Prefect
- Databases: PostgreSQL, MySQL, MongoDB, PostGIS
- GIS: QGIS, ArcGIS Pro, LeafletJS, Geo-django, Geopandas, Pandas, Shapely, Numpy
- Cloud and Storage: AWS S3, Redshift
- Data analytics: Metabase
- Workflow Automation: n8n, Makecom
- ERP: ERPNext, Frappe Framework
- Machine Learning: Scikit Learn, Tensorflow, MlFlow
Certification
- Git & GitHUB: Code Academy
- Advanced SQL: LinkedIn
- ESRI Spatial Data Science: The New Frontier in Analytics
- ATINGI: Machine Learning on Earth Observation
Timeline
Data Engineer
Nevira Minerals LTD
01.2026 - Current
Data Engineer
OdukTech
09.2025 - 01.2026
Business Engineer
agriBORA
09.2024 - 09.2025
Earth Observation Engineer
agriBORA
06.2023 - 08.2024
Geospatial Engineering Intern
Geo-Explicit Systems
01.2020 - 06.2020
Bachelor of Science - Geomatics and Geospatial Information Systems
Dedan Kimathi University of Technology
Kenya Certificate of Secondary Education -
Kakamega School
References
Dr Sebastian Egli
Chief Data Scientist (former) - agriBORA
sebastian.egli@geo.uni-marburg.de
Phone: +49 174 2465052
Mr Nicolas Caspari
CTO - agriBORA
nicolas.caspari@agribora.com
Phone: +49 176 40403163
Mr Moses Njue
CEO - OdukTech LTD
mosesnjue294@gmail.com
Phone: +254 799 182 130
Mr Kizito Odhiambo
CEO - agriBORA GmbH
kizito.odhiambo@agribora.com
+254 705 859 648
Mr Edwin Joel
Director - Nevira Minerals LTD
edwinmjoel@gmail.co
VOLUNTEER EXPERIENCE
- Geospatial Engineering Intern, Geo-Explicit Systems, 01/01/20, 06/01/20, Managing spatial databases and syncing with open source spatial databases based on PostGIS on PostgreSQL., Deploying web map services using Geo Server and Geo Node., Carrying out digital image analysis for land use and land cover using ERDAS Imagine and ENVI.
- Volunteer, HOTOSM Humanitarian Mapping, 03/01/19, 03/01/19, Digitization of ground features, editing attributes and mapping of remote areas affected by disasters in Northern Kenya.
- Organizer, GeoDev, Dedan Kimathi University of Technology, 01/01/18, 01/01/22, Organizing meet ups and events at the Geo Dev community in Dedan Kimathi University.
REFEREES
Dr Sebastian Egli
Chief Data Scientist (former) - agriBORA
sebastian.egli@geo.uni-marburg.de
Phone: +49 174 2465052
Mr Nicolas Caspari
CTO - agriBORA
nicolas.caspari@agribora.com
Phone: +49 176 40403163
Mr Moses Njue
CEO - OdukTech LTD
mosesnjue294@gmail.com
Phone: +254 799 182 130
Mr Kizito Odhiambo
CEO - agriBORA GmbH
kizito.odhiambo@agribora.com
+254 705 859 648
Mr Edwin Joel
Director - Nevira Minerals LTD
edwinmjoel@gmail.com
+254 722 789 417