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.
On page and off page seo Category: Content Marketing, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, SEO Auditing, SEO Writing Budget: €30 - €250 EUR
05-Apr-2026 21:53 GMT
SketchUp to SolidWorks Parts Conversion Category: 3D CAD, 3D Design, 3D Modelling, CAD / CAM, Manufacturing Design, Mechanical Engineering, SketchUp, Solidworks Budget: $3 - $10 NZD
05-Apr-2026 21:52 GMT
Night sky painting Category: Art Consulting, Art Installation, Creative Design, Graphic Art, Illustration, Oil Painting, Painting, Sketching, Visual Arts, Watercolor Painting Budget: $30 - $250 CAD
05-Apr-2026 21:51 GMT
Job Placement Agency Website Development Category: Content Writing, CSS, HTML, Laravel, PHP, React.js, SEO, UX / User Experience, Web Development, Web Design Budget: ₹1500 - ₹2000 INR
05-Apr-2026 21:50 GMT
Instagram Content Creation & Management Category: Content Creation, Content Writing, Copywriting, Ghostwriting, Graphic Design, Instagram Marketing, Social Media Management, Social Media Marketing Budget: ₹750 - ₹1250 INR
05-Apr-2026 21:49 GMT
Full Stack Developer Needed Category: AngularJS, API Integration, Backend Development, Frontend Development, Full Stack Development, JavaScript, Node.js, NoSQL Couch & Mongo Budget: min $50 AUD
05-Apr-2026 21:49 GMT
H ve Matematik Logo Tasarımı Category: Adobe Illustrator, Photoshop, Graphic Design, Illustration, Logo Design, Vector Design Budget: $10 - $15 USD
05-Apr-2026 21:46 GMT
Boundary Staking for Forms Category: AutoCAD, Building Architecture, Building Regulations, Civil Engineering, Construction Management, Environmental Consulting, Project Management, Structural Engineering Budget: $30 - $250 USD
05-Apr-2026 21:46 GMT
High-Poly Modern Rifle Modeling(blender ) Category: 3D Animation, 3D Art, 3D Design, 3D Graphic Design, 3D Modelling, 3D Printing, 3D Rendering, 3D Visualization, 3ds Max, Blender Budget: $10 - $30 USD
Mixed Data Entry From Online Sources -- 2 Category: Data Analysis, Data Entry, Data Processing, Database Management, Database Programming, Microsoft Access, MySQL, SQL Budget: ₹750 - ₹1250 INR
