McCarthy Stone Modern Data Warehouse Consolidation

Transparity delivered the McCarthy Stone modern data warehouse consolidation, replacing legacy reporting systems with a single integration repository. This centralised platform ensures a single point of truth, improves governance, and provides accurate, real-time insights for decision-makers across the organisation.

The project utilised our Data Consultancy Services, combining Data Engineering, Data Strategy and Power BI Consultancy to create a scalable, governed solution that supports self-service analytics and drives long-term business growth.

McCarthy Stone 300x150 1

Replaced legacy reporting systems

with a single integration repository

Delivered a modern data warehouse

providing a single point of truth

Enabled scalable, self-service analytics

with improved governance

Transparity have helped us transform our Business Intelligence and integration solutions. Letting us take advantage of our data to support reporting and analysis in the business and helping us manage the integration of our operational systems.

Subhash Sreedharan
Director of Technology at McCarthy Stone

The challenge

Having worked with McCarthy Stone for the past three years, we have explored and examined many of the challenges in their business and have worked with them to continue to drive their strategic vision. In this case study we’ll explore how continuous value-led delivery enables a wider strategy.

Ownership of solutions and empowerment of team members is important to McCarthy Stone; as it is with many of the companies we engage with. We have worked in collaboration with the McCarthy Stone team to develop knowledge, skills and frameworks that allow the internal team to build and progress the solutions forwards as they continue to drive stakeholder value.

Using technology solutions to realise an overall vision, whilst dealing with the challenges of legacy solutions is difficult; and providing immediate and short-term value, while responding to the many challenges a large and complex business faces can be challenging. You’ll get some insight on how this has been achieved below.

Our initial involvement

McCarthy Stone approached us as they were transitioning some key systems in the business. They recognised the value of data and the need to put in place a data strategy that could drive them towards the overall vision for the business.

This vision would provide McCarthy Stone with a single point of truth across the business. Such a viewpoint would replace existing reporting and analytical solutions with a Modern Data Warehouse and Integration Repository, bringing control over data and its use in the business. As a result, such a system could offer analytical insight that would help keep McCarthy Stone a leader in their sector; and fulfilling the demands from the various business units for data and insight.

We started with a full assessment of the existing operational systems, BI tooling, and platforms, and consulted with key business stakeholders on the vision for an enterprise-wide solution. This was shaped into a high-level strategy that outlined the key long-term objectives; making decisions on platforms, tools and the skills needed to support the long-term vision.

The Solution

Navigating sector-unique challenges

‘From my perspective, Transparity were an extension of McCarthy Stone, working in collaboration with our technology team, and forging great relationships with stakeholders in the wider business.’

During our partnership with McCarthy Stone, we have encountered many challenges in meeting the demands placed on the programme of work.

Time Sensitive

There were a number of time-sensitive aspects to the projects, such as;

Having to put in place a scalable architecture for the wider strategy
Integrating a new sales system into the data warehouse
Replacing the legacy reporting and analysis that was going end-of-life

We met the demand for insights from the business whilst meeting the objectives around data quality & consistency – against the backdrop of a new system the business was continuing to develop.

Complex Requirements

We also navigated the complexities of the reporting and analytical requirements of McCarthy Stone.

With a sales lifecycle consisting of multiple phases, differences between renting, buying and shared ownership, and the need to provide point in time analysis in the past and the future; clarity and consistency of data was critical.

Complexity is not only challenging from a technical point of view, but the need to deliver this to the business users in a way that was accessible and user friendly was critical for adoption.

Enhanced Snapshotting

Enhanced snapshotting capabilities equipped report users with the tools to uncover date-specific results and viewpoints by moving beyond traditional salesforce capabilities.

By giving users these tools, they were able to shift to an ‘as things looked’ approach, being able to look over past reports before they were updated with new results.

This was particularly useful in an industry in which buyer cycles differ greatly from other sectors. When a single sale can take months, even years to complete, and when unexpected changes and updates are likely to occur, being able to gauge the at any given time is invaluable.

A clear vision and good communication among the helped us deliver on these and many more challenges.

The Outcome

In addition to the reporting and analytical capabilities gained from centralising data from multiple systems; there is also an opportunity to fulfil integration needs. Transparity have worked with McCarthy Stone to build multiple integrations, leveraging the data architecture put in place.

The removal of manual processes where users are importing files or keying entries, and the addition of automated validation rules and notifications of issues all help with data quality across an enterprise. McCarthy Stone have dozens of solutions across the business and will continue to drive a standard approach to integration to ensure high quality data – building on the integration repository framework now in place.

These platforms and frameworks can also be used to fulfil one-off or ad-hoc demands for datasets outside the existing reports and integrations. This enables an analyst to undertake one-off activity exploring data as required; or supports the need to supply 3rd party agencies with data extracts. Another example of the flexibility needed from an architecture that has to support so many use cases.

About McCarthy Stone

McCarthy Stone are the UK’s leading developer of retirement communities, providing high-quality later living properties with a focus on ensuring peace of mind and independence. With more than 475 developments as of November 2021 and over 20,000 residents, their award-winning services champion the needs of older people, successfully driven by their core values of excellence, innovation, and responsibility.