Analytics Engineer, Data Instructor at Le Wagon, and solo founder building AI products. I design and ship data pipelines end-to-end — from raw API to production dashboard.

Previously: pharmacist 🧪 → retail manager 🏪 → data 📊

Currently based in France, working globally.

profile = {
    "role":       "Analytics Engineer",
    "teaching":   "Le Wagon (SQL, Python, BigQuery, Power BI)",
    "building":   ["AuditGuard AI", "LIFO.AI"],
    "stack":      ["dbt", "BigQuery", "DuckDB", "Prefect", "FastAPI"],
    "available":  True,  # open to freelance missions
}

End-to-end analytics platform on French railway punctuality (SNCF Open Data). Python ingestion with Strategy Pattern, dbt transformation (staging → marts), and a Streamlit dashboard with DuckDB/BigQuery backend switching.

Stack:

→ Streamlit Dashboard
→ github.com/slimane-lakehal/ferrodata

Production-grade analytics engineering pipeline on the Olist e-commerce dataset. Full Medallion architecture with dbt Core + DuckDB, 25+ tests, automated CI.

Stack:

→ github.com/slimane-lakehal/dbt-analytics-showcase

End-to-end ELT pipeline tracking GitHub trending repos. GitHub API → DuckDB → dbt → Evidence.dev dashboard. Orchestrated with Prefect, running on a daily schedule.

Stack:

→ github.com/slimane-lakehal/modern-data-pipeline

🛡️ AuditGuard AI [building]

Compliance automation SaaS — scans Google Drive for exposed PII, API keys, and passwords. Generates audit-ready reports for SOC2 / GDPR / HIPAA.

Next.js · FastAPI · Supabase · Inngest

🌱 LIFO.AI [beta]

Food waste reduction platform for retail stores. Intelligent scoring engine predicting expiry risk per product, with Square POS integration.

Python · FastAPI · Supabase · Square API