Data Engineer, SCOT AIM: Inventory Research and Analytics

Job summary
Amazon’s Automated Inventory Management (AIM) team is looking for passionate, hard-working, and talented individuals to join our fast paced, stimulating environment to help invent the future of business ownership with Technology, and to translate big data into actionable insights.

The AIM team is part of the Supply Chain Optimization Technology (SCOT) Team within the Operations Organization. The charter of the SCOT team is to maximize Amazon’s return on our inventory investment in terms of Free Cash Flow and customer satisfaction. We accomplish this by determining how much inventory Amazon needs of each SKU and what to do if we have too much. This puts the Inventory Planning group at the nexus of operations, logistics, capacity planning, and our retail business teams.

As a Data Engineer on the AIM team, you will be working in one of the world's largest and most complex data warehouse environments. We maintain one of the largest data marts in Amazon as well as work on Business Intelligence reporting and dashboarding solutions that are used by users world-wide.
Our team is responsible for mission critical analytic reports and metrics that are viewed at the highest levels in the organization. We are also working on newer tools that help users discover data using visualization and Big Data technologies.

You should have deep expertise in the design, creation, management, and business use of significantly large datasets. You should have excellent business and communication skills to be able to work with business owners to develop and define key business questions, and to build data sets that answer those questions. You should be expert at designing, implementing, and operating stable, scalable, low cost solutions to flow data from production systems into the data warehouse and into end-user facing applications. You should be able to work with business customers in a fast paced environment understanding the business requirements and implementing reporting solutions. Above all you should be passionate about working with huge data sets and someone who loves to bring datasets together to answer business questions and drive change.
This opportunity is perfect for highly motivated and talented data engineers who want to apply and grow their technical depth and breadth while defining and driving key aspects of the customer experience on Amazon.com.

To help describe some of our challenges, we created a short video about Supply Chain Optimization at Amazon - http://bit.ly/amazon-scot

Basic Qualifications

• 2+ years of experience analyzing and interpreting data and experience with Redshift, Oracle, NoSQL etc.
• Experience with data modeling, data warehousing, and building ETL pipelines
• 3+ years of experience as a Data Engineer or in a similar role
• Experience in working and delivering end-to-end projects independently.
• Knowledge of distributed systems as it pertains to data storage and computing
• Experience in at least one modern object-oriented programming language (Ruby, Python, Java)
• Experience with Redshift, Oracle, NoSQL etc.

• Bachelor's degree in Computer Science, Engineering, Mathematics, or a related technical discipline. Master's degree is a definite plus.
• 4+ years of industry experience in Software Development, Data Engineering, Business Intelligence or related field with a solid track record of manipulating, processing, and extracting values from large datasets.
• Hands-on experience and highly advanced knowledge of SQL, Data Modeling, ETL Development, and Data Warehousing.
• Experience with working with multi-node data clusters

Solid experience using big data technologies (Redshift, Hadoop, Hive, Hbase, Spark, EMR, etc.).

• Knowledge and experience with Data Management and Data Storage best practices.
• Strong customer focus, ownership, and ability to deliver results.
• Excellent communication and collaboration skills
• Effective analytical, troubleshooting, and problem-solving skills.

Preferred Qualifications

• Extensive knowledge and practical experience in several of the following areas: machine learning system architecture, distributed systems for storage, reporting and visualization, computer science fundamentals including data structures, object oriented design etc.
• Experience processing, filtering, and presenting large quantities (Millions to Billions of rows) of data.

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.