Data Engineer I — Big Data & Analytics Platform

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 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.