Data Engineer, Supply Chain Simulation

Looking for an exciting challenge to accelerate your career? Are you customer obsessed? Imagine being part of a team that predicts inventory flows for Amazon’s worldwide supply chain. Amazon’s worldwide inventory planning involves many algorithms to buy inventory in the right quantities, at the right frequencies, from the right vendors, and assigning to the best warehouse to fulfill customer demand forecast. Our massive simulation system lives at the heart of these algorithms, keeping up with the rapid pace of optimization improvements and simulating how they interact with each other. We simulate what these systems will do for months into the future, predicting inventory flows across the network for both labor planning and AB test experimentation, end-to-end from vendors to customers.

The Amazon Supply Chain Optimization Technology (SCOT) organization is looking for a highly motivated Data Engineer (DE). SCOT is a unique opportunity to both create and see the direct impact of your work on billions of dollars worth of inventory, in one of the world’s most advanced supply chains, and at massive scale.

As an DE in SCOT Simulation team, you will work closely with some of the brightest software engineers, scientists, economists, and product managers, to solve highly complex supply chain challenges. You will work on one of the largest distributed systems in the world in order to support new use cases and design its future state, you will think of how we can leverage AWS technologies (specifically technologies such as ECS and EMR), that will allow our next generation system to run elastically at a much larger scale and on demand, as well as define new frameworks (data APIs, plug and play technology) that will allow supply chain teams to integrate their components in simulation in a low touch manner. You will be responsible for building and maintaining data pipelines, warehouses, and lakes across our Simulation tool set, successfully delivering reliable data infrastructure and meeting program goals. You will design, implement, and optimize ETL processes, data models, and analytical solutions for Amazon Supply Chain, using SQL, PySpark, Amazon Big Data Technologies (BDT), AWS services (such as Redshift, EMR, Glue), and data visualization tools.

Finally, here are some more reasons you might find this opportunity exciting:

- Being part of a team that is at the heart of the most sophisticated supply chain and decision making system on the planet

- Working at the intersection of science and engineering to simulate and predict future supply chain flows in order to ultimately impact Amazon user experience (by helping supply chain teams run experiments that allow for speed and same day availability for example), saving hundreds of millions of dollars along the way

- Closely collaborating with some of the brightest software engineers, scientists, and economists, in order to solve complex supply chain problems and implement systems to tackle these challenges at scale (billions of simulation events per day), and an evolving need for faster and more scalable applications

- Being part of a team that values creativity and welcomes outside of the box thinking (thinking big!)

- Being part of a team with a high emphasis on a positive work culture of collaboration

- Being part of a fast growing team with many growth opportunities

Key job responsibilities
- Work closely with data scientists, business intelligence engineers, product managers, and software engineers to create robust data architectures and pipelines
- Take ownership of the design, creation, and maintenance of business critical metrics, tables, and jobs
- Optimize data and queries to improve simulation performance runtime and cost structure
- Develop and manage scalable, automated, and fault-tolerant data solutions using technologies such as Cradle, EMR, Redshift, Glue, Andes, and S3
- Lead/orchestrate org-wide data migration and data privacy campaigns

Basic Qualifications

- 1+ years of data engineering experience
- 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Bachelor's degree in a quantitative/technical field such as computer science, engineering, statistics
- Knowledge of distributed systems as it pertains to data storage and computing
- Experience with data modeling, warehousing and building ETL pipelines
- Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala)
- Experience with one or more scripting language (e.g., Python, KornShell)

Preferred Qualifications

- Experience with big data technologies such as: Hadoop, Hive, Spark, EMR
- Experience with any ETL tool like, Informatica, ODI, SSIS, BODI, Datastage, etc.

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $91,200/year in our lowest geographic market up to $185,000/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.