BI & Data Automation Developer focused on helping businesses automate repetitive reporting and turn messy, multi-source data into reliable business information. I build end-to-end data workflows using Python, Pandas, SQL Server, ETL, data warehousing, Power BI and DAX. I work with Excel/CSV files, APIs and databases to clean, validate, transform and consolidate data before turning it into useful reporting. My experience includes Power BI dashboards and semantic models, SQL Server ETL, data validation, reconciliation, incremental loading, SCD Type 1/2, data modeling, scheduled pipelines and reporting automation. I’m particularly interested in ecommerce, retail, logistics, distribution and other businesses where teams spend significant time combining data from different systems and preparing recurring reports. My focus is not just building dashboards, but improving the workflow behind them so reporting becomes more consistent, repeatable and less manual.…

Mohamad Ayoub

BI & Data Automation Developer focused on helping businesses automate repetitive reporting and turn messy, multi-source data into reliable business information. I build end-to-end data workflows using Python, Pandas, SQL Server, ETL, data warehousing, Power BI and DAX. I work with Excel/CSV files, APIs and databases to clean, validate, transform and consolidate data before turning it into useful reporting. My experience includes Power BI dashboards and semantic models, SQL Server ETL, data validation, reconciliation, incremental loading, SCD Type 1/2, data modeling, scheduled pipelines and reporting automation. I’m particularly interested in ecommerce, retail, logistics, distribution and other businesses where teams spend significant time combining data from different systems and preparing recurring reports. My focus is not just building dashboards, but improving the workflow behind them so reporting becomes more consistent, repeatable and less manual.…

Available to hire

BI & Data Automation Developer focused on helping businesses automate repetitive reporting and turn messy, multi-source data into reliable business information.

I build end-to-end data workflows using Python, Pandas, SQL Server, ETL, data warehousing, Power BI and DAX. I work with Excel/CSV files, APIs and databases to clean, validate, transform and consolidate data before turning it into useful reporting.

My experience includes Power BI dashboards and semantic models, SQL Server ETL, data validation, reconciliation, incremental loading, SCD Type 1/2, data modeling, scheduled pipelines and reporting automation.

I’m particularly interested in ecommerce, retail, logistics, distribution and other businesses where teams spend significant time combining data from different systems and preparing recurring reports.

My focus is not just building dashboards, but improving the workflow behind them so reporting becomes more consistent, repeatable and less manual.

See more

Skills

Experience Level

ETL
Expert
Microsoft Excel
Expert
Microsoft SQL
Expert
Power BI
Expert
SQL
Expert
Data Visualization
Expert
Python
Expert
API
Intermediate
Github
Intermediate
Data Science
Beginner

Language

Arabic
Fluent
English
Fluent
French
Intermediate

Work Experience

BI & Data Automation Developer at Self-Employed / Freelance
July 26, 2026 - Present
Build end-to-end BI and data automation solutions using Python, Pandas, SQL Server, ETL, data warehousing, Power BI and DAX. Develop workflows for multi-source data ingestion, cleaning, validation, transformation, reconciliation and recurring reporting. Build SQL Server (Bronze -> Silver -> Gold) data warehouses and Power BI semantic models, including dimensional modeling, incremental loading, SCD Type 1/2, scheduled pipelines and reporting automation. Portfolio work includes multi-source BI automation and automated sales reporting pipelines using Excel/CSV data, APIs, Python, SQL Server and Power BI.

Education

Bachelor in Management Information System (MIS) at Lebanese University (LU)
October 26, 2023 - July 26, 2026
GPA (3.4/4)

Qualifications

Add your qualifications or awards here.

Industry Experience

Software & Internet, Computers & Electronics, Financial Services, Retail, Education, Professional Services
    Sales Data Warehouse & BI Dashboard
    Business intelligence project focused on transforming a large transactional sales dataset into a structured SQL Server data warehouse and Power BI reporting solution. Designed a star schema with fact and dimension tables, performed ETL cleaning and validation, and built Power BI reporting for revenue, gross profit, transactions, average ticket, gross margin and monthly target performance. The dashboard provides management-focused views of sales performance, profitability and target achievement from a centralized analytical model. PowerBI SQLServer DataWarehouse DataModeling DAX BusinessIntelligence DataAnalytics…
    Automated Sales BI Pipeline
    Automated reporting pipeline that transforms raw Excel/CSV sales data into a structured SQL Server warehouse and Power BI reporting environment. Built a Python/Pandas processing layer for data profiling, cleaning and validation, followed by SQL Server staging and ETL. The warehouse uses dimensional modeling, incremental loading, SCD Type 1/2, reconciliation and ETL logging before delivering data to a Power BI semantic model. The final solution provides automated sales, customer, product and profitability reporting while replacing repetitive manual preparation with a repeatable workflow. PowerBI Python SQLServer ETL DataAutomation DAX DataWarehouse…
    VantaCommerce — Multi-Source BI & Data Automation Platform
    VantaCommerce is an end-to-end BI and data automation platform designed to turn messy, multi-source business data into reliable reporting. The project combines Python/Pandas, REST APIs, CSV/Excel files and SQL Server to automate data ingestion, cleaning, validation, transformation and reconciliation before delivering the data to Power BI. It includes (Bronze - Silver- Gold ) ETL workflows, data warehousing, dimensional modeling, incremental processing, SCD Type 1/2, logging and automated reporting across sales, customers, products, profitability and geographic performance. The goal is simple: reduce repetitive manual data preparation and create a reliable path from raw business data to decision-ready insights. BusinessIntelligence DataAutomation PowerBI Python SQL ETL DataEngineering DataWarehouse…

Hire a Data Engineer

We have the best data engineer experts on Twine. Hire a data engineer in Beirut today.