Data Engineer II, Amazon Selection and Catalog Systems (ASCS)

Amazon.com

Bengaluru

On-site

INR 1,200,000 - 2,400,000

Full time

28 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Amazon Inc. seeks a Data Engineer II for ASCS to build scalable data pipelines that power catalog analytics and AI-driven insights.

You’ll move from siloed datasets to governed gold datasets and datamarts on Andes, designing architectures that process petabytes of catalog, listing and offer data while supporting BI and GenAI tools. As the team’s first data engineer, you’ll mentor others, drive CI/CD deployments with Maestro CDK, improve query performance, reduce infra costs, and partner with

Qualifications

  • 3+ years of data engineering experience.
  • 4+ years of SQL experience.
  • Experience with data modeling, warehousing and ETL/ELT pipelines.

Responsibilities

  • Design large-scale data structures and pipelines to support analytics and BI.
  • Implement real-time and batch data ingestion using AWS tools and best practices.
  • Translate business requirements into scalable, maintainable data solutions.
  • Collaborate with cross-functional teams to ensure data quality and governance.
  • Mentor junior engineers and contribute to CI/CD improvements.
  • Develop gold datasets and datamarts for AI use.

Skills

3+ years data engineering
4+ years SQL
ETL pipelines

Tools

AWS Redshift
AWS S3
AWS Glue
EMR
Kinesis
Firehose
Lambda
IAM roles

Job description

Data Engineer II, Amazon Selection and Catalog Systems (ASCS)

Amazon Selection and Catalog Systems (ASCS) builds the systems that host and run Amazon's product catalog. Its distributed systems process hundreds of millions of updates across billions of physical, digital and service products, powering how customers worldwide find, discover and buy what they want. You'll join CATALIST (Catalog Analytics, Insights, Strategy and Tech), the central Business Intelligence Engineering (BIE) team in Catalog Support Programs (CSP), part of Catalog Support Operations (CSO) within ASCS. CATALIST builds self-service analytics and AI-powered insights that help ASCS find and prevent catalog issues before customers feel them. We're looking for a Data Engineer II to build the data foundation behind this work. You'll move ASCS reporting from one-off datasets to governed gold datasets and datamarts on Andes, designed for both people and generative AI (GenAI) tools such as ANDI. You'll design scalable pipelines that process petabytes of catalog, listing and offer data. You'll also own operational excellence: moving releases to continuous integration and delivery (CI/CD) through Maestro CDK, automating pipeline health checks, and improving query performance and infrastructure cost. You'll partner with BIEs, Technical Program Managers (TPMs) and engineering teams across ASCS to turn business questions into reliable data products. You should be a self-starter who learns quickly, communicates clearly and raises the bar on data quality. As the team's first Data Engineer, you'll also mentor BIEs who want to grow into data engineering and help shape how the team scales its data capacity.

Key job responsibilities
  • Design and develop large-scale data structures and pipelines that support analytics, machine learning, and business intelligence across the organization
  • Implement data ingestion solutions using both real-time and batch processing approaches, applying best practices in data modeling and ETL/ELT processes with AWS technologies and big data tools
  • Gather and translate business requirements into scalable, maintainable technical solutions that integrate seamlessly with our overall data architecture
  • Analyze source data systems, document findings, and collaborate with source teams to establish and share best practices
  • Mentor and support junior data engineers by reviewing their work, providing guidance on technical decisions, and helping them grow their skills
  • Build governed gold datasets and datamarts for ASCS programs, designed for AI use
  • Move deployments to versioned, tested releases through continuous integration and delivery (CI/CD)
  • Own pipeline health, run times and query performance, with AI-driven checks for data drift and stale data
  • Lower infrastructure (IMR) cost by retiring unused assets
A day in the life

As a Data Engineer II, you'll spend your time architecting and building large-scale data solutions that support analytics and insights across ASCS. You might start your day reviewing business requirements from stakeholders and the BIE team, then transition into designing data pipelines that ingest information from catalog, listing, FCs and offer data, and design them so both stakeholders and generative AI (GenAI) tools like ANDI can use them. You'll collaborate with BIEs and SDEs to evaluate different technical approaches, write and test code using tools like AWS Redshift, Spark, and Hive, and document your solutions so others can understand and build upon your work. Beyond your core responsibilities, you'll have opportunities to guide junior engineers through complex problems and contribute to discussions about which tools and technologies best serve our evolving needs.

About the team

You'll join CATALIST (Catalog Analytics, Insights, Strategy and Tech), the central Business Intelligence Engineering (BIE) team in Catalog Support Programs (CSO), within ASCS. CSO runs program management, technical support and strategic initiatives that improve the customer experience. CATALIST builds self-service analytics and AI-powered insights for programs such as BLMA, Package Hierarchy (PH), World Product Catalog (WPC)

Basic Qualifications
  • 3+ years of data engineering experience
  • 4+ years of SQL experience
  • Experience with data modeling, warehousing and building ETL pipelines
Preferred Qualifications
  • Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
  • Experience with non-relational databases / data stores (object storage, document or key-value stores, graph databases, column-family databases)

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status. Veterans, military spouses, and people with disabilities are encouraged to apply.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer II, Amazon Selection and Catalog Systems (ASCS)
Data Engineer II, Amazon Selection and Catalog Systems (ASCS)

Amazon.com Inc. • Hyderabad

On-site
INR 1,000,000 - 1,400,000
Data Engineer II
Data Engineer II

Mployee.me • Hyderabad

On-site
INR 1,200,000 - 2,400,000
Data Engineer , Amazon Customer Service
Data Engineer , Amazon Customer Service

Mployee.me • Hyderabad

On-site
INR 1,400,000 - 2,300,000
Data Engineer, MIDAS, Digital Acceleration
Data Engineer, MIDAS, Digital Acceleration

Amazon.com • Chennai

On-site
INR 1,500,000 - 2,100,000
Data Engineer I, Business Data Technologies
Data Engineer I, Business Data Technologies

Amazon.com Inc. • Hyderabad

On-site
INR 1,200,000 - 1,800,000
Data Engineer II
Data Engineer II

Amazon.com • Hyderabad

On-site
INR 1,500,000 - 3,000,000
System Development Engineer I, Amazon
System Development Engineer I, Amazon

Amazon.com • Chennai

On-site
INR 1,500,000 - 2,500,000
Data Engineer, Amazon Operations Finance Standardisation and Automation
Data Engineer, Amazon Operations Finance Standardisation and Automation

Amazon.com Inc. • Hyderabad

On-site
INR 1,500,000 - 2,100,000
System Development Engineer I, Amazon
System Development Engineer I, Amazon

Amazon Inc. • Chennai District

On-site
INR 1,500,000 - 2,800,000
Data Engineer
Data Engineer

Amazon.com Inc. • Hyderabad

On-site
INR 2,500,000 - 4,200,000