Open to opportunities

Zamzam arafat

@zamzamarafat

Message

I build production-style ELT pipelines and cloud data warehouses with Python, SQL, BigQuery, Airflow, and dbt.

Kenya

Message

What I'm looking for

I'm looking to grow in a data engineering role where I can build reliable cloud ELT pipelines, strengthen orchestration depth, and develop PySpark, monitoring, and alerting skills.

I've built an end-to-end cryptocurrency ELT pipeline that integrates live CoinGecko market data and Alternative.me sentiment data, processing more than 150,000 records across 55 coins.

I orchestrated independent Apache Airflow DAGs for ingestion and sentiment workflows, then built Bronze, Silver, and Gold dbt layers in BigQuery. I designed dimensional fact and dimension tables, added dbt quality tests, and implemented MERGE-based incremental loading to keep warehouse runs idempotent and free of duplicates.

I'm completing a Computer Science degree at Kabarak University and continuing to deepen my cloud, orchestration, PySpark, monitoring, and alerting skills. I also built a SARIMAX retail-demand forecasting pipeline and a Streamlit and Plotly dashboard for live cryptocurrency prices and sentiment.

Experience

Work history, roles, and key accomplishments

Graduate Data Engineer

Self Employed

Computer Science graduate specializing in data engineering, with hands-on experience building production-style ELT pipelines using Python, SQL, BigQuery, Apache Airflow, and dbt. Experienced in designing dimensional data models, orchestrating multi-source ingestion, and implementing idempotent, incrementally loaded warehouses.