Description

Design and implement AWS-based data warehousing solutions with a focus on Redshift architecture.

Responsibilities

• Translate functional and technical requirements into detailed architecture and design specifications.
• Develop ETL pipelines for data movement to Redshift, including source-to-target mapping.
• Design data warehouse schemas and implement database designs within Redshift.
• Perform technical root cause analysis and define corrective actions for system issues.
• Participate in code and design reviews to ensure development standards are met.

Required Skills

• 5+ years of experience in cloud architecture and data warehousing.
• Hands-on experience with Amazon Redshift architecture and database design.
• Proficiency with AWS services including EC2, S3, Amazon API Gateway, and AWS Lambda.
• Experience managing AWS Aurora, AWS RDS, ElasticSearch, and ElastiCache.
• Strong understanding of BI concepts and data warehouse schema design.
• Knowledge of microservices and API interactions with Redshift.
• Ability to communicate technical concepts to non-technical stakeholders.

Preferred Skills

• Expertise in writing complex queries using nested joins and derived tables.
• Experience coding and testing complex system components.

Key Skills

Education

Any Gradute