We’re looking for an experienced data engineer or analytics specialist to help us bring multiple existing data sources together into a single, well-structured Amazon Redshift environment.
The goal is to set up a reliable data foundation so our team can run analytics, reporting, and future AI models from one clean source of truth.
⸻
Data Sources to Integrate
You’ll be connecting and consolidating data from: • Aurora (MySQL) – transactions, users • HelpScout – customer service tickets • Mailchimp – email campaigns & engagement • Meta Ads (Facebook Marketing API) – campaign performance, spend, ROAS • Google Analytics 4 (GA4) – web sessions & conversions
All data should flow into Amazon Redshift Serverless, using S3 as the raw landing zone.
⸻
Deliverables 1. Data Warehouse Setup • Configure Redshift + S3 structure (raw, staging, analytics schemas) • Set up secure, automated access and permissions 2. ETL / ELT Pipelines • Build or configure ingestion pipelines (Airbyte, Fivetran, or custom Python/Lambda) • Create transformations (SQL / dbt) for clean, analytics-ready tables 3. Data Modeling • Standardize user IDs and timestamps across all sources • Produce core joined tables (users, orders, engagement, campaigns, support) 4. Documentation • Schema diagram, data dictionary, and connection details • Clear handover instructions for internal use 5. Validation • Sample dashboards or queries to confirm the data joins correctly
⸻
Required Skills • Strong experience with AWS Redshift, S3, and SQL • Hands-on with ETL tools (Airbyte, Fivetran, Stitch, or custom scripts) • Familiarity with API integrations (Mailchimp, Meta Ads, GA4, HelpScout) • Knowledge of dbt or similar for transformation and testing • Good communication and documentation skills
⸻
Nice to Have • Experience with AWS Glue / Lambda / Step Functions • Understanding of marketing analytics (attribution, ROAS, LTV)
⸻
Project Details • Location: Remote (UK / EU time zone preferred) • Start: Immediate • Duration: Approx. 4–6 weeks, with potential for follow-up work
⸻
To Apply
Please include: • Short summary of similar AWS/Redshift projects • Preferred ETL tool or stack • Example of a data model or architecture you’ve built (no sensitive info)
⸻
✅ Objective: Deliver a working Redshift data warehouse with automated pipelines, consolidated datasets, and clear documentation — ready for analytics and AI use.
Senior UI/UX Designer (US-Based) with Lovable / Vibe Coding Experience Category: Android, Android App Development, IOS Development, Mobile App Testing, Mobile Development, Testing / QA, UI / User Interface, Usability Testing, User Experience Research, Website Testing Budget: $2 - $8 USD
24-Mar-2026 17:03 GMT
Amapiano Music Empire Simulator Category: Android, Game Design, Game Development, IOS Development, IPhone, Mobile App Development, Simulation, Unity, Unreal Engine Budget: £250 - £750 GBP
24-Mar-2026 17:02 GMT
UiPath Automation for Customer Service Category: Asset Management, Automation, Customer Service, Documentation, REST API, RPA Development Budget: ₹400 - ₹750 INR
24-Mar-2026 17:01 GMT
Social Media Marketing Ecommerce App - Target country Category: Analytics, Conversion Rate Optimization, Digital Marketing, Facebook Ads, Facebook Marketing, Instagram Marketing, Internet Marketing, Marketing Strategy, Social Media Marketing, Twitter Budget: $250 - $750 USD
New Store Construction Grants Needed Category: Budgeting And Forecasting, Business Development, Construction, Financial Consulting, Grant Writing, Project Management, Proposal Writing, Technical Writing Budget: $250 - $750 CAD
24-Mar-2026 16:59 GMT
Flutter based Traffic project Category: CSS, ECommerce, Payment Gateway Integration, UI / User Interface, Web Development, Web Design, WordPress Budget: $30 - $250 USD
24-Mar-2026 16:59 GMT
Clean One-Page Redesign Comps Category: Photoshop, Figma, Graphic Design, UI / User Interface, User Interface / IA, Web Design Budget: $30 - $250 USD
Convert HTML Layout to Elementor Category: CSS, Elementor, HTML, JavaScript, PHP, Web Design, Web Development, WordPress Budget: $10 - $30 USD
24-Mar-2026 16:58 GMT
Dating app Category: Android, App Design, App Development, App Localization, Database Management, IOS Development, Mobile Accessibility, Mobile App Development, Mobile App Testing, Mobile Development Budget: $10 - $30 USD
