Dalriada Drug Discovery – ETL, Multi-Omics Data Warehouse + Web Portal

Customer

Our client is a leading CRO for turnkey small molecule drug discovery. The company offers global biotechnology and pharmaceutical companies a full suite of drug discovery expertise and state-of-the-art R&D operations converting promising scientific discoveries into life-transforming therapies.

Business goals

The customer sought to modernize their data infrastructure, eliminate manual toil through data processing and storage automation, and empower end-users to efficiently access and interact with data insights.

Challenge

A drug discovery CRO faced challenges in managing and analyzing vast amounts of multi-dimensional data and processing scripts scattered across various systems. Another issue was scaling operations with growing geography, number of customers, and programs.

Results/ Benefits

Our team harmonized multi-omics data from multiple sources into a centralized data warehouse, developed automatic data processing and a user-friendly web portal for researchers and customers allowing the latter to make online purchases.

Streamlined Data Management

• Implementation of the centralized multi-omics warehouse streamlined data management processes, providing a single, unified source of truth for chemical space, proteomics, and multi-dimensional research data, execution-ready and suitable for further AI implementation.

Direct Access to Real-time Data Insights

• End-users were granted direct access to interactive dashboards and plots, facilitating self-service analytics and decreasing reliance on data scientists and sales for data retrieval.

Informed Decision-Making

• Drug discovery professionals and executives gained the ability to make informed decisions promptly, leveraging real-time data insights provided by the centralized data warehouse and research web portal.

Scalability for Future Growth

• The modernized automatic data processing and centralized multi-omics data warehouse were designed to scale efficiently, accommodating future data growth and the addition of new customers and programs with ease, eliminating the need to increase number of employees.

Roadmap

The project had a total duration of 4 months.

Team

• Life Science Data Architect
• Web Software Architect
• Project Manager
• Data Engineer
• Fullstack Web Developer

Technologies

• Node.js
• Angular
• GCP
• Docker