Martin Kilombe

Data Engineer · Data Analyst

Data Engineer and Analyst who builds the whole path from source to decision: Python and SQL pipelines, PostgreSQL and BigQuery warehouses, and the dashboards and analysis that run on them. An actuarial statistician before an engineer, which means the platform is built by someone who knows what the numbers are for and can stand behind them when the business pushes back.

Experience

Cloud Intelligence

Jun 2023 - Present

South Africa (Remote)

Data Engineer

  • Built and deployed ETL pipelines in Python and SQL that ingest 10M+ financial and operational records monthly, cutting manual data preparation by 60%.
  • Designed and maintained PostgreSQL and Google Cloud SQL warehouse models serving real-time analytics to 5 business units, reducing reporting delays by 40%.
  • Containerised pipeline orchestration with Docker, standardising deployment across environments and holding 99.5% pipeline uptime.
  • Built monitoring and alerting for production pipelines so failures surface automatically, cutting incident resolution time by 30%.

Lead Data Analyst

  • Partnered with business stakeholders to deliver dashboards and analysis that improved decision-making effectiveness by 40%.
  • Designed a real-time data quality framework monitoring 100+ metrics, giving the organisation continuous visibility of data health.
  • Optimised SQL and PostgreSQL query performance, reducing execution times by 30% across production reporting.
  • Documented reporting processes and data governance standards, aligning analytics output with compliance requirements.
  • Deployed local large language models (Google MedGemma) to automate report summarisation, keeping sensitive data inside the environment.
Crunch Garage

Jan 2022 - May 2023

Nairobi, Kenya

Data Analyst

  • Automated recurring reporting in Python and SQL, cutting turnaround by 50% and putting results directly in the hands of operational teams.
  • Introduced data quality monitoring that reduced data errors by 20% and raised confidence in reported figures.
  • Defined KPIs and built dashboards with marketing and operations teams, improving campaign targeting efficiency.
  • Trained non-technical staff in data interpretation, raising data literacy and dashboard adoption across the business.
Trident Insurance Ltd

May 2021 - Dec 2021

Nairobi, Kenya

Business Intelligence Analyst

  • Delivered market research and competitive analysis reports that informed strategic planning and product development.
  • Identified market trends and customer preferences from internal and external data, shaping growth and positioning decisions.
  • Developed data models, OLAP cubes and metadata documentation that enabled efficient ad hoc analysis.

Skills

Data Engineering & Pipelines

ETL development, Data modelling, Data warehousing (PostgreSQL, Cloud SQL, BigQuery), Orchestration (Apache Airflow, dbt, Docker), Streaming (Kafka, Spark Streaming), CI/CD (Git, GitHub)

Data Analysis & Visualization

SQL, Python (pandas, NumPy), Power BI, Tableau, Metabase, Excel

Cloud Platforms

Google Cloud Platform (BigQuery, Cloud SQL, Cloud Storage), Cloudflare (Pages, Pages Functions, Turnstile)

Programming & Automation

Python, SQL, JavaScript (Node.js), Bash, Docker, SQLAlchemy, REST API integration

Data Governance & Quality

Data validation, Profiling, Quality monitoring, Metadata documentation

Business Intelligence

Dashboard development, KPI definition, Stakeholder reporting, Data literacy training

AI & Emerging Tech

AI-assisted development (Claude Code, daily), AI data preparation, Local LLM deployment (Google MedGemma), Ethical AI practices

Statistics & Research

Statistical modelling, Time-series analysis, Actuarial methods, Peer-reviewed research

Education

BSc Actuarial Science and Statistics

Jomo Kenyatta University of Agriculture and Technology · Nairobi, Kenya

Second Class Honours, Upper Division

Certifications

  • Google Data Analytics Professional Certificate
  • Microsoft Power BI Data Analyst (PL-300)

Selected Projects

martinkilombe.dev

Full-Stack Web

Personal site built and shipped solo in JavaScript on Cloudflare Pages: a Node build that generates every resume variant from one JSON record, and serverless Functions handling the contact endpoint against the Gmail REST API with service-account JWT auth and Turnstile verification. Built and maintained with Claude Code.

Financial Data Engineering Pipeline

Data Engineering

Dual-source OHLC and real-time market data pipeline built with Python, Google Cloud Platform, PostgreSQL and SQLAlchemy.

Netflix and UK Job Market Case Study

Data Analysis

Interactive dashboards exploring Netflix viewership and UK labour-market patterns, published to Tableau Public.