John Mwangi
Data Analyst | Data Science | Business Intelligence
Hire this person
Send a job offer directly to this candidate
About
Data Analyst with hands-on experience using SQL, Python, Excel, Power BI, Pandas, and MySQL to clean, transform, validate, analyze, and visualize data. Experienced in working with large and multi-source datasets, developing complex SQL queries, identifying trends and anomalies, performing data quality checks, building dashboards, and automating data-processing workflows. Strong ability to break down complex analytical problems, investigate root causes, develop repeatable processes, and translate analytical results into actionable insights.
Experienced in predictive analytics, business intelligence, data visualization, reporting, and machine learning.
Experience
Data Analytics & Business Intelligence Projects (2021-01 – Present)
- Analyze structured and multi-source datasets using SQL, Python, Pandas, Excel, and Power BI to identify trends, patterns, anomalies, and actionable business insights.
- Develop SQL queries using joins, aggregations, subqueries, filtering, conditional logic, and window functions to extract and analyze data for reporting and decision support.
- Clean, transform, validate, and reconcile datasets to identify missing values, inconsistencies, duplicate records, and data-quality issues.
- Build interactive Power BI dashboards and Excel reports incorporating KPIs, charts, graphs, trends, and analytical summaries for business reporting.
- Develop automated data-processing and ETL workflows that reduce repetitive manual data preparation and improve consistency of analytical outputs.
- Investigate anomalies and unexpected results by breaking complex analytical problems into logical steps and tracing issues to their underlying data or processing causes.
- Perform exploratory and statistical analysis to identify relationships, trends, outliers, and opportunities within large datasets.
- Translate analytical requirements into data queries, transformation logic, reports, dashboards, and documented analytical workflows.
- Develop predictive analytics solutions involving customer segmentation, churn prediction, and sales forecasting.
- Document analytical processes, assumptions, transformation logic, results, and recommendations to support repeatability and effective communication.
Education
Bachelor of Science in Electrical and Electronics Engineering – Dedan Kimathi University of Technology (2021-01 – 2026-12)
