Browse Skills

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.

Guides geospatial data analysis including GIS fundamentals, PostGIS spatial queries, coordinate systems, geocoding, spatial indexing, and map visualization. Helps design location intelligence solutions and spatial analytics workflows.

Expert guidance for building high-performance analytical queries and data pipelines using DuckDB, the embedded OLAP database engine with columnar storage and vectorized execution.

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

Designs real-time analytics systems using stream processing frameworks like Kafka Streams, Apache Flink, and Spark Streaming. Covers event-time processing, windowing strategies, exactly-once semantics, and low-latency dashboard architectures.

Create publication-quality static figures with Matplotlib and interactive web-ready visualizations with Plotly, guided by visual perception research and data storytelling principles.

Guides analytics engineering best practices using dbt, SQL modeling patterns, semantic layers, metrics definitions, and testing strategies. Helps design maintainable, well-documented analytics workflows from raw data to business-ready datasets.

Designs measurable outcome indicator frameworks for social impact programs, including theories of change, logic models, SMART indicators, and results-based monitoring systems.

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

Guides you through designing effective, insight-driven dashboards with proper KPI selection, visual encoding, and data storytelling — applying Tufte and Few principles to avoid common anti-patterns.

Designs and implements enterprise skills taxonomies and competency frameworks that enable skills-based workforce planning, internal mobility, gap analysis, and learning path mapping using validated I/O psychology methodologies.

Build, evaluate, and deploy machine learning models directly in Google BigQuery using SQL, from classification and regression to time-series forecasting and recommendations.

Design dimensional models, data vault architectures, and analytics schemas optimized for Snowflake with Kimball methodology, dbt integration, and platform-native performance tuning.

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 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.

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.

Design, optimize, and operate ClickHouse OLAP clusters for real-time analytics on billions of rows with sub-second query performance.

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

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

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

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 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.

Expert in Google BigQuery — SQL analytics at scale, partitioning and clustering strategies, BigQuery ML, materialized views, Dataform pipelines, cost optimization, and data governance.

Design and build production-grade real-time data pipelines using Apache Kafka, Flink, Spark Streaming, and CDC patterns with exactly-once semantics and operational observability.