AWS Redshift Data Engineer

Role Summary

We are looking for a hands-on Redshift Data Engineer who will take technical ownership of
our AWS Redshift data warehouse while actively developing and optimising it.

This is a combined developer + administrator role:

You will design and write complex queries and stored procedures, while also monitoring,
maintaining, and tuning the Redshift cluster that underpins our data platform.

Our Redshift warehouse ingests data from a customer-facing application, streaming
DynamoDB data into Redshift using Kinesis Data Streams.

You will be responsible for ensuring this pipeline and the warehouse itself remain performant, reliable, and well governed.

Key Responsibilities

Redshift Development
• Write and optimise complex analytical SQL queries
• Design and maintain stored procedures (PL/pgSQL)
• Create and manage materialized views for performance and reporting
• Support downstream analytics and reporting use cases
• Implement best practices for schema design and data modelling

Redshift Administration & Operations
• Monitor and maintain the AWS Redshift cluster
• Regularly check and assess cluster health
• Respond to and investigate AWS alerts and notifications
• Troubleshoot performance, query failures, and data issues
• Perform performance tuning (WLM, distribution styles, sort keys, vacuuming, etc.)
• Manage workload management and concurrency where required

Data Pipeline Awareness
• Work with data streamed from DynamoDB → Kinesis → Redshift
• Understand ingestion patterns and their impact on warehouse performance
• Support reliability and efficiency of the ingestion process

Technical Skills & ExperienceEssential:
• Strong SQL (advanced joins, window functions, optimisation)
• Hands-on experience with AWS Redshift
• Experience writing stored procedures
• Knowledge of materialized views
• Performance tuning and troubleshooting skills
• Experience working with production data systems
• Comfortable responding to operational alerts and issues

Desirable:
• AWS services: Kinesis Data Streams, DynamoDB, S3, CloudWatch
• Understanding of streaming or near-real-time ingestion
• Experience with monitoring and alerting
• Knowledge of data warehousing principles
• Familiarity with infrastructure or serverless AWS services

Soft Skills & Personal Qualities
• Quick learner with strong problem-solving ability
• Comfortable working independently and taking ownership
• Able to investigate and resolve issues methodically
• Clear communicator with both technical and non-technical stakeholders
• Organised and reliable
• Proactive mindset – spots problems before they become incidents