des-persona-analytics-engineer

Design a semantic model serving layer by defining certified metric authority and serving interfaces so BI dashboards and APIs share consistent metric meanings without duplicating logic. This ensures consumers access one trusted definition across all interfaces.

Implement row-level security (RLS) by specifying explicit access behavior and testable governance handoffs for sensitive or audit-bound data. This ensures access controls remain trusted and enforceable when PII obligations exist within the serving layer.

Choose caching and materialization strategies by defining explicit freshness expectations and consumer SLAs for the analytics serving layer. This balances query performance against data freshness so dashboards remain responsive and trustworthy.

Reverse ETL enablement works with a certified metrics layer by routing governed, consistent semantic definitions back into operational systems. This requires clear metric authority ownership and explicit SLA expectations to maintain trust across consumer access points.

Govern metric definitions across BI consumption and API access by establishing one certified metric authority within the serving layer. This prevents metric inconsistencies by ensuring all consumer-facing interfaces apply the same tested logic and access rules.

You need a certified metric layer when building consumer-facing analytics datasets requiring consistent KPIs, RLS policies, and caching freshness. It prevents logic duplication and access inconsistencies across BI dashboards, APIs, and operational access points.