Skip to main content
skill CX Codex

analytics-engineer — Claude Code skill: dbt models and SQL transformations

analytics-engineer — a skill for Claude Code, Codex, Cursor, Copilot, Gemini CLI and OpenCode that builds dbt transformations and dimensional schemas. Triggered when you need SQL models, tests, incremental fact tables or metrics.

LicenseRef-MIT-Commons-Clause 207 installs ★ 1,183 updated 2026-10-23

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add borghei/Claude-Skills --skill analytics-engineer -a claude-code
Open on GitHub

What analytics-engineer does

Acts as a senior analytics engineer: designs star and snowflake schemas, writes stg_, int_ and mart dbt models, configures materialization (view, table, incremental), adds tests (unique, not_null, relationships) and YAML docs, registers metrics in the semantic layer.

Before building models, the agent asks about row grain, data sources and refresh cadence. Runs dbt build, checks test pass rate and verifies dashboard numbers. No FFmpeg or external dependencies, just SQL and Jinja.

Includes full examples for dimension models (dim_customer) and fact tables (fct_orders), materialization strategy by layer (staging as view, intermediate as ephemeral, marts as table or incremental), test schema and dbt project structure.

What it helps with

  • write a dbt staging model from a source table with column renaming
  • design a star schema for sales mart
  • set up an incremental fact table partitioned by date
  • add unique and not_null tests to all primary keys
  • register sum and count_distinct metrics in the semantic layer

Example prompts for the agent

  • Write a staging model stg_crm__customers from raw.customers
  • Design a star schema for orders: which dim and fct tables do I need
  • Create an incremental model fct_orders, partition by order_date

How to install analytics-engineer

1Skills CLI (Vercel)

npx skills add borghei/Claude-Skills --skill analytics-engineer -a claude-code

2Manually: put the files in place

~/.claude/skills/analytics-engineer/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/analytics-engineer/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about analytics-engineer

How to install analytics-engineer in Claude Code?

Run npx skills add borghei/Claude-Skills --skill analytics-engineer -a claude-code, the skill will appear in ~/.claude/skills/analytics-engineer/SKILL.md.

What does the analytics-engineer skill do?

Builds dbt transformation models, designs dimensional schemas, writes staging, intermediate and mart SQL, configures materialization and tests, registers metrics in the semantic layer.

Which dbt materialization should I use for a fact table?

For large facts use incremental with date partitioning. For small lookup tables table is enough. Staging layer is usually view.

Similar skills

All skills for Data and databases →

From the same set120

The whole set →
seo-specialist The seo-specialist skill guides technical SEO audits, keyword research, and on-page improvements. Use it to investigate a site or review organic search performance. CX Codex +1 244installs senior-prompt-engineer senior-prompt-engineer — a skill for Claude Code that reviews prompt architecture, scores RAG quality, and diagrams agent workflows. Flags redundant instructions and missing output contracts during prompt tuning. CX Codex +1 239installs senior-qa senior-qa — a skill for Claude Code and five other platforms that structures test suites for React and Next.js apps. Scaffolds Jest unit tests, Playwright specs, and inspects coverage reports. CX Codex +1 232installs senior-devops senior-devops is a Claude Code skill that generates CI/CD pipelines, Docker images, and Terraform infrastructure, selects deployment strategies, and orchestrates rollbacks. CX Codex +1 209installs people-analytics The people-analytics skill examines workforce metrics, engagement surveys, pay equity, and employee flight risk. Use it when an HR question needs structured analysis or a prediction model. CX Codex +1 206installs senior-security senior-security is a Claude Code and Codex skill for threat modeling, code review, and secret scanning. It supports application security assessments and defensive architecture planning. CX Codex +1 203installs contract-and-proposal-writer The contract-and-proposal-writer skill drafts contracts, proposals, SOWs, NDAs, and MSAs around a chosen jurisdiction. Use it when preparing client-facing business documents. CX Codex +1 202installs senior-data-engineer senior-data-engineer — a skill for Claude Code and Codex that automates data engineering workflows. Generates orchestrator DAGs, profiles data schemas, and flags query bottlenecks in Spark and SQL. CX Codex +1 199installs

Project sponsors

Companies that keep this analytics open