The challenges we overcome

Being a good archivist of data

December 7, 2025A comprehensive walk through how Data Warehouses provide full traceability into historical truth by leveraging source system capabilities and filling in the gaps.

#Data historization#Data integration#DWH

Tracking design & implementation

May 10, 2025A practical analytics tracking implementation playbook covering schema design, CI/CD, active metadata, observability and team operating model.

#Tracking#Active metadata#Team

Map out your DBT models

November 30, 2024A learning journey that transformed our way of working with diagrams and lowered the boundaries of collaboration between business and data.

#DBT#Data modeling#MermaidJS

A testing framework for Snowflake Dynamic Tables

October 28, 2024Following our challenges with trying to adopt Snowflake Dynamic Tables, we built a bespoke testing framework to support our scalability ambitions.

#Snowflake#Data quality#Data testing

Snowflake Dynamic Tables are wonderful! But how do you test them?

October 16, 2024In this article we cover our experience helping an Analytics Engineering team create a next-level data infrastructure based on Snowflake Dynamic Tables with a robust and responsive data quality testing framework.

#Snowflake#Data quality

Gone But Not Forgotten: Navigating Kafka tombstones with DBT

July 17, 2024A story on how we supported an Analytics Engineering department of a top Digital Marketing enterprise adopt a consistent framework for modeling entities deleted by the sources using Kafka tombstones, the challenges we encountered and how this was made to work using DBT.

#Kafka#DBT#Data engineering

Taking data snapshots using DBT (part 2)

June 19, 2024Following the previous thought process, we implemented an automation for data snapshoting in DBT.

#Data modeling#DBT

Taking data snapshots using DBT (part 1)

June 10, 2024In this case study, we present a custom solution for reshaping historical data into a snapshot format. In a modeling paradigm relying on 3NF and SCD-Type4, analyst are often finding it hard to report on entity dynamics. Snapshots - to the rescue - provide an alternative perspective on the historical data that is easy to consume.

#Data modeling#DBT