Looking for a job

John Lotome

@johnlotome

Message

Data Engineer at KopoKopo building Kafka and Debezium pipelines for near-real-time fintech analytics.

Kenya

Message

At KopoKopo, I built Kafka and Debezium CDC pipelines that synchronise transactional data into ClickHouse for near-real-time analytics.

I also built a production fraud detection graph using Neo4j and ClickHouse to model customer-to-merchant relationships. I designed and maintained Airflow and Prefect pipelines for analytical and operational workloads.

At KopoKopo, I optimised ClickHouse tables and SQL queries to improve dashboard performance and reduce query latency. I managed PostgreSQL databases supporting fintech transactions and implemented monitoring with Prometheus and Grafana.

Previously, at Ajua, I worked on data pipelines and data warehousing across AWS and GCP, using Prefect, Airflow, and dbt. I also developed and maintained BigQuery and Looker dashboards serving over 15 clients.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

KopoKopo

Jun 2024 - Present (2 years 4 months)

Built Kafka and Debezium CDC pipelines to synchronise transactional data into ClickHouse for near real-time analytics. Designed and maintained production-grade Airflow and Prefect pipelines supporting analytical and operational workloads.

Kafka Debezium Clickhouse Airflow Prefect PostgreSQL Prometheus Grafana Neo4j SQL

Data Engineer

Ajua

Jan 2023 - May 2024 (1 year 4 months)

Built ETL data pipelines and maintained data pipelines in AWS and GCP. Orchestrated DAGs using Prefect and Airflow, and utilized dbt for ELT transformations.

AWS GCP Prefect Airflow DBT BigQuery Looker ETL Data Pipelines

Data Scientist

Prospect33 Global Data Lab

Oct 2022 - Feb 2023 (4 months)

Performed data analysis, modeling, and visualization using Python. Collaborated with a global team and utilized cloud technology for big data storage and predictive modeling on GCP.

Python GCP Data Analysis predictive modeling Big Data

Analytics & BI Associate

Ajua

Jul 2021 - Jan 2023 (1 year 6 months)

Performed data analytics and ad hoc reporting, and built dashboards for BI using Logi Analytics and Looker. Conducted quarterly market analysis and research into consumer spending habits.

Data Analysis BIツール Logi Analytics Looker Market Research

Education

Degrees, certifications, and relevant coursework

Strathmore University

Master of Science, Data Science and Analytics

2024 -

Pursuing an Msc. in Data Science and Analytics with a thesis on graph-based fraud detection in mobile financial systems using a heterogeneous GNN-RL model.