Skip to main content

Mohamed Abdelhalim

Data Engineer II at Koinz · Cairo, Egypt

mohamed-abdelhalim.meLinkedInGitHubDownload PDF

Summary

Data Engineer II building and scaling data infrastructure for analytics and reporting. Currently at Koinz, I optimize ClickHouse clusters and build Spark/Airflow pipelines for large-scale data processing. Previously at 4Sale International, I owned backend and analytics systems that cut analytics query latency from 10+ minutes to under 5 seconds and reduced P95 API latency from ~1.6s to under 450ms.

Experience

Data Engineer II · Koinz

Jul 2026 — Present

Cairo, Egypt

  • Maintain and scale core data infrastructure supporting company-wide analytics and reporting.
  • Optimize ClickHouse query and cluster performance through schema, indexing, and partitioning improvements.
  • Design and maintain data marts in ClickHouse for reporting and analytical use cases across teams.
  • Build and maintain Apache Spark pipelines for large-scale data processing and transformation.
  • Orchestrate and monitor data workflows using Apache Airflow, ensuring reliable and timely pipeline execution.

Stack: ClickHouse, Apache Spark, Apache Airflow, Python, SQL

Data Engineer · 4Sale International Co.

2025 — 2026

Cairo, Egypt

  • Reduced analytics query latency from 10+ minutes to under 5 seconds by building a time-series analytics layer with TimescaleDB.
  • Cut storage footprint by ~50% through continuous aggregates and data retention strategies.
  • Built event-driven backend services on AWS, reducing incorrect push notifications by 30% and improving system reliability.
  • Reduced P95 API latency from ~1.6 seconds to under 450 ms on production services.
  • Built an internal scheduling platform on top of EventBridge, replacing ad-hoc automation scripts with a centralized and observable solution.
  • Built internal tooling that helped teams investigate metric changes faster and reduced time spent on root-cause analysis.
  • Diagnosed and fixed production data quality issues, restoring trust in analytics used for business decision-making.

Stack: AWS, PostgreSQL, TimescaleDB, DynamoDB, Python, SQL, Docker, Snowflake

Big Data Intern · Orange Digital Center

2024

Egypt

  • Built and optimized data processing workflows using Apache Spark and Hive.
  • Worked with distributed systems and large-scale datasets across the Hadoop ecosystem.
  • Improved analytical workloads and reporting pipelines through query and data processing optimizations.

Stack: Apache Spark, Hadoop, Hive, MongoDB, Python

Education

B.Sc. Computer Science

Mansoura University · Distinction with Honors

  • Graduation Project: A+
  • Ideal Student award

Skills

Programming Languages:
Python, SQL, R, C#
Data Engineering:
Docker, Linux, Git, PostgreSQL, SQL Server, FastAPI, Snowflake, Delta Lake, dbt, SSIS, Spark, Airflow, ClickHouse
Cloud & Tools:
AWS Lambda, EventBridge, DynamoDB, API Gateway, Azure Container Apps, Azure Web Apps, Azure Data Factory, Azure Data Lake
AI & Agents:
LLMs, RAG, Agentic Workflows, LangChain, Vector DBs (ChromaDB), Prompt Engineering

Certifications

  • AWS Certified Cloud Practitioner — Amazon Web Services
  • Apache Airflow 3 Fundamentals — Astronomer
  • Google Cloud Professional Data Engineer — Google Cloud
  • ClickHouse Certified Developer

Achievements

  • ECPC Finalist — Egyptian Collegiate Programming Contest, 2025
  • Best Business Model — MIE (Made In Egypt) Competition, 2025
  • 3rd Place — IEEE Victories 3.0, 2024
  • 3rd Place — GDG DevFest Hackathon, 2024
  • 500+ problems solved on LeetCode · 300+ on Codeforces
  • Head of Data Science — Mega Team, Mansoura University (workshops & mentorship in ML and data analysis)