Medhat Soliman
Senior Data Engineer
Auckland
Summary
Senior Data Engineer with 15+ years of experience in SQL development, data integration, and enterprise data pipelines. Skilled in transforming data into actionable insights through ETL/ELT design, cross-system integration, and stakeholder collaboration. Passionate about data quality, performance optimization, enabling data-driven decisions and cloud-based solutions (Azure SQL, Snowflake).
Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions.
Overview
26
26
years of professional experience
8
8
years of post-secondary education
2
2
Certifications
Work History
Data Engineer | Software Engineer (Academic Project)
EquityAI
08.2024 - 11.2024
- Developed optimized SQL queries to support a GIS-based web application, reducing query execution time by 40%.
- Designed stored procedures and indexing strategies, improving database performance for high-volume transactions.
- Built ETL, automating data transformation for tens of millions of data records.
- Optimized SQL queries and indexing, reducing report generation time by 40% and improving BI system performance.
- Implemented role-based security policies, ensuring data integrity and compliance.
Senior SQL/Data Engineer | Applications Supervisor
Presidential Flight
08.2001 - 07.2022
- Designed and maintained enterprise-grade SQL Server databases supporting operational, maintenance, and finance systems.
- Developed end-to-end ETL/ELT pipelines using Stored Procedures, SSIS, integrating data from various sources (Flight Schedule, Aircraft MRO, HR, ERP, custom apps) to build unified data layers.
- Designed and validated ETL workflows for analytics platforms, implementing SQL-based integrity checks and performance tests across pipeline stages.
- Partnered with cross-functional stakeholders to build custom reports and dashboards that improved decision-making across departments.
- Conducted regular performance tuning, indexing, and normalization to improve system speed and stability by 40%.
- Automated data validation and alerting processes for early detection of inconsistencies, reducing manual review efforts by 60%.
- Contributed to planning and documentation for system upgrades and data migration projects, including QA and UAT phases.
Reporting Specialist | Database Administrator
Al Nahda National Schools
09.1998 - 08.2001
- Developed custom reports and dashboards, improving financial and performance analysis.
- Provided IT support and managed network infrastructure for 70+ users.
Education
Master of Science - Information Science
Massey University
Auckland, New Zealand 01.2022 - 01.2024
Postgraduate Diploma - Quantitative Methods
Ain Shams University
Cairo, Egypt 01.1994 - 01.1996
Bachelor of Science - Computer & Information Systems
Sadat Academy
Cairo, Egypt 01.1989 - 01.1993
Skills
- Data Engineering: ETL/ELT Pipelines, Data Integration, Dimensional Modeling, Data Validation, ETL Test Automation, Data Pipeline QA
- Databases: Microsoft SQL Server, Azure SQL, Oracle 12c, PostgreSQL
- Data Tools: SSIS, DevExpress, Power BI, T-SQL, Stored Procedures
- Cloud & Big Data: Snowflake, Data Warehousing concepts
- Programming: SQL, Python, Machine Learning, VBNet, scripting (VBScript/macros)
- Data Quality & Governance: Data Cleansing, Validation, Performance Optimization
- Workflow & Automation: Job Scheduling, Alert Systems, Reporting Automation
- Collaboration: Stakeholder Engagement, Cross-Functional Team Collaboration
Certification
SAP ABAP Certified Development Associate
New Zealand Visa
Work Visa (Open – Post-Study) – Expiry Date: 2028-01-21
Timeline
Data Engineer | Software Engineer (Academic Project)
EquityAI
08.2024 - 11.2024
Master of Science - Information Science
Massey University
01.2022 - 01.2024
Senior SQL/Data Engineer | Applications Supervisor
Presidential Flight
08.2001 - 07.2022
Reporting Specialist | Database Administrator
Al Nahda National Schools
09.1998 - 08.2001
Postgraduate Diploma - Quantitative Methods
Ain Shams University
01.1994 - 01.1996
Bachelor of Science - Computer & Information Systems
Sadat Academy
01.1989 - 01.1993
Similar Profiles
ELAINE PATTONELAINE PATTON
Trade Manager – New Zealand at Brand USATrade Manager – New Zealand at Brand USA
Rohit SehgalRohit Sehgal
Assistant Long Life Manager at Woolworths SupermarketAssistant Long Life Manager at Woolworths Supermarket
Mya FennessyMya Fennessy
Volunteer - Teacher Aide at Bairds Mainfreight Primary SchoolVolunteer - Teacher Aide at Bairds Mainfreight Primary School
Greta VagujhelyiGreta Vagujhelyi
Entrepreneur / Co-Founder at ÁBRA Art Kft.Entrepreneur / Co-Founder at ÁBRA Art Kft.
Venkat BobbiliVenkat Bobbili
Cloud Data & Solution Architect | AI/ML Head at Tech MahindraCloud Data & Solution Architect | AI/ML Head at Tech Mahindra