DATA

Hey there, I'm

OMAR
ALFAROUK

I'm a  |

I design and build BI systems that enable organizations to make faster and more reliable decisions. With 5+ years in business intelligence & data engineering, I've delivered scalable BI solutions, optimized ETL/ELT pipelines, and built 100+ analytical dashboards & data workflows across banking and enterprise. My work has reduced pipeline runtimes by up to 80%, transforming reporting cycles from hours to near real-time. I specialize in SQL, Python, dbt, and cloud-native architectures on GCP & Azure. Currently completing my MSc in Data Science. Open to Remote, Freelance contracts ๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ป, and Relocation ๐ŸŒŽ.

๐Ÿ‡ธ๐Ÿ‡ฆ Based in Saudi Arabia ยท ๐Ÿ—ฃ๏ธ Arabic & English
0
+
Years Exp.
0
+
Dashboards & Reports
0
+
Data Workflows
SCROLL TO EXPLORE

// Tech Stack

Tools & Technologies

Airflow Airflow
dbt dbt
Google Cloud Google Cloud
BigQuery BigQuery
Power BI Power BI
Tableau Tableau
Python Python
Docker Docker
Kubernetes Kubernetes
SQL Server SQL Server
Snowflake Snowflake
PostgreSQL PostgreSQL
Git Git
Azure Azure
Data Modeling

Warehouse Design

dbt CoreStar SchemaSnowflake SchemaSCD Type 2Incremental ModelsSurrogate Keys
Databases

Query & Storage

BigQueryPostgreSQLSnowflakeSQL ServerOracleMySQL
Orchestration

Pipelines & ETL

Apache AirflowFlywayETL / ELTArgo CDGitLab CI/CD
Visualization

BI & Dashboards

TableauPower BILooker StudioSSRSKPI Engineering
Cloud

Cloud Platforms

GCPBigQueryAzureCloud StorageAzure Data Fundamentals
Dev & Infra

Engineering Tools

DockerKubernetesPythonGitJiraConfluence

// Career Journey

Where I've Built Things

JAN 2025
PRESENT
๐Ÿฆ
Business Intelligence Engineer
Vision Bank ยท Saudi Arabia
Led cloud migration from PostgreSQL/Oracle to Google BigQuery with Google's professional services. Automated SAMA regulatory reporting to 100% accuracy. Built self-service BI in Tableau, reducing ad-hoc requests across departments.
BigQuerydbtTableauGCPRegulatory Reporting
APR 2024
DEC 2024
๐Ÿ›๏ธ
BI Consultant
Zakat, Tax & Customs Authority ยท Saudi Arabia
Worked across 4 companies (Deloitte, PwC, Devo Team). Built unified BI platform reducing report duplication. Delivered improvements in data accuracy and integration across enterprise systems.
Power BISQLEnterprise BIData Integration
APR 2022
APR 2024
๐ŸŽ“
BI Developer
Tatweer Educational Technologies ยท Saudi Arabia
Delivered 9+ executive dashboards. Reduced ETL runtime by 80% (60+ min โ†’ 5โ€“10 min). Built multi-source DWH. Recognized for excellent performance H1 2023.
ETL OptimizationSQL ServerPower BIData Warehouse
MAR 2020
MAR 2022
๐Ÿš€
Data Analyst
Blueprint Technologies ยท United Arab Emirates (UAE)
Built Power BI and SSRS dashboards for operations and executive reporting. Reduced dashboard refresh from 2+ hours to under 5 minutes. Cut Power BI file size by 79% (500MB โ†’ 100MB).
Power BISSRSPerformance OptimizationDubai

// What I've Built

Featured Projects

Capstone ยท Machine Learning

Logistics Profitability Optimizer ๐ŸŒณ

Data-driven profitability optimization for an Italian logistics company using Decision Trees, revenue segmentation, and geographic insights.

PythonDecision TreesRevenue SegmentationGIS
Production ยท Data Engineering

dbt + BigQuery Analytics Stack ๐Ÿ“Š

Production-grade analytics stack: staging โ†’ dimensions โ†’ facts. SCD Type 2, incremental models, and proper surrogate key management.

dbtBigQueryStar SchemaSCD2
Enterprise ยท Cloud Migration

Vision Bank Cloud Migration โ˜๏ธ

Led migration from PostgreSQL DWH + Oracle to Google BigQuery with Google's professional services.

BigQueryGCPPostgreSQLOracle
Optimization ยท Performance

ETL Pipeline Overhaul โšก

Rebuilt legacy ETL pipeline reducing runtime by 80%. Cut Power BI file size 79%. Reduced dashboard refresh from 2+ hours to under 5 minutes.

ETLPower BISQL OptimizationPerformance

// Real Work Samples

Dashboard Showcase

Telecom Dashboard
Telecom Ports Dashboard โ€” Dark Theme
Sales Light
Sales Performance Dashboard โ€” Light Theme
Global Map
Global Distribution Map โ€” Geographic Analytics
Sales Dark
Sales Performance Dashboard โ€” Dark Theme
KPI Monitoring
KPI Monitoring & Time Series โ€” Executive Dashboard


// Get In Touch

Letโ€™s collaborate
โ€” or simply connect over a coffee โ˜•

Open to Remote, Freelance projects and Relocation opportunities.