Developed a Customer Last Order Snapshot Table for analytics in the soubhikgorai/ah-datakitchen-dbt-tool-eval repository, focusing on enhancing the accuracy and timeliness of customer-order insights. Built an intermediate table using SQL and dbt to capture each customer’s most recent order details, including customer ID, name, account balance, last order date, and total price. Incorporated data quality tests for uniqueness and non-nullability to ensure reliable analytics. The approach emphasized robust data engineering practices, enabling faster and more accurate business analysis of customer activity. This work improved the freshness and reliability of customer order data for downstream analytics use cases.