Healthcare BIG Data
Analytics

Custom web platform

Business need

BIG Healthcare delivers valuable insights to healthcare organizations. However, the platform faced critical stability and performance challenges. These issues cast doubt on the company’s ability to scale beyond 2 provinces in Canada.

Result

MindK redesigned the entire platform to improve the UX. With a scalable service-oriented architecture, a new ETL, and a Star Schema data warehouse, the system can easily handle increased data volumes and a growing user count.

Industry
Healthcare
Location
Canada
Canada
Working together since
2025

BIG Healthcare is a Canadian data analytics firm that provides actionable insights to help healthcare providers improve operations and optimize costs.

The challenge

The BIG Healthcare platform suffered from multiple technical issues. It had an unoptimized DB and lacked dynamic scaling. As a result, it couldn't handle the increase in data volumes without suffering drops in performance. A non-intuitive design and frequent errors made the experience even worse.

The solution

MindK reworked the platform by introducing a scalable service-oriented architecture (SOA). The team has created a robust ETL process that quickly ingests data, transforms it, and visualizes insights as intuitive dashboards and reports. We also redesigned most user flows to make them intuitive and efficient.

Scalable Service-Oriented Architecture

We re-architected the platform as a collection of independent, loosely coupled modules. Each module fulfills a specific business function. Updating any of these modules no longer disrupts other components. Each service scales independently with the help of AWS Lambda.

Scalable Service-Oriented Architecture

We re-architected the platform as a collection of independent, loosely coupled modules. Each module fulfills a specific business function. Updating any of these modules no longer disrupts other components. Each service scales independently with the help of AWS Lambda.

This modular design will allow the system to meet future business needs efficiently. Specific functionalities can be modified, scaled, or extended without affecting the entire platform. A unified tech stack accelerates development and reduces overhead. Moreover, decoupled services and AWS-managed solutions enhance resilience, availability, and fault tolerance.

Highly available
ETL pipeline

The initial ETL process led to calculation failures, making the results untrustworthy. MindK implemented a new ETL outside the reporting database to ensure high availability during data processing. The mechanism uses AWS-managed services, which inherently support vertical and horizontal scaling.

The system accommodates increasing data volumes and concurrency without significant redesign. Due to a seamless integration with the admin application, data pipelines, updates, and transformations are synchronized with application workflows. This enables high data availability in dashboards and features.

High-performance
data warehouse

The Star Schema (Kimball methodology) structures data into fact and dimension tables for better performance and flexibility. This design supports efficient analytical queries, simplifies schema evolution, and reduces the risk of significant rework as data grows.

Optimized multi-tenant data processing

The ETL balances tenant isolation and usage of shared resources. With isolated processing clusters, each organization's ETL workload is now processed independently. This prevents resource contention or performance drops.

Shared data is processed centrally, minimizing the duplication of effort and ensuring consistency across tenants.

Better performance with task prioritization and pooling

Users are no longer affected by resource-heavy processes like large-scale ETL task runs with intelligent task prioritization and pooling.

Better performance with task prioritization and pooling

Users are no longer affected by resource-heavy processes like large-scale ETL task runs with intelligent task prioritization and pooling.

Lightweight, user-facing tasks are prioritized to ensure responsiveness. The system queues resource-intensive tasks and executes them without disrupting ongoing operations.

Audit logging and
improved security

The initial system did not fully adhere to the necessary security standards, posing risks to sensitive data. The gaps included the use of outdated libraries, weak authentication mechanisms, inadequate encryption, and the lack of audit trails.

Our team made numerous improvements to remove the security gaps

Secure password policies enforcement, password expiration
Multi-factor authentication via AWS Cognito
AWS Secrets Manager for managing sensitive keys
Secure API access using AWS Identity and IAM roles, policies
Encryption for all storage layers, including S3, RDS, and SQS
TLS encryption, certificates managed via AWS Certificate Manager
Dependency scanning with Snyk to identify vulnerabilities in libraries
CI/CD pipelines with automated dependency management
AWS CloudTrail to log API calls, user actions, and system changes

Custom analytics

The platform had preset reports based on 100+ proprietary metrics. However, any customization required the team to hard-code new reports. The new warehouse has solved this problem. Customers can now easily connect to Tableau or Power BI, run custom queries, and generate reports without involving developers.

Now users can

Authenticate securely using MFA
01
See the biggest opportunities & savings
02
Compare themselves with select peer hospitals
03
Easily generate custom reports
04
Upload trial balance sheets without degrading performance
05
Edit and add new KPIs to the analytics dashboard
06
Customize in-app and email notifications
07
View a streamlined executive dashboard
08

Services provided

Data engineering

Software modernization

DevSecOps

UI/UX design

Test Automation

Business analysis

Project management

Tech stack

  • TypeScript TypeScript
  • Node.js Node.js
  • NestJS NestJS
  • React React
  • Amazon CloudFront Amazon CloudFront
  • AWS Lambda AWS Lambda
  • AWS Glue AWS Glue
  • Amazon SQS Amazon SQS
  • AWS ElastiCache AWS ElastiCache
  • Amazon RDS Amazon RDS
  • Amazon S3 Amazon S3
  • API Gateway API Gateway
  • CloudWatch CloudWatch
  • DataDog DataDog
  • AWS Secrets Manager AWS Secrets Manager
  • AWS WAF AWS WAF
  • AWS Config AWS Config

Business value

MindK reengineered the platform with big improvements across all non-functional requirements. The interface is no longer confusing for senior healthcare officials. A new architecture allows the system to handle a higher data volume and user count. Furthermore, new opportunities can be added as features without disrupting other modules.
1
to load any page
1
hours of disruptions caused by uploading trial balance sheets (down from 7 days)
1
simultaneous user sessions supported

More case studies

International Surrogacy Center

Cloud-Native Medical System for Surrogate Parents

Learn more

The Lactation Network

The First EMR for Lactation Consultants

Learn more

Innmeldt

Rethinking pension and insurance consulting

Learn more

    Looking for healthcare software development experts?

    Let us know about your technology challenges and we'll
    help you resolve them.

    Get in touch