Business Intelligence Engineer II, PAM
DESCRIPTION
The Sales and Operations Planning (S&OP) team plays a pivotal role in forecasting inventory flows across various countries. We manage everything from what Amazon receives from vendors and sellers to what it ships from our Fulfillment Centers (FCs). Our responsibilities also include measuring S&OP performance and driving continuous improvement in planning processes for local networks, with a focus on reliability, speed, cost, and sustainability. We collaborate closely with Supply Chain Optimization Technology (SCOT) teams in North America and internal tech stakeholders across Transportation, Labor Planning, and Finance teams. As part of S&OP, the Planning Automation Modules (PAM) team is currently revolutionizing the way S&OP generate plans, building a dedicated infrastructure to support the S&OP process at a global scale. This includes platforms to run complex optimization models on-demand in a fast and scalable ways. The current version of PAM is already in use in North America and Europe and used to plan inventory flows across more than 300 FCs globally.
Why Join Us:
• Autonomy and ownership to solve challenging problems that directly impact customers.
• Critical role in driving decision-making for WW Operation teams.
• Opportunity to work at the forefront of business intelligence, leveraging complex data for operational excellence.
• Be part of a dynamic team committed to continuous improvement and innovation.
Key job responsibilities
• Develop and implement scalable models, data solutions, and visualization metrics to enhance S&OP planning automation.
• Maintain and create new data pipelines, establishing single source of truths for operations teams.
• Lead critical process improvement initiatives, leveraging complex models to enhance S&OP planning automation.
• Collaborate with cross-functional teams to ensure alignment with business goals and objectives.
A day in the life
We are now seeking a Business Intelligence Engineer II to help us scale PAM for worldwide operations. This is a Day 1 opportunity to be part of an entrepreneurial and pioneering team building from the ground up. You will be at the forefront of building models, developing data solutions, and creating new visualization metrics to enhance S&OP activities and drive process automation. You will play a vital role in maintaining and creating new data pipelines and create new models consumed by worldwide S&OP and operation teams. If you are someone who has shown success in analyzing, diving deep in complex data, streamlining and identifying process improvement opportunities and pioneering new ways to do things, we would like to talk to you.
About the team
At Amazon Supply Chain, we power the world's fastest-growing e-commerce business and embrace the mission of being Earth’s most customer-centric company. As our business continues to expand, the customer fulfillment operations become larger and more complex each year.
BASIC QUALIFICATIONS
- Experience in analyzing and interpreting data with Redshift, Oracle, NoSQL etc.
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience with data modeling, warehousing and building ETL pipelines
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Knowledge of SQL and data warehousing concepts
- Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
- Bachelor's Degree in sciences, engineering, finance or equivalent
PREFERRED QUALIFICATIONS
- Master's degree in sciences, engineering, finance or equivalent
- Experience in Supply Chain Management/Operations Research
Amazon is an equal opportunities employer. We believe passionately that employing a diverse workforce is central to our success. We make recruiting decisions based on your experience and skills. We value your passion to discover, invent, simplify and build. Protecting your privacy and the security of your data is a longstanding top priority for Amazon. Please consult our Privacy Notice (https://www.amazon.jobs/en/privacy_page) to know more about how we collect, use and transfer the personal data of our candidates.
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.