Islam Elsheikh

Data Engineer @ Digital Hub

About

Passionate Data Engineer & ETL Developer with a focus on building robust, scalable data infrastructures that turn complex raw data into actionable business intelligenceMy expertise lies in designing end-to-end data pipelines using the Modern Data Stack (dbt, Airbyte, ClickHouse)I specialize in handling messy, unstructured datasets (including complex Arabic statistical bulletins) and transforming them into high-performance analytical warehousesKey Technical Strengths:Data Architecture: Designing Star Schemas and Dimensional Warehouses for optimized queryingETL/ELT Automation: Building automated extraction pipelines from diverse sources (SQL Server, Excel, JSON)Performance Engineering: Optimizing ClickHouse databases using Materialized Views to achieve sub-second dashboard response timesTools & Languages: Python (Pandas), SQL, dbt, Airbyte, ClickHouse, Apache Superset, GitI thrive at the intersection of data reliability and system performance. Let’s connect to discuss how we can build better data foundations together!Technical Stack:Ingestion: Airbyte, SSIS, Python ScrapersTransformation: dbt, Informatica PowerCenterOrchestration: Apache AirflowWarehousing: ClickHouse, SQL Server, SSASWhat I Deliver• Scalable, production-grade data pipelines• Trusted warehouse models for BI & ML• Automated, reliable data workflows• Data platform modernization & migrationAvailabilityOpen to remote Data Engineering roles. Remote-ready with strong communication skills and flexible time zone availability (EU, USA, Canada, KSA, UAE)

Country

Egypt

City

New Cairo

Industry

Information Technology & Services

Skill

ClickHouse, dbt / airbyte / airflow / clickhouse , Informatica PowerCenter, Cloud Services, Data Integration, Data Modeling (Star, Snowflake), Python / PySpark / SQL, Azure / AWS (Redshift, S3, Glue), DBT / Airflow / Snowflake, ETL Development (SSIS, NiFi, Informatica), DataOps, Cloud-native solutions, ETL Tools, Data Warehouse Architecture, Data Maintenance, SQL Server Integration Services (SSIS), Hadoop, MapReduce, Hive, Microsoft Azure Machine Learning

Experience

Data Engineer

Digital Hub

2024-8 - Present · 2 yrs 2 mos

New Cairo

Present | Remote-Hybrid - TECHNICAL CONTRIBUTIONS: - ETL & Automation • Developed robust ETL pipelines using SSIS, automating data ingestion from 18+ source tables with incremental loading, dynamic table creation, and error handling using ForEach Loop Containers and Script Tasks • Designed and implemented reusable expressions for handling data inconsistencies (e.g., scientific notation, placeholder values, null defaults) - Data Modeling & Warehousing • Designed Star Schema models to support analytical queries for national account data - Modern Stack & Cloud Integration • Developed data flows using Apache NiFi to extract and load data from SQL Server, enabling seamless transformation pipelines via QueryDatabaseTable, ScriptedTransformRecord, and PutDatabaseRecord • Actively learning and applying tools from the modern data stack: GCP (BigQuery, Pub/Sub), Snowflake, Airflow, and DBT - BI & Analytics Enablement • Delivered clean, structured datasets that powered dashboards in Power BI and Tableau • Supported business users and analysts by ensuring data accuracy, consistency, and completeness across dimensions and KPIs - Collaboration & Communication • Participated in cross-functional meetings in English to gather requirements and document solutions • Bridged gaps between technical teams and business stakeholders with clear, data-driven communication - TECH STACK: Python , SSIS , snowflake, pyspark, SQL, Azure (Data Factory, Synapse, ML Studio), Apache Airflow, Docker

Data Analyst

Digital Hub

2024-5 - 2024-8 · 4 mos

-Assist in data collection, cleaning, and preparation for analysis. -Conduct exploratory data analysis to identify patterns and trends. -Support data-driven decision making by providing insights and recommendations. -utilized data extraction and transformation expertise (Microsoft Excel, Power Query, ETL software) from bulletins as pdf files to facilitate research on researchers’ website.

Software Engineer

Innovation Strategies

2024-1 - 2024-5 · 5 mos

El Maadi, Cairo, Egypt

Education

Minufiya University

Bioinformatics

2017-9 - 2021-9 · 4 yrs 1 mo

(Graduation Project) burns diagnosis by using the scanner •Machine learning and automation are being used to create more accurate and objective methods for diagnosing and triaging burn injuries. •This technology aims to improve burn management by providing quantitative diagnoses, increasing diagnostic accuracy, and making burn care more accessible