analytics-data-engineer
/analytics-data-engineer
Prowadzi projekt analityczny w dbt: modele staging i marty, testy, kontrakty danych, dokumentację, przyrostowe ładowanie i CI.
- Autor
- rade-nugroho ↗
- Repozytorium
- agentic-enteprises-skill ↗
- Licencja
- MIT
- Ostatnia zmiana repozytorium
- 20.05.2026
Ocena i bezpieczeństwo
- Pliki w paczce
- 7
- Skrypty
- 0
- Komentarze HTML
- 0
- Adresy URL w SKILL.md
- 0
Brak sygnałów. Repozytorium zmienione 20.05.2026, bez odwołań do wycofanych modeli i API.
MIT, otwarta: można używać i zmieniać, z zachowaniem informacji o autorze.
Co robi i kiedy
Prowadzi projekt analityczny w dbt: modele staging i marty, testy, kontrakty danych, dokumentację, przyrostowe ładowanie i CI.
Oryginalny opis (EN)
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-a
Jak działa
- When to Use
- When NOT to Use
- Related skills
- Core Workflows
- Output standards
- When to load references
Podgląd SKILL.md
--- name: analytics-data-engineer description: | 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). --- # 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`
Pliki w paczce (7)
- SKILL.md 4 KB
- references/analytics_modeling.md 1 KB
- references/dbt_project_structure.md 1 KB
- references/docs_lineage_exposures.md 1 KB
- references/incremental_cdc.md 1 KB
- references/metrics_alignment.md 1 KB
- references/testing_quality.md 1 KB
Wersje
W bazie nie ma innych skilli o nazwie analytics-data-engineer.
Migawka bazy z 13.11.2026 · wersja paczki ce10c4d58da2 (skrót SHA-256 całej paczki)
Pobrania w ostatnich 30 dniach: 0 · ranking
Zgłoś problem z tym skillem: szkodliwa treść, błędny opis albo prośba autora o usunięcie.
Podobne skille
- 100analytics-engineer
Prowadzi inżynierię analityczną: modelowanie danych, dbt, projektowanie schematów gwiazdy, SQL dla warstw staging i mart oraz testy danych. - 90dbt-and-analytics-engineering
Prowadzi przez analytics engineering w dbt: modele staging i marty, testy, snapshoty, dokumentacja, exposures i modele warstwy semantycznej. - 100dbt-expert
Pomaga w pracy z dbt na poziomie eksperckim: modele, testy, dokumentacja, modele przyrostowe, makra i szablony Jinja oraz struktura projektu ze źródłami, warstwą staging i marts. - 100dbt-models
Układa, pisze, testuje i dokumentuje modele dbt w warstwach staging, intermediate i mart, z modelami przyrostowymi i migawkami historii. - 95dbt-modeling
Pisze i refaktoryzuje modele dbt z wzorcami CTE i szablonami warstw staging, intermediate oraz mart. - 100dbt
Obsługuje warstwę transformacji dbt: wersjonowane i testowane modele SQL w warstwach staging, intermediate i mart dla projektów z katalogiem dbt/.