StartupTechCo runs a fleet of vendor integrations: two flat-file vendors it pulls from over SFTP, a third that pushes files into an SFTP endpoint...

Alignment lives at the facet level

A scheduled merge into dim_members overwrote the member_id for a few hundred rows. The job had run the same way every day for months....

In the last post, we built out the model structure: staging, intermediate, marts. This post is about testing it: asserting that what those models...

In the last post, we talked about the ownership problem: StartupTechCo’s transformation layer had grown into logic copied between notebooks and SQL duplicated across...

The data engineer can tell you the history of how StartupTechCo’s transformation layer got the way it is. She helped build part of it...