Data Engineer II, Sales Data Services (SDS)

Amazon.com; Seattle (WA); On-site; USD 132,000 - 179,000; Full time

Job summary

Amazon Inc. in Seattle, WA is seeking a Data Engineer II to join Sales Data Services. You will design data warehouse and data lake infrastructure using AWS, develop ETL/ELT pipelines, and enable self-serve analytics for internal customers.

You will mentor engineers and collaborate across BI, data science, and product teams. The role emphasizes scalable, robust data architectures, exposure to large datasets, and building analytics-ready data models leveraging Redshift, S3, Glue, and other AWS

Qualifications

• 3+ years of data engineering experience.
• 1+ years building ETL/ELT pipelines for BI analytics.
• 1+ years building and operating OLAP data structures.
• 1+ years data modeling for analytics.
• 1+ years SQL experience in large datasets.
• 1+ years Oracle experience.
• Bachelor's degree or foreign equivalent in CS/Engineering/IS/Math.
• Experience with data warehousing and ETL pipelines.

Responsibilities

• Design, implement, and support data warehouse / data lake infra using AWS stack, Python, Redshift.
• Develop and manage ETLs to source data from data lakes and create unified data model.
• Enable self-serve analytics and ad-hoc reporting for internal customers.
• Develop understanding of data sources and appropriate data usage for problems.
• Manage multiple requests, prioritize, and collaborate across teams.
• Mentor engineers and contribute to team culture.

Skills

Data engineering

ETL/ELT

OLAP

Data modeling

SQL

Oracle

Education

Bachelor's degree in Computer Science / Engineering / Information Systems / Mathematics

Tools

AWS Redshift

S3

AWS Glue

EMR

Kinesis

Lambda

IAM roles

Job description

Data Engineer II, Sales Data Services (SDS)

Job ID: 10593890 | Amazon.com Services LLC

Amazon Advertising operates at the intersection of eCommerce and advertising, offering a rich array of digital display advertising solutions with the goal of helping our customers find and discover anything they want to buy. We help advertisers reach Amazon customers on Amazon.com, across our other owned and operated sites, on other high-quality sites across the web, and on millions of Kindles, tablets, and mobile devices. We start with the customer and work backwards in everything we do, including advertising. If you’re interested in joining a rapidly growing team working to build a unique, world‑class advertising group with a relentless focus on the customer, you’ve come to the right place.

SDS is part of the Sales Intelligence, Technology, & Enablement organization (SITE). We are a big‑data focused engineering team that provides unique, pan‑Amazon datasets consolidating advertiser, seller, and vendor KPIs, exposed via data warehousing , fast APIs and agentic soutions. Our data platform is designed to serve Sales teams across WW Advertising orgs for various applications including business processes, ML, account management, marketing, and decisioning systems.

Key job responsibilities

• Design, implement, and support data warehouse / data lake infrastructure using AWS big data stack, Python, Redshift.
• Develop and manage ETLs to source data from various data lakes and create unified data model for analytics and reporting
• Empower technical and non‑technical, internal customers to drive their own analytics and reporting (self‑serve reporting) and support ad‑hoc reporting when needed.
• Develop deep understanding of vast data sources and know exactly how, when, and which data to use to solve particular business problems.
• Manage numerous requests concurrently and strategically, prioritizing when necessary collaborate across teams to deliver results.
• Mentor other engineers, influence positively team culture, and help grow the team.

A day in the life

You will work closely with the Business Intelligence Engineers, Data Scientists, Product Managers, Software Development teams and other business stakeholders on many unique business problems and use creative problem solving to deliver actionable output in data gathering, transformation, ingestion and storage. You should be able to gather business and functional requirements and translate these requirements into robust, scalable, operable solutions with a flexible and adaptable data architecture. As a DE, you will be regularly mentoring junior engineerings, developing technical your leadership, and contributing to the design and implementation of highly available, scalable, stable, secure, and cost‑effective analytic solutions.

Basic Qualifications

• 3+ years of data engineering experience
• 1+ years of developing and operating large‑scale data structures for business intelligence analytics using ETL/ELT processes experience
• 1+ years of developing and operating large‑scale data structures for business intelligence analytics using OLAP technologies experience
• 1+ years of developing and operating large‑scale data structures for business intelligence analytics using data modeling experience
• 1+ years of developing and operating large‑scale data structures for business intelligence analytics using SQL experience
• 1+ years of developing and operating large‑scale data structures for business intelligence analytics using Oracle experience
• 3+ years of in the job offered or a related occupation experience
• 1+ years of developing and operating large‑scale data structures for business intelligence analytics using each of the following: ETL (Extract, Transform, Load)/ELT (Extract, Load, Transform) processes experience
• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Information Systems, Mathematics, or a related field
• 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)

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

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.

The base salary range for this position is listed below. Your Amazon package will include sign‑on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits .

USA, NY, New York - 145,300.00 - 196,600.00 USD annually

USA, WA, SEATTLE - 132,100.00 - 178,800.00 USD annually

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.