Home
/
Experts
/
Carson Ongei

Carson Ongei

Data Analyst

Highest degree :

Bachelors

Field of study :

Statistics

Location :

Nairobi

Citizenships :

Kenyan

Experience :

2 Year(s)

Countries :

Kenya, Uganda

Gender :

Male

Sectors :

Banking operations, finance

Digital ICT Expert | Data Scientist (AI/ML) | Digital Healthcare Technologist | Cloud & Data Center Specialist

Data analyst who transforms complex business challenges into actionable insights through strategic problem- solving and compelling data narratives. Track record of reducing operational costs by 70%, improving profit margins by 35%, and accelerating decision-making by 50% through innovative data solutions and automation frameworks.

Experience

Data Analyst

Nairobi

Numida YC

May 2025

-

Present

At Numida, I tackled the challenge of fragmented data sources and slow manual reporting processes that were delaying critical business decisions by weeks. I built a self-serve analytics infrastructure using n8n, Metabase, and Lightdash that empowered over 50 team members to generate their own reports, slashing turnaround time from 5 days to just 2 hours. By designing automated ELT workflows with dbt and Redash, I unified 15+ disparate data sources into a single analytics layer processing 2M+ daily transactions with 99.9% accuracy. Working closely with the AI/ML team, I helped deploy Taktile-powered credit risk models that improved loan approval accuracy by 28% while reducing default rates by 15%. I also integrated Pnngme data with custom Lua scripts to create a real-time decision engine that shortened underwriting from 48 hours to just 4 hours. The cumulative impact saved 200+ analyst hours monthly, enabled KES 159M in additional loan disbursements, and reduced data infrastructure costs by 35%.

Data Analyst

Nairobi

Dataseal Software Limited

October 2024

-

February 2025

My mission at Dataseal was solving a critical performance crisis where an enterprise client's business reports took 6 hours to execute, threatening SLA compliance and causing significant revenue loss from delayed insights. I diagnosed the bottlenecks using diagnostic utilities and completely rebuilt the data warehouse with an optimized Star Schema, implementing materialized views and strategic partitioning that reduced query time from 6 hours to just 8 minutes—a 98% improvement. I designed scalable multi-dimensional data models using Erwin and Power Designer that could handle a 10x increase in data volume without performance degradation. My automated ETL framework eliminated 15 hours of weekly manual processing while improving data quality scores from 73% to 97%. By conducting JAD sessions with stakeholders and leveraging Cursor AI-assisted development, I accelerated solution delivery by 45% through intelligent code generation. This work recovered KES 800K in annual revenue, enabled real-time decision-making for 200+ users, and cut infrastructure costs by 40%.

Data Analyst

Nairobi

Afripixel Solutions

December 2023

-

October 2024

At Afripixel, I confronted a market competitiveness problem where the company was losing share due to uncompetitive pricing across 2,800+ products, with manual pricing processes taking 3 weeks per brand and eroding profit margins by 22%. I developed a Python-based A/B testing framework with statistical rigor that automatically analyzed market positioning for major brands like Simba Merchants, TP-Link, and Logitech, improving profit margins by 35% and market competitiveness by 40%. I created interactive Power BI dashboards with real-time market intelligence that reduced pricing decision cycles from 21 days to just 3 days—an 85% acceleration. By leveraging Google Analytics and Power Automate, I built a self-updating competitive analysis system that eliminated 70+ hours of monthly manual data collection. My version-controlled reporting system with automated validation checks reduced discrepancies by 20% and increased stakeholder trust by 60%. The total impact recovered KES 350K in annual profit margin, accelerated time-to-market by 85%, and improved decision accuracy by 50%.

Education

Statistics and Programming

Nairobi

KENYATTA UNIVERSITY

September 2019

-

December 2024

Specialized Coursework: Database Systems • Multivariate Statistics • Statistical Programming • Data Science & Analytics • Research Methodology • Survey Design & Analysis

Highschool

Mbita

Mbita High School

February 2015

-

December 2018

Languages
English
Speak
Excellent
Read
Native
Write
Excellent
Skills

Data Analysis

Data Analysis (Excel, Google Sheets)

Data Analysis

SQL

Power Automate

Powerbi

dbt

n8n

metabase

lightdash

redash

Python

Python

Research

Experience with financing agencies

1 year