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

Ilan Cohen

Data Architect

€850/day
Genève, CH
3-7 years

Average response time: 1 hour

About Ilan

Background
12+ years in corporate and private banking (HSBC, Barclays) before transitioning to data and AI systems. I understand how businesses operate, not just how databases work. I build data foundations and AI systems that serve the business logic - not the other way around.

What I build
Data architectures that make AI actually useful. Ingestion from any source (PDFs, legacy systems, scraped data, vendor exports, APIs), structured around the specific business question, then AI on top - chat interfaces grounded in your data, autonomous agents, automated workflows. I currently run production agents 24/7 across multiple databases, curating and cleaning data continuously. Shipped systems include Lamap, LBI, Camelote, and several SaaS replacements - all data + AI products live in production.

How I work
Fast scoping. Clear communication. Working systems delivered in 4 to 8 weeks. No endless discovery, no over-engineering. You get clean architecture, documented schemas, full ownership of the code, and something your team can maintain after I leave. When clients want the system kept alive long-term, I operate it on retainer.

Stack
Supabase, PostgreSQL, Edge Functions, Claude and OpenAI APIs for AI orchestration, Lovable for rapid product delivery (top 1% user globally), custom pipelines for automation. I don't write Python or heavy backend services - I design data systems and ship AI-native products with modern tooling.
  • French

    Native or bilingual

  • English

    Native or bilingual

  • Hebrew

    Fluent

Can work on-site
Genève (up to 50km)

Experience

  • Big Data LLC
    Database Architect | Supabase, PostgreSQL, Data Infrastructure
    TECH
    March 2023 - Today (3 years and 4 months)
    Genève, Switzerland
    I design and build production-grade databases and data infrastructure, primarily on Supabase/PostgreSQL.
    Recent work:
    Built the entire data backend for Lamap.ch, a real estate intelligence platform with +100k property records, +100 tables, complex relational schemas, owner-matching algorithms, and a bronze/silver/gold data pipeline. Zero legacy debt. Scales cleanly.
    What I deliver:
    → Database architecture from scratch or restructuring existing chaos
    → Complex PostgreSQL schemas, RLS policies, Edge Functions
    → Data pipelines and ETL logic
    → Admin dashboards and internal tools (Lovable & similar)
    Best fit:
    You have data that needs structure. Or a product that needs a real backend. Or a Supabase project that's grown messy. You want someone who thinks in systems, not just tasks.
    Geneva-based. French, English, Hebrew.
  • HSBC Private Bank (Suisse) SA
    Relationship Officer
    BANKING AND INSURANCE
    September 2022 - January 2025 (2 years and 4 months)
    Genève, Switzerland
    Managed $1.5B+ in client portfolios across UHNW clients. Handled KYC, onboarding of complex structures, and compliance processes. Relevant to data work: operated within strict data governance frameworks, managed sensitive client data, redesigned internal workflows.
    Wealth Management KYC Banking and Financial Services avaloq
  • Lamap SA
    CEO
    REAL ESTATE
    February 2022 - Today (4 years and 5 months)
    Genève, Switzerland
    Built a real estate intelligence platform from scratch covering all Geneva property ownership and transactions since 1994. Designed the full data architecture: 100,000+ records, owner-matching algorithms, bronze/silver/gold data pipeline. Stack: Supabase, PostgreSQL, Edge Functions. Managed data scientists and developers. Handled large-scale data restructuring, cleaning, and normalization from fragmented public sources.
    Supabase PostgreSQL Data architecture ETL Web Scraping

Recommendations

Be the first to recommend Ilan

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

  • Series 3
    National Futures Association
    2008

Skill set

Categories