AWS Redshift Data Engineer

Vouchagram India; New Delhi; On-site; INR 900,000 - 1,400,000; Full time

Job summary

Vouchagram India is seeking an experienced AWS Redshift Data Engineer to design, optimize, and maintain scalable data pipelines and cloud data warehouse solutions. The role requires hands-on Redshift, advanced SQL, ETL/ELT development, and strong collaboration with analytics teams to deliver reliable data insights.

You will work in an office-based environment in Delhi, handling large datasets, performance tuning, and cost-conscious data architecture.

Qualifications

• Strong SQL skills and hands-on experience with Amazon Redshift.
• Experience building, optimizing, and maintaining scalable data pipelines.
• Knowledge of AWS data services and best practices for cloud data warehouses.
• Familiarity with performance tuning, distribution styles, and workload management in Redshift.
• Experience with data quality checks and data reconciliation.

Responsibilities

• Design, develop, and maintain data warehouse solutions using Amazon Redshift.
• Write complex SQL queries involving joins, subqueries, CTEs, window functions, and aggregations.
• Develop optimized SQL scripts, stored procedures, views, and data transformation logic.
• Build and maintain ETL/ELT pipelines using AWS Glue, S3, and other AWS services.
• Perform data ingestion from multiple sources into Amazon Redshift.
• Optimize query performance using EXPLAIN, distribution styles, sort keys, and workload management.
• Implement incremental data loads, CDC, and data reconciliation.
• Develop data quality checks and troubleshoot data pipeline failures.
• Work with large datasets and implement efficient data partitioning and storage strategies.
• Collaborate with analytics, BI, and business teams to deliver reliable data solutions.
• Monitor Redshift performance, query execution, storage utilization, and operational costs.
• Implement data security using IAM roles, encryption, and appropriate access controls.

Skills

AWS Redshift

SQL

ETL/ELT

AWS Glue

S3

Python

Job description

Job Title: AWS Redshift Data Engineer

Working Mode:- (Work from Office only)

Experience: 36 years (customizable)

Primary Skills: AWS Redshift, SQL, ETL/ELT, AWS Glue, S3, Python

Role Type: Data Engineering / Cloud Data Warehouse

Job Summary

We are looking for an experienced AWS Redshift Data Engineer with strong SQL skills and expertise in building, optimizing, and maintaining scalable data pipelines and cloud data warehouse solutions. The candidate should have hands‑on experience with Amazon Redshift, complex SQL queries, ETL/ELT processes, performance tuning, and AWS data services.

Key Responsibilities

• Design, develop, and maintain data warehouse solutions using Amazon Redshift.
• Write complex SQL queries involving joins, subqueries, CTEs, window functions, and aggregations.
• Develop optimized SQL scripts, stored procedures, views, and data transformation logic.
• Build and maintain ETL/ELT pipelines using AWS Glue, S3, and other AWS services.
• Perform data ingestion from multiple sources into Amazon Redshift.
• Optimize query performance using EXPLAIN, distribution styles, sort keys, and workload management.
• Implement incremental data loads, CDC (Change Data Capture), and data reconciliation.
• Develop data quality checks and troubleshoot data pipeline failures.
• Work with large datasets and implement efficient data partitioning and storage strategies.
• Collaborate with analytics, BI, and business teams to deliver reliable data solutions.
• Monitor Redshift performance, query execution, storage utilization, and operational costs.
• Implement data security using IAM roles, encryption, and appropriate access controls.