Trident Housing is a social housing provider managing several thousand homes across the West Midlands. The organisation not only manages affordable homes but also provides specialist supported housing and help for those with additional care needs.
Like many organisations in the sector, Trident has evolved over time through system changes, organisational growth, and shifting regulatory expectations. While frontline services remained the priority, back-office systems and data quality had not always kept pace.
As Trident strengthened its Insight and Innovation function, it became clear that legacy technology and inconsistent controls were affecting the quality of the data held across core systems. These issues made it harder for teams to work efficiently and increased the amount of time dealing with avoidable data problems.
Staff were often reacting to data issues, correcting problems as they were found, but without a clear strategy to improve long-term data quality across the organisation.
Rather than continuing to rely on workarounds, Trident made the decision to take a more pro-active and structured approach to improving the quality of data it holds. As part of this strategy, Trident partnered with 3C, an external consultancy specialising in data management solutions for the social housing sector.
Trident’s legacy systems made it difficult to understand the true state of its data. While staff were aware there were issues, the organisation lacked the tools to locate the problems or understand how widespread they were.
Extracting data from the system was a challenge. Even pulling a full property list was not always possible, limiting Trident’s ability to audit, cleanse, or prepare information.
“We knew there was a problem with data validation, but we didn’t know where the problems were”, Insight and Innovation Manager Gary Wooldridge explains. “We couldn’t get every record up to check.”
Key controls on data entry were missing. Text was being entered in date fields and core data entries were inconsistent.
“There were no drop downs or validation to pull people back in,” Gary says,
“we had locations being spelled incorrectly, invalid postcodes, it was just a real problem for us”.
Data issues were often addressed reactively, relying on problems being discovered and manual processes to correct them. As well as potential operational risk, it was also allowing poor data to become an accepted explanation for underperformance.
“Poor data can sometimes be used as an excuse,” Gary reflects, “as soon as you make the data better, that excuse isn’t there any more”.
There is now a drive to improve data quality before moving to a new housing management system that would better fit Trident’s needs. Bringing poor-quality data into a new system would simply embed existing problems and damage trust from day one. As Gary puts it plainly, “We can’t put unclean data into new systems.”
Like many housing providers, Trident had reached a tipping point. Continuing to make do was no longer viable.
To shift from reactive fixes to proactive control, Trident partnered with 3C, an external data consultancy, and implemented 3C Data Logic as a data governance tool.
Rather than relying on staff to spot errors, 3C Data Logic systematically checks the data held within Trident’s systems against a defined set of rules. These governance rules flag issues such as missing values, invalid formats, or inconsistencies in key fields.
Gary explains “We’ve now created a set of around 300 rules, covering our property, tenancy, and occupancy data”.
These rules check for missing values, invalid formats, and inconsistencies such as incorrectly spelled locations, and highlights issues clearly. Crucially, this work was not about one-off cleansing. As new issues emerged, new rules were added, ensuring that mistakes are caught early and do not reoccur.
Importantly, 3C Data Logic provided a structured approach to make improvement work manageable. Complex datasets were broken down into clear areas of focus, allowing steady progress without overwhelming the team.
“We can now work on different sections of the data, chip away at it and see improvement every month,” Gary explains. “Making sure it’s in more manageable pieces makes it less overwhelming.”
Being able to see improvements almost immediately, helped to create momentum and reinforce the value of the approach.
The impact of this work has been both measurable and cultural. Trident’s data quality scores have improved significantly.
“We started around 74%, we’re on about 85% at the minute,” Gary says, with a clear plan to reach near 100%.
While adding rules can cause short-term dips as previously unchecked issues are exposed, the overall trajectory is positive and transparent. The organisation can now see tangible progress month by month and have demonstrable confidence in the data it holds.
Operationally, the benefits are clear. Data issues that once blocked reporting or required workarounds are identified quickly. Incorrect postcodes, incomplete records, and inconsistencies are identified and resolved quickly, reducing delays and repeat work.
The increased visibility has also helped drive a cultural change, moving away from using poor data as an excuse and focussing on delivering services more efficiently. Working with 3C brought an objective perspective that helped Trident focus on removing root causes rather than tackling symptoms.
“A 3rd party can come at it with a fresh pair of eyes, they just look at it as a set of data,” Gary explains. “Having someone come in and look at things from a different angle really helped.”
An additional advantage is future readiness. With plans to move to a new housing management system, Trident is now in a much stronger position. Using 3C Data Logic to support data migration can save time and will improve the results achieved from the investment in the new software.
Clean, well-governed data reduces the risk of carrying historic problems into a new platform and ensures that investment in new technology supports better services from day one.
For Trident, improving data quality has not been a one-off project, but a longer-term shift in how data is managed and maintained across the organisation.
Taking control of data quality is critical to achieving the highest levels of regulatory grading. For housing providers facing similar challenges, Trident’s experience demonstrates that acknowledging the problem, seeking expert support, and taking a structured approach can turn even the most complex data issues into achievable, measurable progress.