
Mathieu Voirgard
Senior Data Engineer
Salary / Daily rate
Lyon, France
Mobility: Lyon
Freelance
Can come onsite
Skills
Languages
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
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