Browse Skills

Maps end-to-end data lineage from source systems through transformations to downstream consumers, enabling impact analysis, debugging data quality issues, and ensuring regulatory compliance.

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.

Design and optimize graph database schemas, Cypher queries, and production deployments for knowledge graphs, recommendation engines, fraud detection, and network analysis applications.

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.

Master SQL window functions for advanced analytical queries including ranking, running aggregates, time-series analysis, and cohort calculations across PostgreSQL, Snowflake, and BigQuery.

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 analytics engineering skill for dbt Core/Cloud — guides you through SQL-based data modeling with staging/intermediate/mart layers, dimensional modeling (Kimball methodology), incremental models, SCD Type 2 snapshots, comprehensive testing strategies, Jinja macros, dbt packages, and warehouse-specific optimization for Snowflake, BigQuery, and Redshift.

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

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.

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.

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

Expert guidance for creating compelling geospatial visualizations and spatial data analysis. Covers map design, PostGIS spatial queries, web mapping libraries (Mapbox, Deck.gl, Leaflet), data formats, and location intelligence.

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.

Design and build Salesforce reports, dashboards, and CRM Analytics solutions that transform raw CRM data into actionable business intelligence for sales, marketing, and customer success teams.

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

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.

Guide practitioners through selecting, designing, and interpreting statistical hypothesis tests with proper assumptions checking, sample size calculations, and actionable conclusions.

Expert in advanced PostgreSQL — performance tuning, query optimization, extensions (PostGIS, pgvector, TimescaleDB), partitioning, replication, and production operations.

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

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

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

Expert regression analysis guidance covering model selection, diagnostics, regularization, and causal inference across OLS, GLM, and ML techniques.

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