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
- Microsoft Power BI - 8 years
- Data Modeling - 7 years
- Spreadsheets - 7 years
- Python - 6 years
- Azure Databricks - 5 years
- Tableau - 5 years
- Data Analytics - 5 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
Data Engineer
Cloudsufi Inc
- Built the KOMPASS Gold Layer on GCP BigQuery and Dataform — 6 production tables processing 25+ million sales records, recovering 21.4 million lost rows from a dedup bug, and reducing data volume by 85%.
- Engineered scalable data pipelines using BigQuery, Dataform 3.0, SQL, JavaScript, and GCP, applying incremental load patterns, partition pruning, and composite key assertions across a multi-layer architecture.
- Designed and built a unified hierarchy dimension in BigQuery using Dataform, consolidating 14 SAP BW hierarchies with recursive flattening, multi-source description resolution, and automated per-InfoObject views.
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, Power BI REST APIs, Salesforce API, Claude API
Tools
Microsoft Power BI, Tableau, Spreadsheets, Google Sheets, BigQuery, Microsoft Excel, Looker, Jupyter, Power BI Desktop, Power Query, Spyder, Apache Airflow, Salesforce Sales Cloud, Visual Studio, Google Analytics, dbt Cloud, Amazon CloudWatch, Sentry, AWS Glue, Claude, Claude Code, Codex
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), HL7 FHIR Standard
Platforms
Azure, Google Cloud Platform (GCP), Databricks, Microsoft, Azure SQL Data Warehouse, SharePoint, SharePoint 365, Azure Data Lake Storage, Salesforce, Jupyter Notebook, Anaconda, Amazon Web Services (AWS), Microsoft Fabric, Qlik, Oracle, New Relic, Dataform, Google Dataform, AWS IoT
Storage
Google Cloud, QuickBase, PostgreSQL, Data Lakes, Microsoft SQL Server, Azure SQL Databases, Azure SQL, Relational Databases, Data Validation, Google Cloud SQL, Google Cloud Storage, SQL Server Reporting Services (SSRS), Data Integration, SSAS Tabular, Data Pipelines, Amazon S3 (AWS S3)
Industry Expertise
Project Management, Healthcare
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, Data Warehousing, 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, Data Build Tool (dbt), 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, BI Reporting, BI Reports, Audits, Data Warehouse Design, Database Schema Design, Financial Reporting Dashboards, Query Optimization, Workflow Automation, Data Architecture, Dashboard Design, Reports, Key Performance Indicators (KPIs), ETL Pipelines, Identity & Access Management (IAM), Cloud, Cloud Storage, Compliance, Data Security, Enterprise Data Warehouse (EDW), Architecture, Performance Optimization, Reporting, Marketing Analytics, Performance Measurement, Business to Business (B2B), Customer Relationship Management (CRM), Data Integrity Testing, ETL Testing, QA Automation, Quality Assurance (QA), APIs, Cloud Platforms, Data Quality, 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, Stakeholder Engagement, Agile DevOps, SAP, Diversity, Equity, & Inclusion (DEI), Looker Studio, Forecasting, Complex Problem Solving, eCommerce, Statistical Data Analysis, Teamwork, ERD, Machine Learning, Genesys, 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, EMR, HIPAA, Artificial Intelligence (AI), Marketing Leadership, Artificial Intelligence (AI), 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