Data Analyst | Business Intelligence | Monitoring & Evaluation (MEL) | Data Engineering (Automation & ETL)
Nairobi, Kenya

GitHub: https://github.com/rajab-bett-analytics
LinkedIn: https://www.linkedin.com/in/rajab-bett
Email: rajab.bett.data@gmail.com

Data Analyst and Statistics graduate specializing in data-driven decision systems, Monitoring & Evaluation (MEL), Business Intelligence, and data pipeline automation.

I design and implement end-to-end data systems that transform raw operational data into structured intelligence for decision-making. My work combines SQL, Python, BI tools, and workflow automation (n8n/Make) to build scalable reporting systems, KPI frameworks, and analytics pipelines.

I have practical experience building systems for:

• Humanitarian data pipelines (KoboToolbox → PostgreSQL → dashboards → alerts)
• MEL impact evaluation frameworks (treatment vs control analysis)
• Financial fraud detection systems using SQL at scale
• Business intelligence dashboards for retail analytics

My focus is on building reliable, automated, and decision-ready data systems for NGOs, financial institutions, and development programs.

• Logframe and Theory of Change (ToC) design
• Indicator development and KPI frameworks
• Impact evaluation (quasi-experimental analysis)
• Outcome tracking and longitudinal analysis
• Program performance measurement systems

• End-to-end ETL pipeline design
• API-based data ingestion (KoboToolbox integration)
• Workflow automation using n8n and Make
• Data transformation and orchestration
• PostgreSQL-based data architecture

• Power BI dashboard development (DAX, KPIs, reporting models)
• Executive reporting systems
• Customer and operational analytics
• RFM segmentation and behavioral analysis
• Data storytelling for decision-making

• Predictive and descriptive analytics
• Regression, classification, clustering
• Anomaly detection and risk analysis
• Statistical modeling and experimental evaluation
• Feature engineering and data validation

• Python (Pandas, NumPy, Scikit-learn)
• SQL (PostgreSQL, query optimization, analytics)
• Statistical modeling and simulation

• PostgreSQL (data modeling, schema design)
• ETL pipelines and data transformation workflows
• API data ingestion (REST-based systems)
• Data validation and quality frameworks

• n8n (workflow orchestration, ETL automation)
• Make (integration workflows)
• Web scraping and automated data collection systems

• Power BI (dashboards, KPIs, DAX)
• Streamlit (interactive analytics apps)
• Matplotlib, Seaborn
• Excel (advanced reporting & pivot systems)

• Git, GitHub

Tech: Python | PostgreSQL | n8n | API Integration | WhatsApp Alerts

• Built an end-to-end humanitarian data pipeline converting KoboToolbox submissions into structured intelligence
• Designed automated ETL workflows using n8n hosted on cloud infrastructure
• Implemented vulnerability scoring engine for food security classification
• Developed real-time alert system for high-risk households (WhatsApp/SMS)
• Created PostgreSQL data warehouse for analytics and reporting

Impact: Reduced reporting latency from days to near real-time decision support.

Tech: SQL | PostgreSQL | Statistical Analysis | Experimental Design

• Designed MEL framework with KPIs and logframe structure for 50,000+ beneficiaries
• Implemented treatment vs control group evaluation model
• Analyzed employment outcomes across training interventions
• Identified program effectiveness differences across skill tracks
• Produced policy-ready insights for program optimization

Impact: Enabled evidence-based assessment of program effectiveness.

Tech: SQL | PostgreSQL | Audit Analytics | Data Engineering

• Analyzed 6M+ financial transactions using optimized SQL workflows
• Identified fraud patterns and high-risk transaction behaviors
• Built index-optimized queries for large-scale performance analysis
• Designed audit-style reporting system for risk detection

Impact: Improved detection of systemic fraud patterns and anomalies.

Tech: Power BI | DAX | Data Modeling

• Built interactive BI dashboard for sales and customer analytics
• Designed KPIs for revenue, customer behavior, and product performance
• Implemented segmentation analysis using RFM methodology
• Delivered executive-level reporting system

Nov 2022 – Present

• Built automated data pipelines and reporting systems using Python and SQL
• Developed BI dashboards and KPI tracking frameworks for decision-making
• Designed ETL workflows and integrated multi-source datasets
• Implemented data quality checks and validation systems
• Delivered analytics solutions for business and program evaluation use cases

Key Achievements:

• Built multi-region data collection pipelines across 10+ markets
• Developed automated reporting systems reducing manual workload significantly
• Analyzed large-scale financial and behavioral datasets for trend insights
• Designed scalable data workflows for analytics automation

May 2022 – Aug 2022

• Supported production and sales data analysis
• Built reports and dashboards for operational monitoring
• Performed data cleaning and validation for reporting systems
• Assisted in KPI tracking and performance reporting

Bachelor of Science in Statistics
Taita Taveta University | 2018 – 2023

• Strong focus on data integrity and governance
• Experience working with structured and unstructured datasets
• Passion for MEL systems, automation, and impact-driven analytics
• Languages: English, Kiswahili

• Data Analyst / Business Intelligence Analyst
• Monitoring & Evaluation (MEL) Officer
• Data Engineer (Junior / Associate level)
• NGO Data & Impact Analyst
• Financial / Risk Data Analyst
• Automation & Reporting Systems Developer