datamart-hld-design

What problem does it solve?

This Skill eliminates inconsistent, non-compliant Datamart high-level design (HLD) documentation for UBCKNN's Lakehouse project built on the Medallion (Bronze/Atomic/Gold) architecture, ensuring all designs align with approved Atomic layer entities, cross-module reuse standards, and mandatory phase-gate approval workflows.

Core Features & Use Cases

• Structured Phase-Gate Workflow: Enforces a mandatory 2-phase design process (Phase 1: HLD design with human approval checkpoints, Phase 2: Entities file generation) to prevent skipped validation steps and ensure stakeholder alignment.
• 4-Layer Reuse Analysis: Automates checks across conformed dimension whitelists, classification value mapping, source matching, and partial table reuse to maximize reuse of existing Datamart tables, reducing redundant design work.
• Built-in Compliance Validation: Includes strict rules for erDiagram syntax, flowchart lineage, naming conventions, KPI tracking, and Atomic entity alignment to eliminate common design errors and ensure consistency with UBCKNN's data model standards.
• Use Case: Data modelers designing new Datamart modules for UBCKNN (including TT, NHNCK, NDTNN, QLCB, FMS, GSTT, GSDC, QLKD) can use this Skill to generate fully compliant HLD and Entities files that pass review on the first attempt.

Quick Start

Use the datamart-hld-design skill to generate a compliant Phase 1 HLD for the new FMS Datamart module using the provided BA analyst CSV, report screenshot, and Atomic dm_manifest.yaml file.