DataOps Maturity Assessment AI Prompt

Conduct a DataOps maturity assessment for this data team and create an improvement roadmap.

Team: {{team_description}}
Current practices: {{current_practices}}
Pain points: {{pain_points}}
Goals: {{goals}}

1. Maturity dimensions to assess (score 1-5 each):

   Version control:
   1: No version control; SQL in spreadsheets / ad-hoc scripts
   3: All code in git; PRs required for changes
   5: All code, config, and DDL in git; automated linting and formatting

   Automated testing:
   1: No automated tests; manual QA before deployment
   3: Unit tests for transformations; basic schema tests
   5: Full test pyramid; contract tests; automated regression testing

   CI/CD:
   1: Manual deployments; no CI
   3: CI runs on PR; deployment is semi-automated with a manual step
   5: Fully automated CI/CD; canary deployments; automated rollback

   Monitoring and alerting:
   1: Consumers notice data issues before the data team
   3: Pipeline success/failure alerts; basic freshness monitoring
   5: Comprehensive quality monitoring; anomaly detection; SLA tracking per table

   Documentation:
   1: No documentation; knowledge in people's heads
   3: Key models documented in the catalog; ownership assigned
   5: All assets documented; auto-updated catalog; data contracts for all public data products

   Incident management:
   1: Ad-hoc response; no runbooks
   3: Runbooks for common failures; post-mortems for major incidents
   5: Automated incident detection; auto-remediation for known failure patterns; blameless post-mortems

2. Current state scoring:
   Score each dimension for the current team.
   Identify: the two lowest-scoring dimensions (highest improvement opportunity).

3. 90-day improvement roadmap:
   Based on the lowest scores, propose 3 high-impact initiatives for the next 90 days.
   Each initiative: title, current state, target state, actions, owner, success metric.

4. Quick wins (< 2 weeks each):
   Identify 3 changes that can be made immediately with high visibility impact.

Return: maturity scorecard for each dimension, gap analysis, 90-day roadmap, and quick wins.