Senior Data Engineer AWS Redshift

globe (3)

globe (3)

Hungary

hourglass (1)

Contract

business-cards (1)

Data Engineering and Streaming

1

Senior Data Engineer – AWS Redshift

Location: Fully Remote – Hungary

Engagement: 12-month contract, extendable

Employment type: Contract

About the Role

We are seeking an experienced Senior Data Engineer to design, optimize, and maintain scalable cloud data warehouse solutions on AWS. In this fully remote role, you will work closely with data, analytics, and engineering teams to build reliable data pipelines, improve Redshift performance, and support high-quality analytics and reporting.

Key Responsibilities

  • Design, develop, and maintain robust, scalable data pipelines and ETL/ELT workflows.
  • Build and optimize data models in AWS Redshift, including dimensional (Kimball), normalized, and hybrid modeling approaches.
  • Analyze and tune Redshift query performance using execution plans, workload metrics, distribution keys, sort keys, and workload management (WLM).
  • Design efficient table structures, distribution strategies, and sort-key strategies to minimize data movement, skew, and query latency.
  • Develop and maintain data transformation workflows using PySpark and SQL.
  • Build, schedule, monitor, and troubleshoot orchestrated workflows in Apache Airflow.
  • Implement data quality checks, data validation, and observability practices across pipelines and warehouse assets.
  • Use AWS CloudWatch and the Redshift Console to monitor cluster health, query performance, concurrency, and operational issues.
  • Collaborate with analytics, product, and engineering stakeholders to translate business requirements into scalable data solutions.
  • Contribute to dbt-based development practices, including version control, code reviews, testing, documentation, and CI/CD.
  • Support incident investigation, root-cause analysis, and continuous improvement of data platform reliability and performance.

Required Skills and Experience

  • 5+ years of professional experience in data engineering, with substantial experience in cloud data warehouse environments.
  • Proven hands-on expertise with AWS Redshift, including:
    • Redshift internals and architecture
    • Workload Management (WLM), including automatic and manual queue configuration
    • Distribution keys/styles and sort keys
    • Query execution plan analysis using EXPLAIN and related diagnostics
    • Query optimization, join strategies, aggregation tuning, and data-skew remediation
  • Strong advanced SQL skills and deep experience tuning complex queries in Redshift.
  • Hands-on experience with PySpark for large-scale data processing.
  • Hands-on experience with Apache Airflow for workflow orchestration.
  • Solid understanding of data modeling principles, including:
    • Kimball dimensional modeling
    • Normalized relational models
    • Hybrid modeling approaches
  • Experience with monitoring and observability tools, particularly Amazon CloudWatch and the Redshift Console.
  • Familiarity with data versioning, Git-based workflows, CI/CD, and collaborative development practices in dbt.
  • Strong communication skills and ability to work independently in a remote, distributed team.

Good to Have

  • Advanced expertise in Apache Airflow, including DAG design, scheduling, dependency management, and operational troubleshooting.
  • Experience with AWS Glue for data integration, cataloging, and serverless ETL.
  • Experience with AWS data services such as S3, Lambda, Step Functions, or Athena.
  • Experience with performance benchmarking, cost optimization, and Redshift Advisor recommendations.
  • Experience implementing automated testing, data contracts, and lineage/documentation practices.
  • Experience supporting analytics teams, BI tools, or self-service data platforms.

What Success Looks Like

  • Faster, more reliable Redshift queries through well-designed tables, effective WLM configuration, and informed query tuning.
  • Dependable PySpark and Airflow pipelines with clear ownership, monitoring, and failure recovery.
  • Clean, maintainable dbt models with strong testing, documentation, and version control.
  • Improved data quality, observability, and collaboration across data and analytics teams.

Redshift Expertise We Value

The ideal candidate understands how Redshift stores and processes data: appropriate sort keys can reduce scanned blocks for filtered queries, while suitable distribution keys help minimize redistribution during joins and aggregations. They should also be comfortable interpreting query plans, identifying bottlenecks, and balancing workload priorities through WLM.

Darwin Recruitment is acting as an Employment Business in relation to this vacancy.

Sheikh Salem

Featured Image
Consultant Name

Sheikh Salem

Job Title

Senior Recruitment Consultant

SOCIAL MEDIA

Submit Your CV

This field is for validation purposes and should be left unchanged.
Name_1
Max. file size: 512 MB.

Similar Jobs

1

Contract

PHP Developer (DRWN)

Technology

Data Engineering and Streaming

Job title – Senior Full-Stack Engineer (PHP/Symfony + React) Client Location – Amsterdam, Netherlands Remote work offering – 100% (fully remote) Client Industry – See more…

to €271/year

Amsterdam

Netherlands

0

Permanent

Senior Flink Engineer

Technology

Data Engineering and Streaming

Senior Flink Engineer – Telecommunications Industry: Telecommunications | Level: Senior Engineer | Location: Amsterdam – Hybrid | Reports to: Lead Streaming Engineer About the See more…

to €90,000/year

Amsterdam

Netherlands

1

Permanent

Senior Flink Engineer

Technology

Data Engineering and Streaming

Senior Flink Engineer – Telecommunications Industry: Telecommunications | Level: Senior Engineer | Location: Amsterdam – Hybrid | Reports to: Lead Streaming Engineer About the See more…

to €90,000/year

Amsterdam

Netherlands