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

Ancelin Lavaux

Data Engineer | Expert Snowflake | DBT | Power BI

€500/day
Lille, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Ancelin

Data Engineer | Expert Snowflake, SQL & Power BI | 8 years of experience

I am a **Data Engineer specializing in Snowflake, Power BI, DBT, and Talend**, with comprehensive experience ranging from data ingestion to visualization. My role is to implement reliable, documented, and scalable data solutions that enable decision-makers to quickly access quality insights.

I have already assisted companies in various contexts: migrating data warehouses toSnowflake**, implementing transformation models with **DBT or Talend**, automating ETL/ELT pipelines, and creating clear reports and dashboards in **Power BIfor tracking key indicators.My goal is always to reduce the time between raw data and business decisions.

My approach is turnkey: I design a solid architecture, ensure data quality and governance, and deliver stable pipelines that are easy to maintain and evolve. This provides you with a reliable foundation for your analyses and smooth reporting for your teams.

On the tech stack side, I primarily work with **Snowflake, DBT, Power BI**, and major cloud integration tools. I adopt an agile methodology with frequent deliverables and clear communication, to ensure transparent progress aligned with your business priorities.

If you are looking for a Snowflake / Power BI / DBT Data Engineer capable of transforming your data into a true decision-making lever, I invite you to connect for a video call to define your needs.I respond quickly and can start within a few days.
  • French

    Native or bilingual

  • English

    Fluent

Can work on-site
Lille (up to 50km), Paris (up to 50km), Bruxelles (up to 50km)

Experience

  • Credit Agricole Consumer Finance
    Data Engineer / Project Manager | Snowflake | Talend | Power BI
    BANKING AND INSURANCE
    July 2024 - Today (1 year and 11 months)
    Roubaix, France
    → Mission Objective:
    Implement and industrialize reliable data pipelines for new Sofinco applications as part of a migration of **all data to Snowflake**.

    → Achievements:

    Designed integration workflows withTalend / DBT and SQLto automate flows, improve data quality, and reduce processing times.

    Modeled and created data structures inSnowflaketo enhance performance, ensure scalability, and make the data architecture reliable.

    Coordinated and managed data projects to align stakeholders, secure deadlines, and maximize the business impact of deliverables.

    → Technical Stack:
    Snowflake, Talend, DBT, SQL, Python
    Snowflake Python Talend Git DBT
  • Norauto
    Data Engineer | Snowflake | Semarchy xDi | DBT
    TECH
    January 2024 - July 2024 (6 months)
    Lille, France
    → Mission Objective:
    Design and optimize reliable data pipelines to improve the quality, availability, and utilization of business data in reports on Tableau Software.

    → Achievements:

    Deployed integration flows with Stambia and SQL to centralize data, reduce silos, and improve the speed and reliability of processing.

    Optimized data structures in Snowflake to increase query performance and reduce access times to strategic information.

    Created dynamic dashboards with Tableau Software to accelerate decision-making and provide better business visibility.

    Developed Python code for Snowflake procedures for certain processes where Stambia usage was not optimal.

    → Technical Stack:
    Snowflake, Stambia, SQL, Python, Tableau Software
    Snowflake Stambia MySQL Git Tableau software
  • Creditsafe
    Data Engineer / Project Manager | Snowflake | Semarchy xDi | Power BI
    BANKING AND INSURANCE
    February 2022 - December 2023 (1 year and 10 months)
    Roubaix, France
    → Mission Objective:
    Lead data development activities, from tool standardization to team management, to build and optimize a robust and high-performing decision-making ecosystem.

    → Achievements:

    Led the development team (2 interns): defined standards, code reviews, and project management to structure and ensure the quality of deliverables.

    Designed and automated complex data flows with Stambia to consolidate information from heterogeneous sources (databases, APIs, files).

    Managed various client extractions done via SQL / Stambia and created via a generalized template developed by myself (+400 client extractions).

    Modernized task scheduling and monitoring by integrating Python and Airflow into the data ecosystem.

    Created Power BI reports to transform raw data from the data warehouse into visual and actionable analyses for business teams.

    Benchmarked different databases with a view to migrating to a database better suited to various business needs (Snowflake).

    → Technical Stack:
    Snowflake, Stambia (xDi), Power BI, Python, Airflow, Aurora MySQL, Oracle, Redshift
    Stambia Snowflake Microsoft Power BI SQL Python

Recommendations

Aurélie DuynslaegerAD
Eddy BoughanmiEB
Pascal ReynierPR
+2
Aurélie Duynslaeger and 4 other people have recommended Ancelin

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

  • Computer Science and Statistics
    Polytech Lille
    2017
    Informatique et Statistiques
  • Mathematics and Physics
    Institut Emmanuel d'Alzon, Nîmes
    2014
    Mathématiques et Physique

Skill set

Categories