DescriptionFulfillment Exception Management (FXM) within the SCOT organization Seattle team, is looking for an experienced Business Intelligence Engineer. This group owns the systems that orchestrates services involved in the fulfillment process from the time the orders are assigned to fulfillment until they are ready to be packed and shipped to our customers. Our systems cover a wide range of business and technology areas including inventory management, workflow management, shipment creation, load balancing, and availability.This is a high-impact space packed with challenging problems involving very complex systems and smart people - our systems handle the fulfillment of all customer orders that are sold on Amazon & merchant websites. This is a unique chance to become an owner of part of Amazon's business-critical fulfillment pipeline!Key job responsibilities
Defining, developing and maintaining critical business and operational reports reviewed on a weekly, monthly, quarterly, and annual basis
Transform complicated business problems into mathematics modeling and provide data-driven solutions
Analysis of historical data to identify trends and support decision making, including written and verbal presentation of results and recommendations
Collaborating with software development teams to implement analytics systems and data structures to support large-scale data analysis and delivery of machine learning and econometric models
Establish scalable, efficient, automated processes for large scale data analyses, model development, model validation, and model implementation.
Mining and manipulating data from database tables, simulation results and log files
Identifying data needs and driving data quality improvement projects
Understanding the broad range of Amazon’s data resources, which to use, how, and when.
A day in the lifeA BIE II in FXM BI team:
Routinely performs and presents deep dives and anecdotes to gain more granular understanding of why a missed promise occurred and whether there are gaps in fulfillment systems which, if resolved, could prevent future misses. Build logic to attribute these root causes at large scale and put together underlying data pipeline to make this information available for metricizing and accessible for other teams within Amazon.
Regularly reviews the missed promise metrics for putting together callouts for weekly business reviews by performing ad hoc analysis and reaching out to appropriate teams to get further understanding of the issue. Another part of this exercise is to track and callout negative trends which need more attention from the leadership, identify the root cause(s), and recommend next steps to resolve the issue.
Works cross-functionally with various teams in Fulfillment Optimization organization to understand how they interact and affect the order fulfillment process and identify system gaps which could impact missed promises and aging orders. They continue to resolve the gap by working closely with software teams to design and implement solutions to address these gaps and develop metrics to track it going forward.
About the teamFulfillment Exceptions Management (FXM) (aka Missed Promise team) owns systems that manage exceptions arising from the large number of events within Amazon's supply chain that affect fulfillment during the lifetime of a customer order. When a customer places an order, they are given an expected delivery date - called the "promise." If something happens and we predict we can no longer meet that date, it becomes a "missed promise" and FXM team sends an email to the customer notifying of the miss and new expected delivery date. The FXM Business Intelligence (BI) team's responsibility is to build business logic and supporting data pipelines to identify root causes for the missed promises and aging orders, build business/operational metrics for daily and weekly reporting, and drive system changes to improve customer experience using this data, and support the Cold Pricklies process during Peak.We are open to hiring candidates to work out of one of the following locations:Bellevue, WA, USABasic Qualifications
3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
Experience with data visualization using Tableau, Quicksight, or similar tools
Experience with data modeling, warehousing and building ETL pipelines
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.