Analytics Engineering Bundle
Semantic-layer design, exposure tracking, metric definitions, change-management, and BI-handoff skills.
Browse all skill bundles
Included Skills (43)
- Data Build Tool — This skill helps data engineers transform data in their warehouse using SQL SELECT statements with dbt.
- 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.
- dbt Validation Generator — Automates the creation of SQL validation notebooks for dbt model changes, helping data engineers verify data integrity during pull requests.
- 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.
- Product Analytics — Use when defining product KPIs, building metric dashboards, running cohort or retention analysis, or interpreting feature adoption trends across product stages.
- 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.
- 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.
- 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.
- Monte Carlo Optimizer — Analyzes Monte Carlo monitor reports to identify alert patterns and recommend configuration adjustments that effectively reduce noise for data engineers.
- Snowflake Development Assistant — Assists data engineers and analysts in developing Snowflake SQL, data pipelines, and Snowpark Python applications efficiently and effectively.
- SQL Query Generator — This tool transforms natural language requirements into optimized SQL queries, helping analysts and engineers efficiently retrieve data across various database platforms.
- DLT Pipeline Builder — Assists developers in building data pipelines using the open-source dlt Python library for data loading and ingestion.
- CSV Data Processor — This skill parses and generates CSV files, assisting developers with data import/export, ETL pipelines, and report generation tasks.
- Analytics Quality Framework — This skill helps data engineers and analysts establish robust testing, automated monitoring, and incident response protocols for analytics models and dashboards.
- 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.
- 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.
- 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.
- 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.
- PostHog Analytics Automator — This tool automates PostHog event tracking and feature flag management, helping developers streamline product analytics workflows via the Rube MCP integration.
- 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.
- 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.
- 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.
- Document Data Extractor — Extracts structured data from various document formats, converting them into JSON or CSV for data analysis and processing.
- 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.
- 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.
- 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.
- Data Quality Validator — This skill validates data quality in various formats, helping data engineers and analysts ensure reliable data pipelines and analytics.
- 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.
- 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.
- Kafka Event Streaming — Facilitates building event-driven systems using Apache Kafka for users needing message streaming and real-time data processing.
- SQL Cost Optimizer — This tool audits SQL queries for performance anti-patterns to help data engineers reduce warehouse costs and improve overall database efficiency.
- Monte Carlo Triage — This skill provides modular tools and workflows to help data teams interactively triage, score, and troubleshoot Monte Carlo alerts efficiently.
- 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.
- 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.
- Executive Dashboard Architect — This skill provides a structured framework and layout templates to help marketing leaders create clear, actionable, and board-ready performance dashboards.
- 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.
- 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.
- Loyalty Analytics Engine — This tool empowers marketing and operations teams to analyze member behavior, segment audiences, and evaluate experiment performance through data-driven insights.
- 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.
- 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.
- Pipeline Health Analyzer — This tool evaluates sales opportunity quality and win probability to help sales managers prioritize pipeline reviews and improve data hygiene.
- 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.
- Analytics Instrumentation Architect — This skill helps product and data teams design, govern, and maintain standardized event tracking plans for robust analytics pipelines.