HJFreelancer profile translated to English.
Back to original languageAbout Hicham
Data Engineer & Business Intelligence Specialist with over 15 years of experience in data engineering, BI optimization, and managing analytical solutions on the Azure cloud.
Thanks to my expertise in Azure DevOps CI/CD, Databricks, Azure Synapse, Power BI, and data modeling, I have contributed to the implementation and optimization of decision-making solutions for renowned companies such as MSC, Selecta AG, ELCA Informatique, Nestlé, and Philip Morris International.
I possess a strong adaptability and a deep analytical approach, enabling me to optimize BI infrastructure performance, improve data governance, and support companies in their digital transformation.
French
Native or bilingual
English
Fluent
Can work on-site
Lyon (up to 50km)
Experience
- Technology Staffing GroupData ArchitectJune 2025 - Today (1 year and 2 months)Geneva, Switzerland• • Design and build a centralized Data Hub architecture for CRM systems• • Define data models and integration patterns to consolidate CRM data sources Analysis Services and Power BI• • Design and develop scalable data pipelines and transformation processes• • Ensure data quality, governance, and security best practices• • Collaborate with business stakeholders to translate CRM requirements into technical architecture• • Architect and implement a modern Data Analytics Platform using Microsoft Fabric, integrating data engineering, semantic modeling, and reporting layers• • Leverage LLM (GPT-based capabilities) to enhance data exploration, analytics, and intelligent insights generation• • Design and implement AI-powered workflows using Power Automate and OpenAI, enabling process automation, intelligent notifications, and data-driven decision support• • Utilize Perplexity AI for advanced research, technical benchmarking, architecture validation, and continuous technology monitoring to support data platform design decisionsTechnical Environment: Microsoft Fabric, Power BI, Azure Data Factory, SQL, LLM (GPT), Perplexity AI, Azure Synapse, Git, CI/CD
- MSC (Mediterranean Shipping Company Geneva)Senior BI & Data Engineer ConsultantNovember 2024 - November 2024Responsibilities:• • BI Performance Optimization: Reducing Power BI response times by improving tabular models and DAX queries.• • Development of Analytical Solutions: Design and maintenance of tabular models and financial reports on Azure Analysis Services and Power BI.• • Implementation of a Data Lake Architecture: Implementation of the Medallion approach with Databricks to load and structure SAP data in real-time.• • Automation and CI/CD: Management and deployment of CI/CD pipelines via Azure DevOps.• • Data Governance and Quality: Quality control• • Cloud & Data POC: Integration and processing of Parquet files from Amazon S3 with Databricks.Achievements:✓ BI Optimization: Reducing ✓ Enhanced Decision-Making: Implementing precise KPIs for more analysis. ✓ Data Governance: Standardizing and strengthening data quality controlTechnical Environment: Azure Synapse Analytics, MS Fabric, Databricks, Delta Lake, PySpark, SQL, DAX, Power BI, Azure Analysis Services, Azure DevOps, Visual Studio 2019
- MSC (Mediterranean Shipping CompanySenior BI & Data Engineer ConsultantJanuary 2024 - November 2024 (10 months)Geneva, SwitzerlandA global leader in shipping and logistics, based in Geneva. With a modern fleet and an international network, MSC offers container transport solutions and integrated services across more than 155 countries.Role: Senior BI & Data Engineer Consultant Responsibilities:• BI Performance Optimization: Reducing Power BI response times by improving tabular models and DAX queries.• Development of Analytical Solutions: Design and maintenance of tabular models and financial reports on Azure Analysis Services and Power BI.• Implementation of a Data Lake Architecture: Implementation of the Medallion approach with Databricks to load and structure SAP data in real-time.• Automation and CI/CD: Management and deployment of CI/CD pipelines via Azure DevOps.• Data Governance and Quality: Quality control, and supervision of pipelines with Informatica.• Cloud & Data POC: Integration and processing of Parquet files from Amazon S3 with Databricks.Benefits:✓ BI Optimization: Reduction of Power BI response times and improvement of tabular models. ✓ Enhanced Decision-Making: Implementation of precise KPIs for more efficient financial analysis. ✓ Data Governance: Standardization and strengthening of data quality control.Technical Environment: Azure Synapse Analytics, Databricks, Delta Lake, PySpark, SQL, DAX, Power BI, Azure Analysis Services, Azure DevOps, Visual Studio 2019, Informatica
Recommendations
Be the first to recommend Hicham
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Microsoft Certified: Azure Data Engineer Associate2020Microsoft Certified: Azure Data Engineer Associate
- Microsoft Certified Business Intelligence IT Professional2012Microsoft Certified Business Intelligence IT Professional