5
External clients now using automated data ingestion using sftp and s3 buckets, replacing the previous process of retrieving data via email
100+
Tables migrated from CRM and on-premise databases to Snowflake, centralizing all data sources in a cloud datawarehouse
170+
dbt modeles created and maintained, ensuring only quality data reaches production
Background
Our client is a global pharmaceutical company specializing in the research, development, and commercialization of innovative treatments for brain diseases, including depression, schizophrenia, and Alzheimer's disease.
Challenge
The client faced challenges in maintaining numerous data sources in an on-prem environment, relying on legacy tools and manual effort to prepare their data for reporting. They required a centralized data warehouse where they could consolidate and ingest their data automatically in order to reduce manual effort and oversight.
Approach
Keyrus met with relevant stakeholders and assessed their current state and provided guidance to determine their specific needs. We engaged by providing options deemed fit for their use case and began implementing their full-stack with constant communication with the client.
Key results
Benefits
The work done by Keyrus resulted in several key benefits: consolidated data sources and improved documentation made data easier to access and understand. Automated data quality checks and standardized naming conventions enhanced reliability. These improvements led to faster, more accurate insights and a more secure, organized data environment.
Technology partners
AWS
Amazon Web Services (AWS) is a global leader in cloud-computing services that offers over 200 fully featured services from data centers worldwide. AWS provides services to organizations of all sizes to help lower costs, become more agile, and innovate faster.
Advanced Tier Partner
with a Data & Analytics Competency
30+
General Certifications
15
Speciality and Professional Certifications
Share this key play
