Ahmed Gharib
Principal Advanced Analytics Engineer at ITWorx
Data engineering leader with 8+ years building scalable pipelines, warehouses, and analytics solutions across Azure, Snowflake, AWS, and Databricks. Currently architecting data infrastructure for enterprise clients at ITWorx, with a strong focus on Agentic AI and autonomous data pipelines.
Core Skills
About Me
Personal Info
Name
Ahmed Gharib
Location
Cairo, Egypt
Phone
+2010 96995535
Languages
Professional Summary
Data engineering leader with 8+ years building scalable pipelines, warehouses, and analytics solutions across Azure, Snowflake, AWS, GCP, and Databricks. Currently at ITWorx as Principal Advanced Analytics Engineer, leading analytics initiatives for enterprise clients in financial services and healthcare — including architecting the data infrastructure for Abu Dhabi Securities Exchange's digital transformation and building an Agentic AI-powered competitor intelligence system.
Hands-on experience leading teams, migrating to Medallion architecture (Snowflake + DBT), and building async ETL pipelines with 68x performance gains. Advanced practitioner of AI coding tools (Claude Code, GitHub Copilot) with multiple training sessions delivered at ITWorx and Raisa Energy. Combines data engineering depth with AI/ML skills (TensorFlow, PyTorch, Scikit-learn) and a strong focus on Agentic AI and autonomous data pipelines.
Education
Bachelor's Degree of Commerce
Ain Shams University
2008 - 2011
Certifications
Professional Experience
Principal Advanced Analytics Engineer
ITWorx - Free Zone, Cairo
- Architected data infrastructure for Abu Dhabi Securities Exchange (ADX) digital transformation, optimizing Azure SQL and Synapse data warehouse for trading platform performance.
- Built Agentic AI-powered competitor intelligence system using N8N, Azure OpenAI GPT, LangChain, star-schema Azure SQL, Docker Compose, Playwright, and FlareSolverr.
- Standardized 190+ Power BI Paginated Reports across 4 environments (Dev, Test, UAT, Prod) with a custom Python CLI tool, reducing processing time from 4 hours to 15 minutes.
- Delivered multiple training sessions on AI coding assistants (Claude Code, GitHub Copilot) to engineering teams, driving adoption of AI-augmented development workflows.
- Led presales activities and POCs in Agentic AI, data engineering, and analytics for enterprise clients in financial services and healthcare.
Senior Data Engineer
Raisa Energy LLC - Cairo, Egypt
- Led a team of 4 engineers, migrating legacy multi-layer architecture to a proper Medallion architecture (Bronze/Silver/Gold) using Snowflake and DBT.
- Developed an Entity Correction Model using DBT with exact and fuzzy matching, improving financial attribution accuracy from ~70% to ~98%.
- Built WEnergyDocsEL — an async Python ETL pipeline (asyncio) for document processing, achieving a 68x performance improvement over the synchronous version.
- Delivered training sessions on AI tools and coding assistants to the engineering team.
- Implemented data governance strategies ensuring data quality, security, and compliance across all data assets.
Business Insights Sr. Lead
_VOIS - Smart Village, Giza
- Built a Python desktop application (PyQT6 + Selenium + Win32com API) that automated daily operations, reducing manual effort by 25%.
- Directed the creation and maintenance of comprehensive Power BI dashboards for Pre-sales, Demand and Utilization, and Work in Progress analysis.
- Played a pivotal role in designing and maintaining a scalable Oracle SQL Data Warehouse.
- Migrated datasets to AWS Redshift and Google BigQuery, enhancing scalability and performance.
- Collaborated with cross-departmental teams to embed analytics-driven strategies within organizational workflows.
Senior Business Intelligence Developer
Atos - Cairo, Egypt
- Technical lead for pre-sales on Enterprise BI and data platform projects, contributing to new client acquisition and relationship expansion.
- Developed and optimized analytical frameworks using Python, Scikit-learn, and TensorFlow.
- Implemented MongoDB-based IaaS on Azure, enabling scalable and efficient data storage.
- Established Elastic Cloud on Kubernetes (ECK) infrastructure on AKS to enhance application monitoring.
- Provided critical analytical insights and data visualization solutions leveraging Power BI, Excel, and SQL Server.
Data Analyst
ALSAFY GROUP - Fifth Settlement, New Cairo
- Created a sales dashboard using Excel Power Query, DAX functions, and VBA to analyze and compare branch performance.
- Facilitated analysis and reporting of key performance indicators across multiple departments.
- Designed and executed complex SQL queries to retrieve and analyze data from enterprise databases.
Major Projects
Jan 2025 - Present
Agentic AI-powered competitor intelligence system that autonomously scrapes, processes, and analyzes market data to generate actionable business insights.
Key Achievements:
- Designed star-schema Azure SQL data warehouse for structured competitor data storage
- Built autonomous scraping pipeline using Playwright and FlareSolverr for dynamic web content
- Integrated Azure OpenAI GPT and LangChain for intelligent data extraction and summarization
- Orchestrated end-to-end workflows with N8N, containerized with Docker Compose
Technologies:
Tools:
Jan 2024 - Dec 2024
Digital transformation initiative for Abu Dhabi Securities Exchange (ADX) to modernize data infrastructure, optimize trading platform performance, and enhance market accessibility.
Key Achievements:
- Optimized Azure SQL Database read queries and refined Synapse Dedicated SQL Pool warehouse structure
- Standardized 190+ Power BI Paginated Reports across 4 environments with custom Python CLI, reducing processing from 4 hours to 15 minutes
- Designed real-time Power BI dashboards for trading performance monitoring
- Migrated data infrastructure to Azure Synapse, improving query performance and scalability
Technologies:
Tools:
Oct 2023 - Jan 2024
Automated workflow system to manage patient request handling across clinics in German, French, and Italian, anonymizing patient data while distributing requests based on predefined criteria.
Key Achievements:
- Designed data pipelines and ETL processes using SSIS
- Developed sophisticated SSRS reports for in-depth insights
- Deployed SSIS packages across various environments
- Automated public list report generation
Technologies:
Tools:
Feb 2023 - Sep 2023
DBT-based data quality model for Raisa Energy that corrects entity attribution errors in financial data using exact and fuzzy matching algorithms.
Key Achievements:
- Improved financial attribution accuracy from ~70% to ~98%
- Implemented multi-stage matching pipeline: exact match, fuzzy match, and manual review
- Built with DBT on Snowflake, integrated into the Medallion architecture Silver layer
Technologies:
Tools:
Mar 2022 - Nov 2022
High-performance async Python ETL pipeline for processing energy sector documents from Azure Blob Storage into Snowflake, built for Raisa Energy.
Key Achievements:
- Achieved 68x performance improvement over the synchronous version using asyncio
- Processed documents from Azure Blob Storage into structured Snowflake tables
- Implemented secure credential management with Azure Key Vault
- Built comprehensive logging and error handling for production reliability