Job Title: Data Engineer
Location: Hungary (Hybrid)
Type: Contract
Length: 12 Months
About the Role
We are seeking an experienced Data Engineer to join our client’s team on a 12-month contract in Hungary. This role is ideal for someone with a strong background in cloud data warehouse environments and a proven track record of working with AWS Redshift. You will play a key role in designing, optimizing, and maintaining scalable data solutions while ensuring best practices in data modeling and transformation.
Key Responsibilities
1. Design, build, and optimize data pipelines in AWS Redshift, ensuring performance and scalability.
2. Use dbt for data transformation, model building, and collaborative development.
3. Analyze query execution plans, tune SQL, and apply optimization techniques for Redshift performance.
4. Implement and maintain robust data models, including dimensional modeling (Kimball), normalized, and hybrid strategies.
5. Monitor data pipelines and warehouse performance using CloudWatch and Redshift Console.
6. Contribute to CI/CD processes, data versioning, and best practices for collaborative development.
7. Work closely with cross-functional teams to support analytics and business intelligence initiatives.
Required Skills & Experience
8. 6+ years of experience in data engineering, with a focus on cloud data warehouses.
9. Proven expertise in AWS Redshift (internals, WLM, distribution/sort keys, execution plan analysis, optimization).
10. Hands-on experience with dbt for transformation and model building.
11. Strong SQL skills with deep knowledge of performance tuning in Redshift.
12. Solid understanding of data modeling principles (Kimball, normalized, hybrid).
13. Experience with monitoring tools (CloudWatch, Redshift Console).
14. Familiarity with data versioning, CI/CD pipelines, and collaborative dev practices in dbt.
Contract Details
15. Start: ASAP
16. Duration: 12 Months
17. Location: Hungary (Hybrid working model)
18. Engagement: Freelance / Contract
*Rates depend on experience and client requirements