AWS Redshift Data Engineer / Data Architect

Numentica LLC • Cypress, CA

11h • Remote

About The Position

We are looking for a senior AWS Redshift expert to support analytics platform enhancements, including Redshift optimization, migration to Redshift Serverless, and modern data ingestion architecture.

Requirements

• Strong hands-on experience with Amazon Redshift (Provisioned, Serverless, RMS).
• Deep SQL performance tuning and query optimization expertise.
• Solid AWS data engineering background (RDS, DynamoDB, Kinesis).
• Experience with modern lakehouse concepts, especially Apache Iceberg.
• Data architecture and analytical platform design experience.

Nice To Haves

• Exposure to AI-assisted query optimization or analytics platforms.
• Experience building or supporting BI and analytics use cases at scale.

Responsibilities

• Optimize and modernize Amazon Redshift environments, including consolidation into Redshift Managed Storage (RMS).
• Lead or support migration from Provisioned Redshift to Redshift Serverless with zero or minimal downtime.
• Analyze and tune Redshift SQL for performance across batch and ad-hoc analytical workloads.
• Review and enhance data ingestion pipelines from AWS sources such as RDS, DynamoDB, and Kinesis.
• Design data delivery into Apache Iceberg tables and Redshift with minimal duplication and high efficiency.
• Collaborate with stakeholders on architecture recommendations and best practices.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed