Data Engineer II, Analytics & Data Management

- 3+ years of data engineering experience
- Experience with data modeling, warehousing and building ETL pipelines
- Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets
- Experience with SQL
- Experience in at least one modern scripting or programming language, such as Python, Java, Scala, or NodeJS
- 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)
- Experience with big data technologies such as: Hadoop, Hive, Spark, EMR

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, disability, age, or other legally protected status. If you would like to request an accommodation, please notify your Recruiter.
Amazon was recently voted #2 most admired company in the US, #1 most innovative, and #1 in Customer Service. We are investing heavily in building an excellent advertising business, and are responsible for defining, and delivering a collection of self-service performance advertising products that is fully scalable and reliable. Our products are strategically important to our leadership, finance, economists, analysts, and BI partners to drive long-term growth. We mine billions of ad impressions and millions of clicks daily and are breaking fresh ground to create world-class products. We are highly motivated, collaborative, and fun loving with an entrepreneurial spirit and bias for action. With a broad mandate to experiment and innovate, we are growing at an unprecedented rate with a seemingly endless range of new opportunities.

Analytics & Data Management team in Amazon Advertising is looking for a Data Engineer who is passionate about data and the insights that large amounts of data can provide, experienced in designing and building data marts, and enjoys working with PB-scale data. The role will work with a team of business and tech savvy professionals (DEs, BIEs, SDEs, and PMs) to lay down scalable data architecture for ingesting large amounts of structured and unstructured datasets, building views that can be easily consumed by customers, and partnering with stakeholders to drive data-based business decisions.

The ideal candidate will possess both a data engineering background and a strong business acumen that enables him/her to think strategically. He/she will experience a wide range of problem solving situations, requiring extensive use of data collection and analysis techniques such as data mining and machine learning.

Key job responsibilities
In this role, you will work with business leaders, engineers, and stakeholders across Ads, Sales, Finance, Marketing, and Service teams. You will:

- Develop and improve the current data architecture using AWS Redshift, AWS S3, AWS Aurora (Postgres) and Hadoop/EMR
- Improve upon the data ingestion models, ETL jobs, and alarming to maintain data integrity and data availability
- Stay up-to-date with advances in data persistence and big data technologies and run pilots to design the data architecture to scale with the increased datasets of advertiser experience
- Partner with stakeholders to build and verify hypothesis to improve business performance
- Manage and support business critical reports and reporting tools to monitor KPIs