Mostafa Elanany

– Sole data partner for an SMB client, owning the full lifecycle (requirements, data modeling, dashboards, and documentation) across repeat engagements – Modeled and transformed raw business data in BigQuery into a clean, reliable analytics layer — the SQL foundation powering all client reporting – Consolidated Dynamics 365 and operational spreadsheets into automated Power BI models, replacing manual tracking and saving teams hours per week – Translated requirements from non-technical stakeholders into KPI definitions, reporting logic, and SQL transformations

As a Data analytics engineer in the Data-as-a-Service team at Shippeo, I played a key role in transforming raw data into actionable insights, optimizing processes, and driving significant business improvements. Missions: - Designed and delivered real-time dashboards that improved business performance by 20%. - Optimized data pipelines, reducing processing time by 30%. - Partnered with cross-functional teams to develop and implement data quality solutions, leading to a 25% revenue increase. - Led the design and maintenance of comprehensive documentation for data pipelines and dashboards. - Developed and implemented dimensional data models using the Kimball methodology. - Conducted in-depth data investigations to identify trends and issues in customer operations. Technical Stack: Data Modeling & Analysis: SQL, Python, DBT, Snowflake. Data Visualization: Tableau. Methodologies: Kimball, Agile.