Available for opportunities · Nairobi, Kenya

Lerroy Gatimu

Data Engineer & Full-Stack Developer

I build the infrastructure that makes data useful — pipelines, APIs,
cloud systems, and the interfaces that bring them all together.

Python Go Rust TypeScript AWS Data Warehouses Lakehouses ETL/ELT Django

Building systems that hold up

I work at the intersection of data infrastructure, backend engineering, and cloud architecture — designing systems that collect, process, and deliver data efficiently from pipeline to product.

Working primarily in Rust, Go, and Python, I design ETL/ELT pipelines, backend APIs, and processing systems built for performance and long-term maintainability. I'm especially drawn to data engineering workflows that support analytics and data-driven decision making.

Beyond data engineering, I build full-stack applications and cloud systems (AWS) that span the entire layer — from schema design and backend logic to clean, functional interfaces. I hold a strong interest in distributed systems, cloud-based architectures, and performance-focused programming, and I'm always exploring better ways to build software that actually holds up in production.

200+ Learners Mentored AWS Cloud Computing @ ALX Africa
2 AWS Certifications CCP & SAA-C03
5+ Production-Grade Projects Production-grade systems
ALX Africa Software Engineering ·Cloud computing · Data Analytics · 2025 – 2026
AWS Solutions Architect Associate
View Credential
AWS Certified Cloud Practitioner
View Credential

Technical toolkit

Core Strengths

Data Engineering AWS Cloud Services Full-Stack Development

Languages

PythonRustGo TypeScriptSQLBash

Frameworks & APIs

DjangoAxumFastAPI REST APIsGraphQL

Data Engineering & Analytics

ETL/ELTApache SparkPySparkdbtPolars PandasNumPyPower BI Data CleaningVisualization

Cloud · AWS

EC2S3Lambda RDSCloudFormationRoute 53 IAMCloudWatchCloudFront

Tools & DevOps

DockerGit/GitHub CI/CDAgile/ScrumJupyter

Featured work

GoLang Data Warehouse
Data Engineering ·Go

GoLang Data Warehouse

Designed and built an end-to-end ETL pipeline in Go that extracts real-time hourly weather data from a public REST API for 5 global cities, transforms raw JSON into structured records, and loads data into a three-layer PostgreSQL warehouse (Raw → Staging → Warehouse) following the medallion architecture. Automated daily execution and monitoring using an Apache Airflow DAG with database health checks and row-count verification. Implemented idempotent upserts to ensure safe pipeline re-runs, transactional batch inserts for data integrity, and connection pooling for database performance. Containerised the full infrastructure stack using Docker Compose.

GoPostgreSQLPythonApache AirflowDocker
Multi-Tenant SaaS Backend with FastAPI
Backend Development

Multi-Tenant SaaS Backend with FastAPI

Core features implemented: JWT authentication with access + refresh tokens Organization/workspace management (multi-tenancy). Role-Based Access Control (Owner → Admin → Member → Viewer). API rate limiting via Redis. Full audit logging (who did what, when, from where). Subscription plans (Free / Starter / Pro / Enterprise) with usage limits. Key engineering decisions: Strict tenant data isolation — every query scoped by organization ID Layered dependency-injection architecture for auth & permission checks. Async-first design throughout (database, Redis, API) Automated test suite covering auth flows.

PythonPostgreSQLFastAPIJWTDockerRedisAlembic
Python Data Warehouse
Data Engineering

Python Data Warehouse

Production-grade ETL pipeline that ingests hourly weather data from a live REST API, transforms it into a dimensional data model, and loads it into a MySQL data warehouse. Demonstrates idempotent loading, connection pooling, and structured logging.

PythonMySQLETLPandasSQLAlchemy
Rust Data Pipeline
Data Engineering · Rust

Rust Data Pipeline

Clean, performant, production-ready ETL pipeline written in Rust. Extracts data from JSON, applies lightweight transformations, and loads into MySQL with idempotent upsert behavior using sqlx and Tokio.

RustsqlxMySQLtokioserde
Python Data Pipeline
Data Engineering

Python Data Pipeline

Modular and containerized ETL pipeline built to ingest, transform, and reliably store sales transaction data. Uses Docker for portability with a clean separation of extraction, transformation, and loading layers.

PythonPandasSQLAlchemyDockerMySQL

Professional work

July 2026 – Present Chipuka Academy

Software Engineer

  • Built a full-stack Django 6 backend running an entire youth football academy end-to-end — public marketing site, parent/player onboarding, fee billing, attendance tracking, player development records, and staff operations tooling — backed by PostgreSQL, across 11 Django apps, with Cloudflare R2 object storage in production.
  • Designed role-based access control (Super Admin, Academy Director, Coach, Parent) enforced centrally via reusable permission helpers and an HMAC-signed barcode check-in system.
  • Automated fee collection via Pesapal (card/M-Pesa) with IPN webhook handling plus a manual M-Pesa verification flow, driven by Celery + Redis background jobs (7 scheduled tasks) covering monthly invoicing, overdue flagging, and payment reminders. ● Built a Django REST Framework + JWT API layer with an auto-generated OpenAPI schema, plus WeasyPrint-rendered PDF report generation and a shared branded HTML/email template system.
DjangoPostgreSQLCeleryRedisCloudflare R2Nginx

Oct 2025 – Apr 2026 ALX Africa

AWS Lead Volunteer Mentor

  • Mentored 200+ learners in the AWS Cloud Computing programme across CCP and SAA-C03 tracks, achieving a 60% pass rate — 120 learners earned CCP certification and 70 earned SAA-C03.
  • Delivered technical guidance on AWS architecture design, cloud deployments, and infrastructure best practices through 1:1 and group sessions.
  • Facilitated peer-learning sessions and technical discussions that reduced time-to-certification by an estimated 2 weeks per cohort.
  • Monitored individual learner progress, identifying at-risk students early and providing targeted support on cloud labs and real-world deployment tasks.
  • Participated in weekly mentor meetings to refine curriculum delivery and improve student outcomes across successive cohorts.
AWSCloud ArchitectureMentorshipCommunity
Cloud Architecture Full-Stack Development Blockchain Technology Cybersecurity AI & Automation Distributed Systems

Let's build something

Open to data engineering roles, full-stack opportunities, cloud architecture projects, and mentoring initiatives. Based in Nairobi — open to remote work globally.