Analytics Data Engineer
When to Use
- Structure a dbt project (layers, naming, materializations)
- Build staging → intermediate → mart pipelines in the warehouse
- Implement incremental, snapshot, or CDC-driven models
- Add tests (unique, not null, relationships, custom SQL) and freshness checks
- Document models and expose lineage for BI and stakeholders
- Define marts that map to metrics and dashboards
- Set up CI for analytics SQL (compile, test, slim CI)
- Debug metric mismatches between mart and dashboard
When NOT to Use
- Enterprise mesh, governance program, platform selection →
data-architect
- Partition/cluster tuning without dbt context →
data-warehouse-engineer
- Chart choice, executive dashboards, stakeholder storytelling →
bi-analyst
- Feature engineering, training, experiments →
data-scientist
- Data org roadmap and steward operations →
data-manager
- Analytics eng hiring, squad roadmap, launch governance →
analytics-data-engineering-manager-product
- Generic app CI/CD without analytics patterns →
devops
Related skills
| Need |
Skill |
| Warehouse SQL tuning, star schema theory |
data-warehouse-engineer |
| KPI definitions and dashboards |
bi-analyst |
| Platform and domain architecture |
data-architect |
| Pipeline on-call and platform SLOs |
data-system-ops-lead |
| ML and advanced stats |
data-scientist |
| Requirements and metric business rules |
business-analyst |
Core Workflows
1. Project layout and conventions
Layering, naming (stg_, int_, fct_, dim_), materialization defaults, env targets.
See references/dbt_project_structure.md.
2. Modeling for analytics
Facts, dimensions, wide marts, grain, degenerate dimensions, bridge tables.
See references/analytics_modeling.md.
3. Incremental and CDC
Merge strategies, full-refresh exceptions, late-arriving facts.
See references/incremental_cdc.md.
4. Quality and contracts
Tests, severity, source freshness, optional contracts with downstream.
See references/testing_quality.md.
5. Docs, lineage, exposures
Model descriptions, column docs, exposures to BI tools.
See references/docs_lineage_exposures.md.
6. Metrics alignment
Grain, definitions, ownership with bi-analyst and business-analyst.
See references/metrics_alignment.md.
Output standards
- Every mart documents grain and primary key in YAML
- Tests on keys and critical business rules before merge
- PR includes: models changed, test plan, backfill impact, downstream exposures
- No breaking grain change without migration note to BI
When to load references
- dbt layout →
references/dbt_project_structure.md
- Modeling →
references/analytics_modeling.md
- Incremental →
references/incremental_cdc.md
- Tests →
references/testing_quality.md
- Docs/CI →
references/docs_lineage_exposures.md
- Metrics →
references/metrics_alignment.md
1---2name: analytics-data-engineer3description: Guides analytics engineering—dbt (or equivalent) project structure, staging/intermediate/mart models, dimensional and wide-mart patterns, incremental and CDC loads, data tests and contracts, documentation and lineage, CI for analytics code, and handoff to BI semantic layers. Use when building or refactoring analytics models, writing dbt SQL, defining tests and exposures, debugging mart freshness, or aligning warehouse tables to business metrics—not for leading product-embedded analytics teams or launch roadmaps (analytics-data-engineering-manager-product), enterprise data platform ADRs (data-architect), deep warehouse platform tuning only (data-warehouse-engineer), dashboard design (bi-analyst), or ML modeling (data-scientist).4---56# Analytics Data Engineer78## When to Use910- Structure a **dbt project** (layers, naming, materializations)11- Build **staging → intermediate → mart** pipelines in the warehouse12- Implement **incremental**, snapshot, or CDC-driven models13- Add **tests** (unique, not null, relationships, custom SQL) and freshness checks14- Document models and expose **lineage** for BI and stakeholders15- Define **marts** that map to metrics and dashboards16- Set up **CI** for analytics SQL (compile, test, slim CI)17- Debug **metric mismatches** between mart and dashboard1819## When NOT to Use2021- Enterprise mesh, governance program, platform selection → `data-architect`22- Partition/cluster tuning without dbt context → `data-warehouse-engineer`23- Chart choice, executive dashboards, stakeholder storytelling → `bi-analyst`24- Feature engineering, training, experiments → `data-scientist`25- Data org roadmap and steward operations → `data-manager`26- Analytics eng hiring, squad roadmap, launch governance → `analytics-data-engineering-manager-product`27- Generic app CI/CD without analytics patterns → `devops`2829## Related skills3031| Need | Skill |32|---|---|33| Warehouse SQL tuning, star schema theory | `data-warehouse-engineer` |34| KPI definitions and dashboards | `bi-analyst` |35| Platform and domain architecture | `data-architect` |36| Pipeline on-call and platform SLOs | `data-system-ops-lead` |37| ML and advanced stats | `data-scientist` |38| Requirements and metric business rules | `business-analyst` |3940## Core Workflows4142### 1. Project layout and conventions4344Layering, naming (`stg_`, `int_`, `fct_`, `dim_`), materialization defaults, env targets.4546**See `references/dbt_project_structure.md`.**4748### 2. Modeling for analytics4950Facts, dimensions, wide marts, grain, degenerate dimensions, bridge tables.5152**See `references/analytics_modeling.md`.**5354### 3. Incremental and CDC5556Merge strategies, full-refresh exceptions, late-arriving facts.5758**See `references/incremental_cdc.md`.**5960### 4. Quality and contracts6162Tests, severity, source freshness, optional contracts with downstream.6364**See `references/testing_quality.md`.**6566### 5. Docs, lineage, exposures6768Model descriptions, column docs, exposures to BI tools.6970**See `references/docs_lineage_exposures.md`.**7172### 6. Metrics alignment7374Grain, definitions, ownership with `bi-analyst` and `business-analyst`.7576**See `references/metrics_alignment.md`.**7778## Output standards7980- Every mart documents **grain** and **primary key** in YAML81- Tests on keys and critical business rules before merge82- PR includes: models changed, test plan, backfill impact, downstream exposures83- No breaking grain change without migration note to BI8485## When to load references8687- **dbt layout** → `references/dbt_project_structure.md`88- **Modeling** → `references/analytics_modeling.md`89- **Incremental** → `references/incremental_cdc.md`90- **Tests** → `references/testing_quality.md`91- **Docs/CI** → `references/docs_lineage_exposures.md`92- **Metrics** → `references/metrics_alignment.md`
daemon-blockint-tech