modelling patterns (3NF, dimensional/star, Data Vault, canonical models) and guide teams on when and how to apply them.... Optimise physical designs for performance, scalability, cost and resilience across cloud data platforms (e.g., Snowflake...