Coalesce Case Study: Modernising a Global Toy Manufacturer’s Data Platform
Overview
Modern businesses rely on data transformation and cataloging tools to organise, standardise, and govern how data flows, turning raw information into trusted, usable assets. These capabilities came to life in a foundational project delivered by Synogize for a global toy manufacturer known for its imaginative, award-winning products.
Synogize set out to transform the company’s data processes from various solutions into a modern, scalable, and efficient data platform. The foundational project aimed to establish cloud-based data warehouse, streamline data acquisition from several source systems, provide modern data modelling and CI/CD approach, strengthen data security, develop skills of internal team and prepare ground for future expansion of analytics capabilities. By designing a modular, best-in-class architecture anchored by a powerful transformation and metadata management platform, Synogize delivered a platform that empowers the company with actionable insights and advanced decision-making tools.
The Challenge
The company’s legacy processes presented opportunities for enhancement, especially:
- Fragmented data logic: Data was passed through from source systems to reports without persistent, centralised modelling, leading to duplication and inconsistent business logic.
- Lack of governance and documentation: No version control, minimal documentation, and ad hoc release management increased operational risk.
- Limited scalability: The legacy on-premise SQL Server environment restricted the ability to scale and innovate with data.
Our Approach
Synogize set out to reimagine the company’s data ecosystem, ensuring it was not only modern and scalable but also aligned with broader business goals. Our approach focused on streamlining data operations, enhancing governance, and enabling data-driven decision-making through a future-ready platform. To achieve this, we conducted a thorough assessment of the company’s existing data landscape, identifying key areas for improvement. By leveraging best-in-class technologies, we designed a modern data platform that seamlessly integrates multiple data sources, automates workflows, and enhances data visibility across the organisation. Security and governance were prioritised from the outset, ensuring controlled access, compliance, and auditability. This structured framework introduced clear data organisation, eliminating inefficiencies and inconsistencies while maintaining continuity with existing reporting needs.
Coalesce played a pivotal role as the transformation engine, streamlining development and ensuring auditability throughout the lifecycle. The data transformation platform enabled Synogize to implement a modular, repeatable transformation framework using column-aware architecture. Synogize leveraged Coalesce’s intuitive UI, data lineage visibility, and Git-backed version control to accelerate delivery cycles, reduce technical debt, and bring structure to core data models. Together, we ensured that every transformation was trackable, governed, and ready for future iterations, without adding unnecessary engineering overhead.
Beyond implementation, Synogize also empowered the company’s internal teams with the knowledge and tools to take ownership of their data journey. Through hands-on training and comprehensive documentation, we ensured the business could maximise the platform’s value long-term.
Results
The transformation of the brand’s data platform delivered measurable improvements across all key areas. Overall processing times were reduced by over 90%, significantly accelerating decision-making and operational efficiency. Coalesce enabled data transformation and quality to be delivered 10x faster through its robust frameworks and real-time validation mechanisms. Feeding into this transformation layer, Fivetran provided near real-time ingestion from over five key source systems, while Snowflake acted as the cloud data warehouse, ensuring scalable, high-performance storage and compute. Together, these technologies formed a seamless, modular pipeline that gave the company greater control over data access and visibility. This scalable architecture ensures the platform can accommodate future growth and evolving needs.
Conclusion
By combining Synogize’s data expertise with Coalesce’s transformation technology as part of a best-of-breed modern data platform, the company not only optimised its operations but also positioned the organisation as a leader in leveraging data to drive improved business outcomes. This joint effort underscored Synogize expertise in data engineering, analytics, and platform modernisation, setting a new standard for data platforms in the toy industry.