Moustafa Amer
Verified Expert in Engineering
Data Analyst and Developer
Amsterdam, Netherlands
Toptal member since January 10, 2024
Moustafa is a senior data and analytics engineer with 7+ years of experience building scalable data platforms at Shimano Europe and Henkel. Stack: dbt (Cloud/Core), Kimball Dimensional, Data Vault, Medallion Architecture. Cloud: Azure (Databricks, Delta Lake, ADF, ADLS) and GCP (BigQuery, Cloud Composer, Dataflow, Looker). Advanced SQL, Python (Pandas, PySpark, scikit-learn), Power BI, Tableau. Skilled in Claude and Claude Agents for workflow automation, CI/CD, DataOps, and data governance.
Portfolio
Experience
- SQL - 9 years
- Spreadsheets - 7 years
- Data Modeling - 7 years
- Microsoft Power BI - 6 years
- Python - 6 years
- Data Analytics - 5 years
- Azure Databricks - 5 years
- Tableau - 3 years
Preferred Environment
Azure Databricks, SQL, Azure, Google BigQuery, Microsoft Power BI, ADF, ETL, Business Intelligence (BI), Python, Claude
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, Claude API
Tools
Microsoft Power BI, Tableau, Spreadsheets, Google Sheets, BigQuery, Microsoft Excel, Looker, Jupyter, Power BI Desktop, Spyder, Apache Airflow, Salesforce Sales Cloud, Visual Studio, Google Analytics, dbt Cloud, Amazon CloudWatch, Sentry, AWS Glue, Claude
Languages
SQL, Snowflake, Python, Excel VBA, COBOL, PowerBuilder, Looker Modeling Language (LookML), R, C#, Scala, Bash, JavaScript, BigMachines Query Language (BMQL)
Paradigms
ETL, Business Intelligence (BI), Unit Testing, Database Design, Agile, User Acceptance Testing (UAT)
Platforms
Azure, Databricks, Microsoft, Azure SQL Data Warehouse, SharePoint, SharePoint 365, Azure Data Lake Storage, Jupyter Notebook, Anaconda, Google Cloud Platform (GCP), Amazon Web Services (AWS), Microsoft Fabric, Qlik, Oracle, New Relic, AWS IoT
Storage
QuickBase, PostgreSQL, Data Lakes, Microsoft SQL Server, Azure SQL Databases, Azure SQL, Relational Databases, SSAS Tabular, Data Pipelines, Google Cloud, Amazon S3 (AWS S3)
Industry Expertise
Project Management
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, Data Science, ELT, Stakeholder Management, Data Migration, Single Sign-on (SSO), Excel Macros, Enterprise, Star Schema, Reporting, Microsoft 365, SharePoint Online, Product Lifecycle Management (PLM), Dagster, Access Control, Data Governance, 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), Financial Planning & Analysis (FP&A), SEC Financial Reporting, Financial Reporting, Azure Data Factory (ADF), Azure Data Lake, Data Migration Testing, Fivetran, Financial Modeling, Metabase, Team Leadership, Front-end, 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