Job Description
Key Responsibilities
• Design, develop, and maintain batch and near-real-time data pipelines using AWS services.
• Build and optimize data ingestion and transformation workflows feeding Amazon Redshift.
• Implement scalable ETL/ELT frameworks using Python and SQL.
• Support data integration from multiple source systems across domains.
• Develop and maintain Redshift data models, tables, and views.
• Optimize Redshift performance using appropriate distribution styles, sort keys, and query tuning.
• Support data validation, reconciliation, and quality checks.
• Work within the AWS ecosystem (S3, Glue, Redshift, Lambda, IAM, etc.).
• Support and integrate with Snowflake for analytics or downstream consumption.
• Ensure security, scalability, and cost efficiency of data solutions.
• Work closely with Data Architects and Data Modelers to implement approved designs.
• Partner with analysts and business teams to understand data requirements.
• Support production issues, root-cause analysis, and continuous improvements