Available for opportunities

Data Analyst
& BI Engineer

Building end-to-end analytics solutions with SQL, dbt, Databricks, Snowflake and Azure. Turning complex datasets into dashboards that drive decisions.

View GitHub See My Work →
John Muthoka
5+
Years exp.
10+
Projects
3
Cloud Platforms
KE
Nairobi
01

About Me

I'm a Senior Business Intelligence and Data professional with over 5 years of experience delivering analytics, reporting and data engineering solutions across technology, NGO and enterprise environments.

I transform complex datasets into reliable, well-tested analytics tables and dashboards used by leadership to make timely decisions. My work emphasises clear stakeholder communication, reproducible data workflows, and measurable business impact.

I design and maintain interactive dashboards that surface key KPIs, operational metrics and customer insights — building pipelines that prioritise data quality, observability and automation.

SQL — T-SQL, Snowflake SQL for data modelling & analytics
dbt — Modular transformations, testing, documentation
Databricks — PySpark for scalable data processing
Azure — Data Factory, Blob, cloud orchestration
Power BI / Tableau — Executive dashboards & KPI storytelling
02

Skills & Tools

SQL (T-SQL, Snowflake SQL)
dbt
Databricks
PySpark
Power BI
Tableau
Azure Data Factory
Snowflake
ETL / ELT
Python
Data Modelling
Star Schema
DAX
Git
AWS Redshift
04

Featured Projects

Tech Workforce Project
Featured
Tech Workforce Project
End-to-end analytics for workforce metrics — hiring funnels, attrition analysis, and staffing KPIs. Built Python ML models to predict employee attrition and headcount needs, layered with dbt transformations and Power BI dashboards that give HR leadership actionable, real-time insight.
Python ML Prediction SQL dbt Power BI
View Repository →
dbt Project
dbt Project
Transformations and testing using dbt to deliver analytics-ready models. Modular design with enforced data quality and complete documentation.
dbt SQL
View Repo →
Databricks Pipeline
Databricks Pipeline
Scalable ETL/ELT pipelines on Databricks using PySpark transformations and automated jobs for ingesting and preparing data for analytics.
Databricks PySpark
View Repo →
Azure Pipeline
Azure Data Pipeline
Cloud pipelines built on Azure using Data Factory, Blob storage and scheduling. End-to-end ingestion and orchestration workflows.
Azure ADF Cloud
View Repo →
Data Warehouse
SQL Data Warehouse
Star-schema data warehouse implementation supporting business reporting and analytical queries with ETL processes and full documentation.
SQL Star Schema ETL
View Repo →
Tableau Dashboards
Tableau Dashboards
Interactive HR and operational dashboards in Tableau — demographics, hiring trends, and income analysis for decision support.
Tableau HR Analytics
View Repo →
Power BI
Power BI Dashboards
Interactive Power BI reports and executive dashboards — KPI design, storytelling and performance monitoring for online sales analysis.
Power BI DAX Data Modeling
View Repo →
See all projects on GitHub
04

Work Experience

Apr 2024 — Present
Senior Business Intelligence Analyst
Griffin Global Technologies · Remote, Atlanta, GA
  • Built end-to-end dbt + Gitlab pipelines as a single source of truth for sales & client reporting, integrating Salesforce, crypto transaction systems, and Excel sources.
  • Designed Power BI and Tableau dashboards enabling self-service analytics for Relationship Managers and Customer Success teams.
  • Automated OKR tracking and executive reporting; collaborated with global teams.
  • Analyzed client revenue, product adoption, and transaction data to surface growth and retention opportunities.
dbtSnowflakePower BITableauPython
Oct 2022 — Mar 2024
Programme Analyst
Safaricom PLC · Nairobi, Kenya
  • Developed interactive Power BI and Qliksense dashboards for real-time tracking of operational and financial KPIs.
  • Performed Analysis using Excel to streamlining operational reporting.
  • Led data governance and quality assurance initiatives, improving reporting reliability across departments.
TableauPower BIPythonExcelETL
Feb 2022 — Sep 2022
Data Assistant
Science for Africa Foundation · Nairobi, Kenya
  • Built and maintained dashboards tracking programme performance, grants, and operational efficiency.
  • Supported ERP system rollout including data preparation and UAT for procurement and grant management.
DashboardsERPData Quality
Jul 2021 — Jan 2022
Data Analyst — Operations & ERP Support
PwC Kenya · Nairobi, Kenya
  • Supported the operational setup of a pan-African research NGO through data modeling, ERP configuration, and reporting frameworks.
  • Designed operational data standards for grants, finance, and HR; assisted in system testing, rollout, and staff onboarding.
Data ModelingERPSQL
Sep 2020 — Jul 2021
Data Assistant
CTC, The African Academy of Sciences · Nairobi, Kenya
  • Conducted daily data validation and developed structured workflows for efficient data processing and analysis.
  • Prepared statistical reports for internal and external stakeholders.
Data ValidationReportingResearch
05

Get In Touch

Let's build something
great together.

Open to full-time roles, consulting, and freelance data projects. Whether you need a BI engineer, a data pipeline built, or insight into your data — let's talk.

⬡
GitHub
github.com/nguni
in
LinkedIn
john-muthoka-theanalyst
Location
Nairobi, Kenya
Phone
+254 704 895 391
Email
[email protected]
Experience
5+ years in Data & BI
Resume
Download PDF →