Building a Centralized Data Platform for 16 Companies in 12 Weeks

Carbon6 is an all-in-one platform for Amazon sellers to run their businesses. In order to accomplish this mission, Carbon6 acquired 16 companies within the span of a year.

The Challenge: Having so many different operating tools and technology stacks under one roof made obtaining critical operational data increasingly difficult.

Problems
Solutions

Business teams were unable to get real-time, reliable sources of truth in their operational systems

Built out a data platform on AWS using Airflow and Redshift which produced highly reliable data at a 30 minute cadence.

Needed to populate the newly implemented CRM system (Netsuite) with fresh and reliable data

Created ETLs and reverse ETLs for Netsuite to populate the CRM with real time fresh data.

No consolidated view of all user records, with each company having its own fragmented set

Aggregated all user records and created a single customer 360 view across all entities

Results

total companies integrated
16
companies
time to deliver
12
weeks
Custom Connectors
30+

The Process

Discovery

Build Out

Outcomes

The Boosted team has become a critical partner to Carbon6, working deeply with us to tackle our toughest data challenges and API integrations that would have taken months more without their experience and involvement. - Brett McLaughlin, CTO

Outcomes

Financial reporting refreshed on a 30 minute cadence

Reverse ETLs built into CRM system

Single source of truth through the data warehouse

Data integrity and reliability with automated data ingestion and transformation

Operational improvements from insights derived from the data platform

Scalable Data Infrastructure using Airflow on EKS

What was built