Skip to content
Scope, price and timeline published on every engagement page Engineers assigned within 3 working days of kickoff Your repositories, cloud accounts and licences stay in your name
Data & AI Most booked Fixed scope

Postgres and dbt Analytics Warehouse

One warehouse where your app, payments and ads data agree, with dbt models that are tested and documented.

Delivered in

25 working days

Revisions

One round, included

Ownership

Yours from day one

Overview

What this engagement is

Reporting arguments are usually definition arguments. Marketing counts a customer one way, finance another, and both are working from a different export. We build a warehouse on Postgres or Snowflake, load your sources on a schedule, and model them in dbt so a term like active customer is defined once, in version control, with a test that fails loudly when the data breaks. Documentation is generated from the models themselves, which means it stays current instead of rotting in a shared drive.

Deliverables

What lands in your repositories

7 items
  • Warehouse provisioned on Postgres or Snowflake with access roles
  • Ingestion from up to five sources, such as your app database, Razorpay and ad platforms
  • Staging, intermediate and mart layers built as dbt models
  • Data tests for uniqueness, referential integrity and freshness on key tables
  • Generated documentation site with model lineage
  • Daily scheduled runs with failure alerts to email or Slack
  • Handover session covering how to add a model

Outcomes

What changes once it ships

One number per metric, defined in code and testable

Broken upstream data is caught by a failing test, not by a customer

Analysts spend their time analysing instead of copying

Process

How the 4 stages run

  1. 01

    Interview

    we collect the questions the business keeps failing to answer

  2. 02

    Model

    sources are mapped and the mart layer is designed around those questions

  3. 03

    Build

    ingestion, dbt models and tests are implemented and backfilled

  4. 04

    Handover

    walkthrough, documentation and two weeks of question answering

Booked most often by

  • Companies where every report comes from a different spreadsheet
  • Teams whose analyst spends most of the week joining exports by hand
  • Businesses preparing for due diligence and needing consistent numbers

What we need from you

  • Read access to source databases and platform accounts
  • An hour each with the people who own the definitions that differ
  • A decision on where the warehouse lives and who pays for it

These are collected in the technical brief that opens in your dashboard the moment payment clears. The clock starts when they arrive, not before.

Answers

Questions this engagement raises

Below a few hundred million rows Postgres is usually cheaper and simpler. We will size it with you before committing.

That is normal and it is handled in the staging layer. Where the mess is unfixable we document it rather than hiding it.

No. Metabase Reporting Setup covers the dashboard layer and is designed to sit on top of this.

This is engineering work, not a physical product — nothing ships and there is no stock to run out of. Delivery is to the working days stated above, into systems you control, and the refund terms set out what happens if we miss the date.

Booked alongside

Engagements that pair with this one

All Data & AI

Airflow Data Pipeline Build

Scheduled pipelines in Airflow that retry, alert and backfill properly, replacing the cron jobs nobody monitors.

Airflow deployment on MWAA, Composer or your Kubernetes cluster
18 working days Scope published

Fixed fee · GST incl.

₹34,999

Metabase Reporting Setup

Dashboards your leadership team will actually open, built on governed queries rather than ad-hoc SQL.

Metabase installed and connected to your database or warehouse
9 working days Scope published

Fixed fee · GST incl.

₹14,999

Retrieval Chatbot on Your Documents

A grounded assistant that answers from your own manuals and policies, cites its sources and says when it does not know.

Ingestion pipeline for PDF, Word, HTML and Confluence content
22 working days Scope published

Fixed fee · GST incl.

₹44,999

GST included

₹39,999

Capacity open this month

Read the scope. Know the price. Start on Monday.

No discovery calls to find out a number, no statements of work that take three weeks to sign. Pick the engagement that matches the problem and we assign the engineers.