Business Intelligence Engineer II, SCOT - Optimal Sourcing Systems - Amazon

Description Strategic Sourcing team in Supply Chain Optimization and Technology organization, is seeking an experienced and motivated Business Intelligence Engineer. Strategic Sourcing team owns systems that are designed to: 1) reduce end to end costs from inbound supply chain and (2) improve vendor performance. Some of the key decisions that these systems make: when and if we should source a product (e.g. is the product obsolete or temporarily unavailable); from which vendor and at what cost we should source an ASIN; what is the ideal supply chain setup (e.g. Pallet, Truckload, etc.) for an ASIN/vendor; when should vendor ship/deliver inventory to Amazon FCs; which inbound lanes - vendor warehouse to Amazon FC - should have pre-allocated transportation with how many shipments; when should we penalize vendors for defects/infractions through chargebacks and by how much. Together these set of decisions and systems work together to ensure Amazon's inventory needs are met on time and in the most efficient way. We develop sophisticated algorithms that involve learning from large amounts of data to drive decisions that impact sourcing of $100B+ inventory WW. Key job responsibilities In this role, you will develop and maintain a diverse portfolio of business intelligence products, tools, and services. You'll collaborate closely with product and tech teams to identify opportunities for innovation and improvement. Your responsibilities will include conducting in-depth analyses and creating comprehensive reports to support business decisions and strategic initiatives. You'll contribute to projects that span across Retail and Operations departments, aligning your work with S-Team and OLT goals to drive company-wide success. Candidate in this role should excel at diving into data in order to analyze root causes and implement simple, long term solutions. They will thrive in a highly collaborative, creative, analytical, and fast-paced environment oriented around building the world's most flexible and effective supply chain. To stay at the forefront of the industry, you'll need to keep up current trends and best practices in business intelligence and data analytics. Additionally, you'll play a crucial role in mentoring team members and sharing knowledge to foster a culture of continuous learning within the organization. Basic Qualifications - 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience - Experience with data modeling, warehousing and building ETL pipelines - Experience with data visualization using Tableau, Quicksight, or similar tools - Experience writing complex SQL queries - Experience in Statistical Analysis packages such as R, SAS and Matlab - Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling Preferred Qualifications - 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 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. Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/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.