- Redshift Engineer
- 5 years of experience in Data Engineering and Data Warehousing with robust expertise in Amazon Redshift
- Design develop and maintain scalable Redshift data warehouses to support enterprise analytics and reporting needs
- Build and implement Dimensional Data Models Star Schema including fact and dimension tables for analytical workloads
- Develop optimize and troubleshoot complex SQL queries for large scale data processing and performance improvement
- Design and maintain ETL ELT pipelines using AWS Glue and other data integration tools
- Optimize Redshift performance through effective use of RA3 nodes Distribution Keys Sort Keys and Redshift Spectrum
- Integrate data from multiple sources such as S3 PostgreSQL APIs and third party applications into the data warehouse
- Collaborate with Data Architects Analysts and Business stakeholders to deliver scalable and efficient data solutions
- Ensure data quality governance security and compliance across the AWS data platform
- Hands on experience with AWS services S3 Lambda IAM CloudWatch and exposure to Python PySpark