Audit & Implement EU Brevo Email Alert System (Node.js)

We recently completed a UK-specific automated email alert system that connects our PostgreSQL + Google Sheets data to Brevo (Sendinblue) for user notifications. The system is fully functional and documented in detail (22-page technical document provided).

We’ve now parted ways with the original developer, and we’re looking for a new expert to:

Audit and verify the completed UK alert system — ensuring it meets best practices, follows clean architecture, and that there are no code or performance issues.

Duplicate and adapt the same system for our European Union product (France, Germany, Spain, and Ireland).

What’s Already Done (UK System):

Node.js + Express + TypeScript backend

PostgreSQL (Neon) + Drizzle ORM

Google Sheets API integration for live savings data

Automated Brevo lists + contact sync

6 email templates for various alert types

Daily + weekly cron jobs

Duplicate prevention, scheduled emails, and smart alert logic

Full system documentation (provided)

Your Tasks:
Phase 1 — Audit (Estimated: 1–2 days)

Review all code, configuration, and Brevo integration

Verify cron jobs, email triggers, and database schemas match documentation

Test end-to-end flow (sign-up → Brevo list → email delivery → logs)

Identify and fix any reliability, performance, or data consistency issues

Phase 2 — EU Implementation (Estimated: 2–3 days)

Duplicate UK alert flow for EU region (France, Germany, Spain, Ireland)

Integrate EU-specific Google Sheets data endpoints (already hosted)

Create separate Brevo lists and folder for EU alerts

Ensure rate updates trigger relevant EU emails

Update templates where necessary (e.g., "Weekly Roundup EU")

Deploy and test full flow on Replit

Deliverables:

Verified and clean UK alert system

EU alert system live and fully functional

Separate Brevo folder and lists for EU contacts

Working cron jobs (daily + weekly)

Test documentation and basic setup instructions

Tech Stack:

Node.js + Express + TypeScript

PostgreSQL (Neon) with Drizzle ORM

Brevo API (v3)

Google Sheets API

Hosted on Replit

What We’re Looking For:

Strong backend skills in Node.js/TypeScript

Experience with PostgreSQL + Drizzle ORM

Knowledge of Brevo (Sendinblue) or similar email systems

Familiarity with cron jobs, background tasks, and transactional email logic

Proven ability to work from and extend existing codebases

Budget & Timeline: