Senior BI Architect & Head of Analytics at Deraah Retail Group
I transform fragmented reporting into enterprise data ecosystems. My work sits at the intersection of data engineering, BI architecture, and business strategy.
- BI Architecture: Star schema design, Medallion lakehouse, enterprise data modeling
- Data Engineering: ClickHouse, dbt, Airflow, Airbyte, SSIS — end-to-end automated pipelines
- Advanced Analytics: Customer 360, RFM scoring, churn prediction, next-best-action
- Visualization: Power BI (353+ DAX measures), Apache Superset, executive dashboards
- Data Governance: SDAIA/PDPL compliance, RBAC, OpenMetadata, data classification
| Metric | Result |
|---|---|
| BI Transformation | 6 tables → 32-model production lakehouse |
| Performance | 259x faster dashboards (ClickHouse migration) |
| Cost Savings | $80K annual savings through analytics automation |
| Customer Data | 2.7M records unified (Customer 360) |
| DAX Measures | 353 authored across all retail domains |
| Pipeline | Fully automated daily via Airflow 3.0 |
BI & Visualization: Power BI · DAX · Apache Superset · Excel/Power Pivot Data Engineering: SQL Server · ClickHouse · SSIS · Airbyte · dbt · Alteryx Orchestration: Apache Airflow 3.0 · Prometheus · Grafana Governance: OpenMetadata · SDAIA/PDPL · RBAC Business Systems: Dynamics 365 · Salesforce CRM · SharePoint Languages: SQL · DAX · M (Power Query) · Python
- LinkedIn: linkedin.com/in/hamedelbhrawy
- Email: hamed.elbhrawy@outlook.com
- Location: Saudi Arabia
"The most important outcome of a data transformation is not a faster dashboard — it's an organization that trusts its data and acts on it."