Khaled Gohar
Transforming data into powerful analytics solutions—building pipelines, dashboards, and automated workflows that deliver actionable insights through storytelling and business analysis.
Transforming data into powerful analytics solutions—building pipelines, dashboards, and automated workflows that deliver actionable insights through storytelling and business analysis.
Passionate about data, driven by results
I am a passionate Data Analyst and Data Engineer with expertise in transforming raw data into actionable insights. I specialize in building data pipelines, interactive dashboards, and automation workflows that streamline operations and empower decision-makers with clear, data-driven strategies.
My technical expertise includes SQL, Power BI, Python, Microsoft Fabric, N8N, and ETL/ELT processes, with proven experience in delivering scalable analytics solutions that integrate seamlessly across business functions.
Beyond technical skills, I bring strong capabilities in business analysis, data storytelling, and process optimization, ensuring that analytics not only inform but also inspire action.
I am particularly interested in data analytics, workflow automation, and building scalable data pipelines that power insightful dashboards and business solutions. I approach data like a detective uncovering the truth, combining technical expertise with business analysis and storytelling to reveal actionable insights that drive meaningful decisions.
Outside of work, I enjoy exploring new data technologies, contributing to knowledge-sharing communities, and experimenting with automation tools to push the boundaries of what data can achieve.
Tools and technologies I work with
Query tuning, database remodeling, transforming and reshaping tables, models, and views. (SQL Server, PostgreSQL, BigQuery,DuckDB).
Interactive dashboards, data visualization, and business insights reporting with dynamic analytics solutions.
Data processing, automation, and scripting for analytics, and data transformation.
Data integration, modeling, and visualization across cloud services to streamline analytics workflows.
Building and maintaining scalable data transformation pipelines with version-controlled models.
Extracting, transforming, and loading data efficiently across multiple sources and systems.
Automating data workflows, notifications, and processes for efficiency and consistency.
Creating scalable data models and turning data into actionable insights through storytelling and analysis.
Recent work and case studies
Interactive dashboards and business insights
Power BI dashboard for fleet performance and financial KPIs.
Segmentation, heatmaps, and geo distribution.
Modern layout, KPI deltas, intuitive navigation.
ETL/ELT pipelines and semantic models
dbt models + Snowflake + BI layer.
Star schema with SCDs and conformed dims.
Aggregations and time-intelligence layer.
Orchestration, alerts, and operational tooling
GitHub Actions + REST API + Slack alerts.
Stats models + scheduled notifications.
Email to Snowflake with validation.