Mathieu Voirgard

Senior Data Engineer

Salary / Daily rate

Lyon, France

Mobility: Lyon

Freelance

Can come onsite

Skills

ETLSQL databasesPythonApache Spark

Languages

English (Native)French (Native)

About me

Intro

I design and deploy robust, scalable data platforms for organisations with high-stakes business requirements. Senior Data Engineer with 15+ years of experience, I work on the most impactful projects: Data Lake architecture, real-time ingestion, cloud migration, legacy platform modernisation. Concrete results from recent engagements: → Designed a Data Lake architecture from scratch (Azure, Snowflake) for an international group of 30,000+ employees → Near Real-time ingestion pipelines

Links

Work experience

EnedisFreelance

Jun 2024 - Present

2 years 5 months

Lyon, France

Senior Data Engineer

Jun 2024 - Present

2 years 5 months

Lyon, France

Design and implementation of the data platform for the nationwide logistics tracking of Linky smart meters (deployment and after-sales service). • Architecture of a near real-time ingestion pipeline (micro-batch): Kafka → Spark → Bronze Data Lake (CEPH) → Silver historisation via Delta Lake • Business object modelling and data historisation in Oracle (PL/SQL) • Facilitating scoping workshops with business teams to formalise business rules and map partner data sources • Writing functional and technical specifications for the Oracle → Databricks migration, anticipating platform modernization • Data visualisation via Tableau Software and PowerBI for operational teams • Architecture recommendations to prevent information system obsolescence Stack : Kafka, Spark, Delta Lake, CEPH, Oracle, PL/SQL, Databricks, Tableau, PowerBI, Control M, Git, Jenkins, CI/CD, Confluence, Jira Methodology : Scrum, SAFe (ART / TRAIN), Data Mesh

Senior Data Engineer — Migration & Modernisation

Jan 2025 - Mar 2025

3 months

Lyon, France

Expert reinforcement for the migration of the data infrastructure from Oracle to PostgreSQL and adaptation of the entire ETL/BI chain. • Database migration from Oracle → PostgreSQL with flow performance optimisation • Adaptation and rewriting of Informatica ETL flows for the new PostgreSQL stack • Generation and adaptation of Tableau reporting cubes on the new Postgres database • Ensuring service continuity and data quality throughout the migration Stack : Oracle, PostgreSQL, Informatica, Tableau

Data Architect / Consultant Data

AmiltoneFreelance

Aug 2024 - Sep 2024

2 months

Lyon, France

Support in scoping responses to Data Architecture tenders for major enterprise clients. • Evaluation and recommendation of target architectures: Snowflake, Data Catalog, Data Lineage • Recommendations on ETL stack choices and Data Mesh patterns • Writing technical responses for tenders Domains : Snowflake, Data Catalog, Data Lineage, Data Mesh, ETL

Senior Data Engineer

The Adecco Group

Sep 2021 - Jun 2024

2 years 10 months

Lyon, France

Design and deployment of the new data platform (Data Architecture 2.0) for an international group of 30,000+ employees, replacing the legacy on-premise infrastructure. Adecco Data Architecture 2.0 Project : • From-scratch design of a cloud Data Lake with Azure Data Factory, Airbyte, dbt, Airflow, Terraform, Snowflake and PowerBI • Implementation of orchestration, versioning and CI/CD for all data pipelines • Industrialisation of ingestion flows to cover new use cases impossible on the legacy platform • Setup of a POC on AWS to compare solutions Oracle Exadata Migration : • Led the migration of the existing infrastructure to Oracle Exadata • Result: significant reduction in licence costs and improved ingestion and reporting performance Near Real-Time Business Intelligence Ingestion: • Design of ingestion flows: Salesforce → Oracle → MicroStrategy cubes • Modelling optimisation to ensure high availability and optimal performance across the entire chain • Delivery of new business KPIs to end users Technical Leadership: • Training and upskilling of the BI/Data team on new paradigms (Data Lake, dbt, Airflow) • Cross-functional role: implementation of development standards, performance-oriented modelling best practices, code reviews Stack : Python, Spark, Snowflake, Azure Data Factory, Airbyte, dbt, Airflow, Terraform, PowerBI, Oracle, ODI, MicroStrategy, Salesforce, Git, CI/CD

Data Platform Owner / Lead Data Engineer

The Adecco Group France

Aug 2016 - Nov 2023

7 years 4 months

Région de Lyon, France

Responsible for the stability, performance and evolution of the group's entire data platform (Oracle, MicroStrategy, Tableau, Essbase, ODI). Architecture Security & Migration: • POC for database migration (Snowflake, Teradata, Exadata, Vertica) with full benchmark of the ETL chain + MicroStrategy reporting • In-depth evaluation of costs / complexity / effort to define the long-term migration strategy Data Science : • Support and maintenance of churn prediction models (machine learning, Knime, Python, R) New Use Cases: • Development of a ChatBot via the MicroStrategy API • API integration between applications (Salesforce, MicroStrategy, mobile BI application) Audit & Security: • Responsible for auditing, remediation and security of the entire data stack Stack : Oracle, MicroStrategy, Tableau, Essbase, ODI, Snowflake, Teradata, Exadata, Vertica, Azure, Python, R, Knime, Salesforce API

Senior BI & Data Consultant

Business & Decision Group

Jan 2011 - Aug 2016

5 years 8 months

Région de Lyon, France

Senior consultant working with major accounts in the energy, insurance and mutual insurance sectors Modelling & Performance: • Database modelling optimisation for MicroStrategy reporting environments • Weekly client team support over several months to build robust and high-performing data models Standards & Best Practices: • Implementation of development standards and BI best practices aligned with group guidelines • Ensuring data quality and consistency of delivered solutions Training: • Creation of customised training guides for MicroStrategy developers, power users and clients Stack : MicroStrategy, SQL Server, PostgreSQL, Oracle, Exadata


Education

SUPINFO

Master of Science (M.S.), Information Technology

2009 - 2011

3 years

Grade: Master Bac+5 Niveau 1

Skills: Transfert des données · Data Modeling · Visualisation de données · Extract, Transform, Load (ETL) · Analyse des données · Ensemble de compétences techniques · Autonomie · Compétences analytiques · Analytique · Oracle · Sens de l’organisation · Indicateurs de performance · Anglais · Déploiement de projet · PL/SQL · SQL · Business Intelligence · Niveau élevé de précision · Delivrables · ETL · Techniques de présentation · Modélisation des données · Architecture de données · Gestion des données · Travail d’équipe · Traitement analytique en ligne · Esprit d’équipe · Oracle Database · Data Analysis · Python (langage de programmation) · Base de données · Bases de données relationnelles · Minutieux

EPITECH - European Institute of Technology

Bachelor, Expert Informatique

2008 - 2009

2 years

Skills: Transfert des données · Data Modeling · Extract, Transform, Load (ETL) · Ensemble de compétences techniques · Autonomie · Analytique · Oracle · Sens de l’organisation · Indicateurs de performance · Anglais · Déploiement de projet · PL/SQL · SQL · Business Intelligence · Niveau élevé de précision · Delivrables · ETL · Modélisation des données · Architecture de données · Gestion des données · Travail d’équipe · Traitement analytique en ligne · Esprit d’équipe · Oracle Database · Data Analysis · Python (langage de programmation) · Base de données · Bases de données relationnelles · Minutieux


Licenses & certifications

MicroStrategy MCD

Issued: Jan 2016

Certified by MicroStrategy

The best place to find your next move

© 2026. All Rights Reserved.