endorsedCompleted

AWS Cloud Analytics Platform for Skylight Health Group

Services Covered:

Cloud Consulting and Services • Data Engineering • Data Integration • Big Data Analytics and Business Intelligence • IT Consulting

Industry

Healthcare

2 months

Budget

Confidential

Start Date

1 January 2022

Team Size

Confidential

Engagement Model

Offshore

Project Capability Score (PCS)

71/100

Good

Project Capability Score (PCS) estimates how capable Adastra is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Skylight Health Group

Toronto, Canada

Project Summary

Adastra built an AWS-based cloud analytics platform for a healthcare technology company, implementing an S3 data lake, Redshift data warehouse, and BI dashboards using QuickSight and Tableau. The solution automated business intelligence, eliminated manual data manipulations, and provided complex insights to support the client's mission to deliver integrated healthcare services. Collaboration between the vendor and client teams was strong throughout the engagement.

Key Challenges

Integrate data from numerous Electronic Medical Records (EMR) systems and other data sources
Provide predictive and prescriptive analytics capabilities
Build a scalable, secure AWS-based analytics platform

Project Deliverables

AWS S3 data lake for ingestion and storage
AWS Redshift data warehouse
BI dashboards built with AWS QuickSight and Tableau
Encrypted, cost-effective data storage and ingestion pipelines
Initial architecture and implementation by Cloud Solution Architect and remote data engineering team

Project Solution

Adastra developed a two-component AWS analytics platform consisting of an S3 data lake for ingesting diverse sources and an Amazon Redshift data warehouse to satisfy reporting requirements. They implemented ingestion strategies, encryption-at-rest, and downstream accessibility for ML models, and built interactive BI dashboards using AWS QuickSight and Tableau. A Cloud Solution Architect led initial discovery and architecture, while implementation was executed by remote data engineers collaborating with the client team in Canada.

Project Outcome

Automated business intelligence and eliminated manual data manipulation
Enabled complex, automated insights for business users
Strong collaboration and a productive working relationship between teams

Platforms

Cloud

Tech Stack

Amazon Web Services (AWS)
Amazon RedShift
Tableau
S3

Client Endorsement

Overall Review Rating

4.75

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Adastra’s efforts automated the client’s production of business intelligence, streamlining their operations. Their collaborative and communicative approach resulted in a productive working relationship. A true partner, they were dedicated to the company’s success and growth.”
Chris Smith
VP Digital Health
Date: 05/12/2022