Growth Intelligence App Development for eCommerce Teams

We are looking for a skilled developer to build a Growth Intelligence App specifically designed for eCommerce teams.

This app will leverage unified operational data, analytics, and AI assisted Insights to facilitate faster and more accurate decision-making processes.

This is not a generic BI tool and not an open-ended R&D effort.

The application has a clearly defined MVP scope focused on:

• Operational visibility (orders, inventory, fulfillment, performance)
• Strategic analytics (products, customers, forecasting, profitability)
• AI-assisted insights (alerts, explanations, recommendations, natural language queries)

The product scope, UI designs, and database schema are already finalized.

We are looking for an experienced delivery-focused agency to execute the remaining engineering work and bring the application to a production-ready state.

## What Is Already Completed

The following items are fully completed and will be provided to the Developer:

• UI/UX designs and screen flows
• Detailed feature scope and MVP definition
• Database schema and core data models
• High-level architecture direction

Note

You will not be responsible for product discovery, UX design, or requirements definition.

## Scope of Work

The selected vendor will own end-to-end implementation beyond UI and schema, including:

• Backend & Application Logic
• REST API development
• Business logic for KPIs, analytics, and aggregations
• Role-based access control (RBAC)
• Secure, scalable application architecture
• Data Pipelines & Processing
• Data ingestion via APIs and file-based imports
• Incremental and historical data sync
• Data validation, normalization, and transformation
• Analytics-optimized data structures
• Experience with workflow orchestration is a significant plus for managing complex ERP syncs and retries.
• Integrations
• ERP and eCommerce system integrations
• Abstraction layers for future extensibility
• Error handling, retries, and monitoring
• Analytics & Intelligence Layer
• KPI computation using SQL-driven logic
• Forecasting and trend analysis
• Alerting and anomaly detection
• Drill-down and segmentation support
• AI / LLM Enablement
• Integration with an LLM provider (no model training required)
• Natural language query support
• Implementation of RAG patterns to allow the LLM to interact accurately with our specific SQL schemas and KPIs.
• AI-generated explanations and root-cause narratives
• Guardrails, prompt structure, and response consistency
• QA, Deployment & Handover
• Unit and integration testing
• Performance testing for analytics queries
• Cloud deployment
• Technical documentation
• Knowledge transfer and handover
• Performance Targets
• Targeting less than 1 second latency for core analytical dashboards
• Support for multi-channel data ingestion (up to 1M+ records per month)

## Preferred Technical Skills & Stack

(Equivalent experience is explicitly acceptable)

Skill Category - Preferred Technology / Capability

Data Pipelines - Airbyte (Cloud or OSS) for incremental and historical ingestion

Database - Supabase with PostgreSQL

Data & Business Logic - Advanced SQL (CTEs, Views, Window Functions)

Backend APIs - with Express

Frontend - React with modern state management

ERP Integration - NetSuite APIs and Saved Searches

E-commerce Integration - Magento REST APIs

Security & Auth - Supabase Authentication and Row-Level Security (RLS)

Reporting Logic - Financial / Excel-style calculation logic and reconciliations

Data Visualization - Charting libraries such as or Recharts

Important

This stack reflects our current preference, not a hard requirement. Anyone with strong, relevant experience using alternative tools are encouraged to apply and explain their approach.

Effort, Timeline & Engagement Model

Estimated MVP duration: 2–3 months

Engagement type

Milestone-based preferred

Communication cadence

o Weekly written progress updates

o Bi-weekly review and demo calls

Vendor is expected to

o Own delivery quality and timelines

o Proactively surface risks and tradeoffs

o Operate with minimal supervision once aligned

## What We Are Looking For

We are looking for established agencies or senior vendors with:

• Proven experience building data-heavy or analytics-driven applications
• Strong backend and data architecture capability
• Experience integrating LLMs into real production systems
• Comfort working from existing designs and schemas
• Clear communication and structured execution

This role is NOT suitable for

• Junior or learning-focused teams
• UI-only or frontend-heavy vendors
• Vendors requiring extensive product discovery

Nice to Have (Optional)

• Prior experience with eCommerce or retail analytics
• Forecasting or anomaly detection implementations
• Multi-tenant SaaS experience
• Complex ERP or financial data integrations

Contract duration of 1 to 3 months. with 30 hours per week.

Mandatory skills

airbite, Supabase, Advanced SQL, Magento REST APIs, Recharts, PostgreSQL, , React,