Agent Skills by nrakow
Showing 40 vetted skills indexed across 1 GitHub repositories.
nrakowmarts-design
Design dbt data mart layers with domain ownership, stable grain, and BI-ready structure.
nrakowadvanced-jinja-patterns
Generate dynamic SQL with reusable Jinja macros in dbt.
nrakowdata-catalog
Generate dbt YAML documentation and OpenMetadata connector configuration.
nrakownew-source-onboarding
Onboard new data sources through ingestion, staging, testing, documentation, and lineage phases.
nrakowpipeline-design
Designs end-to-end data pipelines with orchestration tools and dbt for ingestion to serving layers.
nrakowdata-modeling
Design dimensional data models and warehouse schemas for analytics projects.
nrakownew-mart-build
Automates mart creation from staging to BI exposure with dbt tasks and metrics integration.
nrakowdata-stack-context
Create and maintain a centralized data stack context document from dbt project files.
nrakowingestion-strategy
Select and configure data ingestion strategies for Fivetran, Airbyte, or custom pipelines.
nrakowobt-design
Design and implement wide, pre-joined OBT models with declared grain and dbt materialization.
nrakowdbt-project-setup
Scaffold dbt projects with folder structure, profiles, packages, and CI configuration.
nrakownew-project-setup
Sequence six foundational skills to scaffold a complete dbt analytics project.
nrakowcohort-analysis
Model user cohorts to quantify retention and lifetime value in dbt workflows.
nrakowincremental-models
Automate incremental dbt modeling for new or changed data across Snowflake, BigQuery, Redshift, Databricks, and DuckDB.
nrakowpii-handling
Identify and classify PII in Snowflake and dbt workflows.
nrakowkpi-framework
Define organization KPIs and generate dbt-compatible dictionaries and hierarchies.
nrakowstaging-layer
Convert raw source tables into standardized dbt staging models with 1:1 mapping.
nrakowdbt-unit-testing
Validate dbt transformation logic with unit tests using mocked inputs and expected outputs.
nrakowmetrics-layer
Define semantic models and metrics for dbt Semantic Layer, MetricFlow, and Cube.
nrakowdashboard-design
Design BI dashboards with KPI hierarchy, layout, and filters.
nrakowmodel-deprecation
Deprecate dbt models, columns, or sources with lineage checks and dbt compile validation.
nrakowdata-lineage
Trace data lineage across dbt sources, transformations, and reports.
nrakowself-serve-analytics
Designs and deploys a self-serve analytics layer for non-technical users.
nrakowwarehouse-optimization
Optimize data warehouse performance with clustering, partitioning, and query tuning.