Mahmoud Elhalfawy
Ottawa,ON
Summary
Experienced Data Engineer Lead with 15+ years of expertise in Data Engineering, Data Warehousing, and Business Intelligence. Skilled in leveraging Python and cloud technologies to build robust data pipelines for collecting, transforming, and loading data from multiple sources into a central data warehouse. Proficient in complex SQL queries to drive data insights. Strong leadership background managing data engineering and business intelligence teams.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Manager, Data Science
Merkle | Cardinal Path Inc.
Ottawa, Ontario
10.2022 - Current
- Manage data engineering team goals, tasks, and roadmap.
- Mentor, train, and support team members.
- Design and build a unified Data Ops processes for different project types in GCP.
- Architect and develop automated data pipelines in Google Cloud Platform to use GA4 data in BigQuery.
- Using products like Dataform, Workflows, Pub/Sub, and others.
- Build a documentation process for clients' deliverables.
- Automate ML models in GCP.
- Work with GA4 data in BigQuery to extract analytics and build queries to match GA4 UI reports.
- Collaborate with the data visualization team to create and implement data models for both internal and client dashboards.
Senior Data Engineer
Platform161, Verve (Part time)
, Netherlands (Remote)
05.2022 - 10.2023
- Built complex yet effective Airflow DAGs for seamless integration between various systems, facilitating the ingestion and modification of large volumes of data.
- Maintained and optimized existing airflow DAGs to maximize performance.
- Collaborated with cross-functional teams to create Looker dashboards that provided insights into business queries and tracked KPI metrics.
- Integrated Jira with BigQuery for a team's performance monitoring dashboard on Looker.
Senior Consultant, Data Science
Cardinal Path Inc.
Ottawa, Ontario
07.2022 - 09.2022
- Architected and developed an automated data pipeline within Google Cloud Platform to seamlessly receive files from various source systems, transmitting them directly to a Google Analytics 360 property data import via the management API.
- Developed multiple data pipelines for transforming and consolidating Google Analytics 360 records into various file destinations like Cloud Storage, AWS S3, and SFTP.
- Contributed to the creation of data models used in internal and client-facing dashboards and reports through collaboration with the data visualization team.
- Expertly managed multiple data sources using a variety of tools, including DOMO, Funnel.io, Supermetrics, and Google BigQuery.
- Utilized Talend Data Integration to develop customized ETL jobs and successfully implemented them on Talend cloud as well as Cloud-based VMs.
Senior Consultant, Data Engineer
Cardinal Path, Dentsu
Cairo, Egypt
10.2017 - 06.2022
- Architected and developed an automated data pipeline in Google Cloud Platform to receive files from different source systems and send them to a Google Analytics 360 property data import through the management API
- Built several data pipelines that transform and consolidate Google Analytics 360 data in Google Big Query and send it to files in Cloud Storage, AWS S3, or SFTP destinations
- Built a process to identify and redact/mask PII instances in clients’ data in the cloud, using Cloud DLP and regex
- Worked closely with data visualization team to design and build data models to be used for internal and client-facing dashboards and reports
- Worked with third-party tools like DOMO, Funnel.io, and Supermetrics to extract data from different data sources and work with it either within the tools themselves or transfer it into Google Big Query for further analysis
- Worked with Talend Data Integration to build custom automated ETL jobs and deploy them to Talend cloud or Cloud-based VMs
- Designed and developed an automated pipeline that collects data from CRM system (Salesforce) using the API, and other client-specific data sources and ingest the data into Google Big Query to be joined with GA360 dataset for analytics and visualizations.
Business Intelligence Team Leader
Vodafone
Cairo, Egypt
03.2010 - 10.2017
- Led a reporting team overseeing the Postpaid Segment, Enterprise, Finance, and Retail departments.
- Contributed to the development of a comprehensive data mart that catered to varying business requirements across corporate departments.
- Deliver weekly ad-hoc reports with speed and high quality.
- Involved in building and maintaining high-quality dashboards to monitor major KPIs on an hourly, daily, weekly, and monthly basis.
- Participate in the financial monthly and yearly closing activities.
- Created and developed a service requests system for efficient life cycle management of weekly requests made by business users.
- Empowered business users to make informed decisions by providing easy access to critical data through user-friendly dashboards.
- Enforced corporate protocols to safeguard confidentiality and accuracy of data, reports, and records.
- Conducted monthly and annual government audits on company-issued SIM card sales and activations.
- Provided guidance and support to newly arrived team members of all levels - senior, mid and junior.
- Served as second-level support for online dashboard and reports, ensuring smooth operations and prompt resolution of bugs and errors.
Sr. Developer
ASSET Technology Group
Cairo, Egypt
08.2006 - 03.2010
- Designed, implemented, and delivered high-quality, tested code for multiple systems throughout the company in an agile environment.
- Developed and implemented software solutions for integrating various systems according to vendor specifications.
- Managed ongoing maintenance and enhancement of bug fixes and patch sets for current web apps.
- Conducted product demos and training sessions to educate clients about new products.
- Designed and implemented automated and dynamic reports for Orascom Development Egypt, utilizing PL/SQL.
- Developed and implemented backend database structures to support client applications.
- Produced and maintained regular ad-hoc SQL reports.
- Collaborated with project management, testing, and support teams.
Education
B.Sc. Computer Science -
Zagazig University
Egypt06-2005
Diploma in Software Development and Databases -
Information Technology Institute
Egypt06-2006
Skills
- Python Programming
- SQL and Databases
- Data Analytics
- Teamwork and Collaboration
- Continuous Improvement
- Problem-Solving
- Self Motivation
- Load Balancing
- Time Management
- Multitasking
Languages
English
Full Professional
Arabic
Native/ Bilingual
Certification
- Google Cloud Certified Professional Data Engineer
Residency
Canadian Permanent Residency
Timeline
Manager, Data Science
Merkle | Cardinal Path Inc.
10.2022 - Current
Senior Consultant, Data Science
Cardinal Path Inc.
07.2022 - 09.2022
Senior Data Engineer
Platform161, Verve (Part time)
05.2022 - 10.2023
Senior Consultant, Data Engineer
Cardinal Path, Dentsu
10.2017 - 06.2022
Business Intelligence Team Leader
Vodafone
03.2010 - 10.2017
Sr. Developer
ASSET Technology Group
08.2006 - 03.2010
B.Sc. Computer Science -
Zagazig University
Diploma in Software Development and Databases -
Information Technology Institute
Similar Profiles
Sneha Ganesh NayakSneha Ganesh Nayak
Robotics Software Engineer at Path Robotics, Inc. Path Robotics, IncRobotics Software Engineer at Path Robotics, Inc. Path Robotics, Inc
Marilyn LunnonMarilyn Lunnon
CEO at PATH OF LIFE, INC/PATH OF LIFE CAREER ACADEMYCEO at PATH OF LIFE, INC/PATH OF LIFE CAREER ACADEMY
Ahmed HefnyAhmed Hefny
Senior Manager, Data Solutions / from 09.2023 Director, Data Solutions at Merkle Germany GmbHSenior Manager, Data Solutions / from 09.2023 Director, Data Solutions at Merkle Germany GmbH
PATRICIA CHAMBERLAINPATRICIA CHAMBERLAIN
Turkey Guide at Irish creek outfittersTurkey Guide at Irish creek outfitters
Cullen WoodCullen Wood
Pro Shop Customer Service Representative at Amberwood Village GolfPro Shop Customer Service Representative at Amberwood Village Golf