Browse Skills

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.

Conduct environmental lifecycle assessments (LCA) of products following ISO 14040/14044, covering goal definition, inventory analysis, impact assessment, and improvement recommendations for sustainable product design.

Designs dimensional data warehouse schemas using Kimball, Inmon, or Data Vault methodologies. Guides star/snowflake schema design, slowly changing dimensions, ETL/ELT patterns, and cloud warehouse optimization for Snowflake, BigQuery, and Redshift.

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 guidance for building and optimizing Looker LookML models, Explores, and dashboards. Covers semantic layer design, derived tables, performance optimization, and governance patterns for scalable self-serve analytics.

Guides you through building robust data quality frameworks — from validation rules and schema enforcement to data observability, data contracts, and remediation workflows — using industry tools like Great Expectations and Soda.

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.

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.

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.

Design interactive maps, choropleths, and spatial data visualizations using best practices in cartographic design, web mapping libraries, and geospatial data engineering.

Prepare research outputs for public sharing and long-term preservation with FAIR-compliant data packaging, reproducible environments, proper licensing, and repository publication strategies.

Builds and evaluates demand forecasting systems using statistical time series methods and machine learning, covering decomposition, model selection, accuracy measurement, and translation to inventory and planning decisions.

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.

Design and implement automated data quality frameworks using Great Expectations, dbt tests, data contracts, and observability platforms to ensure trustworthy data pipelines.

Expert guidance on real-time stream processing architectures using Apache Kafka, Flink, and Spark Streaming, covering windowing strategies, exactly-once semantics, CEP, and operational best practices.

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

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

Design domain-oriented, decentralized data architectures using data mesh principles including data-as-a-product, self-serve infrastructure, and federated computational governance.

Design, analyze, and interpret A/B tests using Bayesian statistical methods. Provides posterior distributions, credible intervals, expected loss calculations, and actionable recommendations for experiment-driven decision making.

Isolate the true causal effect of price changes on demand, revenue, and profit using rigorous econometric methods including difference-in-differences, instrumental variables, and synthetic control.

Designs retention measurement systems, builds churn prediction models, and creates data-driven intervention strategies that measurably reduce customer churn across SaaS, e-commerce, and subscription businesses.

Designs and implements sophisticated Airtable automations, scripting extensions, and integration workflows that transform manual business processes into reliable, scalable automated systems.

Design and deploy Statistical Process Control systems with proper control chart selection, rational subgrouping, process capability analysis, and automated monitoring to detect and reduce process variation in manufacturing and service operations.