Freelancer profile translated to English.

Back to original language

Description

Data Engineer for 5 years with extensive experience in the insurance sector, I work on various data-related topics.

Here are the tasks I regularly handle:

**Analytics Engineering / Data Engineering**:

- Database migration to a modern stack (Snowflake, DBT, Python)

- Data collection and integration (API, Databases, Datawarehouses, Datamart, Datalake, SQL...)

- Data transformation in Extract, Transform, Load (ETL) and/or Extract, Load, Transform (ELT) mode (DBT, Talend)

- Optimization and reliability of data pipelines (SQL, CI/CD)

- Data Orchestration (Azure DevOps, Airflow, Jenkins)

- Data quality improvement

- Database documentation

- Creation and maintenance of data aggregation tables for analytical needs.

- Automation of recurring tasks and internal processes to improve team efficiency

- API creation for data restitution and availability (FastAPI)

- Application creation (Streamlit)

**BI Consultant / Data Visualization / Data Analyst / Business Analyst**:

- Dashboard creation for strategic decision-making

- Commercial dashboard creation for sales monitoring and management

- Marketing data extraction

- Facilitation of business workshops for requirements gathering

- Dashboard presentation to guide users and aid understanding

My main goal is to provide solutions and value through data by helping you solve your challenges.

I can easily simplify technical subjects and I am also very proactive and autonomous in my assignments.

Feel free to contact me to learn more about how I can help you address your challenges!

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Lille (up to 50km)

AG2R LA MONDIALE - GIE AG2R
Analytics Engineer
BANKING AND INSURANCE
October 2025 - Today (10 months)
Lille, France
Participation in the project to migrate the Data environment to a stack comprising DBT, Google Cloud Platform (GCP), BigQuery, and Airflow:
- I created optimized and documented DBT models (incremental, snapshots) for BigQuery (partitioning, clustering, CTEs...).
- I automated documentation generation by implementing DBT packages (dbt-utils, codegen).
- I implemented automatic tests on DBT to ensure data quality.
- I set up a development and automation process on DBT to ensure best practices in model development using Python (invoke, subprocess, GitLab CI).
- I orchestrated these models via Airflow DAGs (Cosmos).
- I optimized historical SQL queries to improve their performance (processing time, data volume processed).
DBT Data Migration Google Cloud Platform (GCP) BigQuery Airflow
Mutuelle GSMC
Data Engineer
BANKING AND INSURANCE
September 2021 - Today (4 years and 11 months)
Lille, France
La Mutuelle GSMC is a health and provident mutual society existing for over 80 years and covering more than 200,000 members in France.

I joined the Data team, whose mission is to collect, centralize, and redistribute all incoming data to help General Management and sales teams make the best strategic decisions.

Responsibilities:

- Migration of the company's data warehouse to a modern technical stack (Snowflake, DBT, Python, Azure DevOps)
- Building end-to-end data pipelines (file retrieval, validation, integration, orchestration, deployment...)
- Technical referent in data quality processing
- Ensuring reliability and optimization of data pipelines
- Automating internal company processes using Python, saving several hours per week
- Implementation of the company's Business Intelligence tool
- Gathering requirements and facilitating workshops to best meet user needs based on received data
- Building a reporting tool centralizing all management data, used daily by a team of 20 salespeople on the Business Intelligence solution
- Developing a set of reports to add value to all data used in various departments (Sales, Audit, Fraud, Legal, Accounting...)
- Integrating received data into a unified model to ensure consistency and facilitate its use
- Training and supporting the skill development of new internal technical profiles

Environment: Snowflake, DBT, Python, Microsoft Azure DevOps
Data Engineer DBT Snowflake Azure DevOps Python
Mutuelle GSMC
Data Engineer
BANKING AND INSURANCE
March 2021 - September 2021 (6 months)
Lille, France
La Mutuelle GSMC is a health and provident mutual society existing for over 80 years and covering more than 200,000 members in France.

I joined the Data team, whose mission is to collect, centralize, and redistribute all incoming data to help General Management and sales teams make the best strategic decisions.

Responsibilities:

- I participated in the initial phase of the data warehouse construction project using PostgreSQL, Talend, and Jenkins tools.
- Cleaning historical data files to enable their integration.
- Building the first data pipelines using Talend to integrate historical files into the data warehouse.
- I participated in the implementation of the company's BI tool and built the first reports.
- I participated in the management of the CRM improvement project, particularly regarding the quality of data integrated into it.

Technical Environment: PostgreSQL, Talend, Jenkins, Git
PostgreSQL Talend Open Studio Jenkins Data Engineer Git