Description

Data Engineer with Proven Expertise Leveraging 8+ years of corporate experience, I specialize in Snowflake and dbt, Azure SQL databases, Fabric Solutions, Azure Data Factory Data Pipelines, Azure Synapse Analytics, and Enterprise-level Data Warehousing. Proficient in developing Linked Services via Azure Synapse Analytics and crafting impactful data visualizations using Microsoft PowerBI. My project delivery encompasses end-to-end services, including requirements gathering, data analysis, ETL data pipelines, data ingestion, wrangling, cleaning, modeling, and comprehensive data visualization. Let me bring my certified skills to drive success in your data-related projects.

Industry field of expertise

Languages

English
Native or bilingual
Arabic
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

Smartlytics (NowVertical Group)
Senior Data Engineer
CONSULTING AND AUDITS
September 2023 - January 2024 (4 months)
New Cairo, Egypt
• Led client data discovery sessions and stakeholder meetings to align technical solutions with business objectives and ensure analytical relevance.
• Designed and implemented advanced analytical solutions including ROI, Market Basket, and What-If analyses to drive strategic decision-making.
• Developed analytical datasets and robust data models, delivering scalable and efficient data warehouse solutions.
• Built stored procedures and end-to-end data pipelines using Azure Data Factory and Azure Synapse Analytics to automate data workflows.
• Created interactive Power BI reports to visualize complex datasets, enabling actionable, data-driven insights across business functions.
Data analysis SQL Data Engineer
PwC ETIC
Senior Business Intelligence Engineer
CONSULTING AND AUDITS
January 2024 - Today (2 years and 5 months)
New Cairo, Egypt
• Designed and implemented a Snowflake data warehouse to track media digital excellence, integrating Adverity as the central data source across six platforms (DV360, Meta, TTD, YouTube, Google Ads, Tik Tok).
• Consolidated cross-platform data to enable compliance monitoring and digital spend reporting, delivered through a Power BI dashboard used by 3,000+ employees across the European zone.
• Built a Nature Analytics dashboard for a global pharmaceutical company to track site-and commodity-level environmental impact, aligning with TNFD and LEAP (Locate, Evaluate, Assess, Prepare) phases for nature related risk and opportunity assessment.
• Designed and visualized ESG metrics using Power BI, enabling data-driven decisions on biodiversity, water, and land use across global operations, and supporting TNFD-aligned sustainability reporting.
• Collaborated with cross-functional teams to design a resource management database and develop a Power BI dashboard, streamlining planning and utilization tracking.
• Built an internal SVG chart library for Power BI, enhancing visual storytelling and dashboard customization across business units.
• Developed a Python-based tool to extract and analyze Power BI metadata, supporting data model optimization and generating automated dashboard documentation.
• Shadowed the Director in client-facing engagements, assisting with project planning, stakeholder communication, and follow-ups to ensure smooth execution and client satisfaction.
Python SQL Microsoft Power BI DBT Snowflake
EvaPharma
Dala Engineer
PHARMACEUTICALS INDUSTRY
September 2022 - September 2023 (1 year)
Giza, Egypt
• Designed and built ETL/ELT pipelines in Python to integrate data from Google Analytics, SQL Server, Oracle SQL Developer, FTP Servers, and Google Cloud Storage.
• Extracted and migrated data from Oracle Cloud Infrastructure (OCI) and SQL Server to Google BigQuery using Cloud Run and Cloud Scheduler.
• Administered the Google Cloud Platform (GCP) enterprise environment, ensuring scalability, security, and performance optimization.
• Developed and published Power BI dashboards for senior management and cross-functional teams, delivering actionable insights.
• Automated data ingestion, transformation, and validation workflows, improving efficiency, data quality, and query performance for large-scale datasets in BigQuery.
• Collaborated with stakeholders to define and implement data governance policies and best practices for cloud-based data management.
Data Engineer Python Microsoft Power BI Data analysis SQL