Data Analyst & Mixed-Methods Researcher

Otieno Churchil

***************@*****.*** • +254-********* • Nairobi, Kenya

https://www.linkedin.com/in/otieno-churchil-aa82b3197/ Summary

Data analyst and mixed-methods researcher with hands-on experience building Python/R pipelines, SQL-powered dashboards, and field surveys in low-connectivity settings. I deliver manager- and exec-facing insights (Power BI, Tableau, reproducible R/py reports) that drive operational and product decisions—examples include reducing refresh failures ~50% and cutting manual follow-ups ~30%. Skilled in cohort analysis, survey design (SurveyCTO/Kobo), and stakeholder-ready briefings; actively upskilling Looker/LookML to deliver production Looker dashboards and analytics for multi-market product teams.

Work Experience

Control Tower Analyst Sep 2025 - Present

African Global Logistics Nairobi, Kenya

Maintain SQL Power BI data-QC pipeline that surfaces route-level mismatch_rate, missing_keys_pct, duplicate_count and recent_failures; report emailed daily to Ops lead and Data Owner to enforce a 5-business-day remediation SLA.

Produced standardized handover pack (one-page exec summary, annotated screenshots, 10–15 min walkthrough) for dashboard owners; named owners and deadlines—implementation reduced dashboard refresh failures by ~50%. Built reusable cleaned SQL tables and prototyped a Streamlit app exposing route/date filters, KPI cards and Plotly drilldowns to enable programmatic exploration of on-time delivery and incident patterns. Wrote production SQL (complex joins and window functions) to generate the daily on-time-delivery feed that populates manager-facing KPI tiles and supports intraday decision-making. Documented reproducible checks (row-count reconciliation, random 1% sample checks, pivot subtotal verification) as part of publish QA to ensure dashboards remain trusted by non-technical stakeholders. Data Management Coordinator Sep 2023 - Sep 2024

UFANISI Rehab Nairobi, Kenya

Designed and piloted SurveyCTO questionnaires, managed server-side form versioning and trained enumerators on KoboCollect/SurveyCTO for field deployments in low-connectivity areas. Managed daily enumerator rosters, supervised field data collection and spot-checks, and recovered offline submissions by diagnosing device/form sync issues to preserve data completeness. Produced weekly cohort retention snapshots (SQL aggregates Power BI) and generated at-risk participant lists used by program managers for targeted follow-ups.

Led post-deployment reviews and maintained an evolving codebook to capture lessons and refine survey instruments and qualitative codes for program monitoring.

Implemented approval and audit tracing for sensitive HR/background-check fields, adding expiry alerts and an approvals log that reduced last-minute exclusions before deployments. Data Analyst Jan 2021 - May 2022

AMREC AFRICA Kisumu, Kenya

Produced a 3-panel field brief for an SMS pilot (weekly engagement, opt-outs, cost-per-message) using Stata and pandas; delivered within three business days and informed manager decision to scale the pilot. Exported reproducible CSVs and included a methods footnote so visuals could be reproduced from scripts, improving trust and repeatability for non-technical stakeholders. Projects

Customer Abandonment Automation Workflow

Phoenix Analytics Masterclass Project

Built an n8n workflow to detect and categorize abandonment events, trigger automated email reminders and Slack alerts, and documented triggers/failure modes in a README and 3-week handover note. Pilot adoption by operations reduced manual follow-ups by ~30% and centralized customer event visibility to speed response.

Outreach A/B test

Personal Project

Designed and ran an internal A/B test of two outreach email variants (n 40); tracked opens and replies and found Variant B increased reply rate by 30%, informing adoption of the preferred tone/CTA. Logistics Delays Dashboard

Personal Project

Published a 3-chart Tableau prototype (cleaned dataset, README) and iterated with dispatch managers to add route and timestamp filters; updated dashboard used to prioritise reroutes the following week. R reproducible analysis — Fleet QC

Personal Project

Converted an ETL deduplication logic into R scripts and produced an RMarkdown report with unit checks and rendered HTML to demonstrate reproducible fleet QC workflows. Delivery Data Cleaning Notebook

Personal Project

Performed large-export cleaning and deduplication in Python and SQL, exported aggregated CSV summaries used to create concise manager-facing snapshots.

Education

Data Science Jan 2025 - Present

ALX Nairobi, Kenya

Ongoing practical coursework and hands-on mini-projects in Python, pandas, reproducible reporting and dashboard prototyping.

Data Science Bootcamp Nov 2024 - Apr 2025

GoMyCode Nairobi, Kenya

Led a three-person project, wrote SQL joins and cleaning scripts, coordinated tasks and produced a reproducible demo with top peer feedback for documentation and reproducibility. Bachelor of Science in Statistics and Programming May 2024 Machakos University Machakos, Kenya

Graduated May 2024. Official transcript and certificate available on request. Certifications

CompTIA Data+ (planned)

CompTIA

BCS Business Analysis Foundation (planned)

BCS

Skills

Python • pandas • R • SQL • Looker (LookML) • Power BI • Tableau • SurveyCTO • KoboCollect • ODK • Cohort analysis • A/B testing • Plotly • Streamlit • Stata Languages

English • Swahili

Contact this candidate