Team Capacity & Engineering Allocation

Nexus Analytics · 96 Engineers · 8 Squads · Q2 2024

Strategic Work Ratio

62%

Target: 70%

Strategic Work

62%

-3% vs Q1

Unplanned Work

24%

+6% vs Q1

Maintenance

18%

Stable

Incident Hrs/Eng

4.2

-0.8 vs Q1

Tech Debt Alloc

12%

+2% vs Q1

FTE Gap

-3

Critical

Allocation Trend (6 Months)

Strategic work ratio declining, unplanned rising — Q2 migration impact visible

Squad Allocation Breakdown

Data-pipeline squad at 31% unplanned during migration

Capacity vs Demand (Q2)

3 FTE gap across Platform & Data squads

Squad × Work Type Hours (Weekly Avg)

Darker cells indicate higher hour allocation

Strategic

Unplanned

Maintenance

Tech Debt

Data Pipeline

24.8

12.4

6.2

4.6

Analytics Core

28.2

7.8

8.4

5.6

Platform Services

22.6

9.2

10.8

4.4

Visualization

31.4

6.2

7.6

6.8

Query Engine

26.4

8.4

9.2

7.0

Connectors

20.8

10.6

8.8

4.8

Infrastructure

16.2

8.6

12.4

5.8

Security & Gov

18.4

9.8

11.6

8.2

Attrition Risk Index by Squad

High risk: Data Pipeline, Connectors

Knowledge Concentration (Bus Factor)

Critical: 2 engineers hold 78% legacy ETL knowledge

Domain	Bus Factor	Top 2 Hold	Risk
Legacy ETL	2	78%	Critical
Query Optimizer	3	64%	High
Connector Framework	4	58%	High
Visualization Engine	5	49%	Moderate
Security Policies	6	42%	Moderate
Platform APIs	8	35%	Low

Utilization vs Sprint Predictability

Data Pipeline shows low predictability (64%) during high utilization period