Moustafa Sadek
Verified Expert in Engineering
Data Analyst and Developer
Eindhoven, Netherlands
Toptal member since January 10, 2024
Moustafa is a highly skilled data analytics engineer with 5+ years of experience in full-stack analytics, from business requirement gathering to data modeling in Databricks, DBT, and BigQuery. He's an expert in Power BI, Looker Studio, ETL, CI/CD with Azure DevOps, and Azure Data Factory pipeline orchestration. Moustafa is an Agile/Scrum practitioner with strong documentation and stakeholder onboarding skills.
Portfolio
Experience
- Spreadsheets - 7 years
- Microsoft Power BI - 6 years
- SQL - 6 years
- Python - 6 years
- Data Analytics - 5 years
- Data Modeling - 4 years
- Tableau - 3 years
- Azure Databricks - 2 years
Availability
Preferred Environment
Azure Databricks, SQL, Azure, Google BigQuery, Microsoft Power BI, Tableau, ADF, ETL, Business Intelligence (BI), Python
The most amazing...
...things I've developed were 15+ full-stack dashboards for inventory, demand planning, and logistics, enhancing operational efficiency and data visibility.
Work Experience
Senior Data Analytics Engineer
SHIMANO EUROPE B.V.
- Data Analytics Engineer with expertise in creating ADF pipelines in Azure to implement ETL tools. Developing Python data models for advanced analytics and data processing.
- Power BI dashboard creation for data visualization and reporting.
- Building SQL Views to streamline data access and analysis. Monitoring data migration projects from JDE to SAP.
Data Analyst
Brightly - Main
- Specialized in building insightful dashboards using Power BI.
- Collaborated closely with product owners to gather and refine requirements, translating business needs into actionable metrics.
- Performed mathematical calculations, developed robust data models, and transformed complex datasets into clear, interactive visualizations.
- Built over 25 ETL pipelines to extract and model the data using DBT and Data Bricks, and developed more than seven Dashboards in Power BI.
Senior Data Analytics Engineer
Henkel
- Developed a data model and a dashboard to monitor the product lifecycle in the logistics network regarding quantity and cost.
- Planned features and product backlog items (PBIs) via Azure DevOps, created a data model in Azure Databricks, and presented the dashboard in Microsoft Power BI.
- Optimized and reduced costs through multiple factors, such as truck utilization, which also decreased CO2 emissions.
- Created a dashboard to track and monitor forecast accuracy for regional and monthly levels.
Data Analyst
Noon
- Developed a dashboard to track the number of damaged shipments by defining each shipment's location and timestamps.
- Set weekly and monthly KPIs and analyzed them statistically.
- Created queries and views using SQL, BigQuery, and Data Studio.
- Analyzed distribution demand using Python and R to gain insights and facilitate decision-making.
- Built data models using statistics and programming.
Experience
Cost-to-Deliver Dashboard
The dashboard also tracks the quantities of goods in transit, providing insights into inventory levels and helping to prevent overstocking or understocking. This feature aids in maintaining a balanced inventory, reducing storage costs and waste.
Moreover, the dashboard is environmentally conscious as it tracks the CO2 emissions associated with the transportation of goods, encouraging businesses to adopt greener logistics practices. By reducing CO2 emissions, businesses can not only lower their environmental impact but also potentially benefit from cost savings in regions where carbon pricing is in effect.
Forecast Accuracy Dashboard
The dashboard is divided into two main sections: regional accuracy and monthly accuracy. The regional accuracy section provides data on the accuracy of forecasts for different regions, allowing for comparative analysis across various geographical areas. This helps identify regions where forecasts are consistently accurate or require further attention. The monthly accuracy section, on the other hand, tracks the accuracy of forecasts on a month-by-month basis. This allows users to observe how forecast accuracy fluctuates over time and can help identify specific months where forecasts tend to be more or less accurate.
Data Analyst Work
Education
Bachelor's Degree in Engineering
Alexandria University - Alexandria, Egypt
Certifications
Algorithms and Data Structures MicroMasters Program
Rochester Institute of Technology | via edX
MITx MicroMasters Certificate in Data Analytics
Massachusetts Institute of Technology | via edX
MITx MicroMasters Certificate in Supply Chain Management
Massachusetts Institute of Technology | via edX
Skills
Libraries/APIs
PySpark, NumPy, Pandas, Node.js, REST APIs, ODBC
Tools
Microsoft Power BI, Tableau, Spreadsheets, Google Sheets, BigQuery, Microsoft Excel, Looker, Jupyter, Spyder, Apache Airflow, Salesforce Sales Cloud, Visual Studio, Google Analytics, dbt Cloud
Languages
SQL, Python, Excel VBA, COBOL, PowerBuilder, Snowflake, R, C#, Scala, JavaScript, BigMachines Query Language (BMQL)
Paradigms
ETL, Business Intelligence (BI), Unit Testing, Agile, User Acceptance Testing (UAT)
Platforms
Databricks, Microsoft, Jupyter Notebook, Azure, Anaconda, Google Cloud Platform (GCP), Amazon Web Services (AWS), Microsoft Fabric, Qlik, Oracle, AWS IoT
Storage
QuickBase, PostgreSQL, Data Lakes, Microsoft SQL Server, SSAS Tabular, Data Pipelines, Google Cloud
Frameworks
ADF, Spark, Flask
Other
Azure Databricks, Google BigQuery, Supply Chain Management (SCM), Mathematics, Statistics, Data Modeling, Microsoft Office, Excel Expert, Data Cleaning, Data Analytics, ETL Tools, Data Analysis, Microsoft Azure, DAX, Dashboards, CI/CD Pipelines, Excel 365, Business Analysis, Data Visualization, Data Engineering, Image Annotation, Data Transformation, Data Extraction, Excel Add-ins, ECharts, Product Management, SAP ERP, Data Analytics, Data Product Manager, Microsoft Power BI, ELT, Stakeholder Management, Data Migration, Single Sign-on (SSO), Excel Macros, Industrial Engineering, IT Project Management, Statistical Modeling, Statistical Analysis, Communication, Statistical Programming, Analytical Thinking, Demand Planning, Logistics, Order to Cash (O2C), Supply Chain Operations, Optimization, Big Data, Data Wrangling, Data Warehousing, Stakeholder Engagement, Agile DevOps, SAP, Diversity, Equity, & Inclusion (DEI), Looker Studio, Forecasting, Complex Problem Solving, eCommerce, Statistical Data Analysis, Teamwork, ERD, Machine Learning, Genesys, Data Build Tool (dbt), Data Science, Financial Planning & Analysis (FP&A), SEC Financial Reporting, Financial Reporting, Azure Data Factory (ADF), Azure Data Lake, Data Migration Testing, Fivetran, Financial Modeling, Linear Algebra, Sprint Planning, Call Centers, Causal Inference
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring