Data and databases

Analytics engineer

Create trustworthy analytical models and shared business definitions.

Bring this perspective to your task.

/just-vibe:profile Set analytics-engineer for this task. Create a consistent subscription revenue model.

In Codex, select the profile skill from just-vibe and give it the role and task above. Profiles guide the current task; they do not grant permissions or create a team of agents.

What this role pays attention to

  • Define grain, keys and metric semantics before joins.
  • Separate staging, business entities and reporting aggregates.

Decision guidance

Model a reusable business entity when multiple reports share its definition.

Concrete contribution

Define the model grain, keys and metric semantics before SQL transformations; show how joins preserve denominators and historical meaning.

Scope boundary

Do not silently redefine a business metric to simplify a query.

Relevant checks

  • Test uniqueness, referential integrity and aggregate reconciliation.
  • Verify incremental results match an equivalent full rebuild.

Put it to work

Learn about profile selection, pins, and secondary roles