|
Problem → Multi-country real estate listings arriving as raw, unstructured data with no analytics-ready layer
Solution → Designed a Medallion architecture (Bronze/Silver/Gold) on Snowflake as part of a 4-person team; orchestrated dbt models via Airflow; connected Power BI directly to the Gold-layer star schema ( |
Problem → Real-time crypto market data needed a scalable, structured pipeline for analysis Solution → Built an end-to-end pipeline ingesting live data from the CoinGecko API, structured through a Medallion architecture; automated ingestion/transformation/orchestration with Airflow, stored in MinIO, modeled in Snowflake; delivered Power BI dashboards for market KPIs Role → Solo pipeline design, orchestration & dashboarding |
|
Problem → 1,508 real estate listings across 10 Moroccan cities needed cleaning and structure before any analysis was possible Solution → Built an analytical pipeline transforming raw listings into a structured dataset; handled missing values (city-level mode / grouped median) and outliers (IQR + business rules); modeled the data into a star schema on PostgreSQL; designed a 4-page interactive Power BI report covering pricing, segments and market performance Role → End-to-end: data quality, modeling, and BI reporting |
|
Certifications
|
Education
Languages Arabic (native) · French (intermediate) · English (intermediate) |