Senior BI Consultant & Data Governance Consultant
5+ years bridging Business Intelligence, Data Management, and Governance across banking, energy, and fintech in Egypt and Saudi Arabia.
Companies I've Worked With
Crédit Agricole EgyptBanking
EJADA ConsultingConsulting
IMETechnology
Banque du CaireBanking
TAQA ArabiaEnergy
Arab National BankBanking
Saudi Post (SPL)Government
Al Rajhi TakafulInsurance
Neotek FinTechFinTech
InfatechsTechnologyCrédit Agricole EgyptBankingEJADA ConsultingConsultingIMETechnologyBanque du CaireBankingTAQA ArabiaEnergyArab National BankBankingSaudi Post (SPL)GovernmentAl Rajhi TakafulInsuranceNeotek FinTechFinTechInfatechsTechnologyAbout Me
I'm a Senior BI & Analytics Engineer and Data Governance Consultant with deep expertise in designing enterprise-scale data pipelines, warehouses, and governance frameworks.
Currently at Crédit Agricole Bank, I focus on regulatory compliance reporting (ALM/CBE), ETL with Informatica PowerCenter, and Power BI dashboards. Previously, I led data governance implementations across Saudi Arabia aligned with NDMO, NDI, and PDPL standards for clients including Arab National Bank, Saudi Post, and Al Rajhi Takaful.
My governance work spans establishing Data Ownership & Stewardship models, defining Critical Data Elements (CDEs), building Business Glossaries & Governance Workflows, implementing metadata scanning, lineage analysis & compliance monitoring, driving Data Classification frameworks, ensuring Data Quality standards, and managing end-to-end Metadata Management across enterprise environments.
I am passionate about enabling organizations to build governed, high-quality, and scalable data environments that support strategic decision-making and regulatory compliance.
Certifications & Education
Career
Expertise
Selected Work
Led end-to-end analysis and automation of the CBE 1500 regulatory report. Reverse-engineered OBIEE logic, reconciled DWH data, and resolved ALM discrepancies in financial instruments, maturity buckets, and liquidity gaps.
Implemented Informatica Axon org-wide. Designed ownership & stewardship models, governed CDEs, built governance dashboards and KPIs. Managed Axon and IDQ migration from dev to production.
Classified CDEs across all departments, conducted workshops, and supported IDMC/MCC for metadata scanning, lineage, and compliance monitoring.
End-to-end migration from Eska, Penta, and Siebel with cleansing, de-duplication, audit trail, automated scheduling, and Informatica server administration.
Deployed Informatica EDC for automated metadata harvesting and lineage. Maintained glossaries, defined policies, and assigned ownership roles aligned with NDMO guidelines.
Designed interactive dashboards for customer segmentation, assets portfolio, and facilities portfolio. Enabled KPI monitoring for budgeting and retail operations teams.
Migrated core banking reports from SAP BO to MicroStrategy. Ensured accurate data mapping, optimized performance, and integrated with existing BI infrastructure.
Validated source-to-target mappings against DM sheets, performed accuracy checks and flag verifications, and resolved discrepancies to ensure data integrity throughout migration.
Built regression and deep learning models on 20 years of historical data — achieving 92–95% prediction accuracy to optimize gas distribution and reduce logistics costs across Egypt.
Transformed a 6-day, 3-person manual payroll process into a Python EXE completing in under 5 minutes — covering 4 companies with executive and individual performance dashboards.
Combined CNN and Graph Convolutional Networks for automated breast cancer classification in mammogram images. GCN achieved 95.7% accuracy using VGG16 embeddings and K-nearest neighbor graph construction.
Freelance & Consulting
Interactive dashboards and reports tailored to your business KPIs — built in Power BI, Tableau, MicroStrategy, or Excel. From data connection to final delivery.
Turn repetitive manual workflows into fully automated solutions — Python scripts, Excel macros, scheduled jobs, and end-to-end pipeline automation that saves hours every week.
Design and build robust data pipelines, warehouses, and integration workflows that consolidate your data from multiple sources into a single clean, reliable foundation.
Predictive models, forecasting engines, and AI-powered tools built for real business problems — from demand prediction and customer segmentation to deep learning applications.
Complex Excel models, dynamic dashboards, financial templates, automated reports, and custom formulas — turning plain spreadsheets into powerful business tools.
End-to-end governance framework design — data ownership models, metadata management, data quality standards, business glossaries, and regulatory compliance aligned with NDMO and PDPL.
2+ years of hands-on instructor experience at GOMYCODE and AMIT Learning — delivering structured training in Power BI, Tableau, Excel, SQL, Python, machine learning, and data science fundamentals. Sessions tailored from beginner to advanced, one-on-one or group, online or on-site.
Advisory sessions for startups and SMEs on building a solid data foundation — tool selection, architecture decisions, governance roadmaps, and actionable data strategies that scale.
Ready to work together?
Let's build something great with your data.
Available for freelance projects, consulting engagements, and training sessions.
Social Proof
I had the pleasure of working with Mohamed Magdy at Ejada. Mohamed consistently demonstrated exceptional skills in data management, efficiently driving projects and improving team productivity.
I had the pleasure of partnering with Mohamed Magdy on the MicroStrategy integration project, and he was easily one of the strongest contributors on the team. His technical depth across SQL, Python, and DAX modeling is genuinely impressive — he handled complex data logic with the kind of rigor that saves a project weeks of rework. What sets him apart is that he pairs that technical skill with real business sense: he listens to stakeholders, translates fuzzy requirements into clean deliverables, and pushes back thoughtfully when something doesn't make sense. Any data team would be lucky to have him.
Mohamed has consistently demonstrated great potential and a strong aptitude for excelling in this field. One of his standout qualities is his eagerness to learn and continuously enhance his knowledge of BI tools and technologies. He takes initiative in exploring new approaches and applies his learning effectively to deliver impactful results. He is a valuable asset to any team or company.
Magdy's prowess in data analytics has been instrumental in several of our most successful projects. He has an innate ability to sieve through enormous sets of data, extract meaningful insights, and translate these insights into actionable strategies. His exceptional skills in Python and SQL, combined with his adaptability to evolving technologies, place him at the forefront of the field. Beyond his technical skills, what truly sets Magdy apart is his interpersonal communication and his support to all those surrounding him — he naturally assumes mentoring roles, guiding junior staff with patience and expertise.
I highly recommend Mohamed, who has been a key asset to our team as a BI Developer. He has demonstrated excellent skills in data preparation, analysis, reporting, and delivering high-quality solutions. He is a proactive problem solver who translates complex data into valuable business insights. His ability to collaborate effectively and meet tight deadlines while maintaining quality is exceptional. I'm confident he will continue to excel and add value in any future role.
Mohamed Magdy is an excellent, dedicated candidate — very knowledgeable and supportive, honest and a problem solver. I recommend him to any organisation; he will add great value.
I worked closely with Mohamed on a business case during the hiring process and he showed exceptional performance. Being skillful, organized, attentive to details and having a very good business understanding, he delivered outstanding work.
Mohamed is such a genius person and really dedicated to his work — it was a pleasure working with him.
Mohamed is such a committed and dedicated programmer — helped me reach specific outcomes with a genius solution.
Let's Connect
Whether you're hiring for a BI/data role, need a data governance consultant, or want to explore a project collaboration — I'd love to hear from you.