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
Organisation rigoureuse documents projets Category: Asana, Data Processing, Excel, Google Sheets, Microsoft Office, Monday.com, Project Management, Sharepoint Budget: $15 - $25 USD
18-Apr-2026 16:04 GMT
Service de Voix Off Professionnelle Category: Article Writing, Audio Editing, Audio Engineering, Audio Production, Copywriting, French Translator, Transcription, Voice Over Budget: $25 - $30 USD
18-Apr-2026 16:01 GMT
Motion Graphics Animation for Equipment Rental Category: 2D Animation, 3D Animation, After Effects, Animation, B2B Marketing, Graphic Design, Motion Graphics, Video Editing, Video Production, Visual Effects Budget: $750 - $1500 CAD
18-Apr-2026 15:59 GMT
Python Django Web App Development Category: API Development, Database Design, Django, Flask, Git, JavaScript, Python, Web Development Budget: $250 - $750 USD
Rebuild TradingView Strategy Code Category: Backtesting, Data Analysis, Data Visualization, Financial Analysis, Financial Modeling, Pine Script, Script Writing, Software Development, Software Engineering, Statistical Analysis Budget: $30 - $250 USD
18-Apr-2026 15:53 GMT
Scientific Data Stats in Excel Category: Copy Typing, Data Entry, Data Processing, Excel, Excel VBA, PDF, Visual Basic, Word Budget: ₹100 - ₹400 INR
18-Apr-2026 15:48 GMT
Bilingual Sales Chat Support Category: Chatbot, Conversion Rate Optimization, CRM, Customer Service, Digital Marketing, Lead Generation, Sales, Social Media Management Budget: €12 - €18 EUR
18-Apr-2026 15:47 GMT
Casual UGC Try-On Videos Category: Content Creation, Video Ads, Video Editing, Video Post Editing, Video Production, Video Services, Video Streaming, Videography Budget: ₹1500 - ₹12500 INR
18-Apr-2026 15:45 GMT
Rapid PDF-Text Extraction Category: Adobe Acrobat, Copy Typing, Data Entry, Data Management, Data Processing, Document Checking, Excel, PDF, Transcription, Typing Budget: ₹12500 - ₹37500 INR
18-Apr-2026 15:44 GMT
Political Logo Design Category: Adobe Illustrator, Branding, Design Thinking, Digital Art, Graphic Design, Logo Design, Marketing, Photoshop, Print Design, Vector Design Budget: $30 - $250 USD
AI Software Tutorial Videos Category: Adobe Premiere Pro, After Effects, Camtasia, DaVinci Resolve, Final Cut Pro, Video Editing, Video Production, Video Services Budget: ₹750 - ₹1250 INR
