Data Engineer II, Global Transportation Procurement

Job summary
Global Supply Chain and Transportation Procurement (GSCTP) is an organization under worldwide operations that develops and maintains strategic relationships with third party (3P) supply chain and transportation service providers. The team’s mission is to secure capacity from third-party providers, increase cost efficiencies of the business, expand supplier capabilities, and improve the overall quality of our products and services. GSCTP focuses on the customer, disrupts the status quo, and builds a competitive advantage for Amazon.

We are seeking a Data Engineer to join the team. 3P providers move tens of millions of packages each day for our customers. In order to evaluate the volume, cost, and performance of these providers, as well as make the best forward-looking decisions for contract negotiation, we need to store and process data in the size of terabytes. This presents exciting opportunities to work with very large data sets and perform ETL on them using AWS cloud technologies such as S3 and Redshift. At the end of the day we rely on great design and best practices for cloud-based infrastructure to deliver the speed and scalability required by the procurement organization. If you are passionate about using data analytics to find insights and drive continuous improvements, and are a self-starter who is comfortable working closely with internal and external business partners, you are the candidate we are looking for!

As a Data Engineer, you will work directly with business stakeholders and technical partners to design and implement end-to-end data solutions to ultimately support contract negotiations, business reviews, performance management, and process improvements. You will work with a wide range of data technologies and stay abreast of emerging technologies, investigating and implementing where appropriate. As a Data Engineer you will be responsible for developing the data architecture components that scales for the ever-evolving data needs. You will apply cloud-based AWS services to solve challenging problems around data processing and data warehouse design to enable the development of BI self-service solutions. You will focus on automation and optimization for all areas of DW/ETL maintenance. The ideal candidate should also have strong data analysis skills and can build BI solutions alongside Business Intelligence Engineers (BIE) on the team.

Key job responsibilities
• Design, implement and maintain an analytical data infrastructure providing ad-hoc access to large datasets and computing power
• Interface with other technical teams (both inside and outside Amazon) to extract, transform, and load data from a wide variety of data sources using SQL and AWS big data technologies
• Be enthusiastic about building deep domain knowledge about Amazon’s business and the Transportation Procurement space
• Develop automated solutions to minimize manual processes within the data arena with the focus on efficiency and scalability.
• Become familiar with supplier relationship management, transportation simulation, and procurement sourcing optimization software. Develop data interface solutions to aid with the consumption and analysis of data from such software.
• Collaborate with BIEs to continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers
• Explore and learn the latest AWS technologies to provide new capabilities and increase efficiency.
• Collaborate with other technical teams within Amazon to develop data engineering best practices.

Basic Qualifications

• Bachelor’s degree in Computer Science, Engineering, Statistics, or related field
• 5+ years of experience as a Data Engineer or in a similar role (BIE)
• Proficiency with SQL and Python (or a similar scripting language)
• Strong experience building ETL pipelines
• Demonstrated strength in data modeling and data warehouse design
• Track record of successfully applying data management fundamentals and data storage principles to large scale data analytics projects
• Knowledge of distributed systems and cloud technologies pertaining to data storage and computing
• Ability to communicate well orally and in writing to both technical and business audiences

Preferred Qualifications

• Master’s degree in Logistics, Supply Chain, Engineering, Mathematics or relevant field
• 7+ years of experience as a Data Engineer, BI Engineer, or Systems Analyst in a company with large, complex data sources
• Experience building and operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets
• 2+ years of experience working with AWS big data technologies (EMR, Redshift, S3, Glue, Kinesis, Lambda, etc.)
• Proven success user requirement communications, as well as communicating data modeling decisions and engineering strategy to senior management
• 3+ years of working in the transportation and supply chain industry
• Experience working with business process systems and RFP / sourcing management software (SalesForce, Coupa, Ariba, etc.)
• Knowledge of statistical modeling and advanced quantitative analytical techniques


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.