Skills

Evaluates retrieval quality for search and RAG systems using grounded test sets, relevance metrics, failure taxonomy, chunking experiments, and actionable remediation.

Designs trustworthy product analytics events, properties, identity rules, validation, privacy boundaries, dashboards, and governance for product and growth decisions.

Defines versioned data contracts between producers and consumers, with ownership, schemas, quality expectations, compatibility rules, and operational change management.

Generates and refactors dbt models for analytics engineering. Writes staging, intermediate, and mart models following layered conventions, adds schema.yml tests and descriptions, applies incremental and materialization strategies, and structures sources and refs correctly. Produces SQL plus YAML that fits dbt best practices and is ready to run.

Explains what a SQL query does in plain language and how it executes. Breaks down joins, subqueries, CTEs, and window functions step by step, describes the result set, reads EXPLAIN/EXPLAIN ANALYZE output to identify slow scans and missing indexes, and flags correctness pitfalls. Helps developers understand, review, and trust unfamiliar SQL.

Inspects messy tabular data and produces a repeatable cleaning plan plus code. Detects and fixes common issues: inconsistent types, duplicate rows, missing values, malformed dates, mixed encodings, whitespace and casing problems, and outliers. Outputs pandas or Polars code, a summary of changes, and a validation checklist.

Designs evaluation harnesses for LLM applications, covering dataset construction, task-specific metrics, LLM-as-judge rubrics with bias controls, and regression gates. Helps teams measure quality, catch regressions across model or prompt changes, and report results with confidence intervals rather than vibes.

Designs data quality checks for tables, pipelines, and warehouses. Generates expectation suites covering schema conformance, null and uniqueness constraints, referential integrity, freshness, and statistical drift, then wires them into pipelines so bad data is caught before it reaches dashboards or models.

Helps design and implement features for machine learning models from raw tabular, time-series, or text data. Suggests transformations, encodings, aggregations, and leakage-safe splits, explains the rationale, and generates reproducible feature pipeline code with validation.

Generates realistic synthetic datasets that preserve the statistical properties and relationships of source data without exposing real records. Covers schema-aware generation, correlated and time-series fields, class balancing for ML training, and constraint preservation, with code for tools like SDV, Faker, or custom generators.

Builds retention and behavioral cohort analyses from event or transaction data. Defines cohorts by acquisition date or attributes, computes retention and churn curves, generates the SQL or pandas code to produce cohort tables, and interprets the results into actionable insights about engagement and lifecycle.

Turns raw data and natural-language requests into clear, well-labeled charts and the code to render them. Recommends the right chart type for the data and message, handles aggregation and formatting, and outputs production-ready visualizations using libraries like Matplotlib, Plotly, Vega-Lite, or Chart.js with accessible color palettes.

Designs and implements retrieval-augmented generation (RAG) pipelines end to end. Covers document chunking strategies, embedding model selection, vector store configuration, hybrid and re-ranking retrieval, prompt construction with grounded citations, and evaluation harnesses for measuring retrieval quality and answer faithfulness.

Designs and generates data pipeline configurations for ETL/ELT workflows. Supports Apache Airflow DAGs, dbt models, Spark jobs, and streaming pipelines with Kafka or Flink. Creates data quality checks, schema evolution strategies, and monitoring dashboards for pipeline health.

Performs geospatial data analysis, mapping, and spatial statistics using GeoPandas, Shapely, Rasterio, and Folium. Supports vector and raster operations, coordinate transformations, spatial joins, buffer analysis, satellite imagery processing, choropleth mapping, and route optimization for GIS and remote sensing workflows.

Sets up and manages machine learning experiment tracking, hyperparameter optimization, and model registry workflows. Integrates with MLflow, Weights & Biases, and Optuna for systematic experimentation. Handles metric logging, artifact storage, model versioning, reproducibility, and automated hyperparameter search with early stopping.

Analyzes complex networks and graphs using NetworkX, igraph, and PyTorch Geometric. Supports social network analysis, biological interaction networks, knowledge graphs, and citation networks. Performs community detection, centrality analysis, link prediction, graph neural networks, and network visualization with force-directed layouts.

Builds and evaluates time series forecasting models using statistical and ML approaches. Supports ARIMA, Prophet, LSTM, Transformer-based models, and foundation models like TimesFM. Handles seasonality detection, trend decomposition, anomaly detection, multi-step forecasting, and backtesting with proper train/test splits for financial, IoT, and scientific time series data.

Builds and executes bioinformatics analysis pipelines for genomics, transcriptomics, and proteomics data. Supports single-cell RNA-seq analysis with Scanpy, differential expression with PyDESeq2, sequence alignment, variant calling, gene ontology enrichment, and pathway analysis using KEGG and Reactome databases.

Performs cheminformatics and molecular property analysis using RDKit, PubChem, and ChEMBL. Supports SMILES/InChI parsing, molecular descriptor calculation, drug-likeness filtering (Lipinski, Veber), ADMET prediction, substructure search, and structure-activity relationship (SAR) analysis for drug discovery workflows.

Creates publication-quality scientific figures and plots using matplotlib, seaborn, and plotly. Supports common scientific plot types including heatmaps, volcano plots, survival curves, network graphs, phylogenetic trees, and multi-panel figures with proper statistical annotations, color-blind safe palettes, and journal formatting.