Senior Analytics Engineer
BI Architect & Consultant
- Background
- Senior Analytics Engineer and BI Architect with 20+ years building data platforms across several domains, among them energy, insurance, public finance, e-commerce and travel. Clients include Stedis (TotalEnergies group), the OECD, the IMF, Renault, Pernod Ricard and TUI.
- AI-assisted workflow
- I work with harness agents every day to scaffold dbt models, generate tests and documentation, and review SQL. Delivery is faster, and every output is still checked by tests before it ships, so quality goes up as well.
- How I work
- End to end, from ingestion to dashboard. Low-maintenance architectures, and tested, documented models with figures that hold up in front of a steering committee. Teams are left autonomous through documentation and knowledge transfer.
- 20+Years in data
- 26Freelance projects for 19 clients
- 5.047 Malt reviews · Super Malter
- dbtCertified · IMF & OECD expert
Selected work
All projects →-
2026
European insurer
Insurance · via ClearPeaksSnowflake architecture from ingestion to transformation, feeding AWS SageMaker, with Python duplicate detection.
Snowflake → AWS SageMaker · Splink
-
2025–2026
Stedis
Energy · TotalEnergies groupData stack modernisation · Refactored the data platform onto a modern data stack: dlt for ingestion, dbt for tested, documented transformations.
dlt → dbt → Power BI
-
2025
OECD
Tax administrationDigital approaches to fiscal reporting for Sweden and Austria. Feasibility study, AI use cases identified and ranked.
Feasibility · AI use cases · Prototypes
-
2024–2025
Stedis
Energy · TotalEnergies groupOnePricing · Medallion data lake on S3 feeding a pricing machine-learning model, with Redshift transformations and Step Functions orchestration.
S3 → AWS Glue → Redshift → SageMaker
-
2021–2024
900.care
E-commerceBuilt the data platform: 15 sources and 200 dbt models, with KPIs defined alongside the Head of Data.
Airbyte · Fivetran → BigQuery → dbt → Power BI
-
2003–2012
TUI France
Tour operator · Lead Data EngineerRevenue management and payment-fraud detection using graph analysis in SQL. Chargebacks down about 90%, roughly €1M a year.
SQL Server · SSIS · .NET
What clients say
All feedback →-
Great work from David building our data platform. Responsive and reliable, he went deep into our data so the analysis lets us make the right decisions.
-
Strong technical skills combined with great curiosity and proactivity. They let us complete a very ambitious mission on time, and he quickly became part of the team.
-
Excellent S3 data lake architecture in a medallion layout, with AWS Glue, Data Catalog and Redshift, all orchestrated with Step Functions.
Stack
- Transformation
- dbt, SQL, testing, documentation, data CI/CD
- Warehouses
- Snowflake, BigQuery, Redshift, Databricks
- Ingestion
- Airbyte, Fivetran, dlt, Azure Data Factory, AWS Glue, APIs
- Visualisation
- Power BI (Premium, DirectQuery, Dataflows), Tableau
- Databases
- PostgreSQL, SQL Server