Skill UI

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

Designs scalable batch and streaming pipelines, modern warehouses, and analytics platforms with Spark, dbt, Airflow, cloud data stacks, and governance practices.

Guides data-engineering teams through configuring incremental loads in pipelines, covering best practices, orchestration tips, example code, and output validation for streaming or batch workflows.

Guides multi-location retailers through demand forecasting, safety stock calculation, replenishment planning, promotional lift estimation, and ABC/XYZ segmentation, blending statistical best practices with ML-ready feature engineering to balance service levels and inventory costs.