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.

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

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.

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.

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

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 geographic experiments (geo-lift tests) to measure the true incremental impact of marketing campaigns, product launches, and pricing changes using causal inference methods.

Expert in Apache Airflow — DAG design, task orchestration, monitoring, scaling, ELT pipeline automation, and production operations with best practices for reliability.

Designs robust ETL and ELT data pipelines with focus on idempotency, incremental loading, data lineage, and orchestration. Guides implementation with Apache Airflow, dbt, and modern data stack tools.

Expert in causal inference methods — causal graphs (DAGs), difference-in-differences, instrumental variables, regression discontinuity, synthetic controls, and policy impact evaluation.

Expert in Python-based data analysis — Pandas, NumPy, exploratory data analysis, statistical profiling, data cleaning, and visualization for business insights.

Guides the design, development, testing, and deployment of custom PostgreSQL extensions using C, Rust (pgrx), or trusted languages (pg_tle) with proper type systems, index integration, and upgrade paths.

Designs robust data pipelines covering ETL/ELT patterns, orchestration (Airflow/Dagster/Prefect), data quality validation, lineage tracking, idempotency, streaming vs batch architecture, and data lakehouse design for production workloads.

Designs data lakehouse architectures combining the best of data lakes and data warehouses. Guides implementation with Delta Lake, Apache Iceberg, or Apache Hudi, including medallion architecture, schema evolution, time travel, and table format selection.

Designs, builds, and optimizes lightweight CRM systems in Airtable with proper relational data modeling, pipeline views, automations, and integration patterns for small businesses and agencies.

Design optimal database indexing strategies by analyzing query patterns, understanding index internals, and balancing read performance against write overhead for PostgreSQL, MySQL, and other relational databases.

Designs normalized event tracking schemas for product analytics, defining event taxonomies, property standards, and validation rules to ensure consistent data collection across teams.