Workforce Capacity & Allocation Intelligence

Nexus Analytics • 96 Engineers • 8 Squads

North Star Metric

61% Strategic Work Ratio

Target: 72%

Strategic Work Ratio

61%

+4% vs Q1

Unplanned Work Rate

23%

+3% vs target

Maintenance vs Feature

19%

Stable

Incident Response (h/eng)

3.8h

-1.2h vs Q1

Tech Debt Allocation

11%

-4% vs plan

Capacity vs Demand Gap

-4 FTE

Critical

Capacity Allocation Trend (6 Months)

Squad Allocation Breakdown

Sprint Predictability vs Unplanned Work

Squad × Work Type Hours (Weekly Avg)

Strategic

Unplanned

Maint

Incidents

Tech Debt

Data Pipeline

168h

98h

52h

38h

24h

API Core

212h

42h

48h

18h

32h

Analytics UI

184h

36h

44h

14h

28h

Infra

96h

54h

72h

58h

18h

ML Platform

196h

38h

42h

16h

46h

Security

124h

32h

64h

28h

22h

Data Science

172h

44h

36h

12h

38h

DevExp

148h

48h

56h

22h

34h

Knowledge Concentration Risk (Bus Factor)

System / Domain	Bus Factor	Risk
Legacy ETL Pipeline	2	Critical
Billing System	3	High
Auth Service	4	Medium
ML Model Training	3	High
API Gateway	6	Low
Monitoring Stack	5	Medium
Data Warehouse	4	Medium
Frontend Platform	7	Low

Alert: Two engineers hold 81% of Legacy ETL knowledge. Immediate cross-training required.

Attrition Risk Index (Squad Average)

Overall Index

0.2 API Core

0.4 Analytics UI

0.6 Data Pipeline

0.7 Infra

Key Insights

Strategic Work Gap

11% below target (72%). Rebalance unplanned work from 23% → 20%.

Data Pipeline Crisis

34% unplanned work during Q2 migration drove predictability to 62%.

Incident Response Win

Dropped from 5.0h to 3.8h/eng via on-call automation initiatives.