Job Description

Job Title: AWS Redshift Engineer

Work Location: Remote

Job Overview:

Amazon Redshift is a fast-growing, highly efficient, fully managed, petabyte-scale cloud-based data warehouse service. It allows customers to significantly boost their data analysis performance, handling datasets of any size using familiar SQL-based business intelligence tools. As the fastest and most widely adopted cloud data warehouse, Amazon Redshift continually evolves to meet customer needs across all facets of the service.

This role is part of the Redshift Builder Experience team, which drives Redshift's development, evaluation, and deployment processes. The team operates at the intersection of developer tools, scalable testing frameworks, and distributed systems, enhancing the innovation and delivery pace for the Redshift organization. We are seeking a Senior Software Development Engineer with a passion for creating large-scale, high-availability applications that enhance developer productivity. We’re looking for individuals who aspire to leave a lasting impact on both our product and team, embodying Amazon’s leadership principles.

Role at AWS: 

Response Informatics is seeking an AWS Redshift Data Engineer to join our team and begin a fulfilling career journey. The key responsibilities of the role include:

• Designing and implementing data warehousing solutions using AWS Redshift.
• Collaborating with data analysts and business stakeholders to gather and understand data requirements.
• Developing ETL processes to load data into Redshift from various sources.
• Optimizing Redshift performance for large-scale data processing.
• Providing technical support and troubleshooting Redshift-related issues.
• Staying up-to-date with the latest AWS Redshift features and best practices.
   

Key Responsibilities:

• Data Architecture: Design and manage data architectures with AWS Redshift, ensuring efficient data storage and retrieval.
• ETL Processes: Develop and maintain ETL pipelines to integrate data from diverse sources into AWS Redshift.
• Performance Optimization: Optimize AWS Redshift clusters for peak performance, ensuring smooth query execution and efficient data processing.
• Data Security: Implement and uphold security measures within AWS Redshift, ensuring compliance with data protection regulations.
• Troubleshooting: Identify and resolve data integration, performance, and security issues within AWS Redshift.
• Collaboration: Work closely with data analysts, scientists, and other stakeholders to provide tailored data solutions.
• Documentation: Maintain thorough documentation of data architectures, ETL processes, and security protocols.
   

Educational Qualification:

• A Bachelor's degree in Computer Science or a related field is required.
   

Desired Skills and Knowledge:

• Experience with a variety of cloud products, including Amazon AWS.
• Hands-on experience with cloud technologies such as AWS EC2, S3, VPC, VPN, Amazon API Gateway, AWS ECS, Lambda, Aurora, RDS, Route 53, ElasticSearch, Redis, and ElastiCache.
• Strong understanding of the AWS environment, particularly S3 storage.
• In-depth knowledge of Amazon Redshift architecture and database design.
• Expertise in AWS Pipeline for developing ETL processes to move data into Redshift, with experience mapping source-to-target fields and rules.
• Proficiency in writing complex SQL queries with nested joins and derived tables.
• Solid knowledge of Oracle databases and data warehouse schema design.
   

Additional Responsibilities:

• Translate functional and technical requirements into detailed architecture and design.
• Code and test complex system components.
• Participate in code and design reviews to maintain high development standards.
• Perform technical root cause analysis and propose corrective actions.
• Communicate complex technology concepts to non-technical stakeholders.
• Maintain high team morale and ensure adherence to company and project standards.
• Escalate issues impacting delivery and quality, as needed.
• Pay attention to detail and ensure on-time delivery of agreed-upon deliverables.