Patterns & Anti-patterns.
Senior engineering is rarely about knowing a syntax trick. It is knowing what to repeat, what to avoid and what tradeoff you are accepting.
Persist Tracking History Beyond Data View Retention
Copy time-bounded system tracking into your own historical model when long-term analysis is a requirement.
Explicit SELECT Lists
Name the columns you intend to move instead of depending on SELECT *.
Intermediate Tables for Large Transformations
Split complex transformations into observable stages instead of one giant query.
Externalize Heavy SSJS Processing
Use SSJS for platform-local orchestration, but move large/complex processing to an external system when the workload demands it.
Golden Record Inside SFMC — Constrained Architecture
A pragmatic consolidation layer inside SFMC when enterprise CRM/MDM capabilities are unavailable.
Hardcoded Credentials in Scripts or Assets
Credentials embedded in SSJS, CloudPages or Content Builder become difficult to rotate, audit and protect.
SELECT * in Production Automations
Convenient during exploration, fragile as a durable data contract.
Redesign Before Discovery
Do not “clean up” an undocumented production org before understanding what is actually active.
Operational Baselines Before Alerts
Know normal runtime, row count and cadence before deciding what “unhealthy” means.
Idempotent Integration Writes
Make retries safe by designing an operation so the same event can be processed more than once without duplicating side effects.
Precompute Heavy Message-Time Personalization
Move large lookups and expensive transformations out of email render time when the data can be prepared earlier.
“Complete” Means Healthy
Treating a successful status as the only health signal hides stale data, runtime regression and partial business failure.
Webhook Ingress Boundary
Keep public webhook ingress small, authenticated and validation-focused before handing work to deeper automation.
Backup Before Upgrade
Treat a tested rollback path as part of the upgrade, not as an afterthought.
Schema-First Metadata Ingestion
Normalize external metadata into stable typed records before building reports, graphs or drift logic.
AI Output With Provenance Boundaries
Make AI-assisted technical work label what came from source material, observation, inference and missing context.
Public Admin Surface by Convenience
Do not expose n8n/admin dashboards publicly merely because the webhook endpoints must be public.