Elicit the underlying business need from requests that may initially be incomplete, unstructured, or solution-oriented; identify gaps and contradictions and distinguish among ingestion, modeling, CDP, activation, and reporting requirements. Identify, design, and build the Snowflake models, aggregations, materializations, and other data structures and usability, using views, dynamic tables, semantic views, stored procedures, and other appropriate technologies.