HI! I am John Muthoka

Business Intelligence | Data Analyst | Data Engineer

John

Who Am I ?

About Me

I am John Muthoka, a Senior Business Intelligence and Data Analyst with over 5 years of experience driving data-informed decision-making across technology, NGO, and enterprise environments. I specialize in transforming complex datasets into actionable insights that support product, operations, and strategic initiatives.

I have strong expertise in SQL, Power BI, Tableau, and Python, with hands-on experience in data modeling, automation, and building scalable dashboards used by leadership teams for performance monitoring and executive reporting. My work focuses on KPI design, operational analytics, and delivering insights that directly impact business outcomes.

On the data engineering side, I have worked with modern analytics stacks including Snowflake, DBT, AWS Redshift, Databricks, SSIS, and Azure Data Factory to build reliable ETL pipelines and automated reporting workflows. These solutions have helped reduce manual reporting effort, improve data quality, and enable real-time decision-making.

I have collaborated with cross-functional teams across operations, finance, product, and programs in fast-paced, distributed environments, including global clients such as Chick-fil-A, Brinks US, and CoinFlip. I am known for clear communication, strong stakeholder engagement, and the ability to translate technical analysis into practical business insights for both technical and non-technical audiences.

Through my work, I aim to bridge the gap between data and strategy by building analytics solutions that are not only technically sound, but also directly aligned with organizational goals and measurable impact.

Download My CV

My Professional Journey

Online CV
Senior Business Intelligence Analyst
Griffin Global Technologies – Atlanta, USA

April 2024 – Present

  • Designed and maintained Power BI & Tableau dashboards for leadership.
  • Delivered KPI insights leading to 10% operational cost reduction.
  • Automated reporting using SQL & Python, reducing manual work by 35%.
  • Integrated multi-source data (SQL Server, Salesforce, Azure).
  • Worked with clients: Chick-fil-A, Brinks US, CoinFlip.
Programme Analyst
Safaricom PLC – Nairobi, Kenya

Oct 2022 – Mar 2024

  • Built interactive Tableau dashboards for financial & operational KPIs.
  • Supported forecasting and planning using historical trends.
  • Led data governance and quality assurance initiatives.
  • Automated ETL pipelines using SSIS & Python.
Data Assistant
Science for Africa Foundation – Nairobi, Kenya

Feb 2022 – Sept 2022

  • Built dashboards tracking programme performance and grants.
  • Supported ERP rollout, including UAT and data preparation.
  • Performed data cleaning, validation, and reconciliation.
Data Analyst (Operations & ERP Support)
PwC Kenya – Nairobi, Kenya

Jul 2021 – Jan 2022

  • Supported ERP system setup for a pan-African research NGO.
  • Designed operational data models for grants, HR & finance.
  • Assisted in system testing and staff onboarding.
Data Assistant
African Academy of Sciences – Nairobi, Kenya

Sept 2020 – Jul 2021

  • Performed daily data validation for research datasets.
  • Prepared statistical reports for stakeholders.
  • Provided IT and data support to research teams.
ICT Officer
Hoffman Solutions Ltd – Nairobi, Kenya

May 2020 – Aug 2020

  • Developed web and mobile applications.
  • Conducted data mining and statistical analysis.
  • Provided end-user IT support.
Download Full CV (PDF)

My Data Projects

Portfolio
Power BI Dashboard

Power BI

Category: Business Intelligence

tableau

Tableau

Category: Business Intelligence

SQL Data Query

SQL

Category: Data Analytics

Data Analysis Project

Extract, Transform & Load (ETL)

Category: Data Analytics

Agile Project Management

Agile Methodology

Category: Project Management

Monitoring and Evaluation

Monitoring and Evaluation

Category: Project Management

Detailed Insights

Projects
Online Sales Analysis

Online Sales Analysis Dashboard

Source: Kaggle

This Power BI report provides an interactive analysis of online sales transactions from a popular marketplace dataset. It is designed to help stakeholders understand sales trends, product performance, and regional differences in a visual and intuitive manner. Key Insights Include:

  • Analyze sales trends over time to identify seasonal patterns or growth opportunities.
  • Explore the popularity of different product categories across regions.
  • Investigate the impact of payment methods on sales volume or revenue.
  • Identify top-selling products within each category to optimize inventory and marketing strategies.
  • Evaluate the performance of specific products or categories in different regions to tailor marketing campaigns accordingly.

Adventure Work Report

Adventure Works Power BI Dashboards

Source: Microsoft Data samples

This repository contains Power BI dashboards for Adventure Works, a fictional company used for educational purposes in demonstrating business intelligence and data analysis concepts. The dashboards provide comprehensive insights into sales performance, product analysis, and regional sales data from July 1, 2017, to June 30, 2021.

  • Sales performance metrics including the number of customers, sales orders, revenue, production cost, sales profit, and profit percentage.
  • Product performance, including the number of products, order quantities, and category-wise analysis.
  • Understanding which products are top sellers, seasonal variations, and regional sales patterns.
KensaTel PLC Report

KensaTel PLC Power BI Dashboards

Source: ChatGPT & Python Faker Package

This report provides valuable insights into the operations of KensaTel PLC, a fictional telecommunication company operating in Kenya. Our Power BI dashboards aim to empower decision-makers with data-driven insights for strategic planning and operational efficiency.

  • Customer Growth: Track monthly and yearly customer growth rates to identify trends and assess the impact of marketing campaigns and promotions.
  • Churn Analysis: Identify customers at risk of leaving by analyzing call patterns, service usage, and billing history to develop retention strategies.
  • Call Volume Analysis: Visualize daily, weekly, and monthly call volumes to assess peak times and optimize staffing levels.
  • Call Resolution Time: Analyze average call resolution times and identify patterns to improve customer service efficiency.
  • Service Utilization: Analyze service usage patterns to understand customer preferences and optimize service offerings.

HR Tableau dashboard

HR Tableau Dashboards

Source: Chat GPT Generated

HR Department wanted a comprehensive dashboard to analyze human resources data, providing both summary views for high-level insights and detailed employee records for in-depth analysis. The summary is divided into three main sections: Overview, Demographics, and Income Analysis.

  • Overview: Display the total number of hired employees, active employees, and terminated employees.Visualize the total number of hired and terminated employees over the years.Present a breakdown of total employees by department and job titles.Compare total employees between headquarters (HQ) and branches (New York is the HQ)Show the distribution of employees by city and state.s.
  • Demographics: Present the gender ratio in the company.Visualize the distribution of employees across age groups and education levels.Show the total number of employees within each age group.Show the total number of employees within each education level.Present the correlation between employees’s educational backgrounds and their performance ratings.
  • Income: Compare salaries across different education levels for both genders to identify any discrepancies or patterns.Present how the age correlate with the salary for employees in each department.

Contact Details

Get in touch with me for any queries or collaborations.