Yehya Khaled Khurkhash

Mid-Level Data EngineerFull Time

• Job Details:• Collaborated with downstream data consumers to understand requirements and assessed available data sources for relevance. • Designed, built, and managed a robust data platform on Azure Synapse Analytics to serve large-scale data to machine learning engineers and business users. • Engineered and implemented data warehouse models following Ralph Kimball’s methodology and utilized Erwin Modeler for efficient modeling. • Designed and implemented high-performance ETL pipelines using SSIS, Azure Synapse Pipelines, and Python then developed a notification system using Azure Logic Apps and Slack. • Transformed and standardized NoSQL data stored in MongoDB into a structured, tabular format for storage in Azure SQL Server. • Ensured data integrity and cleanliness through data quality checks and cleansing procedures, employing SQL, Python, and Synapse Data Flows. • Evaluated and selected appropriate tools and services to meet the demands of diverse data engineering tasks. • Facilitated secure access to the data platform for external partners while implementing robust security measures to secure sensitive information. • Developed Power BI reports for the top management and our partners.

Data & AI EngineerFull Time

• Job Details:• Worked on 2 mega analytics projects with the Central Agency for Public Mobilization and Statistics (CAPMAS) and National Population Council (NPC). • Gathered business requirements and evaluated the available data sources. • Conducted exploratory data analysis and cleansing using Python, SSIS, and SQL. • Developed data warehouse models using Ralph Kimball’s approach and Erwin Modeler. • Designed and built high-performance ETL pipelines using SSIS and Azure Data Factory. • Built semantic models using SSAS and reporting layer using Power BI. • Developed machine learning models for time series forecasting and integrated the models into the data pipeline using Python, SqlAlchemy, Pandas, and Scikit-Learn. • Prepared workshops for Microsoft and GBG partners on Azure modern data warehouse.