Freelancer profile translated to English.
Back to original languageAbout Mehdi
Senior Data Consultant with a dual role as Data Analyst / Analytics Engineer, I have been working for over 6 years with major clients (𝐒𝐜𝐡𝐧𝐞𝐢𝐝𝐞𝐫, 𝐂𝐡𝐚𝐧𝐞𝐥, 𝐓𝐨𝐭𝐚𝐥𝐄𝐧𝐞𝐫𝐠𝐢𝐞𝐬, 𝐒𝐨𝐢𝐭𝐞𝐜, 𝐒𝐩𝐅) to build decision-support solutions.
Versatile across multiple technologies, I have particular expertise in Power BI and dbt.
𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐞𝐝 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 (𝐏𝐋-𝟑𝟎𝟎, 𝐃𝐏-𝟓𝟎𝟎), 𝐅𝐚𝐛𝐫𝐢𝐜 (𝐃𝐏-𝟔𝟎𝟎) 𝐚𝐧𝐝 𝐝𝐛𝐭 (𝐚𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫)
🎯 𝐖𝐇𝐀𝐓 𝐈 𝐁𝐑𝐈𝐍𝐆 𝐓𝐎 𝐘𝐎𝐔𝐑 𝐏𝐑𝐎JECT𝐒:
I work on end-to-end analytical projects, from multi-source ingestion to reporting, to transform raw data into actionable indicators.
➊ 𝐃𝐚𝐭𝐚 𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧 :
- Analysis and requirements gathering with users
- Data preparation on PowerQuery and calculations in DAX
- Creation of intuitive and user-friendly Power BI dashboards, focused on fluidity and business impact
- Optimization of the performance of your existing reporting
- Training business users on Power BI to maximize adoption
➋ 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫𝐢𝐧𝐠 :
- Automate integration pipelines with dbt
- Medallion architecture, Data Warehousing and star schema (SQL/dbt)
🛠️ 𝐌𝐲 𝐓𝐨𝐨𝐥𝐛𝐨𝐱 :
𝐒𝐐𝐋, 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈, 𝐓𝐚𝐛𝐥𝐞𝐚𝐮, 𝐝𝐛𝐭, 𝐒𝐧𝐨𝐰𝐟𝐥𝐚𝐤𝐞, 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐅𝐚𝐛𝐫𝐢𝐜, 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐀𝐳𝐮𝐫𝐞, 𝐏𝐲𝐭𝐡𝐨𝐧
🎖️ 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬 :
✔️ Microsoft PL-300 (Power BI Analyst)
✔️ Microsoft DP-500 (Azure Enterprise Data Analyst)
✔️ Microsoft DP-600 (Fabric Analytics Engineer)
✔️ dbt Analytics Engineer
French
Native or bilingual
Can work on-site
Paris (up to 50km)
Experience
- Santé publique FranceAMOA / Analytics EngineerPUBLIC SECTOROctober 2024 - May 2026 (1 year and 7 months)Paris, FranceModernization of a critical analytical platform serving +200 health professionals: modeling of data pipelines integrating 4 heterogeneous sources and +50 MDM repositoriesMy actions
- Gathering and framing user needs through interviews and workshops
- Planning and coordination with various stakeholders (IT, business, technical)
- Writing project documentation: specifications and functional technical specifications
- Designing a medallion architecture on Snowflake (Bronze/Silver/Gold)
- Creating analytical reports on Tableau and Superset
- Integrating business rules into dbt tests to ensure data integrity (Jinja Macro, SQL, YAML)
- dbt modeling: staging, intermediate, and mart layers, SQL optimization, documentation, and lineage
- Structuring the project and ensuring strategic alignment between IT, business, and the technical team
- Facilitating and preparing development phases with comprehensive specifications and functional technical specifications
- Participating in launching a complex project that had experienced 2 previous failures
- ChanelConfirmed PowerBI ConsultantLUXURY GOODSJanuary 2024 - June 2024 (5 months)Paris, FranceDevelopment of an end-to-end reporting application on Power BI for Chanel – Fashion department.**Impact**:• Complete automation of data extraction and KPI preparation, eliminating manual Excel processing• Reduction of errors by eliminating human intervention on data files• Instant and centralized access to KPIs for business teams**Actions**:• Facilitating co-design workshops and creating mockups with users to align dashboards with analytical needs• Data cleaning and star schema modeling with DAX and Power Query• Creation of intuitive dashboards to facilitate monitoring and decision-making• Application of a strict data validation protocol (UAT) to ensure reliability• Training end-users and transferring skills to ensure solution adoption
- SOITECData ConsultantNANO-TECHNOLOGYApril 2021 - September 2023 (2 years and 6 months)Grenoble, FranceI worked collaboratively with multidisciplinary teams (Data Analysts, Data Engineers, Application Owners, and business experts) to provide analytical solutions to various company departments (equipment, purchasing, sales, production, etc.):**As an Analytics Engineer**:
- **Integration**: collection and cleaning of multi-source data (ERP, Salesforce, MES, flat files, etc.)
- **Pipelines**: development of complex data flows (ETL) for populating databases
- **Modeling**: implementation of optimized Datamarts (SQL): star modeling, creation of views
- Steering andcostingof solutions, development of technical proposals, and commitment to delivery deadlines.
*User supportto identify new insights and structure their data needs.*Creation of reportsand clear dashboards focused on decision support on Power BI*Performance improvement of existingPower BI models via DaxStudio and the application of best modeling practices*Migrationof dashboards from SAP BO to Power BI- Technical lead on the tool,trainingover 50 daily users and sharing development standards
- **Governance**: Management of access and workspaces, creation and dissemination of a Data Catalog
Technologies: PowerBI, BusinessObject, SQL Oracle, BODS, Talend, Git
Reviews
Recommendations
Be the first to recommend Mehdi
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
- M2 Information Systems Management and Data IntelligenceIAE (UGA)2019M2 Management des Systèmes d'information et Intelligence des données
- Industrial Engineering and Innovation EngineerEcole Polytechnique of Algiers.2018Ingénieur génie industriel et Innovation
Certifications
- DP 500 - Azure Enterprise Data Analyst AssociateMICROSOFT2023
- PL 300 - Microsoft Power BI Data AnalystMICROSOFT2021