endorsedOngoing

Data Warehouse & Analytics Implementation for Healthcare

Services Covered:

Big Data Analytics and Business Intelligence

Industry

Healthcare

Duration

27 months

Budget

Confidential

Start Date

1 May 2024

Team Size

1-5 Employees

Engagement Model

Nearshore

Project Capability Score (PCS)

75/100

Good

Project Capability Score (PCS) estimates how capable Binariks Inc. 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

Capsana

Canada

Project Summary

Binariks is working with a Montreal-based healthcare organization to build a data warehouse and establish a data analytics foundation using Snowflake, Fivetran and the client’s AWS infrastructure. The engagement began in May 2024 and is ongoing; the vendor provided consultative assessment, ETL/repository work, and BI tool selection and implementation. The client reports the solutions meet business objectives, that deadlines and budgets were met, and that Binariks’ expertise and responsiveness have stood out.

Key Challenges

Build a data warehouse and consolidate data
Implement business intelligence tooling for visualizations
Lack of in-house expertise to structure and analyze data

Project Deliverables

Data warehouse
Data repository and ETL pipelines
Data cleansing and structuring
BI visualizations and tool selection
Consulting and analytics tooling implementation (Snowflake, Fivetran)

Project Solution

Binariks began with a consultative phase to assess the client’s databases and data structure, then designed a repository and ETL approach to pull and clean data for analysis. They implemented and configured analytics tooling—introducing Snowflake and Fivetran—and used the client’s AWS cloud infrastructure. The vendor provided a small team (notably a data scientist and a project manager) to execute the work and iterated on the solution as the client clarified requirements.

Project Outcome

Built a data warehouse and laid the foundation for a data analytics strategy
Solutions are performing as expected and meeting business objectives
Met deadlines and stayed on budget
Improved ability to gain insights for population-health analytics

Platforms

Cloud

Tech Stack

Snowflake
Amazon Web Services (AWS)
SQL

Client Endorsement

Overall Review Rating

4.5

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Binariks has successfully built the client's data warehouse and laid the foundation for their data analytics strategy. The team's work has met the client's business objectives and expectations. Moreover, the team has met deadlines, stayed on budget, and their knowledge and expertise have stood out.”
Steven Christodoulopoulos
Senior Director of eHealth Innovations & IT
Date: 06/19/2025