Open to opportunities

Mayar Hany

@mayarhany

Message

Entry-level data engineer building ETL/ELT pipelines and ML-powered dashboards.

Egypt

Message

What I'm looking for

I’m looking for an entry-level role where I can own production-grade ETL/ELT pipelines, data warehouses, and ML-powered dashboards—using tools like Dagster, Streamlit, and modern SQL—while learning to deliver reliable, business-ready insights.

I’m an entry-level Data Engineer focused on production-grade ETL/ELT pipelines, analytical data warehouses, and machine learning-powered dashboards. I work comfortably across the full workflow—from raw data extraction to orchestrated transformations and interactive delivery.

In my experience as an AI & Machine Learning Trainee and BI Developer Intern, I built ML feature engineering pipelines using SMOTE for class imbalance, and I deployed real-time monitoring dashboards with Streamlit and Plotly. I achieved “85%+ prediction accuracy” on bonus eligibility classification using RandomForestClassifier, and I’ve created automated reporting solutions using SQL Server Report Builder and complex SQL (JOINs, aggregations, window functions).

On the big data side, I processed large-scale datasets with Apache Spark, Hive, and a Hadoop distributed cluster environment, implementing transformation pipelines with HBase and Elasticsearch indexing. I also earned Huawei HCIA-level Big Data certifications, and I’m used to enforcing data quality through automated cleaning and quality checks.

I enjoy turning complex datasets into decisions through dashboards and apps, whether it’s orchestrating a NASA Space Apps Challenge rain prediction ELT pipeline into Snowflake with Dagster, or building end-to-end analytics pipelines (scrape → clean → warehouse → analyze → visualize → predict) with Streamlit. My projects have processed 50,000+ records for domain analytics and supported large-scale experimentation like the Airbnb price prediction pipeline across 251,000+ listings.

Experience

Work history, roles, and key accomplishments

AI & Machine Learning Trainee

National Telecommunication Institute (NTI)

Jul 2025 - Aug 2025 (1 month)

Built ML feature engineering pipelines for HR and customer data, including categorical encoding, numerical scaling, and SMOTE, and developed automated prediction pipelines. Deployed real-time monitoring dashboards using Streamlit and Plotly and achieved 85%+ accuracy for bonus eligibility classification with RandomForestClassifier.

Python Machine Learning Feature Engineering Scaling SMOTE Streamlit Plotly Model Serving

Data Analytics Trainee

Digital Egypt Pioneers Initiative (DEPI)

Oct 2024 - May 2025 (7 months)

Designed Python ETL scripts to extract data from CSV, JSON, and API sources, transform with Pandas, and load into analytical databases. Led a team project analyzing supply chain datasets across 50,000+ records and implemented automated data cleaning and quality checks.

Python ETL Data Extraction Pandas data transformation Data Cleaning Data Quality Analytical Database Supply Chain Analytics

Power BI & Tableau Trainee

CognoRise

Oct 2024 - Nov 2024 (1 month)

Developed interactive dashboards and advanced data visualizations, strengthening DAX functions and real-time reporting proficiency using Power BI and Tableau.

Power BI Tableau DAX Data Visualization

Machine Learning Trainee

Prodigy Infotech

Oct 2024 - Nov 2024 (1 month)

Applied supervised and unsupervised machine learning algorithms to real-world projects to improve feature engineering and model evaluation skills.

Machine Learning Supervised Learning Unsupervised Learning Feature Engineering Model Evaluation

Big Data Analytics Trainee

National Telecommunication Institute (NTI)

Aug 2024 - Sep 2024 (1 month)

Processed large-scale datasets using Apache Spark and Hive on a Hadoop distributed cluster and built transformation pipelines using HBase and Elasticsearch. Developed batch Hive SQL aggregation across multi-terabyte datasets and earned NTI & Huawei HCIA-level Big Data certifications.

Apache Spark Hive Hadoop HBase Elasticsearch

BI Developer Intern

Housing and Development Bank (HDB)

Jul 2025 - Present (1 year)

Developed automated reporting solutions using SQL Server Report Builder to consolidate data from multiple banking systems into structured management reports. Authored complex SQL queries with JOINs, aggregations, and window functions to extract financial data and reduce manual report preparation.

SQL SQL Joins Aggregation Window Functions Data Extraction

Education

Degrees, certifications, and relevant coursework

Helwan National University

Business Intelligence & Analytical Systems

2023 -

Grade: 3.82/4.0

Pursuing a Business Intelligence & Analytical Systems degree at Helwan National University (GPA 3.82/4.0), covering database management, data structures, statistical analysis, machine learning, data visualization, and business analytics.