Browse Skills

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

Design data activation pipelines that sync analytical data from cloud data warehouses back into operational SaaS tools like CRMs, marketing platforms, and support systems.

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

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.

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.

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

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.

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

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.

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 for building and optimizing Apache Spark data processing pipelines, from PySpark development to cluster tuning and lakehouse architecture.

Guide systematic exploratory data analysis workflows — from initial profiling through distribution analysis, correlation discovery, and hypothesis generation — using statistical rigor and effective visualization.

Designs unified customer profiles using Segment, RudderStack, or custom CDP solutions with identity resolution, event streaming, audience segmentation, and privacy-compliant data governance.

Design and implement digital twin systems that create virtual representations of physical assets using IoT sensor data, simulation models, and cloud platforms for predictive maintenance and operational optimization.

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

Design and implement comprehensive Google Analytics 4 event tracking strategies with proper taxonomy, data layer architecture, and consent-aware measurement.

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.

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.

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 advanced PostgreSQL — performance tuning, query optimization, extensions (PostGIS, pgvector, TimescaleDB), partitioning, replication, and production operations.

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.