Hybrid B IR snapshot ships · 8 PRs · CI parity 45% → 100% in one week

Monday-Wednesday closed literal-derivation CI work (PR #4335 NL gate + CAXed scope) and hit structural cluster-dependent wall. Thursday spent the day on 15 Splink standalone-runner iterations (best -4.10% outside AC7 band) before pivoting to Hybrid B: snapshot DC's authoritative IndividualIdentityLink__dlm as static table now (sunset-safe) — PR #4375 opened 15.12M uids at +0.31% AC7 PASS. Friday merged PR #4335 + PR #4375 + 5 new PRs (#4385 GBR · #4386 CAXed · #4387 TRH_Adult · #4388 Engaged_60D · #4389 CAXed+LTP) + late #4391 (Closed_Lost snapshot) + #4392 (12 more CIs in flight). Final standing: 18 of 18 ≤10% of DC = 100% parity, up from 45% baseline (+55pp in one week).

~43.5 h W8 · ~$36,725 cumulative · ~146.9% NTE · 7 PRs merged · 100% CI parity · Hybrid B sunset-safe IR

Canonical bodies ship · #166 CI consolidation builds · Splink RSA auth · NTE crossed cap

Monday landed 7 canonical bodies in PR #4239 (account · opp · sales_order · 3 CPs · individual_unified + individual passthrough split) — all AC7 PASS within ±0.2% vs DC. Tuesday closed JonatanFG/EF #170 (cutover harness · 1,074 LOC PR #4259) + #172 (operational runbook · 798 lines) + 7 RLT tickets in batch. Wednesday Splink runner RSA key-pair auth migration with Allan + 100k scale test PASSED in 47s on free runner. Thursday landed PR #4282 #166 CIs Phase A-C build (17 of 27 CI columns active · 1,373 LOC) — collapsing DC's Helper→Base→Rollup→Final 4-layer arch into single CTEs in int_ci__individual_by_bu. NTE cap crossed mid-W7 (114.5%) · user override 2026-06-08 stands.

~34.75 h W7 · ~$28,635 cumulative · ~114.5% NTE · 7 canonical bodies AC7 PASS · 17/27 CI columns active · 9 tickets closed

Bronze layer closed · IR Phase 1 ships · Boston in-person ratified · NTE threshold crossed

Monday Boston in-person ×2 (Rich canonical sync + SFMC strategy with Vivek + Grabbe). Tuesday 5 PRs covering 32 of 33 remaining bronze ports + parity framework (#324). Wednesday Splink IR Python pipeline authored (#4178 + #4185). Thursday #4177 merged → #158 closed 54/54 parity pairs PASS; EF_SPLINK_WH provisioned; 6 RLT tickets Done; Rich confirmed DC 9.0% ↔ Snowflake 8.97% match parity. Friday IR Phase 1 ships as pure-SQL ER (AC7 PASS at 15,182,794 unified IDs · +0.52% from DC, inside ±2% band); SPCS Splink Phase 2 infrastructure built end-to-end but blocked on HIGH_MEMORY_X64_M not available in eu-central-2.

~145 h · ~$23,910 · ~95.6% NTE · IR Phase 1 ship · 6 RLT closed · 95% threshold crossed

Phase B macros landed · canonical scaffold opened · 7 normalize tickets closed

Memorial Day Monday off. Tuesday opened canonical-model scaffold PR #4083 (7 DMOs · DAG-shape · 4 macros) + S3 bucket setup doc for Grabbe. Wednesday landed 4 cross-repo PRs (#4099 4-BU accounts · #4106 8-BU opportunities · #4107 8-BU sales_orders + 2 school_accounts · #4110 20 ContactPoint scaffolds). Thursday applied the 7 Phase B normalize macros end-to-end — closing RLT-3577 / RLT-3579 / RLT-3989 / RLT-3973 / RLT-3975 / RLT-3578 / RLT-4111. Friday spec 175a RLT-3972 reclassification (RT4→RT3s + rename to Originating_Business_Unit_Name) + ST EFSA carve-out CH↔US parity (delta 0.003%).

121.5 h · $17,340 · 69.4% NTE · Phase 1 closing · canonical scaffold · 7 normalize tickets closed

From placeholders to real per-BU staging models · canonical design locked

Bootstrap PR #3868 merged Monday · Phase B seeds + macros live in PROD · stg_ccap__contacts (878 k rows) ported as the Phase C pilot · same pattern extended to the other 7 BUs (52 M rows in DEV). Rich's reconciliation review closed Friday morning — canonical model #175a design-locked at 85 UI fields. Adrien approved 2 of 3 staging PRs (sources refactor + CCAP pilot); the 7-BU extension still pending review. Verified CH = US 100% match across all 49 source tables.

95 h · $13,640 · 54.6% NTE · Phase 1 closing · Phase 3 design locked · 2 of 3 PRs approved

From live pipeline to project ready-to-merge

Vanilla-audit decisions ratified with Allan + Adrien (collapse 8 schemas → 4 vanilla layers · project-prefixed UPPERCASE · sources outside models/). ef_data_hub_ch dbt project rewritten end-to-end on cross-repo PR #3868 — CI now 14/14 green. Pass 3a + 3b DDL applied live on HH82036 (12 new schemas + grants). PR is mergeable; waiting on Adrien's code-owner review.

74 h · $10,600 · 42.4% NTE · Phase 1 · structural foundation complete · 12 new schemas on HH82036

From plan to live pipeline

Architecture pivoted Tue (single CH dbt project), refined Wed with Rich (3 envs · single CI · marts active · MC-segments primary · reconciliation rules), executed Wed-Thu. Raw data now flows nightly US → CH — 48 source tables, 283 M rows, 47 GB byte-parity on HH82036. P0 done; P1 build unblocked.

42 h · $5,960 · 23.8% NTE · Phase 1 · 6 tickets closed · cross-repo bootstrap PR open

Foundation week — plan endorsed

CH Snowflake dbt-2 home provisioned (sandbox + prod, 6 schemas each, 2 RW roles, transform WH). Three specs landed for the build phase. Plan endorsed in the W1 review with Rich, Mike Grabbe and Adrien — handoff team confirmed, three concrete action items lined up.

14 h · $2,040 · 8.2% NTE · Phase 0 · foundation provisioning + spec writing