“Backup Oversight Workload: Which Engineers Own Too Many Client Backups?”
Autotask PSA Datto RMM Datto Backup Microsoft 365 SmileBack HubSpot IT Glue All reports
AI-GENERATED REPORT
You searched for:

Backup Oversight Workload: Which Engineers Own Too Many Client Backups?

This report crosses HiBob employee data (team structure, reporting lines, span of control) with Datto Backup telemetry (backup job success rates per client) to reveal how backup monitoring workload is distributed. Two sources, one question: is your backup oversight spread evenly, or are a few engineers carrying all the weight?

Built from: Datto Backup
How this report was made
1
Autotask PSA
Multiple data sources combined
2
Proxuma Power BI
Pre-built MSP semantic model, 50+ measures
3
AI via MCP
Claude or ChatGPT writes DAX queries, executes them, formats output
4
This Report
KPIs, breakdowns, trends, recommendations
Ready in < 15 min

Backup Oversight Workload: Which Engineers Own Too Many Client Backups?

This report crosses HiBob employee data (team structure, reporting lines, span of control) with Datto Backup telemetry (backup job success rates per client) to reveal how backup monitoring workload is distributed. Two sources, one question: is your backup oversight spread evenly, or are a few engineers carrying all the weight?

The data covers the full scope of Autotask PSA records relevant to this analysis, broken down by the key dimensions your team needs for day-to-day decisions and client reporting.

Who should use this: NOC teams, service managers, and MSP owners monitoring backup compliance

How often: Daily for operations, weekly for management review, monthly for client reporting

Time saved
Checking backup status across all clients manually means logging into multiple consoles. This report pulls everything into one view.
Risk visibility
Backup failures are invisible until a restore fails. This report surfaces gaps before they become incidents.
Compliance evidence
For regulated clients, documented backup status is not optional. This report provides the audit trail.
Report categoryBackup & Data Protection
Data sourceAutotask PSA · Datto RMM · Datto Backup · Microsoft 365 · SmileBack · HubSpot · IT Glue
RefreshReal-time via Power BI
Generation timeUnder 15 minutes
AI requiredClaude, ChatGPT or Copilot
AudienceNOC teams, service managers
Where to find this in Proxuma
Power BI › Backup › Backup Oversight Workload: Which Engi...
What you can measure in this report
Executive Summary
Engineer Workload Distribution
Backup Success Rate by Engineer Workload
Clients Without an Assigned Backup Engineer
Team-Level Workload Breakdown
Backup Health vs Span of Control
Key Findings
Strategic Recommendations
Frequently Asked Questions
Total Employees
Avg Span of Control
Avg Backup Success Rate
AI-Generated Power BI Report

Backup Oversight Workload: Which Engineers Own Too Many Client Backups?

This report crosses HiBob employee data (team structure, reporting lines, span of control) with Datto Backup telemetry (backup job success rates per client) to reveal how backup monitoring workload is distributed. Two sources, one question: is your backup oversight spread evenly, or are a few engineers carrying all the weight?

Demo mode: This report uses synthetic sample data. Connect your own data sources to see real results.
1.0 Executive Summary
Total Employees
24
Across 4 teams
Avg Span of Control
4.8
Above target of 4.0
Avg Backup Success Rate
91.3%
+2.1% vs last month
Unassigned Clients
7
No backup owner
Data note: Employee records are sourced from BI_HiBob_Employees (team, manager, direct reports). Backup job telemetry comes from BI_Datto_Backup_Jobs (status, client, last run). Client names are matched against BI_Autotask_Companies for consistency.
View DAX - Total Employees
Total Employees =
COUNTROWS(
    FILTER(
        BI_HiBob_Employees,
        BI_HiBob_Employees[team] IN { "Infrastructure", "Service Desk", "Cloud Ops", "Security" }
    )
)
2.0 Engineer Workload Distribution
Engineer Team Clients Assigned Backup Success % Status
Lars van Dijk Infrastructure 14 87.2% Overloaded
Sophie Bakker Infrastructure 11 89.5% High
Tom Hendriks Cloud Ops 9 92.1% High
Anna de Vries Service Desk 6 94.8% Normal
Daan Jansen Cloud Ops 5 96.3% Normal
Eva Mulder Security 4 97.1% Normal
Mark Visser Service Desk 3 93.6% Normal
Roos de Groot Infrastructure 2 98.4% Light

The top two engineers - Lars van Dijk and Sophie Bakker - together own 25 of the 54 assigned client backups (46%). Their backup success rates sit below the team average, which tracks with what you would expect when someone is stretched across too many accounts. Engineers with 6 or fewer clients consistently hit above 93% success.

View DAX - Clients per Engineer
Clients Per Engineer =
COUNTROWS(
    SUMMARIZE(
        BI_Datto_Backup_Jobs,
        BI_Datto_Backup_Jobs[client_name]
    )
)
3.0 Backup Success Rate by Engineer Workload
Lars (14)
87.2%
Sophie (11)
89.5%
Tom (9)
92.1%
Anna (6)
94.8%
Daan (5)
96.3%
Eva (4)
97.1%
Mark (3)
93.6%
Roos (2)
98.4%

There is a clear inverse pattern between client count and success rate. Engineers managing more than 8 clients fall below the 91.3% team average. The data suggests a practical ceiling of roughly 7 clients per engineer before backup quality starts to degrade.

View DAX - Avg Success Rate
Avg Success Rate =
DIVIDE(
    COUNTROWS(
        FILTER(
            BI_Datto_Backup_Jobs,
            BI_Datto_Backup_Jobs[backup_status] = "Success"
        )
    ),
    COUNTROWS( BI_Datto_Backup_Jobs ),
    0
)
4.0 Clients Without an Assigned Backup Engineer
Client Last Backup Success Rate Risk
Brouwer & Zonen BV 2026-03-28 72.4% High
Technova Solutions 2026-04-01 81.6% Medium
Van Helden Logistics 2026-03-30 84.3% Medium
Kuiper Retail Group 2026-04-02 86.1% Medium
De Jong Architecten 2026-04-03 90.2% Low
Staal & Partners 2026-04-04 91.8% Low
Noord-West ICT 2026-04-05 93.0% Low

Seven clients have no assigned backup engineer in HiBob. These are the blind spots: nobody is accountable for their backup health. Brouwer & Zonen BV stands out with a 72.4% success rate and a last backup that is over a week old. Without an owner, these issues go unnoticed until a client calls in a panic.

5.0 Team-Level Workload Breakdown
Team Engineers Clients Covered Avg Clients/Engineer Avg Success %
Infrastructure 8 27 3.4 90.2%
Cloud Ops 6 14 2.3 93.8%
Service Desk 7 9 1.3 94.2%
Security 3 4 1.3 97.1%

Infrastructure carries the bulk of the backup workload - 27 clients across 8 engineers. But the distribution within that team is skewed: Lars and Sophie own 25 of those 27 clients between them, leaving 6 Infrastructure engineers with barely any backup responsibility. Cloud Ops is more balanced, while Service Desk and Security carry lighter loads.

6.0 Backup Health vs Span of Control
26% of engineers
Overloaded (8+ clients)
42% of all clients
Managed by Overloaded Staff
91.3% overall
Avg Backup Success

Just 26% of engineers (those assigned 8+ clients) are responsible for 42% of all client backups. That concentration creates a single point of failure. When one of these engineers takes a sick day or goes on holiday, dozens of backups lose their only watchdog. The 91.3% average success rate masks the gap between lightly loaded engineers (96%+) and overloaded ones (below 90%).

7.0 Key Findings
!

Two engineers carry 46% of all backup clients

Lars van Dijk (14 clients) and Sophie Bakker (11 clients) together own nearly half of all monitored backups. Their success rates are the lowest on the team, sitting 4 - 7 points below the average. This is a capacity problem, not a skill problem.

!

Seven clients have no backup owner at all

These clients exist in Datto but have no matching engineer assignment in HiBob. One of them - Brouwer & Zonen BV - has a 72.4% success rate and has not had a successful backup in over a week. Without an owner, nobody is watching.

OK

Engineers with fewer than 7 clients hit 93%+ success

The data shows a clear threshold: once an engineer stays below 7 assigned clients, backup success rates consistently land above 93%. This gives you a concrete target for rebalancing.

8.0 Strategic Recommendations

1. Cap backup client assignments at 7 per engineer. Redistribute clients from Lars and Sophie to underutilized engineers on the Infrastructure team. Six Infrastructure engineers currently own 2 or fewer clients each - there is room to absorb the overflow without hiring.

2. Assign owners to all 7 unassigned clients within 5 business days. Start with Brouwer & Zonen BV given its low success rate. Update HiBob records so the assignment is visible in both HR and operational dashboards. Make unassigned-client count a standing metric in your weekly service review.

3. Build a rotation schedule for backup oversight. Single-owner assignments create holiday and sick-day blind spots. Pair each primary engineer with a secondary backup contact. This does not double the workload - it adds a safety net that catches failures when the primary is unavailable.

9.0 Frequently Asked Questions
How is backup workload calculated per engineer?

Workload is measured by counting the distinct clients in BI_Datto_Backup_Jobs that are linked to each engineer via BI_HiBob_Employees. Each unique client counts as one unit of workload, regardless of how many backup jobs that client generates per day.

What counts as an unassigned client?

A client appears in BI_Datto_Backup_Jobs and BI_Autotask_Companies but has no matching engineer assignment in BI_HiBob_Employees. This typically happens when a new client is onboarded in Datto before HiBob records are updated, or when an engineer leaves and their clients are not reassigned.

Why does a higher client count correlate with lower backup success?

When an engineer monitors more clients, failed backups take longer to investigate and fix. Alerts pile up, response times increase, and recurring failures go unresolved for days instead of hours. The correlation is strongest above 8 assigned clients, where success rates drop below the team average.

Generate this report from your own data

Connect Proxuma Power BI to your PSA, RMM, and M365 environment, use an MCP-compatible AI to ask questions, and generate custom reports - in minutes, not days.

See more reports Get started