Data Engineer, Analytics and Insights

Job summary
Amazon Advertising exists at the intersection of marketing and ecommerce and offers advertisers a rich array of innovative advertising solutions across Amazon owned properties as well as third party properties Amazon operates. We believe that advertising, when done well, can greatly enhance the value of the customer experience and generate a positive return on investment for our advertising partners.

We are looking for a passionate data engineer (DE) to own creation of a data lake to support Analytics & Media Managers (AMM) who need a broad set of data to develop insights for advertisers. Data is at the center of every insight we will develop as we create business analytics solutions that serve the needs of our advertisers. You will share in the ownership of the technical vision and direction for advanced analytics and insight products/ services. You will be a part of a team of top notch analytical professionals developing complex modeling/analyses for our customers and with a focus on sustained operational excellence. Members of this team will be challenged to innovate using big data technologies. We are looking for people who are motivated by thinking big, moving fast, and changing the way customers use data to drive their business. If you love to implement solutions to hard problems while working hard, having fun, and making history, this may be the opportunity for you.


Key job responsibilities
Build data pipelines and navigate permissions/compliance requirements to onboard new datasets while balancing performance and cost.

Optimization of existing pipelines.

Work with team to scale ad-hoc insights to thousands of customers. Via optimization of workloads and leveraging AWS.

Develop ETL to collect disparate data sources (via API, and AWS) to support critical business operations.

Basic Qualifications

· 3+ years of experience as a Data Engineer or in a similar role
· Experience with data modeling, data warehousing, and building ETL pipelines
· Experience in SQL
Bachelor's degree in computer science, engineering, mathematics, or a related technical discipline

4+ years of industry experience in software development, data engineering, business intelligence, data science, or related field with a track record of manipulating, processing, and extracting value from large datasets

Demonstrated strength in data modeling, data-pipelines development, and data warehousing (big data challenges)

Experience with a data warehouse technology

Experience using big data technologies (S3, MPP database, Spark/Scala, EMR, Redshift/Spectrum, Python, etc.)

Experience using business intelligence reporting tools (Tableau, Business Objects, Cognos, etc.)

Experience working with cloud computing and infrastructure (AWS, Google Cloud, Azure)

Knowledge of data management fundamentals and data storage principles

Knowledge of distributed systems as it pertains to data storage and computing

Experience with writing design documentation

Comfortable working with SDEs

Preferred Qualifications

Experience working with AWS big data technologies (EMR, Redshift, S3, Athena, Glue)

Proven success in communicating with users, other technical teams, and senior management to collect requirements, describe data modeling decisions and data engineering strategy

Experience providing technical leadership and mentoring other engineers for best practices on data engineering

Knowledge of software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes, testing, and operations

Masters or PhD in computer science, mathematics, statistics, economics, or other quantitative field

Understanding of data retention policies and standards in accordance with data privacy laws



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.