Turning Complex Data Into Clear Decisions.

Hi, I’m Ian Mungai. I build reliable data pipelines, shape analytics-ready datasets and create business intelligence solutions that help teams move from information to action.

Dashboards turn it into a clear decision.

About

From Raw Data to Business Value.

I work across the data lifecycle: collecting and transforming source data, investigating patterns, defining meaningful metrics and delivering reports that make those insights useful.

My approach brings engineering discipline and analytical curiosity together. The goal is not simply to move data or build dashboards—it is to create trusted, understandable data products that support better decisions.

Expertise & toolkit

The Work and the Tools.

Three connected disciplines, from dependable pipelines to clear decisions. The tools sit alongside the work they support.

01

Data Engineering

Designing cloud data platforms and automated extract, transform and load (ETL) or extract, load and transform (ELT) workflows for downstream use.

  • ETL / ELT pipelines
  • Cloud data lakes
  • Workflow orchestration

Tools I use

  • Amazon Kinesis
  • Amazon S3
  • Apache Airflow
  • Apache Iceberg
  • Apache Spark
  • AWS Glue
  • dbt
  • Docker
  • GitHub Actions
  • Great Expectations
  • PostgreSQL
  • Soda
  • Terraform
See pipeline work

02

Data Analysis

Exploring complex datasets, validating assumptions, modeling relationships and translating findings into clear recommendations.

  • Exploratory analysis
  • Statistical modeling
  • Insight communication

Tools I use

  • Altair
  • Jupyter
  • Matplotlib
  • NumPy
  • pandas
  • PySpark
  • Python
  • scikit-learn
  • Seaborn
  • SQL
  • statsmodels
See analysis and findings

03

Business Intelligence

Building dashboards, reporting models and key performance indicator (KPI) frameworks that make performance visible and keep stakeholders aligned.

  • Interactive dashboards
  • KPI design
  • Automated reporting

Tools I use

  • Amazon Athena
  • Amazon CloudWatch
  • Data Analysis Expressions (DAX)
  • Grafana
  • Power BI
  • Power Query
  • Streamlit
  • Tableau
See reporting scope

Selected work

Portfolio Projects.

End-to-end projects that connect data infrastructure, analysis and decision support.

Writing

Articles.

Notes on how I build, test and run my projects.

Experience and education

Experience and Education.

A background across client services, technical delivery and data analysis, with graduate and undergraduate study in data analytics, data engineering and computer science.

Experience

Aug 2023 – Present

Client Services Supervisor

Client Services Associate (Aug 2023 – Jun 2024)

SPS North America

Seattle, Washington, USA

Oct 2020 – Dec 2022

Data Analyst

JamboBet

Nairobi, Kenya

Oct 2019 – Sep 2020

Technical Support Specialist

Caby Cabs Ltd

Nairobi, Kenya

Education

Master of Science Data Analytics - Data Engineering

Western Governors University · Capstone project

Salt Lake City, Utah, USA

Bachelor of Science in Informatics and Computer Science

Strathmore University · Capstone project

Nairobi, Kenya

Professional development

Certificates of Completion.

Completed professional certificate programs that support practical work across data engineering, data analysis and business intelligence.

SnowflakeProfessional Certificate

Snowflake Data Engineering Professional Certificate

Data engineering coursework focused on building modern Snowflake pipelines, including ingestion, SQL and Python transformations, orchestration, DevOps practices and observability.

  • Snowflake
  • Data Pipelines
  • SQL / Python
GoogleProfessional Certificate

Google Business Intelligence Professional Certificate

Business intelligence coursework focused on translating stakeholder needs into metrics, reporting workflows, dashboard plans and clear executive-ready insights.

  • BI Reporting
  • Dashboards
  • Stakeholder Needs
GoogleProfessional Certificate

Google Data Analytics Professional Certificate

Data analytics coursework focused on cleaning, analyzing, visualizing and presenting data so findings can support practical business decisions.

  • Data Analysis
  • Visualization
  • Business Insights

Get in touch

Let’s Build Something Useful With Data.

Have a data pipeline, analytics or business intelligence challenge? Tell me what you are working on.

Your name, email and message are sent through Formspree. I retain correspondence without a scheduled deletion date.

↑ ↓ to move · Enter to open · Esc to close