Produce documented data cleaning scripts that log every transformation with N before/after each step, generate a CONSORT-style exclusion…
Generate or improve a company-specific data analysis skill by extracting tribal knowledge from analysts.
Design and verify data contracts, schema changes, migrations, rollbacks, backfills, compatibility windows, tenant isolation, and…
Convert between CSV, TSV, Excel, JSONL, Parquet, and other tabular formats
Data Engineering and Analytics, in 27 concepts.
Enforces user-facing data portability in an offline-first app — backup/restore (exact, machine round-trippable) kept strictly separate…
Common patterns for extracting analytics data from GA4 and GSC with API handling
Find and assess datasets for a research question.
Generates a Mermaid sequence diagram showing how data moves between components.
🐉 Fetches and parses time-series data from various sources.
Review data integrity for Rails changes.
Join two datasets with automatic strategy selection (joinp vs join vs sqlp)
Design field mapping specifications between source and destination systems for synchronizing insurance AMS and CRM data, LOS to reporting…
Establishes a lean product metrics framework, event tracking plan, and analytics dashboard to capture critical user data from day one.
Database migration patterns: zero-downtime schema changes, data backfills, Alembic, Prisma Migrate, Rails migrations
Use this agent when reviewing PRs that touch database migrations, data backfills, or any code that transforms production data.
Large-scale data migrations with validation, rollback, and zero-downtime strategies.
Data modeling methodologies and patterns across paradigms.
Orchestrate marketing data collection, transformation, aggregation, and reporting workflows across platforms
Expert data engineer for ETL/ELT pipelines, streaming, data warehousing.
ETL/ELT patterns, batch vs streaming, idempotency, data quality framework, and pipeline orchestration