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
KIVERA Monthly Social Video Management Category: After Effects, Content Creation, Instagram Marketing, Social Media Management, Social Media Marketing, Video Editing, Video Production, Video Services Budget: $300 - $301 USD
AWS EKS Cluster Setup for Spring Boot Project Category: Amazon Web Services, CI / CD, Documentation, Hadoop, Java, Kubernetes, Linux, Microservices, Spring Boot, Terraform Budget: $30 - $250 USD
11 Nov 2025 05:03 GMT
Mixed Data Entry From Printed Docs Category: Data Analysis, Data Entry, Data Extraction, Data Management, Data Processing, Excel, PDF, Transcription Budget: ₹12500 - ₹37500 INR
150 Verified Cleaning Contract Leads Category: Data Collection, Data Entry, Data Management, Data Processing, Excel, Lead Generation, Leads, Research, Web Search Budget: £20 - £250 GBP
11 Nov 2025 05:02 GMT
Custom Logo for social media Category: Adobe Illustrator, Photoshop, Branding, Graphic Design, Illustration, Logo Design, Typography, Vector Design, Visual Design Budget: ₹1500 - ₹12500 INR
YouTube Science Explainer Videos Category: Adobe Premiere Pro, After Effects, Animation, Explainer Videos, Final Cut Pro, Script Writing, Video Editing, Video Production Budget: ₹600 - ₹1500 INR
11 Nov 2025 04:59 GMT
Face Detection & 3D Try-On -- 2 Category: 3D Animation, 3D Modelling, 3D Rendering, API Development, AR / VR 3D Asset, Face Recognition, Mobile App Development Budget: ₹210000 - ₹400000 INR
AI-Based College Matching Web Development Category: AI (Artificial Intelligence) HW / SW, AI Development, Angular, Artificial Intelligence, Full Stack Development, Laravel, MERN Stack, Node.js, Web Development Budget: ₹75000 - ₹150000 INR
