New York Seasonal Jobs

Job Information

Amazon SDE Intern – High-Performance Query Processing, Query Optimization in New York, New York


Amazon Web Services (AWS) internships are for 12 consecutive weeks during summer. By applying to this position, your application will be considered for the locations listed on this posting.

Amazon Redshift is the world’s most popular fully managed cloud data warehouse. Tens of thousands of enterprise customers use Redshift to crunch through exabytes of data in the cloud to make business critical decisions every day. To stay ahead in such a mission critical setting, at Redshift, we must always re-invent ourselves for customers. We are always looking for the innovative engineers to help shape the future of Redshift.

About the team

Query Processing team is at the heart of Redshift data plane and is responsible for query analysis, query optimization and massively parallel execution engine. Query Processing team is focused on maintaining Amazon Redshift’s lead on price-performance.

Query Processing team delivers extreme performance by uniquely combining novel techniques for distributed query planning, code generation, query compilation, query scheduling, resource-planning, and superscalar query execution with optimized data encodings accessed with high performance SIMD kernels, and hardware conscious algorithms. We also work closely with AWS platform teams in shaping requirements for next generation platforms to run database/analytics applications.

Our team consists of industry leading innovators, with multitudes of patents and research publications in this space. We are a fun-loving team, that is passionate about ideating, designing and delivering query processing and overall database architecture towards extreme performance. We are distributed across many locations in US, Germany, and are expanding in other geographies.

This is a unique and rare opportunity to get in on the ground floor within a fast-growing business and help shape the technology powering analytical workloads for Fortune 500 companies, startups, and everything in between. You will bring deep technical, algorithmic and coding expertise with the ability to work within a fast moving and collaborative environment in the industry leading cloud company to deliver a broad business impact. If this sounds exciting to you - come build the future with us!

Key job responsibilities

As a software engineer in vectorized query execution team, you will:

• Design and implement state-of-the-art distributed data processing algorithms for the parallel execution query engine.

• Identify opportunities for performance improvement by in-depth analysis of the query plan and query execution states.

• Deploy and monitor new features in a highly available and fault tolerant system running in the cloud.

We are open to hiring candidates to work out of one of the following locations:

East Palo Alto, CA, USA | New York, NY, USA

Basic Qualifications

• Pursuing Master’s Degree or higher in Computer Science or related field with graduation conferral date after December 2024

• Programming experience with C or C+• Internship, project, or academic experience in at least one of the areas: query optimization, job scheduling, resource management, query execution, data compression technologies, information theory, GPUs, or ML.

Preferred Qualifications

• Pursuing PhD degree with focus on Systems / Information Theory, Databases, Computer Science, Computer Engineering, or related

• Strong knowledge of Computer Science fundamentals in object-oriented design, data structures, algorithm design, problem solving, and complexity analysis

• Strong software development skills

Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit

Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $88,400/year in our lowest geographic market up to $200,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit Applicants should apply via our internal or external career site.