Data Department Orchestrator
Operating contract
- Identify the requested deliverable, then select exactly one atomic task below.
- Read that task file completely before acting.
- Read references/lifecycle-standard.md and use the task's profile, risk tier and execution path.
- Load only the company context and adapter references needed for the selected task.
- On a cross-role handoff, compare logical ID and SHA-256 in
references/shared-reference-manifest.json; reuse an already loaded shared reference when both match instead of loading its duplicate.
- Inspect real artifacts and systems before making change-sensitive claims.
- Apply Definition of Ready, stage gates, test strategy, Definition of Done, approval and handoff requirements.
- Do not invent access, approvals, successful execution, test results or business confirmation.
- For any Git-backed mutation, regardless of the task's verb or profile, require a pre-change success/scope contract, a post-change
core-audit-change-scope, and fresh core-verify-deliverable evidence before completion.
- For learning, coaching or skill-transition work, resolve the learner-memory interoperability contract. Reuse only relevant verified summaries; never infer mastery from exposure, and expand stale, uncertain, changed-version or safety-critical prerequisites.
Role routing
Read references/role-routing.md to select the primary role by deliverable ownership. Keep one accountable role per atomic task. Use shared core controls as dependencies, not as substitute owners.
Route personal learning, capstone or portfolio projects—including repo-first, dataset-first and external-idea-first requests—to data-personal-project-engineering. Keep organizational repository rebuilds and governed cross-role delivery in this orchestrator.
Execution-pattern routing
- One ordered chain where each task consumes the previous deliverable →
orchestrator-run-sequential-workflow.
- Independent branches with disjoint write paths →
orchestrator-run-parallel-workflow.
- One input split across branches and recombined into a single deliverable →
orchestrator-run-fanout-fanin.
- Route selection that depends on an intermediate result →
orchestrator-run-conditional-workflow.
- A deliverable whose plausible-but-wrong failure is expensive, checked by an independent reviewer →
orchestrator-run-producer-reviewer.
Parallel and fan-out require branch isolation by write path, a validated branch plan, and a declared merge policy; read references/parallel-execution-and-agent-teams.md. A delegated branch never approves, publishes, mutates production or raises its own risk tier, and a dependency between branches means the work is sequential. Concurrent agent execution may be unavailable in a given harness; the branch contract holds in either mode and correctness never depends on the runtime.
Workflow state
For multi-step work, initialize assets/workflow-manifest.json and update it after every completed task or gate. Every task_id must be an exact canonical ID from assets/task-catalog.json; use optional instance_id only as a human-friendly occurrence label. Claim status is limited to draft, verified or rejected. Run scripts/validate_workflow.py before execution, after transitions and in complete mode before the final claim. Read-only work must still validate a temporary manifest outside the target repository. Use assets/approval-record.json for version/hash-bound authority and check it with scripts/validate_approval_record.py --require-approved before any gated action; an expired, out-of-scope or hash-mismatched record is the same as no approval. Track the run with assets/run-state.yaml and scripts/validate_run_state.py. Resume from the latest verified state; never redo an approved artifact without a change request.
Record optional improvement telemetry only through scripts/record_skill_telemetry.py and assets/telemetry-event.json; never store user content, prompts, secrets or data values. Aggregate it with scripts/analyze_skill_telemetry.py; high failure or override rates trigger investigation, never weaker gates. Score contracts against those outcomes with scripts/score_skill_quality.py; its recommendations are change requests with evidence attached, never direct edits. Govern reusable patterns with scripts/manage_instincts.py and assets/instinct-ledger.json: confidence is the Wilson lower bound of counted outcomes, only active instincts may shape behavior, and an instinct unconfirmed for 90 days weakens until it is re-tested.
Atomic task routing
- Plan, define, design, map, specify or create a proposed artifact (3 tasks): read references/catalog-plan-design.md.
- Build, implement, configure, teach, interview or deliver an artifact — project deliverables (3 tasks): read references/catalog-build-deliver-project.md.
- Build, implement, configure, teach, interview or deliver an artifact — register deliverables (3 tasks): read references/catalog-build-deliver-register.md.
- Build, implement, configure, teach, interview or deliver an artifact — decision deliverables (2 tasks): read references/catalog-build-deliver-decision.md.
- Build, implement, configure, teach, interview or deliver an artifact — ledger deliverables (2 tasks): read references/catalog-build-deliver-ledger.md.
- Build, implement, configure, teach, interview or deliver an artifact — remaining deliverables (10 tasks): read references/catalog-build-deliver-other.md.
- Inspect, analyze, test, review, validate, assess, certify or audit (4 tasks): read references/catalog-test-assure.md.
Read only the best-matching catalog. If intent remains ambiguous, inspect a second catalog; do not load all catalogs by default. Select one task by primary deliverable, then read its contract completely.
Completion response
State the selected task ID, primary deliverable, evidence inspected, validation performed, approval status, residual risks and next owner. A draft or plan is not an executed production outcome.
1---2name: data-department-orchestrator3description: Route ambiguous, organizational or multi-role Data Department requests and compose governed workflows with owners, dependencies, gates and handoffs. Use when the named deliverable cannot be built until another role sources, models or certifies its inputs — a dashboard from systems not yet ingested, an incident spanning monitoring, diagnosis and revalidation, a rebuild combining discovery, implementation and proof. The deliverable named last does not decide the owner; the work standing in front of it does. Route personal learning or portfolio projects to Personal Data Project Engineering.4---56# Data Department Orchestrator78## Operating contract9101. Identify the requested deliverable, then select exactly one atomic task below.112. Read that task file completely before acting.123. Read [references/lifecycle-standard.md](references/lifecycle-standard.md) and use the task's profile, risk tier and execution path.134. Load only the company context and adapter references needed for the selected task.145. On a cross-role handoff, compare logical ID and SHA-256 in `references/shared-reference-manifest.json`; reuse an already loaded shared reference when both match instead of loading its duplicate.156. Inspect real artifacts and systems before making change-sensitive claims.167. Apply Definition of Ready, stage gates, test strategy, Definition of Done, approval and handoff requirements.178. Do not invent access, approvals, successful execution, test results or business confirmation.189. For any Git-backed mutation, regardless of the task's verb or profile, require a pre-change success/scope contract, a post-change `core-audit-change-scope`, and fresh `core-verify-deliverable` evidence before completion.1910. For learning, coaching or skill-transition work, resolve [the learner-memory interoperability contract](references/learning-memory-interoperability.md). Reuse only relevant verified summaries; never infer mastery from exposure, and expand stale, uncertain, changed-version or safety-critical prerequisites.2021## Role routing2223Read [references/role-routing.md](references/role-routing.md) to select the primary role by deliverable ownership. Keep one accountable role per atomic task. Use shared core controls as dependencies, not as substitute owners.2425Route personal learning, capstone or portfolio projects—including repo-first, dataset-first and external-idea-first requests—to `data-personal-project-engineering`. Keep organizational repository rebuilds and governed cross-role delivery in this orchestrator.2627## Execution-pattern routing2829- One ordered chain where each task consumes the previous deliverable → `orchestrator-run-sequential-workflow`.30- Independent branches with disjoint write paths → `orchestrator-run-parallel-workflow`.31- One input split across branches and recombined into a single deliverable → `orchestrator-run-fanout-fanin`.32- Route selection that depends on an intermediate result → `orchestrator-run-conditional-workflow`.33- A deliverable whose plausible-but-wrong failure is expensive, checked by an independent reviewer → `orchestrator-run-producer-reviewer`.3435Parallel and fan-out require branch isolation by write path, a validated branch plan, and a declared merge policy; read [references/parallel-execution-and-agent-teams.md](references/parallel-execution-and-agent-teams.md). A delegated branch never approves, publishes, mutates production or raises its own risk tier, and a dependency between branches means the work is sequential. Concurrent agent execution may be unavailable in a given harness; the branch contract holds in either mode and correctness never depends on the runtime.3637## Workflow state3839For multi-step work, initialize `assets/workflow-manifest.json` and update it after every completed task or gate. Every `task_id` must be an exact canonical ID from `assets/task-catalog.json`; use optional `instance_id` only as a human-friendly occurrence label. Claim status is limited to `draft`, `verified` or `rejected`. Run `scripts/validate_workflow.py` before execution, after transitions and in complete mode before the final claim. Read-only work must still validate a temporary manifest outside the target repository. Use `assets/approval-record.json` for version/hash-bound authority and check it with `scripts/validate_approval_record.py --require-approved` before any gated action; an expired, out-of-scope or hash-mismatched record is the same as no approval. Track the run with `assets/run-state.yaml` and `scripts/validate_run_state.py`. Resume from the latest verified state; never redo an approved artifact without a change request.4041Record optional improvement telemetry only through `scripts/record_skill_telemetry.py` and `assets/telemetry-event.json`; never store user content, prompts, secrets or data values. Aggregate it with `scripts/analyze_skill_telemetry.py`; high failure or override rates trigger investigation, never weaker gates. Score contracts against those outcomes with `scripts/score_skill_quality.py`; its recommendations are change requests with evidence attached, never direct edits. Govern reusable patterns with `scripts/manage_instincts.py` and `assets/instinct-ledger.json`: confidence is the Wilson lower bound of counted outcomes, only `active` instincts may shape behavior, and an instinct unconfirmed for 90 days weakens until it is re-tested.424344## Atomic task routing4546- **Plan, define, design, map, specify or create a proposed artifact** (3 tasks): read [references/catalog-plan-design.md](references/catalog-plan-design.md).47- **Build, implement, configure, teach, interview or deliver an artifact — project deliverables** (3 tasks): read [references/catalog-build-deliver-project.md](references/catalog-build-deliver-project.md).48- **Build, implement, configure, teach, interview or deliver an artifact — register deliverables** (3 tasks): read [references/catalog-build-deliver-register.md](references/catalog-build-deliver-register.md).49- **Build, implement, configure, teach, interview or deliver an artifact — decision deliverables** (2 tasks): read [references/catalog-build-deliver-decision.md](references/catalog-build-deliver-decision.md).50- **Build, implement, configure, teach, interview or deliver an artifact — ledger deliverables** (2 tasks): read [references/catalog-build-deliver-ledger.md](references/catalog-build-deliver-ledger.md).51- **Build, implement, configure, teach, interview or deliver an artifact — remaining deliverables** (10 tasks): read [references/catalog-build-deliver-other.md](references/catalog-build-deliver-other.md).52- **Inspect, analyze, test, review, validate, assess, certify or audit** (4 tasks): read [references/catalog-test-assure.md](references/catalog-test-assure.md).5354Read only the best-matching catalog. If intent remains ambiguous, inspect a second catalog; do not load all catalogs by default. Select one task by primary deliverable, then read its contract completely.5556## Completion response5758State the selected task ID, primary deliverable, evidence inspected, validation performed, approval status, residual risks and next owner. A draft or plan is not an executed production outcome.