Data Engineer, Ads Marketing, AMPI

- 3+ years of data engineering experience
- Experience with data modeling, warehousing and building ETL pipelines
- Experience with SQL
- 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 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, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.

Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $118,900/year in our lowest geographic market up to $205,600/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.
At Amazon Advertising, we are dedicated to drive measurable outcomes for brand advertisers, agencies, authors, and entrepreneurs. Our ad solutions—including sponsored, display, video, and custom ads—leverage Amazon’s innovations and insights to find, attract, and engage intended audiences throughout their daily journeys. With a range of flexible pricing and buying models, including self-service, managed service, and programmatic ad buying, these solutions help businesses build brand awareness, increase product sales, and more.

We are hiring a Data Engineer (DE) to help us deliver on a ML initiative to ingest content data(semi and unstructured data) in a scalable way that will enable scientists and BI engineers to measure and derive insights from content delivered to global advertisers through various Ads marketing communications.

The person hired will help build the data-sets to underpin the ML models as well as help create the output pipeline. They will be working very closely with a data science team and a scale Data Engineering team. The ideal candidate will be passionate about working with big data sets and have the expertise to utilize these data-sets to answer business questions and drive growth. This is a highly visible role with global scope, senior leadership exposure, and international stakeholder management. The team is located in Seattle for this role.


The primary responsibilities of this role include:
- Design, develop and maintain scalable, automated, derived / or non-derived, insightful data-marts and tables which will be the main input for the models, reports and dashboards
- Use analytical and statistical rigor to solve complex problems and drive business decisions.
- Write high integrity code to retrieve and analyze data from database tables (Redshift), learn and understand a broad range of Amazon’s data resources and know how, when, and which to use and which not to use
- Explore new datasets, onboard them into our data lake and scale for WW use
- Set up ingest, analyse, output processes
- Set up mechanisms to proactively measure quality of outputs
- Create and maintain key program reports



Key job responsibilities
Collaborate with engineering and business owners to understand how content is created and delivered through various Ads Marketing communications and develop scalable automated data ingestion workflows to data lake



About the team
Ads Marketing Measurement Science