Analytics Engineering Bundle

Semantic-layer design, exposure tracking, metric definitions, change-management, and BI-handoff skills.

Browse all skill bundles

Included Skills (45)

  1. Data Build Tool — This skill helps data engineers transform data in their warehouse using SQL SELECT statements with dbt.
  2. Test Coverage Optimizer — This tool identifies untested code paths and generates targeted unit tests to help developers systematically increase their project's overall test coverage metrics.
  3. dbt Validation Generator — Automates the creation of SQL validation notebooks for dbt model changes, helping data engineers verify data integrity during pull requests.
  4. Performance Optimization Expert — This skill helps developers identify and resolve application bottlenecks through data-driven profiling to ensure optimal speed, responsiveness, and Core Web Vitals compliance.
  5. Product Analytics — Use when defining product KPIs, building metric dashboards, running cohort or retention analysis, or interpreting feature adoption trends across product stages.
  6. Data Quality Orchestrator — This skill assists data engineers in implementing robust validation frameworks, dbt testing suites, and data contracts to ensure reliable, high-quality production data pipelines.
  7. Cosmos DB Architect — This tool assists developers in building secure, production-ready Azure Cosmos DB NoSQL services using clean code and test-driven development principles.
  8. Parallel Batch Processor — This tool enables developers to execute high-performance, parallel file operations and bulk data transformations across large directories with integrated progress tracking and error handling.
  9. Monte Carlo Optimizer — Analyzes Monte Carlo monitor reports to identify alert patterns and recommend configuration adjustments that effectively reduce noise for data engineers.
  10. Snowflake Development Assistant — Assists data engineers and analysts in developing Snowflake SQL, data pipelines, and Snowpark Python applications efficiently and effectively.
  11. SQL Query Generator — This tool transforms natural language requirements into optimized SQL queries, helping analysts and engineers efficiently retrieve data across various database platforms.
  12. DLT Pipeline Builder — Assists developers in building data pipelines using the open-source dlt Python library for data loading and ingestion.
  13. CSV Data Processor — This skill parses and generates CSV files, assisting developers with data import/export, ETL pipelines, and report generation tasks.
  14. Analytics Quality Framework — This skill helps data engineers and analysts establish robust testing, automated monitoring, and incident response protocols for analytics models and dashboards.
  15. Bigquery Observability — The Bigquery Observability skill provides best‑practice data retrieval, tool selection guidance, and optimized SQL syntax for querying telemetry across INFORMATION_SCHEMA, Cloud Monitoring, and the REST API. Analysts and engineers use it to diagnose single‑job performance bottlenecks, investigate slot contention, audit resource usage, and analyze reservation capacity and autoscaling saturation. This enables precise performance tuning and efficient resource management.
  16. Azure Table Integrator — This tool assists Java developers in building scalable table storage applications compatible with both Azure Table Storage and Cosmos DB Table API.
  17. Azure Table Storage — This tool enables developers to manage NoSQL key-value data and perform entity operations within Azure Storage Tables or Cosmos DB Table API.
  18. Analytics Measurement Architect — Design and audit robust analytics tracking systems to ensure data integrity and provide actionable, decision-ready insights for product and marketing teams.
  19. High-Performance Data Processor — Polars provides a lightning-fast, memory-efficient DataFrame library that helps data engineers and analysts accelerate complex ETL pipelines and large-scale tabular data transformations.
  20. PostHog Analytics Automator — This tool automates PostHog event tracking and feature flag management, helping developers streamline product analytics workflows via the Rube MCP integration.
  21. BigQuery Resource Manager — This tool enables developers to efficiently manage BigQuery datasets, tables, and jobs while executing SQL queries for high-speed data analysis and ingestion tasks.
  22. Segment Data Orchestrator — This tool automates Segment customer data platform operations, enabling developers to efficiently track events, identify users, and manage data workflows via Rube MCP.
  23. BigQuery Performance Optimizer — This tool analyzes BigQuery slot consumption and query costs to help data engineers identify performance bottlenecks and optimize expensive, inefficient SQL execution patterns.
  24. KPI Dashboard Architect — This skill provides structured design patterns and best practices to help data analysts and managers build effective, actionable KPI dashboards for business.
  25. Document Data Extractor — Extracts structured data from various document formats, converting them into JSON or CSV for data analysis and processing.
  26. Evidence Dashboard Assistant — Provides expert guidance for Evidence, helping developers build data reports as code and create self-service analytics dashboards from SQL and Markdown.
  27. Data Quality Auditor — This tool profiles datasets to detect anomalies and structural issues, helping data engineers ensure high-quality, reliable data for downstream analysis and modeling.
  28. Data Science Expert — This skill provides advanced analytics, machine learning, and statistical modeling support to help data professionals execute complex data workflows and generate actionable business insights.
  29. Data Quality Validator — This skill validates data quality in various formats, helping data engineers and analysts ensure reliable data pipelines and analytics.
  30. Data Warehouse Analyst — This tool helps data analysts plan, validate, and review read-only warehouse queries to ensure accurate, privacy-compliant, and reproducible business insights.
  31. Real-Time Analytics Pipeline — This skill helps AI agents build real-time analytics pipelines, including event ingestion, ClickHouse storage, and dashboard wiring for live metrics.
  32. Kafka Event Streaming — Facilitates building event-driven systems using Apache Kafka for users needing message streaming and real-time data processing.
  33. SQL Cost Optimizer — This tool audits SQL queries for performance anti-patterns to help data engineers reduce warehouse costs and improve overall database efficiency.
  34. Monte Carlo Triage — This skill provides modular tools and workflows to help data teams interactively triage, score, and troubleshoot Monte Carlo alerts efficiently.
  35. Database Performance Architect — This expert assistant helps developers and engineers optimize complex database queries, implement scalable architectures, and resolve performance bottlenecks for high-traffic production systems.
  36. Spreadsheet Data Merger — This tool enables users to consolidate multiple CSV or Excel files through intelligent column matching, automated data deduplication, and robust conflict resolution strategies.
  37. Executive Dashboard Architect — This skill provides a structured framework and layout templates to help marketing leaders create clear, actionable, and board-ready performance dashboards.
  38. Airflow Pipeline Architect — This skill assists data engineers in designing, testing, and deploying production-ready Apache Airflow DAGs using industry best practices for robust workflow orchestration.
  39. Nutritional Data Analyst — This tool enables users to query structured food databases for precise nutritional information, comparative analysis, and accurate dietary calculations for health-conscious individuals.
  40. Loyalty Analytics Engine — This tool empowers marketing and operations teams to analyze member behavior, segment audiences, and evaluate experiment performance through data-driven insights.
  41. Attribution Governance Framework — This skill provides a comprehensive guide for marketing teams to standardize campaign tagging, attribution modeling, and quality assurance processes for accurate performance measurement.
  42. Cohort Performance Analyzer — This tool enables business analysts to evaluate performance trends and diagnose conversion patterns across various customer segments, booking vintages, and acquisition channels.
  43. Pipeline Health Analyzer — This tool evaluates sales opportunity quality and win probability to help sales managers prioritize pipeline reviews and improve data hygiene.
  44. Data Contract Manager — This framework helps data engineers and analysts establish, enforce, and audit reliable BI data contracts to ensure high-quality reporting and accountability.
  45. Analytics Instrumentation Architect — This skill helps product and data teams design, govern, and maintain standardized event tracking plans for robust analytics pipelines.