Fulton Hogan is a major infrastructure, construction and maintenance company operating across Australia, New Zealand and Fiji. More than 10,000 people across more than 350 sites build, maintain and manage essential assets including roads, bridges, drainage, rail, airports, utilities and community infrastructure. Fulton Hogan relies on Archimedes, its business intelligence and reporting platform, to bring together information from different operational systems and provide a clearer view of activity across its road-maintenance contracts.

Behind that operational view sat a legacy data warehouse built around bespoke extracts, alongside an ageing master data tool that was expensive to change and hard to trust.

The underlying data came from finance, people, customer, asset and health and safety systems. Some were on premises, while others were cloud services available only through APIs. Each source had its own logic and often relied on the knowledge of one person. When reports disagreed, tracing a figure back through those layers could take days. The warehouse also had to be replaced by a fixed date without interrupting reporting for contracts supporting more than $1 billion in revenue.

Those constraints meant a successful cutover was only part of the job. Fulton Hogan needed to preserve access to the dashboards and contract information already in daily use, while making the underlying data easier to trace and more consistent across systems. The new platform also had to be simpler to extend as new sources were added. Otherwise, it would carry forward the same complexity and reliance on one-off knowledge that had constrained the old warehouse.

To meet those needs, Adaptiv migrated the warehouse and its full history into Databricks. On-premises databases connect through change data capture, while cloud systems connect through their APIs. Rather than building a different solution for every source, each ingestion follows the same configuration-driven design. An untouched copy of the incoming data is retained for audit before shared rules turn it into clean, consistent information with its history intact.

Using the same design across every source is what makes the platform easier to manage and extend. Incremental updates, reconciliation and records deleted at source are handled consistently, whichever system the data comes from. Adaptiv also replaced the legacy master data tool with a browser-based application on the same platform, bringing validation and a full record of who changed what closer to the data it governs. Shared standards, reusable building blocks, automated deployment and documentation based on what was built give Fulton Hogan a practical foundation it can continue to develop.

Before the new platform could replace the existing systems, Fulton Hogan needed evidence that the data matched. Every new ingestion therefore ran alongside the existing feed and was reconciled before anything was switched off. Fulton Hogan could see that the information matched before it had to depend on it. The platform also records what it loaded, when and from where. If a source cannot provide a complete answer, the process holds back rather than allowing an uncertain result to move quietly into reporting. Testing, release preparation, business walkthroughs and a full handover supported an on-time, on-budget move into everyday use.

With the new platform in place, Fulton Hogan has a modern and scalable foundation for reporting behind more than $1 billion in contract revenue. The dashboards remained available through a deadline that could not move, while the data beneath them became easier to trace and more consistent to manage. New sources can now be added through a repeatable design rather than another bespoke build, supporting future reporting and analytics without returning to the constraints of the old warehouse.