A state government health shared services organization was running approximately 100 data pipelines across legacy on-premise platforms and disparate clinical and operational source systems with no unified data layer. The organization needed to consolidate reporting infrastructure across WebPAS (patient administration), Oracle systems, Workday (HR and finance), and external health data sources into a single Snowflake environment. Key challenges included no unified health data model across multiple source systems; scheduled and real-time ingestion requiring both Matillion and Oracle GoldenGate for different data types; no modern orchestration or governance framework; escalating costs and architectural debt in legacy infrastructure; and a need to support both scheduled reporting and near real-time operational analytics from the same platform.
Conducted a multi-phase data architecture assessment across the full health system, documenting ingestion patterns, data ownership, governance requirements, and integration complexity
For large public sector and healthcare organizations running multiple legacy ETL tools (Matillion, Oracle GoldenGate, custom scripts) feeding disparate reporting environments, this engagement demonstrates how Snowflake can serve as a consolidation point for heterogeneous data sources and ingestion patterns. The medallion architecture pattern, dual-ingestion approach (batch plus CDC), and Informatica migration pathway are directly reusable for any organization looking to modernize data infrastructure at enterprise scale. The governance and procurement navigation approach is particularly relevant for other public sector organizations facing similar complexity and information-sharing constraints.
Led by a solutions director and data practice lead driving architecture strategy, supported by senior data architects specializing in platform design and data governance, platform architects managing Matillion and GoldenGate integration, multiple senior data engineers building and optimizing data pipelines, and data architects managing the medallion layer design and implementation.
A state government health shared services organization serving 50,000 to 70,000 health workers across multiple hospital networks, health service providers, and regional facilities spanning nearly 1 million square miles needed to replace legacy reporting infrastructure with a modern, real-time analytics platform.
A professional services and advisory firm had a large volume of institutional documents stored in SharePoint and needed to move them into Snowflake to enable AI-powered search and future retrieval-augmented generation (RAG) use cases. Their Snowflake environment was configured on PrivateLink, ruling out common ingestion tools that do not support PrivateLink natively.
A health information exchange serving 4,900+ users modernized its analytics stack for complex semi-structured healthcare data with a three-month Snowflake, Matillion, and Tableau proof of concept.
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072