Ahmed Badour

Analytics Engineer & Data Analyst with a Computer Science background, focused on turning fragmented data into high-performance analytical models and decision-ready dashboards. Experienced in Star Schema and Medallion data warehouse design, advanced SQL (CTEs, Window Functions, Stored Procedures), Python (Pandas, NumPy) pipelines, and interactive Power BI, Tableau, and Excel dashboards with DAX. Completed intensive programs with the National Telecommunication Institute (NTI) and the Digital Egypt Pioneers Initiative (DEPI).

Open to Analytics Engineering, Data Analysis, and BI roles.

Data Analyst Intern - National Telecommunication Institute (NTI) - Tanta, Egypt · On-site

(2026-06 - 2026-09)

• Completed an intensive internship covering the full analytics workflow: data collection, cleaning, analysis, visualization, and reporting.
• Wrote SQL for extraction, transformation, aggregation, joins, subqueries, CTEs, and Window Functions.
• Used Excel (PivotTables, Power Query, Power Pivot, DAX) and Python (Pandas, NumPy, Matplotlib) for analysis and data preparation.
• Built interactive Power BI and Tableau dashboards focused on KPIs, trends, and customer segmentation.
• Applied dimensional modeling (fact and dimension tables, Star Schema) on end-to-end projects, turning raw data into business recommendations.

Data Analyst Intern - Digital Egypt Pioneers Initiative (DEPI)

(2025-11 - 2026-07)

• Cleaned and structured raw datasets using Python (Pandas), reducing data errors by 15%.
• Performed EDA on large datasets, identifying 5+ key trends for stakeholder reporting.
• Optimized SQL queries to improve data retrieval speed from relational databases.
• Built interactive Power BI dashboards to visualize KPIs and support data-driven decisions.

Bachelor's Degree - Computer Science - Tanta University – Faculty of Computers and Information Systems (2023 - 2027)