hello, i'm
Adrienne
Vermorel
Turning messy marketing data into something teams can trust — with a lot of help from AI.
what i write about:
latest cuts:
-
Marketing Attribution in the Warehouse: A 2026 Guide
Build marketing attribution in your data warehouse with SQL. Covers heuristic models, Markov chains, Shapley values, identity resolution, and dbt patterns.
bigquery dbt ga4 analytics -
Building a Custom Materialization in dbt
Tutorial on building custom dbt materializations in BigQuery: zero-downtime table swaps with row-count validation and automated row-level security policies.
dbt bigquery data engineering data modeling -
Cross-Database Macros: Writing Once, Running Anywhere
Write dbt macros that work across BigQuery, Snowflake, and Databricks using the dispatch pattern. Covers key syntax differences and built-in functions.
dbt bigquery snowflake databricks -
Writing Reusable Macros: DRY Principles for dbt
Learn when to create dbt macros and when to leave code inline. Practical patterns for naming, folder organization, testing, and avoiding premature abstraction.
dbt data modeling data engineering testing
about me:
Analytics Engineer at unnest, where I turn messy marketing data into something teams can actually trust. I'm obsessed with AI-powered automation — my goal is to transfer as much of my know-how as possible to my coding agents and let them do the heavy lifting.
I write about dbt, modern data stack, and the growing overlap between data engineering and AI. I also volunteer my data and marketing skills for a French animal welfare organization, because every skill deserves a side quest.