Data Engineer I, Sales Data Services (SDS)

Socket.dev; New York (NY); On-site; USD 111,000 - 185,000; Full time

Job summary

Amazon Advertising in New York, NY, is seeking a data engineer to design and operate data warehouse and ETL pipelines using AWS, Redshift, and Python. You will empower analysts with self-serve reporting and collaborate across teams to deliver scalable data solutions.

The role requires hands-on experience with data modeling, warehousing, and SQL-based languages, and you will mentor engineers while contributing to a culture of operational excellence. Excellent benefits apply.

Qualifications

• 1+ years of data engineering experience with data modeling, warehousing and ETL pipelines.
• Experience with SQL, PL/SQL, HiveQL, SparkSQL or comparable query languages.
• Proficiency in scripting languages such as Python or KornShell.

Responsibilities

• Design, implement, and support data warehouse / data lake infrastructure on AWS using Redshift.
• Develop and manage ETLs to source data from diverse data lakes and create unified analytics models.
• Enable self-serve analytics for internal customers and support ad-hoc reporting as needed.
• Understand data sources deeply to solve business problems and prioritize cross-team delivery.
• Mentor engineers, influence team culture, and help grow the team.

Skills

Data engineering

SQL

Python

ETL pipelines

Data warehousing

Big data

Redshift

SparkSQL

Tools

Informatica

SSIS

Datastage

BODI

Job description

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.

Basic Qualifications

• 1+ years of data engineering experience
• Experience with data modeling, warehousing and building ETL pipelines
• Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala)
• Experience with one or more scripting language (e.g., Python, KornShell)

Preferred Qualifications

• Experience with big data technologies such as: Hadoop, Hive, Spark, EMR
• Experience with any ETL tool like, Informatica, ODI, SSIS, BODI, Datastage, etc.

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 - 111,400.00 - 185,000.00 USD annually