Available for new opportunities

Ahmed Hassan

Data Engineer

I began my career as a .NET backend developer, but soon discovered my passion for data engineering. This led me to join the ITI Data Engineering track, where I honed my skills in building reliable, queryable data platforms. Today, I design and implement everything from batch ETL workflows and star-schema warehouses to real-time CDC pipelines and multi-layer lakehouses. Currently, I’m working at Bassirah as a Data Engineer

Find me on
Ingest Stream or Batch Transform & model Store Analyze

The Story Behind the Systems: Who I Am & What Drives Me

A software engineering background, an ITI journey, and a genuine passion for scalable data platforms.

Ahmed Hassan portrait
1+ Years in Data Eng.
10+ Data Projects
6+ Certifications

I started my career as a .NET backend developer at Techno Management, building web APIs, MVC applications, and reporting solutions for government and private-sector clients. Through the ITI Data Engineering Program, I discovered a genuine passion for data infrastructure and made a deliberate career transition — one I haven't looked back from.

My data engineering work spans both batch and real-time: designing ETL/ELT pipelines with Spark, dbt, Airflow, and SSIS; building star-schema data warehouses and analytical models; and engineering CDC streaming systems with Flink and Kafka for sub-second data delivery. At Bassirah, I'm building an AI-Native Lakehouse on MinIO AIStore with Apache Iceberg medallion layers, centralized ClickHouse warehousing for sub-second OLAP, and GenAI integrations enabling conversational data exploration.

Professional Experience

  1. Data Engineer
    Bassirah
    Aug 2026 – Present Full-Time
    • Built an AI-Native Lakehouse on MinIO AIStore with Apache Iceberg medallion layers, orchestrating both streaming (Flink, Kafka CDC) and batch (Spark, dbt) pipelines.
    • Architected a centralized Data Warehouse on ClickHouse for ultra-fast OLAP analytics and Trino query federation.
    • Integrated ClickHouse with GenAI solutions, empowering clients to query business data in natural language and receive real-time AI-powered answers.
  2. Data Engineering Trainee
    ITI — Information Technology Institute
    Jan 2026 – Present Training Program

    Intensive specialization in Big Data & distributed systems. Completed the flagship graduation project: Football Analytics Platform (Dual Spark/Kafka streaming & Snowflake/dbt/Airflow batch), alongside database architecture and advanced data modeling projects.

  3. Software Engineer
    TrendLine
    Jun 2025 – Present Freelance

    Built and deployed three client-facing web applications with ASP.NET Core and Angular.

  4. Software Engineer
    Techno Management
    Mar 2024 – Jan 2025 Full-Time

    Developed scalable .NET solutions (MVC & Web APIs) for government and private sectors. Built SharePoint web parts with SQL Server and created Power BI dashboards with SSRS reports.

  5. Coding Instructor
    iSchool
    Mar 2024 – May 2024 Part-Time

    Taught 2D game development using Godot Engine and GDScript to students.

Internships & Training

  1. Data Engineering Trainee
    DEPI — Digital Egypt Pioneers Initiative
    Jan 2026 – Jun 2026 Training Program

    Hands-on training in Big Data pipelines, distributed systems, and data warehouse design. Projects include an Examination System Database, Python Data Analysis, and a Dockerized Data Analytics platform.

  2. AI Engineer — Computer Vision
    Skärpt
    Feb 2025 – May 2025 R&D Internship

    Developed computer-vision models achieving 90% accuracy in PPE detection for workplace safety compliance.

  3. Hospital Information Systems (HIS)
    Hospital 57357
    Jul 2023 Internship

    Trained on Hospital Information Systems and healthcare data management workflows.

Education

  1. B.Sc. in Computer & Artificial Intelligence
    Helwan University
    2019 – 2023 Grade: Very Good

    CS — Medical Informatics Department

Core Competencies

A data engineering stack spanning stream processing, batch pipelines, lakehouse storage, analytics, cloud infrastructure, and development tooling.

Programming Languages
Python SQL Scala Java C# JavaScript
Stream & Batch Processing
Apache Flink Apache Spark Apache Kafka Hadoop CDC Pipelines
Storage & Lakehouse
MinIO AIStore Apache Iceberg Snowflake Databricks Delta Lake
Databases & OLAP
ClickHouse SQL Server PostgreSQL MySQL MongoDB Trino
Orchestration & Transformation
Apache Airflow dbt SSIS SSAS ETL/ELT Design
Analytics & BI
Power BI SSRS Pandas Matplotlib Seaborn Excel
Cloud & Infrastructure
AWS Azure Microsoft Fabric GCP Docker CI/CD
Development Tools
Git REST APIs ASP.NET Core Angular SharePoint
Arabic Native
English Professional Proficiency

Data Engineering Work

End-to-end projects spanning pipeline design, data modeling, lakehouse architecture, and analytics delivery.

Architecture diagram and analytics dashboards for the Football Analytics live and batch platform
AWS S3 Apache Spark Apache Kafka Snowflake dbt Airflow Grafana Power BI

ITI Graduation Project · Lambda + Medallion Architecture

Football Analytics & Live Match Intelligence

Objective: Build an end-to-end Lambda + Medallion pipeline ingesting 3M+ football records from Transfermarkt, delivering both historical analytics and live match simulation.

Approach: Ingested raw data into AWS S3 via a Medallion architecture; modeled into a Galaxy Schema using dbt in Snowflake for analytics-ready reporting. Added a Kafka + Spark Structured Streaming layer to simulate live match events, orchestrated with Airflow.

Outcome: Visualized results via real-time Grafana dashboards for live event monitoring and Power BI dashboards for historical business insights.

Architecture diagram showing the Movielens end-to-end ELT pipeline on AWS S3, Snowflake, and Airflow
AWS S3 Snowflake dbt Apache Airflow Power BI

ELT Pipeline · Bronze-Silver-Gold Medallion Architecture

Movielens End-To-End Data Pipeline

Objective: Build an end-to-end ELT pipeline on the MovieLens dataset (20M+ ratings, tags, and genome scores) into an analytics-ready data warehouse.

Approach: Followed a Bronze-Silver-Gold Medallion Architecture and modeled a Star Schema with dbt, from AWS S3 into Snowflake. Orchestrated the daily workflow with an Apache Airflow DAG.

Outcome: Delivered a Power BI dashboard surfacing business insights across ratings trends, tag analysis, and genome score distributions.

SSIS data flow diagram for the Bookstore ETL Data Warehouse pipeline
SSIS SQL Server SSAS Power BI

ELT Data Warehouse · Star Schema

Bookstore ETL Data Warehouse Project

Objective: Build an end-to-end ELT pipeline and enterprise data warehouse for a bookstore to analyze sales trends, customer segmentation, and geographic demand.

Approach: Used SSIS and SQL Server to populate a Star Schema data warehouse from operational sources. Developed SSAS cubes for multidimensional analysis and Power BI dashboards for business reporting.

Outcome: A complete BI stack delivering actionable insights on sales trends, customer segments, and regional demand patterns.

Entity-Relationship diagram for the examination system database
SQL Server SSMS Stored Procedures Indexing

Relational Database Design · Query Optimization

Examination System Database

Objective: Design a normalized relational database schema for an academic examination system capable of handling large-scale student records.

Approach: Designed a fully normalized relational schema, implemented stored procedures for core business logic, and applied indexing strategies and query optimization techniques.

Outcome: A maintainable, high-performance database supporting complex query patterns for exam management across 10,000+ student records.

Data visualization chart from the Python data analysis pipeline
Python Pandas Matplotlib Seaborn

Data Analysis Pipeline

Python Data Analysis Pipeline

Objective: Build an end-to-end data analysis workflow covering ingestion through to visualization.

Approach: Used Python and Pandas for data ingestion, cleaning, and transformation; Matplotlib and Seaborn for exploratory visualization.

Outcome: A reproducible analysis pipeline demonstrating core data wrangling and visualization competencies.

Certifications & Training

Industry certifications and structured training programs that complement hands-on engineering experience.

Certifications

Microsoft
Fabric Data Engineer Associate
DP-700  ·  July 2026
Microsoft Fabric
View Credential
ClickHouse
ClickHouse Certified Developer
Aug 2026
OLAP Analytics
View Certificate
AWS Academy
AWS Academy Graduate — Data Engineering
May 2026
Cloud Data
View Badge
AWS Academy
AWS Academy Graduate — Cloud Foundations
May 2026
Cloud
View Badge
NTI
Python for Data Analysis
Mar 2026
Data Analysis
View Certificate
Coursera
Backend Development — .NET Full Stack
Sep 2023
.NET
Verify Certificate

Mentorship

Data Engineering Mentorship

Completed a structured Data Engineering mentorship program, gaining industry insights and practical guidance on distributed systems and data platform design.

Volunteering

Egyptian Red Crescent
Data Management Specialist
Jul 2026 – Present  ·  Health / Humanitarian

Volunteering to support health data workflows and information systems for humanitarian operations.

Let's Work Together

Have a data engineering challenge or an opportunity to discuss? I'd be glad to connect.

Contact Information

Giza, Egypt

Location

Giza, Egypt

Connect on

Available for new opportunities

Open to data engineering roles and consulting projects

I'm interested in full-time data engineering positions, contract work on data platform projects, and collaborations involving real-time pipelines, lakehouse architecture, or analytics infrastructure.

Send Me an Email