Eston Kamau

Designed and own a BigQuery data warehouse modeled in dbt, delivering analytics-ready datasets for BI dashboards used by ~390 administrators across ~300 health facilities. Built ELT pipelines with dlt and Airflow, automated data-quality tests, and implemented CI/CD with GitHub Actions.

Designed the PostgreSQL (Supabase) data model for an ERP used by manufacturers and distributors, including multi-location stock, credit sales, and accounts. Built the reporting layer with P&L, balance sheet, and a natural-language assistant.

Built multi-page Power BI dashboards refreshing eight times a day, plus monthly revenue, expense, and profit-margin reporting. Digitised manual operations with AppSheet data-entry tools and built time-series sales forecasts.

Wrote Python scrapers and cleaning scripts for a global startup ecosystem database; verified and enriched company records.

Cleaned and analysed healthcare data; built internal dashboards and analytical reports in R.

Completed a Nanodegree in Data Science, focusing on data analysis, machine learning, and data-driven decision making.

Pursued a Bachelor of Science in Economics and Statistics, gaining a strong foundation in economic theory and statistical methods.