{"product_id":"aurelio-data-modeler-warehouse-architect","title":"Aurelio - Data Modeler \u0026 Warehouse Architect AI Skill","description":"\u003ch2\u003eSenior Data Modeler \u0026amp; Warehouse Architect who states a fact table's grain in writing before drawing a single table.\u003c\/h2\u003e\n\u003cp\u003eAurelio covers the full schema and modeling surface: star versus snowflake schema design, Kimball versus Data Vault methodology tradeoffs, slowly changing dimension (SCD type 1\/2\/3) design, fact and dimension grain decisions, and physical schema choices for Snowflake, BigQuery, or Redshift such as clustering keys, partition strategy, and distribution style for cost and performance.\u003c\/p\u003e\n\u003ch3\u003eWho it's for\u003c\/h3\u003e\n\u003cp\u003eAnalytics engineers, warehouse architects, and BI leads who need a star schema, SCD strategy, or clustering\/partition key tied to a measured bytes-scanned or cost number, not a generic best practice.\u003c\/p\u003e\n\u003ch3\u003eKey capabilities\u003c\/h3\u003e\n\u003cul\u003e\n      \u003cli\u003eExplicit fact-table grain statement before any measure or join decision is made\u003c\/li\u003e\n      \u003cli\u003eSCD Type 1\/2\/3 design chosen per attribute, never defaulted to Type 1 for convenience\u003c\/li\u003e\n      \u003cli\u003eSurrogate-key join design so historical facts join to the dimension row true at transaction time\u003c\/li\u003e\n      \u003cli\u003eClustering key, partition strategy, or distribution style matched to the actual dominant query pattern\u003c\/li\u003e\n      \u003cli\u003eFan-out and chasm-trap join audits that catch a double-count or row-loss before it ships\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eHow to use it\u003c\/h3\u003e\n\u003cp\u003ePaste Aurelio's SKILL.md into your Claude Project Instructions (or any AI system prompt), then describe your Data Modeler \u0026amp; Warehouse Architect problem. Works with Claude, ChatGPT, and any AI chat. Under 2 minutes to install.\u003c\/p\u003e\n","brand":"KissMySkills","offers":[{"title":"Default Title","offer_id":58331106181384,"sku":null,"price":34.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1036\/1444\/7880\/files\/da2-aurelio-nf.png?v=1785444780","url":"https:\/\/kissmyskills.com\/nl\/products\/aurelio-data-modeler-warehouse-architect","provider":"KissMySkills","version":"1.0","type":"link"}