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

Jan Aubert

Data Engineer & ETL Specialist

€350/day
1 project
Barcelona, ES
3-7 years

Average response time: 1 hour

About Jan

Je résous vos problèmes techniques : intégration de systèmes, automatisation, migration de données et développement WordPress.

Data Engineer & Développeur avec 3+ ans d'expérience, je travaille avec des PME et e-commerçants en Europe.
Ma spécialité : transformer vos processus manuels en systèmes automatisés qui fonctionnent sans intervention.

Mon expertise :
Développement web & automatisation Sites WordPress : setup, migration, personnalisation Elementor Scripts Python pour automatisation de tâches répétitives Intégration d'APIs REST et webhooks JavaScript/TypeScript pour applications web Connexion de deux plateformes qui ne se parlent pas (ex: WooCommerce ↔ ERP, PrestaShop ↔ fournisseur)

Ingénierie de données & ETL Pipelines ETL avec Talend, KNIME et Python Intégration de données multi-sources (APIs, bases de données, cloud) MySQL, PostgreSQL, modélisation de données pour e-commerce et retail Migration et transformation de bases de données legacy Automatisation de workflows complexes

Projets typiques : Setup de sites WordPress professionnels clé en main Migration de systèmes de données entre plateformes Construction de pipelines d'intégration end-to-end Automatisation de processus manuels (réduction de 70-80% du temps) Nettoyage et structuration de bases de données produits

Mes atouts : Quadrilingue : français, espagnol, catalan, anglais Expérience avec clients internationaux (France, Suisse, pays nordiques) Autonome : je prends vos specs et livre sans micro-management Focus résultats : votre problème résolu, pas juste du code
Stack technique : Python, SQL, JavaScript/TypeScript, Talend, KNIME, MySQL, PostgreSQL, APIs REST, WordPress, Git

Basé à Barcelone, 100% remote. Disponible pour missions courtes ou projets long-terme.
  • French

    Native or bilingual

  • Catalan

    Native or bilingual

  • Spanish

    Native or bilingual

  • English

    Fluent

  • Italian

    Basic

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

Experience

  • Nousmedis
    Data Analyst - ETL Developer
    E-COMMERCE
    June 2023 - Today (3 years and 1 month)
    Barcelona, Spain
    • • Design and maintain ETL pipelines using Talend and KNIME to process data from 5+ supplier data sources
    • • Built custom TypeScript integration syncing 3,000+ products between Saleslayer PIM and Synkka e-commerce platform
    • • Automated catalog production workflows, reducing manual data processing from 20 hours/ week to 2 hours
    • • Develop data models and transformations for multi-language product catalogs (ES, DE, EN, FR)
    • • Create data quality checks and validation rules to ensure 95%+ data accuracy
    • • Consult with clients on PIM implementation and data integration strategies pipeline handling different schemas (MySQL, PostgreSQL, CSV), with automated error detection and monitoring
    ETL Data integration (ETL, ELT and data warehousing) SQL Python Talend
  • VisualKorner
    Web Developer & Database Administrator
    E-COMMERCE
    January 2022 - September 2023 (1 year and 8 months)
    Barcelona, Spain
    • • Automated product imports using Bash scripts and SQL procedures for PrestaShop e-commerce
    • • Managed web server infrastructure and implemented automated backup systems with cron
    • • Developed bulk data processing scripts handling 10,000+ products per batch
    Bash Prestashop Wordpress
  • MarcoPolo Direct
    Junior Developer
    DIGITAL AND IT
    January 2017 - January 2020 (3 years)
    Albi, France
    Developed custom PHP modules and extensions for PrestaShop e-commerce platform, including payment gateway integrations, shipping calculators, and customer-facing features that enhanced user experience and conversion rates

    Designed and maintained relational SQL databases for product catalogs, customer orders, and inventory management, writing optimized queries and stored procedures to support high-traffic e-commerce operations

    Implemented data migration scripts to transfer historical customer and order data from legacy systems to new platform architecture, ensuring data consistency and minimal business disruption

    Collaborated with cross-functional teams including marketing, customer service, and management to translate business requirements into technical specifications and deliverable features

    Performed routine database maintenance including backup scheduling, performance monitoring, and data cleanup procedures to maintain system health and reliability

Recommendations

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

  • Campus 42
    2023
    Campus 42
  • Computer Engineering
    Universitat Politècnica de Catalunya
    2020
    Computer Engineering

Skill set

Categories