North America Sort Centers (NASC) is looking for a Business Intelligence Engineer within the NASC Sales and Operations Planning (S&OP) team. The Sort centers network is the critical middle mile solution in the Amazon Transportation Services (ATS) group that links the fulfillment centers to the last mile/customers. The experience of our customers is dependent upon our ability to accurately, timely, and efficiently sort and deliver packages across North America.

We are looking for a detail-oriented, highly analytical, innovative, hands-on, technically skilled, and customer-obsessed analyst who will help in developing best-in-class solutions for the middle mile network, to deliver high quality customer experiences while minimizing cost and improving fulfillment speed. This role will require the candidate to work cross functionally and understand the long term requirements of the all programs that leverage the sort centers. The ideal candidate will have excellent analytical and communication skills and the ability to thrive in ambiguous situations. The role also offers the candidate the opportunity to work on the Operations Research based planning tools and partner with data and research scientists to define and develop new tools and improve existing products.

Key job responsibilities
• Contributing the analytics space including the BI architecture, tools and modeling to support the operational planning cycles.
• Strong quantitative skills to develop reporting mechanisms to deliver strategic insights.
• Working closely with Network Planners, Product Managers, Data Scientists and various planning teams to drive business decisions and alignment with business stakeholders.
• Write high-quality SQL queries to retrieve and analyze data from database tables (ex. Redshift, MySQL, Oracle).
• Ability to break down and solve complex problems while actively engaging with internal partners throughout the organization to meet and exceed customer service levels & transport-related KPI’s.
• Recognize and adopt best practices in reporting/analysis: data integrity, test design, analysis, validation, and documentation while driving scalable solutions.
• Continue to move forward in the face of ambiguity and imperfect data. Find a solution around the problem that still maintains a high analytical bar.
• Communicate analysis results and techniques, both verbally and in writing, clearly and confidently to peers and business partners.