All projects Consumer IoT · e-commerce

Greenfield Data Warehouse for an IoT Startup

A US consumer IoT startup (smart GPS dog collar)

A low-code Snowflake stack for a smart GPS dog collar company — built by one data engineer.

Snowflake Fivetran Azure Data Factory Azure Cosmos DB Sigma Deepnote

The team

  • 1 Product Manager
  • 1 Analyst
  • 1 Data Engineer

Starting state

  • No data warehouse — a greenfield build

Use cases

  • Data warehouse modelling from scratch
  • API, telemetry and SaaS source integration
  • Reporting for e-commerce, marketing and product
  • Reverse ETL for marketing automation
  • AI agent integration
  • Product improvement analytics

What was built

  • Fivetran for SaaS sources: ads platforms, NetSuite, Stripe, Amazon Selling Partner API, Amplitude, reviews, exchange rates
  • Azure Data Factory for custom sources: App Insights events and an Azure SQL replica
  • Device telemetry from Azure Cosmos DB
  • Snowflake with raw, silver and gold layers
  • Sigma Computing for BI
  • Deepnote for data science

What changed

  • One data engineer could run the whole platform, because ingestion was bought, not built.
  • Product, finance and marketing data landed in one warehouse with the same layered model.
  • The same gold layer feeds BI, reverse ETL for marketing, and AI agent use cases.
Related service

Snowflake Consulting

Snowflake implementation, dbt modeling, and credit cost optimization.

Explore service

Let's talk about your data platform

Tell us what you are working on. We reply within one business day, and we will tell you plainly if we are not the right fit.

Start a conversation Email us

Other projects

E-commerce marketplace · 400 employees

Oracle Data Warehouse to AWS Redshift

AbeBooks (an Amazon subsidiary)

Migrating a marketplace off Oracle, PL/SQL and Crystal Reports onto Redshift and Tableau.

Amazon Redshift Matillion ETL Tableau AWS EMR +4 more
Read the project Consumer technology · internal data products

Product Analytics for a Voice Assistant

Amazon Alexa — Natural Language Understanding

Replacing manual CSV extracts with an automated Redshift and Tableau product analytics stack.

Amazon Redshift Redshift Spectrum Tableau Amazon SageMaker +1 more
Read the project E-commerce · machine learning

Feature Engineering for Machine Learning

Amazon Retail

Building ML feature pipelines from a core data lake — with no warehouse, no data model and no dashboards.

Apache Spark Scala AWS EMR Amazon S3 +3 more
Read the project