Who Am I?
A Data and Analytics Engineer passionate about turning messy, complex datasets into meaningful insights. With a knack for building efficient data pipelines, I specialize in cleaning, organizing, and transforming raw data into something businesses can actually use. I’ve had the chance to work across industries, uncovering trends, solving problems, and helping teams make smarter decisions.
Collaboration and innovation are at the heart of what I do. Whether it’s mentoring team members, automating workflows, or designing dashboards that tell a story, I’m always focused on delivering impactful solutions. I believe in making data accessible and actionable, turning it into a true asset for any organization.
WORKFLOW
Ingest
Transform
Store
Visualize
I am happy to connect
Let's turn your data into decisions.
Hire me
My Skills
Scripting
Python and SQL for data manipulation, automation, and analysis.
ETL/ELT & Orchestration
Building and orchestrating ETL/ELT pipelines with dbt, Dagster, Airbyte, and PySpark, including custom API integrations.
Databases & Warehousing
Modeling and querying data across Snowflake, PostgreSQL, MySQL, MSSQL, and Oracle.
BI & Analytics
Delivering business-facing dashboards and reports with Power BI, Tableau, Looker, and Advanced Excel.
Data Modeling & Quality
Dimensional modeling, data quality testing, documentation, version control with Git, and Agile delivery.
Data Storytelling
Communicating insights through compelling, easy-to-understand narratives and visuals that help non-technical stakeholders make informed decisions.
Experience & Education
Remote, Kenya
- Designed and maintained end-to-end data pipelines ingesting data from APIs and SaaS platforms using Python and SQL.
- Collaborated with stakeholders to translate business requirements into scalable data solutions.
- Built analytics-ready datasets and business-focused data marts using dbt to support reporting and decision-making.
- Implemented data validation and transformation processes to improve data quality and consistency.
- Automated reporting workflows and enabled self-service analytics through intuitive Power BI dashboards and documented datasets.
Nairobi, Kenya
- Designed and optimized datasets within Kasi Data Hub, improving reliability and accessibility of analytics-ready data used across 21 African markets.
- Designed and optimized data pipelines, reducing processing time by 40% and improving reliability of analytics-ready datasets used across 21 African markets.
- Developed custom API integrations handling authentication, pagination, retry logic, and incremental ingestion patterns.
- Developed interactive Tableau and Power BI dashboards tracking consumer confidence and economic sentiment indices to guide strategic programs across sectors.
- Partnered with business and research teams to define data requirements and ensure consistent data quality.
- Documented key analytics processes to improve collaboration and team knowledge sharing.
Nairobi, Kenya
- Collected, cleaned, and analysed multi-country survey data with a verified 4.6/5 data quality rating.
- Streamlined field reporting processes and reduced the reporting turnaround time from 3 hours to under 10 minutes through workflow automation.
- Increased stakeholder engagement by 40% through interactive dashboards and visualization of key trends in social and economic indicators.
- Supported cross-functional teams to deliver insights that informed business strategies and public development projects.
Kenyatta University, Nairobi
Specialization in Applied Mathematics and Computer Science, covering:
- Analytical & Statistical Thinking
- Computer Systems & How Computers Work
- Data Science & Machine Learning
- Programming (OOP, Functional and Logic)
- Web Development
Recent Work
Football Tipster
Python ETL pipeline that fetches live football data, generates rule-based predictions, validates outcomes, and writes everything to a Supabase database. Runs automatically every day via GitHub Actions.
COVID-19 Diagnostic Model
Python-based predictive model that classifies likely COVID-19 cases from patient symptom and test data.
Customer Churn Analysis
Power BI dashboard analyzing customer churn drivers to help the business identify at-risk segments and act on retention.
Sales Database Design
Relational database designed in MySQL Workbench to model and organize sales data for reliable reporting.
Sales Team Performance
T-SQL analysis of the AdventureWorks 2019 database to surface sales team performance trends.
Clientele Exploration
Oracle SQL queries exploring client data to uncover patterns useful for account management.
SQLite3 Database Programming
Python scripts connecting to and manipulating a SQLite3 database, covering core CRUD operations.