Browse Skills

Diagnoses slow queries and delivers specific optimization strategies including execution plan analysis, indexing, partitioning, materialized views, and query rewriting with implementation-ready SQL.

Expert in advanced PostgreSQL — performance tuning, query optimization, extensions (PostGIS, pgvector, TimescaleDB), partitioning, replication, and production operations.

Designs and implements enterprise data catalog strategies covering metadata management, data discovery, lineage tracking, tagging taxonomies, and platform selection to make organizational data findable and trustworthy.

Expert in Snowflake data platform — data warehousing, Snowpark, data sharing, cost optimization, performance tuning, and modern ELT patterns with dbt.

Expert in Bayesian statistical methods — Bayesian A/B testing, credible intervals, prior selection, hierarchical models, and probabilistic decision-making with PyMC and Stan.

Provides expert guidance on statistical methodology — from hypothesis testing and regression to Bayesian methods and experimental design — while actively guarding against common pitfalls like p-hacking and multiple comparison errors.

Expert regression analysis guidance covering model selection, diagnostics, regularization, and causal inference across OLS, GLM, and ML techniques.

Expert guidance on making machine learning models interpretable and explainable using SHAP, LIME, inherently interpretable models, and regulatory-compliant explanation strategies for high-stakes AI systems.

Designs reverse ETL architectures to activate warehouse data in operational tools, covering Census/Hightouch patterns, sync strategies, audience building, and data activation use cases.

Analyzes conversion funnels across acquisition, activation, and monetization stages, identifying drop-off points, statistical significance of changes, and optimization opportunities using event data.

Design rigorous A/B experiments, calculate sample sizes, select statistical methods, analyze results with proper significance testing, and deliver actionable recommendations.

Analyzes and optimizes SQL queries for maximum performance, covering execution plan interpretation, indexing strategies (B-tree/GIN/GiST), window functions, CTEs, materialized views, partitioning, and PostgreSQL-specific optimization techniques.

Master GA4 exploration reports to extract actionable insights from funnel analysis, path exploration, cohort retention, and segment comparisons for data-driven decisions.