- Before
- Builds the five-year plan from HR reports of age and service and a retirement rule of thumb. “I can count who retires. I can't see what work is coming.”
- Now
- Opens a skills cliff refreshed overnight, clicks any cell to see who retires, who leaves and which projects need the people, and sends a sized, costed plan.
One role, from the skills cliff to a signed workforce plan
Lumina Utilities runs electricity and water networks across four regions. Its electricity capital plan peaks in 2029, the same year many of its protection and control engineers can retire. Here is how the 2029 protection gap is found, explained and closed, screen by screen, in the working solution.
- 01Morning
The skills cliff, not a headcount table
Nadia Okafor · Head of Strategic Workforce PlanningNadia builds the five-year workforce plan and answers the board's question: do we have the people? Her home screen is a heatmap of 14 critical roles across electricity network, generation and water, year by year from 2026 to 2031, each cell the share of the work with nobody to do it. Above it sits capital plan v2026.3, $1.26B of work. In 2029, with no action, Lumina is 288 FTE short across the 14 roles, and 4 roles are 25% or more short.
“I can count who retires. I can't see what work is coming.” — Nadia Okafor
- 0202:10–02:24
Five agents rebuilt the forecast while Lumina slept
The overnight refreshThe workforce data reader read 6,840 HR records from the 23:00 extract: 1,546 people in critical roles, 37 job codes held for review. The forecaster found 390 people who can retire by 2031 and expects 294 to. The capital demand translator read 214 projects, 14 of them needing critical skills, and noticed the Eastmere connection moved from Q4 to Q2 2029. The planner drafted a protection plan for Nadia to review.
Needs a person: “37 people have a job code with no critical role” — the data reader suggests a role and asks, it never guesses.
- 03Why the cliff exists
The same grid, coloured by retirements
Retirement and leaver forecasterA switch recolours the grid by Gap, Retirements, Leavers or New work, so the reason for each cliff is visible. By retirements, protection and control engineers reach 13% of today's people in 2029 and 21% in 2031; high-voltage cable jointers reach 28% in 2031. The forecaster uses Lumina's pension rule — age 60, or 55 with 30 years' service — and Lumina's own history, not an assumption that everyone goes at 65.
Limit: “Never assumes everyone retires at eligibility · never forecasts below a group of 5.”
- 04One click on a cell
40% short in 2029 — and where the number comes from
Gap analystNadia clicks protection and control engineers, 2029. The rail explains it: 48 people today, 4 trainees finish, 6 retire, 4 leave, so 42 in post against 70 FTE of work — 28 FTE short. The work is 44 FTE of everyday testing, faults and maintenance plus 26 from six projects. Every line opens its source; the retirement line opens the history behind it.
Retirement history 2019–2025: “Of 213 engineers who became eligible, 38% retired in their first eligible year, 24% in the second, and 3 in 7 offered phased retirement accepted.”
- 05One click on a project
Harrow Ridge lights up the roles it needs
Capital demand translatorOn the capital plan ribbon, Nadia clicks Harrow Ridge 400 kV substation: $186M, energise Q3 2029, Highland. The cells it draws on light up with the FTE it needs each year — 9 protection and control engineers in 2029, 10 substation and relay technicians, 6 transmission lineworkers and 3 SCADA and telecoms engineers. A what-if slips the project a year to show the cliff move, without changing the capital plan.
“The capital demand translator turned this project's resourcing line into FTE for 4 critical roles.”
- 06The source
Every FTE read from the project's own resourcing line
Ken Whitlow · Director of Network DeliveryCapital demand shows each project's FTE by year for the chosen role, beside the document it came from. For Harrow Ridge: project brief HR-400 rev C, page 12, WBS 4.3 protection and control, owner Ken Whitlow — 14 bays of 400 kV GIS, two supergrid transformers and the station bus to IEC 61850, all commissioned between April and September 2029. 14,400 hours in 2029 at 1,600 productive hours a year is 9 FTE.
“Harrow Ridge energises in Q3 2029 with or without the engineers. Without them it doesn't.” — Ken Whitlow
- 07The role in depth
Which skills leave with the people
Owen Castell · Protection and Control ManagerOwen runs Lumina's 48 protection engineers. The role page shows people against the work to 2031, when people can retire in groups of five or more with no names, and the skills that matter: IEC 61850 station commissioning is held by 5 people and 3 can retire by 2029; GIS busbar protection by 2, with 1 left. Four skills are left with two people or fewer by 2029, and Owen can ask for a successor plan for each.
“13 of 48 can retire by 2029, and the forecaster expects 6 to.”
- 08Size the pipeline
Hire 8, keep 3, contract 6 — and train 12
Pipeline and scenario plannerThe planner works from the 2029 gap of 28 FTE. The market gives about 8 experienced hires over 2027–28 (38 applicants for 5 roles in 2025). History says 3 of the 7 seniors eligible in 2027–28 will accept phased retirement. The two framework suppliers can cover 6 FTE at the peak. That leaves 11 who must be competent by 2029; at 24 months and 92% finishing, the intake is 12, two cohorts of six in January and September 2027.
Check the constraint: “12 graduates need 6 mentors at 1:2 · 9 seniors can mentor in 2027 after retirements.”
- 09Signed
Demand confirmed, cost approved, plan signed
Priya Raman · Finance Business Partner · Rafael Duarte · Chief People OfficerThe mix costs $4.48M above payroll over 2027–2031 — train $1.15M, hire $1.01M, keep $0.27M, contract $2.05M — against $11.5M to cover the gap with contractors, if the market has them. Hiring only leaves 2029 29% short. Nadia sends it: Owen Castell confirms the 70 FTE of demand, Priya Raman approves $4.48M, and Rafael Duarte signs protection plan v1.
“Nothing is committed until the Chief People Officer signs. Agents never open a requisition or make an offer.”
- 10Jan and Sep 2027
Two graduate cohorts open, sized to the real work
Nadia Okafor · Head of Strategic Workforce PlanningOn the training pipeline, the two protection graduate cohorts of 2027 move from proposed to approved, competent in January and September 2029. Capacity to train is shown beside them: 15 protection seniors able to mentor, 9 after the 2027–28 retirements, 6 needed. Back on the skills cliff, protection in 2029 now reads Covered.
“Mentoring is tight: 6 of the 9 available seniors would mentor in 2027–28, and 3 of them are the seniors asked to stay longer.”