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.
Multi-Platform Social Media Creatives Category: Adobe Illustrator, Photoshop, Animation, Banner Design, Content Creation, Graphic Design, Logo Design, Social Media Marketing, Visual Arts Budget: ₹1500 - ₹12500 INR
Golden Lovebirds 3D Model Category: 3D Animation, 3D Art, 3D Design, 3D Graphic Design, 3D Illustration, 3D Layout, 3D Modelling, 3D Rendering, 3D Visualization, Maya Budget: ₹600 - ₹1500 INR
29 Apr 2026 10:02 GMT
Excel Cross-File Data Linking Category: Data Analysis, Data Entry, Data Integration, Data Management, Data Processing, Data Visualization, Excel, Excel Macros, Excel VBA, Visual Basic Budget: €8 - €30 EUR
29 Apr 2026 10:02 GMT
Organisation Conférence Technologie en Ligne Category: 3D Animation, 3D Modelling, Animation, Article Writing, Content Development, Event Management, Visual Design, Zoom Budget: $2 - $8 USD
29 Apr 2026 10:00 GMT
YouTube Automation Sales Closer Category: Conversion Rate Optimization, CRM, Digital Marketing, Email Marketing, Internet Marketing, Lead Generation, Sales, Sales Management, Social Media Marketing, Telemarketing Budget: $250 - $750 USD
29 Apr 2026 10:00 GMT
Professionalize AI-Generated Logo Category: Adobe Illustrator, AI Graphic Design, Graphic Design, Illustration, Inkscape, Logo Design, Photoshop, Vector Design Budget: €30 - €250 EUR
29 Apr 2026 09:59 GMT
Complete Revamp of Ladyhouse.store Category: Graphic Design, HTML, PHP, SEO, UI / User Interface, UX / User Experience, Web Development, Web Design Budget: ₹75000 - ₹150000 INR
29 Apr 2026 09:59 GMT
Website Audit & Redesign Fixes Category: Conversion Rate Optimization, PHP, SEO, Shopify, Web Design, Web Development, Website Audit, WordPress Budget: ₹37500 - ₹75000 INR
29 Apr 2026 09:58 GMT
Nigerian Imitation Jewelry Sales Category: Business Development, Customer Service, Field Sales, Link Building, Sales, Sales Management Budget: ₹600 - ₹1500 INR
29 Apr 2026 09:57 GMT
eCommerce Redesign & Optimization Category: ECommerce, Graphic Design, HTML, PHP, SEO, Web Design, Web Development Budget: ₹75000 - ₹150000 INR
29 Apr 2026 09:57 GMT
Garment Export Lead Generation Category: B2B Marketing, Business Development, Data Entry, Email Marketing, Excel, Lead Generation, Leads, Market Research, Web Search Budget: ₹12500 - ₹37500 INR
29 Apr 2026 09:57 GMT
Film Photography Dropshipping Store Category: CSS, Dropshipping, EBay, ECommerce, HTML, Product Descriptions, Shopify, Web Design Budget: £250 - £750 GBP
29 Apr 2026 09:57 GMT
Hotel Booking App Development Category: Backend Development, Flutter, Graphic Design, Mobile App Development, Node.js, PHP, React Native, Web Design Budget: ₹37500 - ₹75000 INR
