About Hugo
French
Native or bilingual
English
Fluent
Experience
- SNCFAutomation & Data Engineer - DBT · AWS · DockerTRANSPORTATIONFebruary 2025 - Today (1 year and 4 months)Paris, FranceAs an Automation & Data Engineer, I supported Captrain Holding, a subsidiary of SNCF, in building and automating its data ecosystem on AWS with DBT, to centralize, make reliable, and standardize data flows from multiple internal and partner systems.My role was to design, structure, and orchestrate data pipelines to automate the collection, transformation, and provision of business data in a secure and maintainable environment.Here is my scope of intervention:✦ Data collection from various business systems and group APIs with Python on AWS✦ Data Warehousing on AWS, Data Modeling, and Data Transformation on DBT✦ Database Management on PostgreSQL✦ Process automation on AWS, testing, documentation, and automated deployment of DBT models✦ Orchestration and monitoring of pipelines with AWS, centralized management of logs and exceptions✦ Cloud deployment and infrastructure security via AWS with a FinOps and scalability approachMy collaboration with Captrain allowed them to:✦ Automate the entire data collection and transformation process✦ Improve the quality, reliability, and availability of business information✦ Reduce operating costs and human errors through centralization and automatic supervision✦ Accelerate the production of reports and analyses for data and business teams✦ Enhance the security and compliance of data processingMy objective was to provide Captrain with a robust, automated, and scalable data infrastructure, aligned with the needs of business and technical teams. I acted as a strategic partner, ensuring the performance, transparency, and added value of their data on a daily basis.
- LeetchiAutomation & Data Engineer - DBT · Snowflake · AWS · DockerBANKING AND INSURANCEMarch 2025 - September 2025 (6 months)Paris, FranceAs an Automation & Data Engineer, I assisted the iRaiser entity of the Leetchi group in the complete construction of its Data Warehouse on Snowflake and AWS with DBT.My role was to design and industrialize data pipelines from multiple sources such as Stripe, Paypal, and Airtable, to centralize them and provide a unified, reliable, and usable vision to business teams through the design of a Data Warehouse on Snowflake and data transformation with DBT.Here is my scope of intervention:✦ Data collection from external APIs (Stripe, PayPal, Ingenico, HubSpot, Airtable, etc.) with Python on AWS✦ Data Warehousing and Data Modeling on Snowflake: implementation of the medallion architecture, environment management, and optimization of usage costs✦ Automated transformation, testing, and documentation with DBT Cloud and CI/CD integration✦ Orchestration and monitoring of flows with AWS and centralized exception manager✦ Cloud deployment and infrastructure security via AWS with Terraform, following a FinOps and scalability approachMy collaboration with iRaiser allowed them to:✦ Centralize all data within a unique and automated data warehouse✦ Improve data reliability and quality through a modular and tested architecture✦ Reduce operating costs and maintenance time through automation and cloud resource optimization✦ Accelerate the production of dashboards and analyses for BI and Finance teamsMy objective was to provide iRaiser with a data infrastructure capable of evolving with its needs. I acted as a trusted technical partner, ensuring the performance, reliability, and valorization of their data.
- DatAI EngineeringAI Automation - n8n · Make / Data Engineer - DBT · Snowflake · AWSSOFTWARE PUBLISHINGOctober 2024 - Today (1 year and 8 months)Paris, FranceAs an Automation & Data Engineer, I have assisted several companies in automating their processes, automatically retrieving data, and orchestrating it through the design of data pipelines, the implementation of data warehouses, and the automatic distribution of their data.My role is to support you from needs definition through the drafting of specifications, to implementation, project management, and delivery.Here is my scope of intervention:✦ Automated data collection from REST APIs, GraphQL APIs, WMS, or via web scraping or any other internal/external sources, with Python on AWS to store it in the data warehouse on Snowflake✦ Data Warehousing and Data Modeling on Snowflake: structuring, normalization, storage and usage cost optimization✦ Transformation and automation with DBT, CI/CD integration, management of tests and documentation✦ Orchestration, supervision, and automation of your data pipelines with AWS or Airflow + alerting and monitoring✦ Cloud deployment and industrialization on AWS with Docker, Terraform, and automated CI/CD pipelinesMy collaboration has enabled my clients to:✦ Centralize their data in a unique, secure, and maintainable environment✦ Make better strategic decisions for their organization✦ Automate internal processes✦ Reduce infrastructure costs through a FinOps approach on AWS, Snowflake, and dbt Cloud✦ Automate their data flows and eliminate time-consuming manual interventions✦ Accelerate the availability of dashboards and decision-making analyses on Tableau, Power BIMy goal is to provide your company with a reliable, automated, and cost-effective data infrastructure, perfectly tailored to your needs. I act as a true technical partner, so you can focus on the business value of your data and leverage it fully.
Reviews
Recommendations
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
- Master, Artificial Intelligence and Big DataESGI2024Délégué de promotion Projet phare : Participation au développement d’un drone autonome avec reconnaissance faciale des étudiants pour automatiser la gestion des présences d'une promotion ✦ Compétences techniques et méthodologies acquises Ingénierie logicielle : Conception d’applications avec maîtrise des principaux langages de programmation (Python, R, Rust et Scala) et des normes/outils de développement (SOLID, Design Patterns). Cloud : Management des services cloud sur AWS, préparation au passage de la certification AWS. Utilisation du cloud AWS pour les projets annuels avec les services (EC2, S3, RDS, Lambda). Intelligence Artificielle : Création de modèles de Machine Learning, Deep Learning et d'algorithmes de Deep Reinforcement Learning avec Tensorflows, Keras, Scikit-Learn et Pytorch. Ingénierie des systèmes : Expertise en systèmes d’exploitation (Linux, Windows), gestion des bases de données (SQL, NoSQL, SGBD). Ingénierie micro-réseau : Connaissance approfondie des protocoles de communication et des environnements de développement/exploitation. Ingénierie Big Data : Structuration et synthèse de grandes quantités de données (Spark, Hadoop), avec une expertise en outils modernes d'analyse et de visualisation (PowerBI, Streamlit). Consultant en systèmes d’information : Analyse de l’existant, modélisation et optimisation des architectures de systèmes d’information. Chef de projet : Gestion et animation d’équipes, planification stratégique, et direction de projets complexes liés à l’intelligence artificielle et aux données en suivant les méthodes agiles SCRUM et Kanban. ✦ Projets transversaux Dalila : Plateforme de benchmarking et de gestion de projets de Machine Learning réalisée avec Symfony, Svelte, Python, AWS, Docker. Genomia : Modèles de Machine Learning pour détecter les séquences promotrices des brins d'ADN réalisés avec Python, Tensorflows, Keras, Scikit-Learn, Docker et AWS. Investic : Plateforme de prédictions immobilière et foncières sur toute la France (33 millions de biens) réalisée avec Symfony, Svelte, Python, AWS, Docker. Résumé : Une formation polyvalente combinant expertise technique, compétences en gestion et méthodologies avancées, adaptée aux défis actuels en IA et Big Data.
- General Computer Science Degree, Computer Programming and Project ManagementConservatoire National des Arts et Métiers2022✦ Major de promotion - 16,04 de moyenne aux examens. ✦ Activités et associations : Délégué et représentant de la promotion et des élèves de la licence pour le CNAM Hauts-de-France. ✦ Code diplôme : LG02501A. Durant ma formation, j'ai acquis une solide expertise dans le domaine du développement logiciel et de la gestion de projets informatiques. Voici quelques-unes des compétences clés que j'ai développées : ✦ Réalisation d'un projet en collaboration avec les Scouts et Guides de France. ✦ Développement de deux PoC avec Symfony, React et Docker. ✦ Administration de serveurs et déploiement d'applications web, démontrant ma capacité à gérer efficacement des environnements cloud comme AWS. ✦ Création de pipeline d'intégration et de déploiement (CI/CD), automatisant les tests et les processus de déploiement pour assurer une livraison rapide et fiable. ✦ Préparation et obtention du TOEIC et du projet voltaire (major de promotion pour voltaire).
Certifications
- dbt FundamentalsDBT2024
- Hands-On Essentials: Collaboration, Marketplace & Cost Estimation WorkshopSnowflake2024