Data Analyst

David

1000/mo
NAIROBI, Kenya
Looking for Full-time
8 hours/day
Availability: EU timezone

Profile Description

Detail-oriented Data Analyst with 2 years of experience in SQL database design, data cleaning, validation, and visualization. Skilled in PostgreSQL, Excel, Tableau, and Looker Studio, with a strong ability to turn raw datasets into actionable insights. Trained in Industrial Mathematics with a focus on statistical analysis, probability, optimization, and mathematical modeling bringing a strong analytical and problem-solving foundation to every project. Adept at performing EDA, building dashboards...

Top Skills

Excel (Advanced) · 2 yearsSQL · 2 yearsData Visualization · <1 yearLooker · <1 yearStatistical Analysis · <1 year

Skills & Expertise

Data & Analytics

SQLIntermediate
LookerBeginner
Data VisualizationBeginner
Statistical AnalysisBeginner
Excel (Advanced)Intermediate

Work Experience

data visualization early internship

Excelerate

Sep 2025 - Oct 2025

Key Achievements:

Designed, built, and maintained a PostgreSQL master database integrating Applicant, Campaign, and Outreach datasets. Conducted data validation using SQL scripts to detect inconsistencies, null values, and duplicates across multiple tables. Performed exploratory data analysis (EDA) to identify key performance trends and support business decisions. Developed Looker Studio dashboards visualizing connectivity rate, agent performance, and regional campaign success metrics. Created automated validation reports and performance summaries for management review. Collaborated with remote teams to define KPIs and ensure alignment between analytical outputs and stakeholder goals. Produced actionable insights and delivered professional presentations summarizing trends, recommendations, and outcomes.

SQLExcel (Advanced)LookerData Visualization

Data analyst

Nairobi City County

Jan 2024 - Jul 2025

Key Achievements:

Analyzed bursary application datasets to identify eligibility trends, funding gaps, and demographic distribution. Built Excel-based dashboards to track bursary allocations, departmental KPIs, and community outreach performance. Cleaned, merged, and validated large applicant datasets using Power Query and SQL to ensure data consistency. Conducted statistical analysis on education and youth empowerment data to inform policy recommendations. Developed summary reports and data visualizations to support decision-making by senior management. Automated parts of the data entry and validation workflow, reducing manual review time by 30%. Collaborated with IT and administrative teams to establish standardized reporting templates and validation rules. Trained staff on basic data entry standards, quality control practices, and spreadsheet analysis.

SQLStatistical AnalysisExcel (Advanced)Data Visualization

Quick Stats

Age25 years
English LevelFluent
ID VerificationNot verified
Portfolio
🔒