Browse Skills

Design BI architectures with semantic layers, dimensional models, self-service analytics, KPI frameworks, and modern data stack patterns using dbt, Looker, Metabase, and Tableau.

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.

Design, implement, and operate real-time event streaming systems using Redis Streams. Covers consumer group topologies, failure recovery with XAUTOCLAIM, memory management, persistence configuration, and architecture comparisons with Kafka and RabbitMQ.

Optimize BigQuery deployments for maximum performance and minimum cost through partitioning, clustering, query tuning, and systematic cost control strategies.

Design and implement automated data quality validation pipelines using Great Expectations, with expectation suite design, threshold calibration, and integration into dbt, Airflow, and Spark workflows.

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.

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.

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 rigorous experiments — from clinical RCTs to A/B tests to industrial DOE — with proper randomization, power analysis, control structures, and statistical validity to produce actionable causal evidence.

Bayesian statistician for measuring true incremental marketing impact — campaign lift estimation, Marketing Mix Modeling, geo-based incrementality experiments, and Bayesian A/B testing with properly quantified uncertainty.

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

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.

Comprehensive methodological guidance for grounded theory research across all three major traditions (Glaserian, Straussian, Constructivist), covering research design, theoretical sampling, coding, memo writing, and theory construction.

Guides the creation of high-impact Tableau dashboards with advanced calculated fields, LOD expressions, performance optimization, and data storytelling best practices.

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.

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

Transform data into compelling visual narratives using chart type selection, Tufte principles, color theory, annotation strategies, and audience-adapted presentation-ready outputs.

Design and build production-grade Power BI dashboards with optimized data models, advanced DAX measures, and professional visualization layouts. Get expert guidance on star schema modeling, performance tuning, Row-Level Security, and deployment pipelines.

Analyze and optimize Snowflake data warehouse costs through warehouse right-sizing, query performance tuning, storage efficiency, and organizational governance using resource monitors and FinOps practices.

Design and adapt survey instruments for cross-cultural and multinational research. Covers translation-backtranslation protocols, measurement invariance testing, cultural response style mitigation, and construct equivalence validation following ITC guidelines and established psychometric standards.

Design and optimize MongoDB aggregation pipelines for complex data transformations, analytics, and reporting. Covers pipeline stage ordering, index utilization, sharded cluster considerations, and schema design patterns that enable efficient aggregation.

Develops comprehensive data governance strategies including data catalogs, metadata management, ownership models, access policies, quality frameworks, and master data management aligned with DMBOK standards.

Configure and optimize Salesforce orgs with expert guidance on object model design, security architecture, Flow automation, reports and dashboards, and deployment best practices.

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