Business Intelligence Engineer, Transportation Planning, North America Transportation Planning - job 2 of 3

DescriptionAre you excited about how information insights can bring value to our transportation team. We are looking for a self-driven, insightful, results-oriented Business Intelligence Engineer to join the North America Transportation team. Our team mission is to drive improvements to customer experience, performance, and cost across Amazon’s transportation systems, from initial delivery promise to final delivery to our customers. This is a tremendous opportunity for Business Intelligence Engineers who want to develop new and innovative ways of interacting with and interpreting business key performance indicators, and shape the future of Amazon Transportation systems.Key job responsibilities• Work with business program owners to build data sets, reports, dashboards, and other products that answer their specific business questions.• Create, support, improve, and deep dive transportation metrics to provide actionable insights related to delivery cost and customer experience. This will require data gathering and analysis, partnering with external teams, synthesis and modeling, problem solving, and communication of insights and recommendations.• Develop scalable and self-serve analytical and visualization solutions to identify anomalies and support team projects. This will involve creating and maintaining reports and dashboards using tools such as SQL, AWS Redshift/S3, Tableau, QuickSight, Shiny, R, and Amazon Metrics, etc.• Perform ad hoc deep dives to understand drivers for transportation issues and opportunities, as well as support North American and Global transportation teams with special projects.• Collaborate with data engineers/scientists and other business intelligence engineers to design data architecture and implement data pipelines to automate manual solutions.• Develop a deep understanding of Amazon’s supply chain and AWS’s vast data sources and tools.About The TeamWe are the central planning and forecasting team for North America transportation. We integrate the E2E customer fulfillment, across both the short term (13 weeks) and long term (3 to 5 years) horizon.Basic Qualifications• 2+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience• Experience with one or more industry analytics visualization tools (e.g. Excel, Tableau, QuickSight, MicroStrategy, PowerBI) and statistical methods (e.g. t-test, Chi-squared)• Experience with scripting language (e.g., Python, Java, or R)• BS in Computer Science, Operations Research, Industrial Engineering, Mathematics/Applied Mathematics, Economics/Applied Economics or in another quantitative and engineering field• Knowledge of how to improve code quality and optimizes BI processes (e.g. speed, cost, reliability)• Advanced SQL knowledge and good understanding of data warehousing concepts.• Demonstrated ability to quickly analyze large data sets to identify complex patterns and relationships resulting in operational insights and actionable projects.Preferred Qualifications• Knowledge of data modeling and data pipeline design• Experience with statistical analysis, co-relation analysisAmazon 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.Los Angeles County applicants: Job duties for this position include: work safely and cooperatively with other employees, supervisors, and staff; adhere to standards of excellence despite stressful conditions; communicate effectively and respectfully with employees, supervisors, and staff to ensure exceptional customer service; and follow all federal, state, and local laws and Company policies. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above, as well as the abilities to adhere to company policies, exercise sound judgment, effectively manage stress and work safely and respectfully with others, exhibit trustworthiness and professionalism, and safeguard business operations and the Company’s reputation. Pursuant to the Los Angeles County Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $74,100/year in our lowest geographic market up to $165,600/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.Company - Amazon.com Services LLCJob ID: A2752451