Case Studies

Delivering Customer 360 with Data Mesh at a Global Pharma Enterprise

customer 360 customer stories data mesh DBT pharma data

Executed a zero-downtime, low-risk data migration with data lineage, alerting, and observability across 10+ pipelines.

Established a unified, monitored data environment that accelerates issue resolution and empowers domain teams with complete customer views.

Challenge

The client was a pharmaceutical company known for its focus on developing and manufacturing a wide range of products in various therapeutic areas, including eye care, central nervous system treatments, gastroenterology, and women’s health. The client’s serverless AWS framework was highly complex, metadata-driven, and dependent on numerous external data sources, making collaboration and experimentation difficult.

The company’s existing business analytics tools offered limited monitoring and visibility, creating blind spots in pipeline performance and slowing issue resolution. Duplicate business logic across teams and the absence of end-to-end data lineage hindered explainability, governance, and the ability to respond quickly to new business requirements.

Solution

Hakkoda migrated the client’s legacy framework to dbt Cloud, implementing a Data Mesh architecture that eliminated redundant business logic and enabled domain-driven ownership. This migration modernized more than 10 pipelines with full data lineage and monitoring, and was executed with zero downtime using Kubernetes Pods to scale external operations while minimizing risk.

The Hakkoda team also introduced a GitHub-based CI/CD process with enforced coding standards, real-time observability and monitoring via DataDog and PagerDuty, and automated alerting for proactive issue management.

The Model

Technology Used:

Snowflake

dbt

PagerDuty

Datadog

Full Time Resources:

1 Engagement Manager

1 Data Engineer

1 Data Architect

Project Duration:

3 Months

Case studies

Case Studies

Fast-Tracking the Client Onboarding Process at a Leading Marketing Agency

Learn how a leading digital marketing agency partnered with Hakkoda to slash its client onboarding process from 3 weeks to...

Case Studies

Driving Sales with a Modern Data Platform at a Luxury Home Builder

Discover how a leading luxury home builder accelerated sales and marketing with a modern data platform built on Snowflake—with a...

Case Studies

Unlocking Time-Series Analytics in Snowflake with A Global Active Fixed Income Company

Discover how Hakkoda is helping a global fixed income company bring time-series analytics into the cloud, cutting storage costs and...

Case Studies

Case Studies

Delivering Customer 360 with Data Mesh at a Global Pharma Enterprise

Enabled a dbt-powered data mesh that eliminates potentially out-of-sync business logic.

Executed a zero-downtime, low-risk data migration with data lineage, alerting, and observability across 10+ pipelines.

Established a unified, monitored data environment that accelerates issue resolution and empowers domain teams with complete customer views.

Challenge

Solution

The Model

Technology Used:

Snowflake

dbt

PagerDuty

Datadog

Full Time Resources:

1 Engagement Manager

1 Data Engineer

1 Data Architect

Project Duration:

3 Months

Case studies

Coalesce