Building a Future-proof Data Foundation With Automated Migration to BigQuery

Challenges

A diversified healthcare innovation company, offering integrated pharmacy services, health insurance, and retail health clinics had built a data ecosystem meant to serve members, prospects, and clinical operations alike. But that ecosystem was running on legacy Hadoop-based infrastructure, and it was starting to hold the business back. Scaling advanced analytics and predictive models to support growing data science needs simply wasn’t possible on the existing platform, and delays in delivering those insights were becoming the norm. Data sources for members, prospects, and claims lived in disconnected systems, making it difficult to get a holistic view across the business. Missed SLAs in data availability were slowing down data scientists and business users alike, and onboarding new data sources like IoT devices, required significant manual effort just to keep pace. To overcome these challenges, the company set out to modernize its data ecosystem and unlock faster, AI-driven insights.

Solution

  • Automated, AI-Ready Migration from Hadoop to BigQuery

    Ascendion partnered with the client to modernize its data landscape, using AAVA – Ascendion’s low-code Data Modernization Platform, to migrate Hive scripts to BigQuery and lay the groundwork for faster, more reliable analytics.

  • Built for Scale and Performance

    The migration was paired with containerization through automated Docker image deployment for streamlined operations, along with parameterized datasets and labels and optimized table partitioning and clustering for stronger performance tuning. To put the new foundation to work right away, Ascendion also developed and deployed lead scoring models using BigQuery ML integrated with Python, turning the modernized platform into an active engine for AI-driven insight, not just a faster version of the old one.

Tech Stack:

Business Impact

Empowered 4,000+ data engineers and data scientists with a scalable, high-performance platform on BigQuery, improving productivity and enabling faster delivery of advanced analytics.

Delivered 60% TCO savings by moving from Hadoop to BigQuery.

Saved 5,000+ hours annually through automation and performance improvements.

Resulted in a robust, future-ready platform that accelerated insights and reduced operational costs across the business.