Mulama Remigius

Senior Data Engineer and Data Analyst with 4+ years of experience architecting cloud-based data pipelines, automated reporting systems, and analytics infrastructure on AWS including fintech and mobile-money transaction data that supports financial decision-making for underserved and low-income customer segments. Proven track record leading end-to-end data engineering delivery, from ingestion and ETL pipeline design through warehousing, automation, and stakeholder-facing reporting, across healthcare, fintech, e-commerce, education, and IoT domains. Deep expertise in Python (pandas, NumPy, Scikit-learn), advanced SQL (PostgreSQL, MySQL, MongoDB), and cloud data infrastructure (AWS S3, RDS, Lambda, Glue, Docker).

Regularly presents pipeline architecture and data-quality findings directly to non-technical executives, translating complex engineering work into clear, decision-ready business recommendations.

Senior Data Engineer / Data Analyst at Independent Consultant (Self-Employed / Freelance) (2023-01 – Present)

Transitioned from academic engineering roles to run an independent consultancy delivering data infrastructure for multiple client organizations

• Led end-to-end data engineering and analytics delivery for 3+ separate clients across healthcare, fintech, e-commerce, and education, owning architecture from raw data ingestion through pipeline automation to final reporting.
• Architected and deployed cloud-native ETL pipelines on AWS (S3 for storage, Lambda for serverless processing, RDS for managed databases, Glue for schema cataloging), all containerized with Docker for consistent, production-grade deployment.
• Built automated Python data pipelines (pandas, NumPy) to clean, transform, and validate large datasets, cutting manual reporting time by over 70% and improving data reliability for downstream reporting.
• Designed automated, self-refresh reporting systems using Google Sheets and Apps Script, giving stakeholders live dashboards without manual data entry or third-party BI licensing costs.
• Engineered advanced SQL queries (CTEs, window functions, subqueries) across PostgreSQL, MySQL, and MongoDB to extract, join, and aggregate multi-source data into clean, analysis-ready tables.
• Automated recurring Excel and Google Sheets reports using Python (openpyxl) and Apps Script, removing hours of repetitive manual reporting work each week for client teams.
• Built and scheduled web-scraping data pipelines (Selenium, BeautifulSoup4) to ingest external market, pricing, and job-market data into PostgreSQL for downstream analysis.
• Presented pipeline architecture, data-quality findings, and reporting outcomes directly to non-technical executives, translating complex engineering work into clear business recommendations.
• Designed ETL processes ingesting data from REST APIs, CSV files, and live databases, standardizing and loading it into cloud-hosted data warehouses for enterprise reporting.

Data Analyst & Software Engineer — Academic & Project Work at Rongo University (2020-09 – 2023-06)

Coursework and applied project work completed alongside BSc studies

• Engineered a Smart Campus data system, analyzing student academic and financial records to produce fee-collection, enrolment, and course-performance reporting for university administration.
• Built a healthcare data module with structured patient records and SQL-driven analysis pipelines to generate occupancy reports, patient-flow summaries, and medication-usage statistics, in a small project team.
• Engineered an IoT sensor data pipeline for a smart parking system, building time-series and occupancy analysis to surface peak-usage patterns across the day.
• Built a job-market data pipeline that scraped listings across multiple platforms, cleaned and standardized the data in Python, and produced weekly in-demand-skills and salary-trend reports.
• Developed a multi-factor authentication audit system, logging login events to a database and writing SQL/Python analysis scripts to detect anomalies and generate security reports.

BSc in Information Science — Specialization: Information Technology – Rongo University (2020-09 – 2023-06)