staff-analytics-engineer

What problem does it solve?

It provides specialized guidance for designing and managing dbt projects focused on financial and analytical models, ensuring consistency, correctness, and auditability.

Core Features & Use Cases

• Model Architecture Design: Assists in structuring staging, intermediate, and mart layers adhering to best practices.
• Data Testing & Documentation: Guides on defining column descriptions, writing tests, and ensuring data quality.
• Semantic Layer & Metrics: Supports creation of business metrics using MetricFlow, and setup of source freshness and snapshots.
• Use Case: A team implementing a new financial metric can use this skill to define the metric in MetricFlow, add relevant tests, and document the schema efficiently.

Quick Start

Request dbt model setup for a new sales reporting star schema.