# analytics-engineer

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.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 207 installs · ★ 1183 repo stars
- Author: borghei
- License: LicenseRef-MIT-Commons-Clause · policy=link-only · description only; the file stays with the author
- Source: https://github.com/borghei/Claude-Skills/tree/HEAD/data-analytics/analytics-engineer/SKILL.md
- Updated: 2026-10-23
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/analytics-engineer

## What it 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.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add borghei/Claude-Skills --skill analytics-engineer -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/analytics-engineer/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/analytics-engineer/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add borghei/Claude-Skills --skill analytics-engineer -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/analytics-engineer/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add borghei/Claude-Skills --skill analytics-engineer -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/analytics-engineer/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install borghei/Claude-Skills data-analytics/analytics-engineer/SKILL.md
```

2. **Manually: put the files in place**
- File: `.github/skills/analytics-engineer/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add borghei/Claude-Skills --skill analytics-engineer -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/borghei/Claude-Skills --path data-analytics/analytics-engineer
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/analytics-engineer/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add borghei/Claude-Skills --skill analytics-engineer -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/borghei/Claude-Skills/tree/HEAD/data-analytics/analytics-engineer/SKILL.md

## When to use it
- 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
- 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`

## Similar
- [using-dbt-for-analytics-engineering](https://affpapa.org/en/nevibecode/skills/using-dbt-for-analytics-engineering.md) — skill · 1200 installs
- [dbt-expert](https://affpapa.org/en/nevibecode/skills/dbt-expert.md) — skill · 180 installs
- [warehouse-init](https://affpapa.org/en/nevibecode/skills/warehouse-init.md) — skill · 865 installs
- [using-dbt-state](https://affpapa.org/en/nevibecode/skills/using-dbt-state.md) — skill · 591 installs
- [data-pipeline-engineer](https://affpapa.org/en/nevibecode/skills/data-pipeline-engineer.md) — skill · 215 installs
- [build-model](https://affpapa.org/en/nevibecode/commands/build-model.md) — command · ★ 450 repo stars

From the same set: [borghei/claude-skills](https://affpapa.org/en/nevibecode/by/borghei/claude-skills.md) — 120 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
