You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Amin BakhtiAB

Amin Bakhti

Analytics Engineer — dbt • Fabric • Power BI

€560/day
1 project
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Amin

Analytics Engineer / Data Engineer freelance, I design and deploy modern end-to-end data platforms to transform data into clear and reliable decision-making tools.

I address concrete issues:
- Data scattered across Shopify, CRM, ERP, Excel, and other sources
- Lack of consolidated KPIs or unreliable dashboards
- Fragile and difficult-to-maintain pipelines
- Manual data tasks to be industrialized

I build complete solutions:
- Lakehouse / data warehouse architecture (Microsoft Fabric, Azure)
- Modern ELT pipelines with dbt (Kimball modeling, tests, CI/CD)
- Data ingestion (REST APIs, native connectors)
- Relational modeling (PostgreSQL, Supabase, SQL Server)
- Workflow automation (n8n, Python)
- Power BI dashboards (Direct Lake, advanced DAX)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PORTFOLIO — AmeOS

I designed and developed AmeOS, a complete data platform for my own DTC e-commerce brand, Ame Sportswear: Medallion architecture on Microsoft Fabric, Shopify ingestion, dbt Kimball modeling, 7 Power BI dashboards (sales, margins, customer behavior, inventory).

→ Public repo: github.com/aminbkt-dev/ameos-v2

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

TYPES OF MISSIONS

- Setting up a modern data stack (Fabric, dbt, Power BI)
- Industrializing ELT pipelines
- Dimensional modeling (Kimball, star schema)
- Audit and validation of existing dashboards
- Automating data flows via n8n / Python
- Consulting on data governance and quality

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

BACKGROUND

4 years of experience: 2 years at VINCI (MDM Semarchy xDM, Power BI, governance for 200K+ employees) and freelance since October 2024.

Objective: transform complex data into industrialized platforms aligned with business steering.
  • French

    Native or bilingual

  • English

    Fluent

Can work on-site
Paris (up to 50km)

Experience

  • Ame Sportswear
    Analytics Engineer / Data Engineer
    E-COMMERCE
    October 2024 - Today (1 year and 10 months)
    Paris, France
    • Design and development of AmeOS, an internal data platform for e-commerce steering of Ame Sportswear (a modest DTC sportswear brand on Shopify, dropshipping).
    Double objective:
    → Equip brand steering (drops, margins, customer behavior, inventory).
    → Serve as an end-to-end technical portfolio on the modern data stack in a Microsoft / Azure environment.
    ━━━━━━━━━━━━━━━━━━━━━━━━━━━━
    🏗️ ARCHITECTURE & INGESTION
    - Medallion lakehouse architecture (Bronze / Silver / Gold) on Microsoft Fabric
    - Shopify Admin API ingestion via Fabric Notebooks (Python / PySpark), Delta writing to OneLake
    - Authentication via Azure Entra ID Service Principal
    - Git versioning + dbt Cloud orchestration
    🔄 DBT TRANSFORMATIONS
    - ELT pipelines: staging, intermediate, marts layers by domain (core, finance, inventory)
    - Kimball modeling: facts (sales, lines, payments, returns), dimensions (customers, products, drops)
    - Quality tests, auto-generated documentation with column-level lineage
    - CI/CD GitHub Actions
    📊 BUSINESS INTELLIGENCE
    7 Power BI dashboards in Direct Lake on the Fabric Warehouse:
    Executive Overview · Drops · Products · Costs & Margins · Velocity & Sell-through · Inventory & Projections · Customer Behavior
    Metrics: revenue, AOV, LTV, sell-through, cohort analysis, refund rate, margin per drop, stockout projections
    🧠 BUSINESS LOGIC
    - Sales attribution by drop with double-counting prevention
    - Management of time windows (active vs archived drop)
    - Modeling of returns and net margin impact
    - Cohort analysis and customer LTV
    ━━━━━━━━━━━━━━━━━━━━━━━━━━━━
    STACK
    dbt (Core + Cloud, dbt-fabric adapter) · Microsoft Fabric (Lakehouse, Warehouse, OneLake, Notebooks) · Azure (Entra ID, Service Principals) · Power BI (DAX, Direct Lake) · Python / PySpark · SQL / T-SQL · Git / GitHub Actions · Shopify Admin API
    ETL Microsoft Power BI SQL DBT Microsoft Fabric
  • VINCI SA (Holding)
    Data Engineer / MDM
    CIVIL ENGINEERING
    July 2022 - July 2024 (2 years)
    92000 Nanterre, France
    Within the Data department of the VINCI group (holding company) on the MDM program. Mission: industrialize the Semarchy xDM MDM hub to validate and centralize the group's strategic repositories (employees: 200K+, entities/divisions: hundreds).
    ━━━━━━━━━━━━━━━━━━━━━━━━━━━━
    🗂️ MDM & GOVERNANCE
    - Industrialization of the Semarchy xDM MDM hub: multi-source integration, master data management
    - Modeling of master entities (employees, entities/divisions): hierarchies, slowly changing dimensions, matching and deduplication rules
    - Design of multi-step business workflows on Semarchy xDM: orchestration of sequential tasks between teams (Data, HR, IT) with role-based permissions and automatic notifications
    📊 BUSINESS INTELLIGENCE
    - Power BI dashboards for MDM steering (repository quality, anomalies, matching performance) for the Data Director and CIO
    - Direct connection to the Semarchy xDM PostgreSQL backend via the native Power BI connector
    🔍 SQL & BUSINESS COLLABORATION
    - Advanced SQL (joins, aggregations, window functions, CTEs) for analysis and production of KPIs on golden records
    - Business stakeholder interface: requirements gathering, definition of business rules, explanation and presentation of KPIs
    🤖 CHATBOT & GENERATIVE AI TRANSITION
    Design of an internal chatbot covering the paradigm shift of conversational AI:
    → Classic NLU phase: intents, training datasets, evaluation
    → Pivot with the arrival of generative LLMs and Copilot in the Microsoft ecosystem: repositioning towards a generative conversational architecture
    First encounter with a major technological disruption. Adaptability is now central to my approach in Microsoft / Azure (Copilot in Fabric, Power BI).
    SQL Microsoft Power BI Data Analysis Business Intelligence (BI) MDM
  • Covéa
    Data Quality Analyst
    BANKING AND INSURANCE
    April 2022 - August 2022 (4 months)
    95120 Ermont, France
    • Analysis and validation of customer data in an insurance context (consistency checks, anomaly detection)
    • Participation in improving data quality for business exploitation
    • Advanced use of Excel for data cleaning, structuring, and verification
    Data Analysis Customer Relationship Management Data Quality Microsoft Excel Database

Reviews

5.0

Out of 1 rating

J

Jf

Gérant - JF Mignon

Reviewed on 4/20/2026

Development of a data modification script on Word

Recommendations

Be the first to recommend Amin

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Master Data Management
    Paris School of Business
    2024
    Master Data Management
  • Bachelor of Science in Economics and Finance
    CY Cergy Paris Université
    2022
    Licence Économie-Finance

Categories