Freelancer profile translated to English.
Back to original languageAbout Mohamed
Senior Data Engineer with over 5 years of experience and certified Databricks Data Engineer, I design and industrialize cloud and on-premise data platforms with high business value. I work on complex environments around Snowflake, Azure Databricks, DBT, Apache Airflow, Microsoft SQL Server, and Semarchy, in contexts of migration and data maturity advancement in large accounts. Comfortable with Medallion architectures, governance, and CI/CD, I am quickly operational.
English
Native or bilingual
French
Native or bilingual
Italian
Fluent
Arabic
Native or bilingual
Can work on-site
Paris (up to 50km), Dijon (up to 50km), Lyon (up to 20km)
Experience
- Maroquinerie Thomas Semur-en-AuxoisData EngineerLUXURY GOODSFebruary 2023 - October 2025 (2 years and 8 months)Semur-en-Auxois, France
- Migration of a SQL Server Data Warehouse to **Snowflake**, including schema redesign, load automation, cost optimization, and implementation of roles & governance.
- Design of a Medallion architecture (Bronze / Silver / Gold) to industrialize pipelines and improve data quality, traceability, and governance.
- Implementation of external Snowflake stages (AWS S3) and Snowpipe for automated, near real-time data ingestion.
- Development of robust analytical models with dbt Core: incremental models, automated tests, documentation, Jinja macros, and adherence to dbt Best Practices.
- Orchestration of transformations via Airflow (Docker): scheduling dbt jobs, monitoring, dependency management, and triggering based on data freshness.
- CI/CD Automation : SQL linting, execution of dbt tests, packaging, and deployment to Snowflake.
- Advanced optimization of SQL & Snowflake performance (refactoring complex queries, warehouse optimization, logical clustering & partitioning).
- Data Governance: implementation of Snowflake Data Masking Policies, security rules, access control, and fine-grained permission management.
- Construction and maintenance of data pipelines with Python, Snowpark, SnowSQL, SSIS, integrating heterogeneous sources (JD Edwards, Cegid, Octime, APIs).
- Proactive administration of SQL Server environments (backups, restore, indexes, statistics, performance monitoring).
- Crédit Mutuel Euro-InformationData EngineerBANKING AND INSURANCEJuly 2021 - January 2023 (1 year and 6 months)21000 Dijon, France
- Design and write functional and technical specifications.
- Design and maintain (BATCH) data pipelines to feed a Vertica Data Warehouse with Semarchy (Stambia) ETL.
- Design of dimensional & analytical data models (star, snowflake, Data Vault) and normalization of business standards with PowerDesigner.
- Optimization of SQL processes and automation of processes.
- Design and implementation of business Datamarts on a Vertica Data Warehouse, to structure access to analytical data.
- Collaborative work with Git (branches, merge requests, code review) and automation of deployments via GitLab CI/CD.
- MANUF FRANC PNEUMATIQ MICHELINData EngineerTRANSPORTATIONJuly 2020 - July 2021 (1 year)Clermont-Ferrand, France
- Azure infrastructure provisioning via ARM Templates : creation and configuration of Azure Data Lake, Azure Databricks, Azure Synapse Analytics resources, and associated dependencies (networks, permissions, secure access).
- Ingestion & Orchestration : Development and orchestration of ingestion pipelines via Azure Data Factory to integrate data from Google Analytics, Salesforce CRM.
- Storage & Structuring : Design and implementation of an optimized storage architecture in Azure Blob Storage based on Delta Lake tables, including data organization, partitioning strategies, and lifecycle management best practices.
- Spark & Databricks Optimization : Advanced performance optimization with Adaptive Query Execution (AQE), broadcast joins, partitioning strategies, data skew management, and Delta Lake optimizations (OPTIMIZE, Z-ORDER, compaction).
- Data Transformation : Design and development of processes in Databricks following the Medallion architecture (Bronze/Silver/Gold) to clean, normalize, and prepare analytical data.
- Modeling & Warehousing : Populating analytical tables in Synapse Analytics, optimizing models for marketing needs (acquisition, campaign performance, conversion).
- Quality & Reliability : Implementation of quality controls, monitoring, and technical documentation of pipelines.
- Exposure & Reporting : Preparation of datasets for Data/Marketing teams and contribution to the creation of dashboards in Power BI.
Recommendations
Be the first to recommend Mohamed
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
- Master Statistics and Data ProcessingUniversité Clermont AuvergneMaster Statistiques et Traitement de Données
- Bachelor's Degree in Mathematics and Applied Computer ScienceUniversité Clermont AuvergneLicence Mathématiques et Informatique Appliquées
Certifications
- Databricks Certified Data Engineer AssociateDatabricks Academy