Browse Skills

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

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

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

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.

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.

Analyzes and optimizes Elasticsearch query performance, index mappings, and cluster configurations to achieve faster search latency and lower resource consumption.

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

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

Designs and implements Monte Carlo simulations for quantitative analysis, covering probability distributions, variance reduction techniques, financial modeling (VaR, options pricing), convergence analysis, sensitivity analysis, and production-quality Python/R implementation patterns.

Design and deploy edge computing systems for industrial energy monitoring, combining IIoT sensor networks with real-time analytics to deliver consumption transparency, anomaly detection, and ISO 50001-aligned energy management.

Expert in MongoDB production systems — document modeling, aggregation pipelines, sharding, indexing strategy, Atlas operations, and migration from relational databases.

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

Design and analyze rigorous policy impact evaluations using causal inference methods including difference-in-differences, regression discontinuity, synthetic control, and propensity score matching.

Designs and enforces formal data contracts between producer and consumer teams, implementing schema governance, automated quality testing, and graduated enforcement strategies to ensure upstream data discipline.

Guides teams through MongoDB Atlas production deployments — cluster architecture, performance optimization, Atlas Search, security hardening, backup strategies, and cost management for cloud-native document database workloads.

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

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

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.

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.

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

Design rigorous, bias-minimized surveys — from research objective clarification and question writing to sampling strategy, skip logic, and analysis planning.

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.

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

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.